public async Task <List <SavingAccountConfigDTO> > GetSavingAccountConfigMasterDetails(string ConnectionString, Int64 SavingAccountId)
{
await Task.Run(() =>
{
listsavingAccountConfig = new List <SavingAccountConfigDTO>();
try
{
SavingAccountConfigDTO _objSavingAccountConfig = new SavingAccountConfigDTO
{
SavingAccountNameandCodelist = getSavingAccountNameandCode(ConnectionString, SavingAccountId),
savingAccountConfiglist = getSavingAccountConfigDetails(ConnectionString, SavingAccountId),
getidentificationdocumentsList = Getdocumentidprofftypes(ConnectionString, SavingAccountId),
ReferralCommissionList = getReferralcommissionDetails(ConnectionString, SavingAccountId),
LoanFacilityList = getLoanFacilityDetails(ConnectionString, SavingAccountId)
};
listsavingAccountConfig.Add(_objSavingAccountConfig);
}
catch (Exception ex)
{
throw ex;
}
});
return(listsavingAccountConfig);
}
public IActionResult saveAccountConfig(SavingAccountConfigDTO savingaccountconfiglist)
{
bool isSaved = false;
try
{
isSaved = objSavingAccountConfig.SaveSavingAccountConfiguration(savingaccountconfiglist, Con);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(isSaved));
}
public IActionResult DeleteSavingAccountConfig(SavingAccountConfigDTO savingaccountconfiglist)
{
bool isSaved = false;
// lstLoanMasterdetails = new List<LoansMasterDTO>();
Int64 savingAccountid = savingaccountconfiglist.pSavingAccountid;
int modifiedby = savingaccountconfiglist.pModifiedby;
try
{
isSaved = objSavingAccountConfig.DeleteSavingAccountConfig(savingAccountid, modifiedby, Con);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(isSaved));
}
public bool SaveSavingAccountConfiguration(SavingAccountConfigDTO objsavingAccountConfig, string connectionstring)
{
bool isSaved = false;
StringBuilder sbinsert = new StringBuilder();
string Recordid = string.Empty;
string query = "";
int createdby = 0;
Int64 savingConfigid = 0;
try
{
con = new NpgsqlConnection(connectionstring);
if (con.State != ConnectionState.Open)
{
con.Open();
}
trans = con.BeginTransaction();
for (int i = 0; i < objsavingAccountConfig.savingAccountConfiglist.Count; i++)
{
if (objsavingAccountConfig.savingAccountConfiglist[i].ptypeofoperation != "CREATE")
{
if (string.IsNullOrEmpty(Recordid))
{
Recordid = objsavingAccountConfig.savingAccountConfiglist[i].pRecordid.ToString();
}
else
{
Recordid = Recordid + "," + objsavingAccountConfig.savingAccountConfiglist[i].pRecordid.ToString();
}
}
if (objsavingAccountConfig.savingAccountConfiglist != null)
{
if (string.IsNullOrEmpty(objsavingAccountConfig.savingAccountConfiglist[i].pSavingmindepositamount.ToString()))
{
objsavingAccountConfig.savingAccountConfiglist[i].pSavingmindepositamount = 0;
}
if (string.IsNullOrEmpty(objsavingAccountConfig.savingAccountConfiglist[i].pSavingmaxdepositamount.ToString()))
{
objsavingAccountConfig.savingAccountConfiglist[i].pSavingmaxdepositamount = 0;
}
if (string.IsNullOrEmpty(objsavingAccountConfig.savingAccountConfiglist[i].pMaxwithdrawllimit.ToString()))
{
objsavingAccountConfig.savingAccountConfiglist[i].pMaxwithdrawllimit = 0;
}
if (string.IsNullOrEmpty(objsavingAccountConfig.savingAccountConfiglist[i].pPenaltyvalue.ToString()))
{
objsavingAccountConfig.savingAccountConfiglist[i].pPenaltyvalue = 0;
}
if (objsavingAccountConfig.savingAccountConfiglist[i].ptypeofoperation == "UPDATE")
{
sbinsert.Append("update tblmstSavingAccountConfigdetails set membertypeid=" + objsavingAccountConfig.savingAccountConfiglist[i].pMembertypeid + ",membertype='" + objsavingAccountConfig.savingAccountConfiglist[i].pMembertype + "',applicanttype='" + objsavingAccountConfig.savingAccountConfiglist[i].pApplicanttype + "',minopenamount=" + objsavingAccountConfig.savingAccountConfiglist[i].pMinopenamount + ",minmaintainbalance =" + objsavingAccountConfig.savingAccountConfiglist[i].pMinbalance + ",interestpayout='" + objsavingAccountConfig.savingAccountConfiglist[i].pInterestpayout + "',interestrate=" + objsavingAccountConfig.savingAccountConfiglist[i].pInterestrate + ",iswithdrawallimitapplicable=" + objsavingAccountConfig.savingAccountConfiglist[i].pIswithdrawallimitapplicable + ",withdrawallimitpayout='" + objsavingAccountConfig.savingAccountConfiglist[i].pWithdrawallimitpayout + "',maxwithdrawallimit=" + objsavingAccountConfig.savingAccountConfiglist[i].pMaxwithdrawllimit + ",ispenaltyapplicableonminbal=" + objsavingAccountConfig.savingAccountConfiglist[i].pIspenaltyapplicableonminbal + ",penaltycaltype='" + objsavingAccountConfig.savingAccountConfiglist[i].pPenaltycaltype + "',penaltyvalue=" + objsavingAccountConfig.savingAccountConfiglist[i].pPenaltyvalue + ",issavingspayinapplicable=" + objsavingAccountConfig.savingAccountConfiglist[i].pIssavingspayinapplicable + "," +
"savingspayinmode='" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingspayinmode + "',savingmindepositamount=" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingmindepositamount + ",savingmaxdepositamount=" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingmaxdepositamount + ",modifiedby =" + objsavingAccountConfig.pCreatedby + ",modifieddate=current_timestamp where savingconfigid =" + objsavingAccountConfig.pSavingAccountid + ";");
}
else if (objsavingAccountConfig.savingAccountConfiglist[i].ptypeofoperation == "CREATE")
{
sbinsert.Append("insert into tblmstSavingAccountConfigdetails(savingconfigid, savingaccname, membertypeid, membertype, applicanttype, minopenamount, minmaintainbalance, interestpayout , interestrate, iswithdrawallimitapplicable, withdrawallimitpayout, maxwithdrawallimit ,ispenaltyapplicableonminbal,penaltycaltype,penaltyvalue,issavingspayinapplicable,savingspayinmode,savingmindepositamount,savingmaxdepositamount, statusid, createdby, createddate)values(" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingConfigid + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingAccname + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pMembertypeid + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pMembertype + "','" + objsavingAccountConfig.savingAccountConfiglist[i].pApplicanttype + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pMinopenamount + "," + objsavingAccountConfig.savingAccountConfiglist[i].pMinbalance + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pInterestpayout + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pInterestrate + "," + objsavingAccountConfig.savingAccountConfiglist[i].pIswithdrawallimitapplicable + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pWithdrawallimitpayout + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pMaxwithdrawllimit + "," + objsavingAccountConfig.savingAccountConfiglist[i].pIspenaltyapplicableonminbal + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pPenaltycaltype + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pPenaltyvalue + "," + objsavingAccountConfig.savingAccountConfiglist[i].pIssavingspayinapplicable + ",'" + objsavingAccountConfig.savingAccountConfiglist[i].pSavingspayinmode + "'," + objsavingAccountConfig.savingAccountConfiglist[i].pSavingmindepositamount + "," + objsavingAccountConfig.savingAccountConfiglist[i].pSavingmaxdepositamount + "," + Convert.ToInt32(Status.Active) + "," + objsavingAccountConfig.savingAccountConfiglist[i].pCreatedby + ",current_timestamp);");
}
}
}
if (!string.IsNullOrEmpty(Recordid))
{
query = "update tblmstSavingAccountConfigdetails set statusid=" + getStatusid("In-Active", connectionstring) + ",modifiedby=" + objsavingAccountConfig.pCreatedby + ",modifieddate=current_timestamp where savingconfigid=" + objsavingAccountConfig.pSavingAccountid + " and recordid not in(" + Recordid + ");";
}
else
{
query = "update tblmstSavingAccountConfigdetails set statusid=" + getStatusid("In-Active", connectionstring) + ",modifiedby=" + objsavingAccountConfig.pCreatedby + ",modifieddate=current_timestamp where savingconfigid=" + objsavingAccountConfig.pSavingAccountid + ";";
}
if (!string.IsNullOrEmpty(query))
{
NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, query);
}
if (!string.IsNullOrEmpty(sbinsert.ToString()))
{
NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbinsert.ToString());
}
trans.Commit();
isSaved = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Dispose();
con.Close();
con.ClearPool();
trans.Dispose();
}
}
return(isSaved);
}
