public async Task <IActionResult> GetSavingAccountTransDetails(Int64 SavingAccountId, string accounttype, string savingsaccountNo)
{
SavingsTransactionDataEdit lstSavingAccTransdetails = new SavingsTransactionDataEdit();
try
{
lstSavingAccTransdetails = await _SavingAccountTransaction.GetSavingAccountTransactionEditDetails(Con, SavingAccountId, accounttype, savingsaccountNo);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(lstSavingAccTransdetails));
}
public async Task <SavingsTransactionDataEdit> GetSavingAccountTransactionEditDetails(string ConnectionString, Int64 SavingAccountId, string accounttype, string savingsaccountNo)
{
SavingsTransactionDataEdit _SavingsTransactionDataEdit = new SavingsTransactionDataEdit();
objshareApplicationDAL = new ShareApplicationDAL();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select savingaccountid,savingaccountno,membertypeid,membertype,applicanttype,transdate,contactid,contacttype,memberid,membername,savingconfigid,savingaccname,savingsamount,isjointapplicable,isreferralapplicable,isnomineedetailsapplicable from tbltranssavingaccountcreation where savingaccountid=" + SavingAccountId + " and statusid=" + Convert.ToInt32(Status.Active) + ""))
{
while (dr.Read())
{
_SavingsTransactionDataEdit.pSavingaccountid = Convert.ToInt64(dr["savingaccountid"]);
_SavingsTransactionDataEdit.pSavingaccountno = Convert.ToString(dr["savingaccountno"]);
_SavingsTransactionDataEdit.pMembertypeid = Convert.ToInt64(dr["membertypeid"]);
_SavingsTransactionDataEdit.pMembertype = Convert.ToString(dr["membertype"]);
_SavingsTransactionDataEdit.pApplicanttype = Convert.ToString(dr["applicanttype"]);
_SavingsTransactionDataEdit.pTransdate = Convert.ToDateTime(dr["transdate"]).ToString("dd/MM/yyyy");
_SavingsTransactionDataEdit.pContactid = Convert.ToInt64(dr["contactid"]);
_SavingsTransactionDataEdit.pContacttype = Convert.ToString(dr["contacttype"]);
_SavingsTransactionDataEdit.pMemberid = Convert.ToInt64(dr["memberid"]);
_SavingsTransactionDataEdit.pMembername = Convert.ToString(dr["membername"]);
_SavingsTransactionDataEdit.pSavingconfigid = Convert.ToInt64(dr["savingconfigid"]);
_SavingsTransactionDataEdit.pSavingaccname = Convert.ToString(dr["savingaccname"]);
_SavingsTransactionDataEdit.pSavingsamount = Convert.ToDecimal(dr["savingsamount"]);
_SavingsTransactionDataEdit.pIsjointapplicable = Convert.ToBoolean(dr["isjointapplicable"]);
_SavingsTransactionDataEdit.pIsreferralapplicable = Convert.ToBoolean(dr["isreferralapplicable"]);
_SavingsTransactionDataEdit.pIsNomineesapplicable = Convert.ToBoolean(dr["isnomineedetailsapplicable"]);
_SavingsTransactionDataEdit.ptypeofoperation = Convert.ToString("UPDATE");
_SavingsTransactionDataEdit.JointMembersandContactDetailsList = objshareApplicationDAL.GetJointMembersListInEdit(savingsaccountNo, accounttype, ConnectionString);
_SavingsTransactionDataEdit.MemberNomineeDetailsList = objshareApplicationDAL.GetNomineesListInEdit(savingsaccountNo, accounttype, ConnectionString);
_SavingsTransactionDataEdit.MemberReferalDetails = objshareApplicationDAL.getReferralDetails(ConnectionString, savingsaccountNo, accounttype);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(_SavingsTransactionDataEdit);
}
