public static List <BankReconHdr> GetPR(NameValueCollection querystring)
        {
            string criteria = querystring.Get("Criteria");
            int    branchID = int.TryParse(querystring.Get("BranchID"), out branchID) ? branchID : 0;

            return(BankReconDAL.GetPR(criteria, branchID));
        }
        public static string UnLockMonth(NameValueCollection querystring)
        {
            string intIDLoc = querystring.Get("BranchID");
            string dtAsof   = querystring.Get("AsOf");

            return(BankReconDAL.UnLockMonth(intIDLoc, dtAsof));
        }
        public static List <BankReconCOABank> getCOABank(NameValueCollection querstring)
        {
            string strcriteria = querstring.Get("Criteria");
            string intIDLoc    = querstring.Get("BranchID");
            string dtAsof      = querstring.Get("AsOf");

            return(BankReconDAL.GetCOABank(strcriteria, intIDLoc, dtAsof));
        }
        public static List <BankReconCOABank> getCOABank3(NameValueCollection querstring)
        {
            string strcriteria     = querstring.Get("Criteria");
            string intIDSubsidiary = querstring.Get("SubID");

            //string intMonth = querstring.Get("intMonth");
            //string intYear = querstring.Get("intYear");

            return(BankReconDAL.GetCOABank3(strcriteria, intIDSubsidiary));
        }
        public static List <BankReconCOABank> getCOABank2(NameValueCollection querstring)
        {
            string strcriteria = querstring.Get("Criteria");

            //string intIDLoc = querstring.Get("BranchID");
            //string intMonth = querstring.Get("intMonth");
            //string intYear = querstring.Get("intYear");

            return(BankReconDAL.GetCOABank2(strcriteria));
        }
        public static string Manage(NameValueCollection querystring, NameValueCollection formdata)
        {
            int     intParser;
            decimal decimalParser;

            UserProfile userProfile = WebCommon.GetUserProfile();

            var cvfgls = new List <BankReconDetail>();

            string isInsert = querystring.Get("transType");

            cvfgls = (List <BankReconDetail>)cvfgls.ToClass(formdata["Data"]);

            bool lck;

            var BnkRecon = new BankReconHdr
            {
                ID = int.TryParse(querystring.Get("BankReconID"), out intParser) ? intParser : 0,
                intIDMasLocation                = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
                intIDMasCOA                     = int.TryParse(querystring.Get("COAID"), out intParser) ? intParser : 0,
                intIDMasCOASubsidiary           = int.TryParse(querystring.Get("COASubsi"), out intParser) ? intParser : 0,
                intIDMasCOAIndividualSubsidiary = int.TryParse(querystring.Get("COAIndividual"), out intParser) ? intParser : 0,
                datAsOf           = querystring.Get("Date"),
                curBalancePerBook = decimal.TryParse(querystring.Get("BalPerBook"), out decimalParser) ? decimalParser : 0,
                curBalancePerBank = decimal.TryParse(querystring.Get("BalPerBank"), out decimalParser) ? decimalParser : 0,
                Remarks           = querystring.Get("BalRemarks"),
                Particulars       = querystring.Get("Particulars"),
                curFundTransfer   = decimal.TryParse(querystring.Get("FundTransfer"), out decimalParser) ? decimalParser : 0,
                intIDSecUser      = userProfile.UserId,
                bolLock           = bool.TryParse(querystring.Get("bolLock"), out lck) ? lck : false,
                BankDetails       = cvfgls
            };

            string param = WebCommon.ToXML(BnkRecon);

            return(BankReconDAL.Manage(param, isInsert));
        }
        public static List <BankReconAREmp> getAREmp(NameValueCollection querstring)
        {
            string strcriteria = querstring.Get("Criteria");

            return(BankReconDAL.GetAREmp(strcriteria));
        }
        public static List <BankReconDetail> GetPRDetail(NameValueCollection querystring)
        {
            int brID = int.TryParse(querystring.Get("BRFundID"), out brID) ? brID : 0;

            return(BankReconDAL.GetPRDetail(brID));
        }