public IActionResult DeleteSavingAccountTrans(SavingAccountTransactionSave savingAccountTransaction) { bool isSaved = false; // lstLoanMasterdetails = new List<LoansMasterDTO>(); Int64 savingAccountid = savingAccountTransaction.pSavingaccountid; long modifiedby = savingAccountTransaction.pCreatedby; try { isSaved = _SavingAccountTransaction.DeleteSavingTransaction(savingAccountid, modifiedby, Con); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } return(Ok(isSaved)); }
public IActionResult SaveSavingAccountTransaction(SavingAccountTransactionSave _SavingAccountTransactionDetails) { SavingAccountTransactionIdAndNo _SavingAccountTransactionIdAndNo = new SavingAccountTransactionIdAndNo(); try { long Savingaccountid = 0; string Savingaccountno = _SavingAccountTransaction.SaveSavingAccountTransaction(_SavingAccountTransactionDetails, Con, out Savingaccountid); if (!string.IsNullOrEmpty(Savingaccountno)) { _SavingAccountTransactionIdAndNo.pSavingaccountno = Savingaccountno; _SavingAccountTransactionIdAndNo.pSavingaccountid = Savingaccountid; return(Ok(_SavingAccountTransactionIdAndNo)); } else { return(StatusCode(StatusCodes.Status304NotModified)); } } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public string SaveSavingAccountTransaction(SavingAccountTransactionSave _SavingAccountTransactionsave, string ConnectionString, out long pSavingaccountid) { StringBuilder sbSavingAccountTransaction = new StringBuilder(); try { con = new NpgsqlConnection(ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); if (!string.IsNullOrEmpty(_SavingAccountTransactionsave.ptypeofoperation)) { if (string.IsNullOrEmpty(_SavingAccountTransactionsave.pSavingsamount.ToString())) { _SavingAccountTransactionsave.pSavingsamount = 0; } _SavingAccountTransactionsave.pTransdate = "'" + FormatDate(_SavingAccountTransactionsave.pTransdate) + "'"; if (ManageQuote(_SavingAccountTransactionsave.ptypeofoperation).ToUpper() == "CREATE") { if (!string.IsNullOrEmpty(_SavingAccountTransactionsave.pSavingaccname)) { _SavingAccountTransactionsave.pSavingaccountno = NPGSqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, "SELECT FN_GENERATENEXTID('SAVING ACCOUNT','" + _SavingAccountTransactionsave.pSavingaccname + "'," + _SavingAccountTransactionsave.pTransdate + ")").ToString(); } _SavingAccountTransactionsave.pSavingaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "INSERT INTO tbltranssavingaccountcreation(savingaccountno , transdate, membertypeid, membertype ,memberid, applicanttype, membercode, membername,contactid, contacttype, contactreferenceid, savingconfigid,savingaccname,savingsamount, savingsamountpayin,interestpayout,isjointapplicable,isreferralapplicable,statusid, createdby, createddate,isnomineedetailsapplicable) VALUES ('" + ManageQuote(_SavingAccountTransactionsave.pSavingaccountno) + "'," + _SavingAccountTransactionsave.pTransdate + "," + _SavingAccountTransactionsave.pMembertypeid + ",'" + ManageQuote(_SavingAccountTransactionsave.pMembertype) + "'," + _SavingAccountTransactionsave.pMemberid + ",'" + ManageQuote(_SavingAccountTransactionsave.pApplicanttype) + "','" + ManageQuote(_SavingAccountTransactionsave.pMembercode) + "','" + ManageQuote(_SavingAccountTransactionsave.pMembername) + "'," + _SavingAccountTransactionsave.pContactid + ",'" + ManageQuote(_SavingAccountTransactionsave.pContacttype) + "','" + ManageQuote(_SavingAccountTransactionsave.pContactreferenceid) + "'," + _SavingAccountTransactionsave.pSavingconfigid + ",'" + ManageQuote(_SavingAccountTransactionsave.pSavingaccname) + "'," + _SavingAccountTransactionsave.pSavingsamount + ",'" + ManageQuote(_SavingAccountTransactionsave.pSavingsamountpayin) + "','" + ManageQuote(_SavingAccountTransactionsave.pInterestpayout) + "'," + _SavingAccountTransactionsave.pIsjointapplicable + "," + _SavingAccountTransactionsave.pIsreferralapplicable + "," + Convert.ToInt32(Status.Active) + ", '" + _SavingAccountTransactionsave.pCreatedby + "', current_timestamp," + _SavingAccountTransactionsave.pIsNomineesapplicable + ") returning savingaccountid; ")); trans.Commit(); } else if (ManageQuote(_SavingAccountTransactionsave.ptypeofoperation).ToUpper() == "UPDATE") { sbSavingAccountTransaction.AppendLine("UPDATE tbltranssavingaccountcreation SET transdate=" + _SavingAccountTransactionsave.pTransdate + ", membertypeid=" + _SavingAccountTransactionsave.pMembertypeid + ", membertype='" + ManageQuote(_SavingAccountTransactionsave.pMembertype) + "',applicanttype='" + ManageQuote(_SavingAccountTransactionsave.pApplicanttype) + "',savingconfigid=" + _SavingAccountTransactionsave.pSavingconfigid + ",savingaccname='" + _SavingAccountTransactionsave.pSavingaccname + "',savingsamount=" + _SavingAccountTransactionsave.pSavingsamount + ",savingsamountpayin='" + ManageQuote(_SavingAccountTransactionsave.pSavingsamountpayin) + "',interestpayout='" + ManageQuote(_SavingAccountTransactionsave.pInterestpayout) + "' WHERE savingaccountid=" + _SavingAccountTransactionsave.pSavingaccountid + ";"); } } pSavingaccountid = _SavingAccountTransactionsave.pSavingaccountid; string Recordid = string.Empty; if (Convert.ToString(sbSavingAccountTransaction) != string.Empty) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbSavingAccountTransaction.ToString()); trans.Commit(); } } catch (Exception Ex) { trans.Rollback(); throw Ex; } finally { if (con.State == ConnectionState.Open) { con.Dispose(); con.Close(); con.ClearPool(); trans.Dispose(); } } return(_SavingAccountTransactionsave.pSavingaccountno); }