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); }