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