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