public static List <BranchAbstract> BranchAbstractList(string DateOfTransaction)
        {
            List <BranchAbstract> BranchAbstractList = new List <BranchAbstract>();

            DataTable GetBranchAbstract = BranchAbstractDataAccess.GetInstance.BranchAbstractList(DateOfTransaction);

            foreach (DataRow dr in GetBranchAbstract.Rows)
            {
                BranchAbstract TheBranchAbstract = DataRowToObject(dr);

                BranchAbstractList.Add(TheBranchAbstract);
            }

            return(BranchAbstractList);
        }
        public static BranchAbstract DataRowToObject(DataRow dr)
        {
            BranchAbstract TheBranchAbstract = new BranchAbstract();

            TheBranchAbstract.BusinessNew            = decimal.Parse(dr["BusinessNew"].ToString());
            TheBranchAbstract.BusinessRenew          = decimal.Parse(dr["BusinessRenew"].ToString());
            TheBranchAbstract.BusinessOneTime        = decimal.Parse(dr["BusinessOneTime"].ToString());
            TheBranchAbstract.PaymentLoan            = decimal.Parse(dr["PaymentLoan"].ToString());
            TheBranchAbstract.RecoveryLoan           = decimal.Parse(dr["RecoveryLoan"].ToString());
            TheBranchAbstract.PaymentMaturity        = decimal.Parse(dr["PaymentMaturity"].ToString());
            TheBranchAbstract.DateOfTransaction      = DateTime.Parse(dr["DateOfTransaction"].ToString()).ToString(MicroConstants.DateFormat);
            TheBranchAbstract.OfficeTypeAbbreviation = dr["OfficeTypeAbbreviation"].ToString();
            TheBranchAbstract.OfficeTypeDescription  = dr["OfficeTypeDescription"].ToString();
            TheBranchAbstract.OfficeTypeID           = int.Parse(dr["OfficeTypeID"].ToString());
            TheBranchAbstract.OfficeName             = dr["OfficeName"].ToString();
            TheBranchAbstract.OfficeCode             = dr["OfficeCode"].ToString();
            TheBranchAbstract.OfficeID = int.Parse(dr["OfficeID"].ToString());

            return(TheBranchAbstract);
        }