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