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