public List <PreclouserchargesDTO> ViewPreclouserCharges(string ConnectionString)
{
lstPreclousercharges = new List <PreclouserchargesDTO>();
try
{
dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "SELECT TBL.RECORDID,TBL.LOANTYPEID,TLP.LOANTYPE,TBL.LOANID,TML.LOANNAME,TBL.ISCHARGEAPPLICABLE,TBL.CHARGECALTYPE,TBL.CHARGECALONFIELD,TBL.CHARGESVALUE,TBL.ISTAXAPPLICABLE,TBL.TAXTYPE,TBL.TAXPERCENTAGE,TBL.LOCKINGPERIOD,TBL.LOCKINGPERIODTYPE,STATUSNAME FROM TBLMSTLOANPRECLOUSERCHARGES TBL JOIN TBLMSTLOANTYPES TLP ON TBL.LOANTYPEID = TLP.LOANTYPEID JOIN TBLMSTLOANS TML ON TBL.LOANID = TML.LOANID JOIN TBLMSTSTATUS TS ON TBL.STATUSID = TS.STATUSID where TBL.STATUSID=1 ORDER BY TBL.RECORDID");
while (dr.Read())
{
objpreclousercharegs = new PreclouserchargesDTO();
objpreclousercharegs.pRecordid = Convert.ToInt64(dr["RECORDID"]);
objpreclousercharegs.pLoantypeid = Convert.ToInt64(dr["LOANTYPEID"]);
objpreclousercharegs.pLoantype = dr["LOANTYPE"].ToString();
objpreclousercharegs.pLoanid = Convert.ToInt64(dr["Loanid"]);
objpreclousercharegs.pLoanname = dr["LOANNAME"].ToString();
objpreclousercharegs.pIschargeapplicable = dr["Ischargeapplicable"].ToString();
objpreclousercharegs.pChargecaltype = dr["Chargecaltype"].ToString();
objpreclousercharegs.pChargecalonfield = dr["Chargecalonfield"].ToString();
objpreclousercharegs.pChargesvalue = Convert.ToInt64(dr["Chargesvalue"]);
objpreclousercharegs.pIstaxapplicable = dr["Istaxapplicable"].ToString();
objpreclousercharegs.pTaxtype = dr["Taxtype"].ToString();
objpreclousercharegs.pTaxpercentage = Convert.ToInt64(dr["Taxpercentage"]);
objpreclousercharegs.pLockingperiod = Convert.ToInt64(dr["Lockingperiod"]);
objpreclousercharegs.pLockingperiodtype = dr["Lockingperiodtype"].ToString();
objpreclousercharegs.pStatusname = dr["STATUSNAME"].ToString();
lstPreclousercharges.Add(objpreclousercharegs);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstPreclousercharges);
}
public IActionResult UpdatePreclouserCharges(PreclouserchargesDTO _preclouserCharges)
{
bool isSaved = false;
try
{
isSaved = objChargemaster.UpdatePreclouserCharges(_preclouserCharges, Con);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(isSaved));
}
public bool UpdatePreclouserCharges(PreclouserchargesDTO PreclouserCharges, string ConnectionString)
{
bool isSaved = false;
try
{
NPGSqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, "Update TBLMSTLOANPRECLOUSERCHARGES Set ISCHARGEAPPLICABLE='" + ManageQuote(PreclouserCharges.pIschargeapplicable) + "',CHARGECALTYPE='" + ManageQuote(PreclouserCharges.pChargecaltype) + "',CHARGECALONFIELD='" + ManageQuote(PreclouserCharges.pChargecalonfield) + "',CHARGESVALUE=" + PreclouserCharges.pChargesvalue + ",ISTAXAPPLICABLE='" + ManageQuote(PreclouserCharges.pIstaxapplicable) + "', TAXTYPE='" + ManageQuote(PreclouserCharges.pTaxtype) + "',TAXPERCENTAGE=" + PreclouserCharges.pTaxpercentage + ",LOCKINGPERIOD=" + PreclouserCharges.pLockingperiod + ",LOCKINGPERIODTYPE='" + ManageQuote(PreclouserCharges.pLockingperiodtype) + "',MODIFIEDBY=" + PreclouserCharges.pCreatedby + ",MODIFIEDDATE=current_timestamp where RECORDID=" + PreclouserCharges.pRecordid + " ;");
isSaved = true;
}
catch (Exception)
{
throw;
}
return(isSaved);
}
public bool SavePreclouserCharges(PreclouserchargesDTO PreclouserCharges, string ConnectionString)
{
bool isSaved = false;
try
{
NPGSqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, "insert into TBLMSTLOANPRECLOUSERCHARGES(LOANTYPEID,LOANID,ISCHARGEAPPLICABLE,CHARGECALTYPE,CHARGECALONFIELD,CHARGESVALUE,ISTAXAPPLICABLE,TAXTYPE,TAXPERCENTAGE,LOCKINGPERIOD,LOCKINGPERIODTYPE,STATUSID,CREATEDBY,CREATEDDATE)values(" + PreclouserCharges.pLoantypeid + "," + PreclouserCharges.pLoanid + ",'" + ManageQuote(PreclouserCharges.pIschargeapplicable) + "','" + ManageQuote(PreclouserCharges.pChargecaltype) + "','" + ManageQuote(PreclouserCharges.pChargecalonfield) + "'," + PreclouserCharges.pChargesvalue + ",'" + ManageQuote(PreclouserCharges.pIstaxapplicable) + "','" + ManageQuote(PreclouserCharges.pTaxtype) + "'," + PreclouserCharges.pTaxpercentage + "," + PreclouserCharges.pLockingperiod + ",'" + ManageQuote(PreclouserCharges.pLockingperiodtype) + "',1," + PreclouserCharges.pCreatedby + ",current_timestamp);");
isSaved = true;
}
catch (Exception ex)
{
throw ex;
}
return(isSaved);
}
