public static List <BANK_AND_BRANCH_WISE_BILLING_MODEL> BANK_AND_BRANCH_WISE_BILLING(int?EXID, int?Bank, int?CityID, string FDATE, string TDATE)
{
try
{
DataSet Dt = CRBusinessLogicLayer.BANK_AND_BRANCH_WISE_BILLING(EXID, Bank, CityID, FDATE, TDATE);
List <BANK_AND_BRANCH_WISE_BILLING_MODEL> NPAList = new List <BANK_AND_BRANCH_WISE_BILLING_MODEL>();
foreach (DataRow DR in Dt.Tables[0].Rows)
{
BANK_AND_BRANCH_WISE_BILLING_MODEL NPA = new BANK_AND_BRANCH_WISE_BILLING_MODEL();
NPA.BANKNAME = DR["BANKNAME"].ToString();
NPA.TOTALCOMMISSION = Convert.ToDecimal(DR["TOTALCOMMISSION"].ToString());
NPA.BILL_AMOUNT_RECOVERED = Convert.ToDecimal(DR["BILL_AMOUNT_RECOVERED"].ToString());
NPAList.Add(NPA);
}
return(NPAList);
}
catch (Exception)
{
return(null);
// ignored
}
}