public List <loanconfigurationDTO> getLoanconfigurationDetails(string ConnectionString, Int64 loanid) { loanconfigurationdetails = new List <loanconfigurationDTO>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select loanconfigid, loantype, loanname, loancode, LOANIDCODE,tl.loanid, applicanttype, contacttype, loanpayin, minloanamount, maxloanamount, tenurefrom, tenureto, interesttype, rateofinterest, effectfromdate, statusname from tblmstloantypes tt join tblmstloans tl on tt.loantypeid = tl.loantypeid join TBLMSTLOANCONFIGURATION tc on tl.loanid = tc.loanid join tblmststatus ts on tl.statusid = ts.statusid where tc.loanid=" + loanid + " order by loantype, loanname; ")) { while (dr.Read()) { loanconfigurationDTO objamasterdetails = new loanconfigurationDTO(); objamasterdetails.pLoanconfigid = Convert.ToInt64(dr["loanconfigid"]); objamasterdetails.pLoanid = Convert.ToInt64(dr["loanid"]); objamasterdetails.pContacttype = dr["contacttype"].ToString(); objamasterdetails.pApplicanttype = dr["applicanttype"].ToString(); objamasterdetails.pLoanpayin = dr["loanpayin"].ToString(); objamasterdetails.pMinloanamount = Convert.ToDecimal(dr["minloanamount"]); objamasterdetails.pMaxloanamount = Convert.ToDecimal(dr["maxloanamount"]); objamasterdetails.pTenurefrom = Convert.ToInt64(dr["tenurefrom"]); objamasterdetails.pTenurefrom = Convert.ToInt64(dr["tenurefrom"]); objamasterdetails.pInteresttype = dr["interesttype"].ToString(); objamasterdetails.pMinloanamount = Convert.ToDecimal(dr["rateofinterest"]); objamasterdetails.pEffectfromdate = Convert.ToDateTime(dr["effectfromdate"]); loanconfigurationdetails.Add(objamasterdetails); } } } catch (Exception ex) { throw ex; } return(loanconfigurationdetails); }
public List <loanconfigurationDTO> getLoanpayins(string ConnectionString) { lstLoanpayins = new List <loanconfigurationDTO>(); try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select laonpayin from tblmstloanpayin where statusid=1 order by recordid")) { while (dr.Read()) { loanconfigurationDTO obj = new loanconfigurationDTO(); obj.pLoanpayin = dr["laonpayin"].ToString(); lstLoanpayins.Add(obj); } } } catch (Exception ex) { throw ex; } return(lstLoanpayins); }