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