예제 #1
0
        public static DailyReportData[] GET_DAILY_REPORT_RELATED_DATA(int?EXID, string BankID, string Branch, int?CityID, string DATE, int?STATUS)
        {
            try
            {
                List <DailyReportData> details = new List <DailyReportData>();
                DataTable dt = CRBusinessLogicLayer.GET_DAILY_REPORT_RELATED_DATA(EXID, BankID, Branch, CityID, DATE, STATUS).Tables[0];

                foreach (DataRow dtrow in dt.Rows)
                {
                    DailyReportData DailyR = new DailyReportData();
                    DailyR.NAMEOFTHEEXECUTIVE       = dtrow["NAME OF THE EXECUTIVE"].ToString();
                    DailyR.TARGET                   = dtrow["TARGET"].ToString();
                    DailyR.NOOFACSALLOTED           = dtrow["NO. OF A/C'S ALLOTED"].ToString();
                    DailyR.NOOFNEWALLOTED           = dtrow["NO. OF NEW ALLOTED"].ToString();
                    DailyR.NOOFACSATTEMPTEDTODAY    = dtrow["NO. OF A/CS ATTEMPTED TODAY"].ToString();
                    DailyR.NOOFACSATTEMPTEDTILLDATE = dtrow["NO.OF A/CS ATTEMPTED TILL DATE"].ToString();
                    DailyR.TODAY                 = dtrow["TODAY"].ToString();
                    DailyR.TILLDATE              = dtrow["TILL DATE"].ToString();
                    DailyR.BANK                  = dtrow["BANK"].ToString();
                    DailyR.BRANCH                = dtrow["BRANCH"].ToString();
                    DailyR.ACCOUNTNO             = dtrow["ACCOUNT NO."].ToString();
                    DailyR.CUSTOMERNAME          = dtrow["CUSTOMER NAME"].ToString();
                    DailyR.AGEOFNPA              = dtrow["AGE OF NPA(DAYS)"].ToString();
                    DailyR.BILLNO                = dtrow["BILL NO"].ToString();
                    DailyR.BILLCLAIMED           = dtrow["BILL CLAIMED"].ToString();
                    DailyR.BILLCOLLECTED         = dtrow["BILL COLLECTED"].ToString();
                    DailyR.PERFORMANCEPERCENTAGE = dtrow["PERFORMANCE PERCENTAGE"].ToString();
                    DailyR.STATUS                = dtrow["A/C STATUS"].ToString();
                    details.Add(DailyR);
                }
                return(details.ToArray());
            }
            catch (Exception)
            {
                // ignored
            }
            return(null);
        }