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