Bplus/ApiWeb/ApiProcessToken/Models/banlance/getListCommon.cs

using ApiProcess.Models.balance;
using CommonObj.common;
using CommonObj.model;
using ResfullApi.Models.balance;
using StackExchange.Redis;
using System;
using System.Collections.Generic;
using System.Data;
using System.Threading.Channels;
using System.Xml.Linq;

namespace ApiProcessToken.Models.banlance
{
    public class getListCommon
    {



      


        public static List<campaignObj> getListCam(string id,string users, string name, string code, string fromDate, string toDate
            , string order, string rowsOnPage, string seqPage, string status, out string _rowsOnPage, out string _seqPage, out string _totalPage,string isDefault,string isMyservice)
        {
            string v1, v2, v3;
            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignObj> _result = new List<campaignObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camGetList(id, users, name, code, fromDate, toDate, order, rowsOnPage, seqPage, status, isDefault, isMyservice);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();



                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignObj _obj = new campaignObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.code = ds_regist.Tables[0].Rows[j]["CODE"].ToString();
                        _obj.name = ds_regist.Tables[0].Rows[j]["NAME"].ToString();
                        _obj.fromDate = ds_regist.Tables[0].Rows[j]["FROM_DATE"].ToString();
                        _obj.toDate = ds_regist.Tables[0].Rows[j]["TO_DATE"].ToString();
                        _obj.fromHour = ds_regist.Tables[0].Rows[j]["FROM_HOUR"].ToString();


                        _obj.toHour = ds_regist.Tables[0].Rows[j]["TO_HOUR"].ToString();
                        _obj.rule = ds_regist.Tables[0].Rows[j]["RULE_ADD"].ToString();


                        _obj.priority = ds_regist.Tables[0].Rows[j]["PRIORITY"].ToString();
                        _obj.balanceId = ds_regist.Tables[0].Rows[j]["BALANCE_ID"].ToString();
                        _obj.expireDateId = ds_regist.Tables[0].Rows[j]["EXPIRE_DATE_ID"].ToString();
                        _obj.status = ds_regist.Tables[0].Rows[j]["STATUS"].ToString();
                        _obj.numberDisplay = ds_regist.Tables[0].Rows[j]["NUMBER_DISPLAY"].ToString();
                        _obj.addType = ds_regist.Tables[0].Rows[j]["ADD_TYPE"].ToString();

                        _obj.title = ds_regist.Tables[0].Rows[j]["TITLE"].ToString();
                        _obj.isReload = ds_regist.Tables[0].Rows[j]["IS_RELOAD"].ToString();
                        _obj.isDefault = ds_regist.Tables[0].Rows[j]["IS_DEFAULT"].ToString();
                        _obj.isMyService = ds_regist.Tables[0].Rows[j]["IS_MYSERVICE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();



                        _obj.listServiceMapCam = getListServiceOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listBalanceMapCam = getListBalanceOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);


                        _obj.listExpireMapCam = getListExpireOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listShortCodeMapCam = getListShortCodeOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listSubMapCam = getListSubOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _result.Add(_obj);
                    }


                    

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }

        public static List<campaignObj> getListHiddenCam(string id, string users, string name, string code, string fromDate, string toDate
            , string order, string rowsOnPage, string seqPage, string status, out string _rowsOnPage, out string _seqPage, out string _totalPage, string isDefault, string isMyservice)
        {
            string v1, v2, v3;
            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignObj> _result = new List<campaignObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.hiddenCamGetList(id, users, name, code, fromDate, toDate, order, rowsOnPage, seqPage, status, isDefault, isMyservice);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();

                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignObj _obj = new campaignObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.code = ds_regist.Tables[0].Rows[j]["CODE"].ToString();
                        _obj.name = ds_regist.Tables[0].Rows[j]["NAME"].ToString();
                        _obj.fromDate = ds_regist.Tables[0].Rows[j]["FROM_DATE"].ToString();
                        _obj.toDate = ds_regist.Tables[0].Rows[j]["TO_DATE"].ToString();
                        _obj.fromHour = ds_regist.Tables[0].Rows[j]["FROM_HOUR"].ToString();

                        _obj.toHour = ds_regist.Tables[0].Rows[j]["TO_HOUR"].ToString();
                        _obj.rule = ds_regist.Tables[0].Rows[j]["RULE_ADD"].ToString();

                        _obj.priority = ds_regist.Tables[0].Rows[j]["PRIORITY"].ToString();
                        _obj.balanceId = ds_regist.Tables[0].Rows[j]["BALANCE_ID"].ToString();
                        _obj.expireDateId = ds_regist.Tables[0].Rows[j]["EXPIRE_DATE_ID"].ToString();
                        _obj.status = ds_regist.Tables[0].Rows[j]["STATUS"].ToString();
                        _obj.numberDisplay = ds_regist.Tables[0].Rows[j]["NUMBER_DISPLAY"].ToString();
                        _obj.addType = ds_regist.Tables[0].Rows[j]["ADD_TYPE"].ToString();

                        _obj.title = ds_regist.Tables[0].Rows[j]["TITLE"].ToString();
                        _obj.isReload = ds_regist.Tables[0].Rows[j]["IS_RELOAD"].ToString();
                        _obj.isDefault = ds_regist.Tables[0].Rows[j]["IS_DEFAULT"].ToString();
                        _obj.isMyService = ds_regist.Tables[0].Rows[j]["IS_MYSERVICE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();

                        _obj.listServiceMapCam = getListServiceOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listBalanceMapCam = getListBalanceOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listExpireMapCam = getListExpireOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listShortCodeMapCam = getListShortCodeOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listSubMapCam = getListSubOfCam("-1", users, _obj.id, fromDate
                        , toDate, order, "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _result.Add(_obj);
                    }
                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }





        public static List<campaignObj> getListCamCalendar(string users, string fromDate, string toDate,string status)
        {
            string v1, v2, v3;
            List<campaignObj> _result = new List<campaignObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camGetListCalendar(users,fromDate,toDate,status);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {




                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignObj _obj = new campaignObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.code = ds_regist.Tables[0].Rows[j]["CODE"].ToString();
                        _obj.name = ds_regist.Tables[0].Rows[j]["NAME"].ToString();
                        _obj.fromDate = ds_regist.Tables[0].Rows[j]["FROM_DATE"].ToString();
                        _obj.toDate = ds_regist.Tables[0].Rows[j]["TO_DATE"].ToString();
                        _obj.fromHour = ds_regist.Tables[0].Rows[j]["FROM_HOUR"].ToString();


                        _obj.toHour = ds_regist.Tables[0].Rows[j]["TO_HOUR"].ToString();
                        _obj.rule = ds_regist.Tables[0].Rows[j]["RULE_ADD"].ToString();


                        _obj.priority = ds_regist.Tables[0].Rows[j]["PRIORITY"].ToString();
                        _obj.balanceId = ds_regist.Tables[0].Rows[j]["BALANCE_ID"].ToString();
                        _obj.expireDateId = ds_regist.Tables[0].Rows[j]["EXPIRE_DATE_ID"].ToString();
                        _obj.status = ds_regist.Tables[0].Rows[j]["STATUS"].ToString();
                        _obj.numberDisplay = ds_regist.Tables[0].Rows[j]["NUMBER_DISPLAY"].ToString();
                        _obj.addType = ds_regist.Tables[0].Rows[j]["ADD_TYPE"].ToString();

                        _obj.title = ds_regist.Tables[0].Rows[j]["TITLE"].ToString();
                        _obj.isReload = ds_regist.Tables[0].Rows[j]["IS_RELOAD"].ToString();
                        _obj.isDefault = ds_regist.Tables[0].Rows[j]["IS_DEFAULT"].ToString();
                        _obj.isMyService = ds_regist.Tables[0].Rows[j]["IS_MYSERVICE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();



                        _obj.listServiceMapCam = getListServiceOfCam("-1", users, _obj.id, fromDate
                        , toDate, "asc", "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listBalanceMapCam = getListBalanceOfCam("-1", users, _obj.id, fromDate
                        , toDate, "asc", "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);


                        _obj.listExpireMapCam = getListExpireOfCam("-1", users, _obj.id, fromDate
                        , toDate, "asc", "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listShortCodeMapCam = getListShortCodeOfCam("-1", users, _obj.id, fromDate
                        , toDate, "asc", "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _obj.listSubMapCam = getListSubOfCam("-1", users, _obj.id, fromDate
                        , toDate, "asc", "100000", "1", "WEB",
                        "EN", out v1, out v2, out v3);

                        _result.Add(_obj);
                    }




                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }


        public static List<campaignAddObj> getListServiceOfCam(string id, string users, string campaignId, string fromDate
            , string toDate, string order, string rowsOnPage, string seqPage, string channel,
            string language, out string _rowsOnPage, out string _seqPage, out string _totalPage)
        {

            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignAddObj> _result = new List<campaignAddObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camAddGetList(id, users, campaignId, fromDate, toDate, order, rowsOnPage, seqPage);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();



                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignAddObj _obj = new campaignAddObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.campaignId = ds_regist.Tables[0].Rows[j]["CAMPAIGN_ID"].ToString();
                        _obj.serviceAddId = ds_regist.Tables[0].Rows[j]["SERVICE_ADD_ID"].ToString();
                        _obj.isDelete = ds_regist.Tables[0].Rows[j]["IS_DELETE"].ToString();
                        _obj.note = ds_regist.Tables[0].Rows[j]["NOTE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();
                        _obj.ussdDisplay = ds_regist.Tables[0].Rows[j]["USSD_DISPLAY"].ToString();
                        _obj.keyRegister = ds_regist.Tables[0].Rows[j]["KEY_REGISTER"].ToString();


                        //Lay them danh sach nua
                        serviceObj _obj1 = new serviceObj();

                        _obj1.id = ds_regist.Tables[0].Rows[j]["oID"].ToString();
                        _obj1.code = ds_regist.Tables[0].Rows[j]["oCODE"].ToString();
                        _obj1.name = ds_regist.Tables[0].Rows[j]["oNAME"].ToString();
                        _obj1.description = ds_regist.Tables[0].Rows[j]["oDESCRIPTION"].ToString();
                        _obj1.shortCode = ds_regist.Tables[0].Rows[j]["oSHORT_CODE"].ToString();
                        _obj1.command = ds_regist.Tables[0].Rows[j]["oCOMMAND_REGISTER"].ToString();


                        _obj1.contentEn = ds_regist.Tables[0].Rows[j]["oCONTENT_EN"].ToString();
                        _obj1.contentFr = ds_regist.Tables[0].Rows[j]["oCONTENT_FR"].ToString();
                        _obj1.contentLc = ds_regist.Tables[0].Rows[j]["oCONTENT_LC"].ToString();
                        _obj1.note = ds_regist.Tables[0].Rows[j]["oNOTE"].ToString();
                        _obj1.companyId = ds_regist.Tables[0].Rows[j]["oCOMPANY_ID"].ToString();

                        _obj1.usersCreated = ds_regist.Tables[0].Rows[j]["oUSERS_CREATED"].ToString();
                        _obj1.dateCreated = ds_regist.Tables[0].Rows[j]["oDATE_CREATED"].ToString();
                        _obj1.usersUpdate = ds_regist.Tables[0].Rows[j]["oUSERS_UPDATE"].ToString();
                        _obj1.dateUpdate = ds_regist.Tables[0].Rows[j]["oDATE_UPDATE"].ToString();

                        _obj1.dateUpdate = ds_regist.Tables[0].Rows[j]["oDATE_UPDATE"].ToString();

                        _obj1.msgRegisterSuccess = ds_regist.Tables[0].Rows[j]["oUSSD_MSG_REGISTER_SUC"].ToString();
                        _obj1.msgRegisterFlase = ds_regist.Tables[0].Rows[j]["oUSSD_MSG_REGISTER_FAIL"].ToString();
                        _obj1.msgConfirm = ds_regist.Tables[0].Rows[j]["oUSSD_CONFIRM"].ToString();

                        _obj1.isActive = ds_regist.Tables[0].Rows[j]["oIS_ACTIVE"].ToString();

                        _obj.serviceObj = _obj1;


                        _result.Add(_obj);
                    }

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }





        public static List<campaignExpObj> getListExpireOfCam(string id, string users, string campaignId, string fromDate
            , string toDate, string order, string rowsOnPage, string seqPage, string channel,
            string language, out string _rowsOnPage, out string _seqPage, out string _totalPage)
        {

            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignExpObj> _result = new List<campaignExpObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camExpGetList(id, users, campaignId, fromDate, toDate, order, rowsOnPage, seqPage, channel, language);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();



                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignExpObj _obj = new campaignExpObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.campaignId = ds_regist.Tables[0].Rows[j]["CAMPAIGN_ID"].ToString();
                        _obj.expireId = ds_regist.Tables[0].Rows[j]["REF_ID"].ToString();
                        _obj.isDelete = ds_regist.Tables[0].Rows[j]["IS_DELETE"].ToString();
                        _obj.note = ds_regist.Tables[0].Rows[j]["NOTE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();


                        expireDate _obj1 = new expireDate();

                        _obj1.id = ds_regist.Tables[0].Rows[j]["oid"].ToString();
                        _obj1.code = ds_regist.Tables[0].Rows[j]["ocode"].ToString();
                        _obj1.name = ds_regist.Tables[0].Rows[j]["oname"].ToString();
                        _obj1.totalDay = ds_regist.Tables[0].Rows[j]["oTOTAL_DAY_USE"].ToString();

                        _obj1.min = ds_regist.Tables[0].Rows[j]["oV_MIN"].ToString();
                        _obj1.max = ds_regist.Tables[0].Rows[j]["oV_MAX"].ToString();

                        _obj1.note = ds_regist.Tables[0].Rows[j]["oNOTE"].ToString();
                        _obj1.usersCreated = ds_regist.Tables[0].Rows[j]["oUSERS_CREATED"].ToString();
                        _obj1.dateCreated = ds_regist.Tables[0].Rows[j]["oDATE_CREATED"].ToString();
                        _obj1.usersUpdate = ds_regist.Tables[0].Rows[j]["oUSERS_UPDATE"].ToString();
                        _obj1.dateUpdate = ds_regist.Tables[0].Rows[j]["oDATE_UPDATE"].ToString();

                        _obj1.isActive = ds_regist.Tables[0].Rows[j]["oIS_ACTIVE"].ToString();

                        _obj.expireDate = _obj1;

                        _result.Add(_obj);
                    }

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }




        public static List<campaignScObj> getListShortCodeOfCam(string id, string users, string campaignId, string fromDate
            , string toDate, string order, string rowsOnPage, string seqPage, string channel,
            string language, out string _rowsOnPage, out string _seqPage, out string _totalPage)
        {

            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignScObj> _result = new List<campaignScObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camScGetList(id, users, campaignId, fromDate, toDate, order, rowsOnPage, seqPage, channel, language);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();



                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignScObj _obj = new campaignScObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.campaignId = ds_regist.Tables[0].Rows[j]["CAMPAIGN_ID"].ToString();
                        _obj.shortCodeId = ds_regist.Tables[0].Rows[j]["REF_ID"].ToString();
                        _obj.isDelete = ds_regist.Tables[0].Rows[j]["IS_DELETE"].ToString();
                        _obj.note = ds_regist.Tables[0].Rows[j]["NOTE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();


                        shortCodeObj _obj1 = new shortCodeObj();

                        _obj1.id = ds_regist.Tables[0].Rows[j]["oid"].ToString();
                        _obj1.name = ds_regist.Tables[0].Rows[j]["oname"].ToString();
                        _obj.shortCodeObj = _obj1;

                        _result.Add(_obj);
                    }

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }



        public static List<campaignBalObj> getListBalanceOfCam(string id, string users, string campaignId, string fromDate
            ,string toDate, string order, string rowsOnPage, string seqPage, string channel, 
            string language, out string _rowsOnPage, out string _seqPage, out string _totalPage)
        {

            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignBalObj> _result = new List<campaignBalObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camBalGetList(id, users, campaignId, fromDate, toDate, order, rowsOnPage, seqPage, channel, language);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();


                    
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignBalObj _obj = new campaignBalObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.campaignId = ds_regist.Tables[0].Rows[j]["CAMPAIGN_ID"].ToString();
                        _obj.balanceId = ds_regist.Tables[0].Rows[j]["REF_ID"].ToString();
                        _obj.isDelete = ds_regist.Tables[0].Rows[j]["IS_DELETE"].ToString();
                        _obj.note = ds_regist.Tables[0].Rows[j]["NOTE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();



                        balanceObj _obj1 = new balanceObj();

                        _obj1.id = ds_regist.Tables[0].Rows[j]["oid"].ToString();
                        _obj1.code = ds_regist.Tables[0].Rows[j]["ocode"].ToString();
                        _obj1.name = ds_regist.Tables[0].Rows[j]["oname"].ToString();
                        _obj1.min = ds_regist.Tables[0].Rows[j]["ov_min"].ToString();
                        _obj1.max = ds_regist.Tables[0].Rows[j]["ov_max"].ToString();
                        _obj1.isActive = ds_regist.Tables[0].Rows[j]["oIS_ACTIVE"].ToString();

                        _obj1.note = ds_regist.Tables[0].Rows[j]["oNOTE"].ToString();
                        _obj1.usersCreated = ds_regist.Tables[0].Rows[j]["oUSERS_CREATED"].ToString();
                        _obj1.dateCreated = ds_regist.Tables[0].Rows[j]["oDATE_CREATED"].ToString();
                        _obj1.usersUpdate = ds_regist.Tables[0].Rows[j]["oUSERS_UPDATE"].ToString();
                        _obj1.dateUpdate = ds_regist.Tables[0].Rows[j]["oDATE_UPDATE"].ToString();

                        _obj.balanceObj = _obj1;


                        _result.Add(_obj);
                    }

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }




        public static List<campaignSubObj> getListSubOfCam(string id, string users, string campaignId, string fromDate
            , string toDate, string order, string rowsOnPage, string seqPage, string channel,
            string language, out string _rowsOnPage, out string _seqPage, out string _totalPage)
        {

            _rowsOnPage = rowsOnPage;
            _seqPage = seqPage;
            _totalPage = "100";
            List<campaignSubObj> _result = new List<campaignSubObj>();
            try
            {
                DataSet ds_regist = balanceDataAccess.camSubGetList(id, users, campaignId, fromDate, toDate, order, rowsOnPage, seqPage, channel, language);
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {


                    _rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    _seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    _totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();



                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        campaignSubObj _obj = new campaignSubObj();

                        _obj.id = ds_regist.Tables[0].Rows[j]["ID"].ToString();
                        _obj.campaignId = ds_regist.Tables[0].Rows[j]["CAMPAIGN_ID"].ToString();
                        _obj.subId = ds_regist.Tables[0].Rows[j]["REF_ID"].ToString();
                        _obj.isDelete = ds_regist.Tables[0].Rows[j]["IS_DELETE"].ToString();
                        _obj.note = ds_regist.Tables[0].Rows[j]["NOTE"].ToString();

                        _obj.usersCreated = ds_regist.Tables[0].Rows[j]["USERS_CREATED"].ToString();
                        _obj.dateCreated = ds_regist.Tables[0].Rows[j]["DATE_CREATED"].ToString();
                        _obj.usersUpdate = ds_regist.Tables[0].Rows[j]["USERS_UPDATE"].ToString();
                        _obj.dateUpdate = ds_regist.Tables[0].Rows[j]["DATE_UPDATE"].ToString();



                        listSubObj _obj1 = new listSubObj();

                        _obj1.id = ds_regist.Tables[0].Rows[j]["oid"].ToString();
                        _obj1.code = ds_regist.Tables[0].Rows[j]["ocode"].ToString();
                        _obj1.name = ds_regist.Tables[0].Rows[j]["oname"].ToString();

                        _obj1.listType = ds_regist.Tables[0].Rows[j]["oLIST_TYPE"].ToString();
                        _obj1.status = ds_regist.Tables[0].Rows[j]["oSTATUS"].ToString();
                        _obj1.totalFile = ds_regist.Tables[0].Rows[j]["oTOTAL_FILE"].ToString();
                        _obj1.totalRecord = ds_regist.Tables[0].Rows[j]["oTOTAL_RECORD"].ToString();
                        _obj1.totalSuccess = ds_regist.Tables[0].Rows[j]["oTOTAL_SUCCESS"].ToString();
                        _obj1.totalFalse = ds_regist.Tables[0].Rows[j]["oTOTAL_FALSE"].ToString();
                        _obj1.isDelete = ds_regist.Tables[0].Rows[j]["oIS_DELETE"].ToString();



                        _obj1.note = ds_regist.Tables[0].Rows[j]["oNOTE"].ToString();
                        _obj1.usersCreated = ds_regist.Tables[0].Rows[j]["oUSERS_CREATED"].ToString();
                        _obj1.dateCreated = ds_regist.Tables[0].Rows[j]["oDATE_CREATED"].ToString();
                        _obj1.usersUpdate = ds_regist.Tables[0].Rows[j]["oUSERS_UPDATE"].ToString();
                        _obj1.dateUpdate = ds_regist.Tables[0].Rows[j]["oDATE_UPDATE"].ToString();

                        _obj1.isActive = ds_regist.Tables[0].Rows[j]["oIS_ACTIVE"].ToString();

                        _obj.listSubObj = _obj1;




                        _result.Add(_obj);
                    }

                }
            }
            catch (Exception ex)
            {

            }
            return _result;
        }



    }
}