예제 #1
0
 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
     }
 }