public DepositOBDto InsertLoanOB(DepositOBDto depositOBDto) { for (int i = 0; i < 4; i++) { DepositOBBySlAccountDto depositOBBySlAccountDto = new DepositOBBySlAccountDto(); if (i == 0 && depositOBDto.DepositBalance1 == 0) { break; } else if (i == 1 && depositOBDto.DepositBalance2 == 0) { break; } else if (i == 2 && depositOBDto.DepositBalance3 == 0) { break; } else if (i == 3 && depositOBDto.DepositBalance4 == 0) { break; } depositOBBySlAccountDto = ConvertDepositDtoToDepositBySlAccountDto(depositOBDto, i); DepositOBDll dll = new DepositOBDll(); depositOBBySlAccountDto = dll.InsertDepositOB(depositOBBySlAccountDto); if (i == 0) { depositOBDto.SLAccountNumberAHID1 = depositOBBySlAccountDto.SLAccountNumberAHID; } else if (i == 1) { depositOBDto.SLAccountNumberAHID2 = depositOBBySlAccountDto.SLAccountNumberAHID; } else if (i == 2) { depositOBDto.SLAccountNumberAHID3 = depositOBBySlAccountDto.SLAccountNumberAHID; } else if (i == 3) { depositOBDto.SLAccountNumberAHID4 = depositOBBySlAccountDto.SLAccountNumberAHID; } if (i == 0) { depositOBDto.Id1 = depositOBBySlAccountDto.ID; } else if (i == 1) { depositOBDto.Id2 = depositOBBySlAccountDto.ID; } else if (i == 2) { depositOBDto.Id3 = depositOBBySlAccountDto.ID; } else if (i == 3) { depositOBDto.Id4 = depositOBBySlAccountDto.ID; } } return(depositOBDto); }
public DepositOBBySlAccountDto ConvertDepositDtoToDepositBySlAccountDto(DepositOBDto loanOBDto, int index) { DepositOBBySlAccountDto loanOBByLoanDto = new DepositOBBySlAccountDto(); loanOBByLoanDto.GroupId = loanOBDto.GroupId; loanOBByLoanDto.MemberId = loanOBDto.MemberId; loanOBByLoanDto.UserID = loanOBDto.UserID; if (loanOBDto.MemberId > 0) { loanOBByLoanDto.IsMemberDeposit = true; } else { loanOBByLoanDto.IsMemberDeposit = false; } if (index == 0) { loanOBByLoanDto.ID = loanOBDto.Id1; loanOBByLoanDto.DemandAmountPerMonth = loanOBDto.DemandAmountPerMonth1; loanOBByLoanDto.DepositAmount = loanOBDto.DepositBalance1; loanOBByLoanDto.DepositDate = loanOBDto.DepositDate1; loanOBByLoanDto.InterestAcmount = loanOBDto.IneterestDue1; loanOBByLoanDto.InterestMasterID = loanOBDto.Interest1; loanOBByLoanDto.LastPaidDate = loanOBDto.LastPaidDate1; loanOBByLoanDto.MeturityDate = loanOBDto.MeturityDate1; loanOBByLoanDto.Period = loanOBDto.Period1; loanOBByLoanDto.SLAccountNumberAHID = loanOBDto.SLAccountNumberAHID1; loanOBByLoanDto.SLAccountNumber = loanOBDto.SLAccountNumber1; } else if (index == 1) { loanOBByLoanDto.ID = loanOBDto.Id2; loanOBByLoanDto.DemandAmountPerMonth = loanOBDto.DemandAmountPerMonth2; loanOBByLoanDto.DepositAmount = loanOBDto.DepositBalance2; loanOBByLoanDto.DepositDate = loanOBDto.DepositDate2; loanOBByLoanDto.InterestAcmount = loanOBDto.IneterestDue2; loanOBByLoanDto.InterestMasterID = loanOBDto.Interest2; loanOBByLoanDto.LastPaidDate = loanOBDto.LastPaidDate2; loanOBByLoanDto.MeturityDate = loanOBDto.MeturityDate2; loanOBByLoanDto.Period = loanOBDto.Period2; loanOBByLoanDto.SLAccountNumberAHID = loanOBDto.SLAccountNumberAHID2; loanOBByLoanDto.SLAccountNumber = loanOBDto.SLAccountNumber2; } else if (index == 2) { loanOBByLoanDto.ID = loanOBDto.Id3; loanOBByLoanDto.DemandAmountPerMonth = loanOBDto.DemandAmountPerMonth3; loanOBByLoanDto.DepositAmount = loanOBDto.DepositBalance3; loanOBByLoanDto.DepositDate = loanOBDto.DepositDate3; loanOBByLoanDto.InterestAcmount = loanOBDto.IneterestDue3; loanOBByLoanDto.InterestMasterID = loanOBDto.Interest3; loanOBByLoanDto.LastPaidDate = loanOBDto.LastPaidDate3; loanOBByLoanDto.MeturityDate = loanOBDto.MeturityDate3; loanOBByLoanDto.Period = loanOBDto.Period3; loanOBByLoanDto.SLAccountNumberAHID = loanOBDto.SLAccountNumberAHID3; loanOBByLoanDto.SLAccountNumber = loanOBDto.SLAccountNumber3; } else if (index == 3) { loanOBByLoanDto.ID = loanOBDto.Id4; loanOBByLoanDto.DemandAmountPerMonth = loanOBDto.DemandAmountPerMonth4; loanOBByLoanDto.DepositAmount = loanOBDto.DepositBalance4; loanOBByLoanDto.DepositDate = loanOBDto.DepositDate4; loanOBByLoanDto.InterestAcmount = loanOBDto.IneterestDue4; loanOBByLoanDto.InterestMasterID = loanOBDto.Interest4; loanOBByLoanDto.LastPaidDate = loanOBDto.LastPaidDate4; loanOBByLoanDto.MeturityDate = loanOBDto.MeturityDate4; loanOBByLoanDto.Period = loanOBDto.Period4; // loanOBByLoanDto.SLAccountAHID = loanOBDto.SLAccountNumberAHID4; loanOBByLoanDto.SLAccountNumberAHID = loanOBDto.SLAccountNumberAHID4; loanOBByLoanDto.SLAccountNumber = loanOBDto.SLAccountNumber4; } return(loanOBByLoanDto); }
public DepositOBBySlAccountDto InsertDepositOB(DepositOBBySlAccountDto loanOBDto) { DepositOBBySlAccountDto result = loanOBDto; try { AdoHelper obj = new AdoHelper(); SqlParameter[] parms = null; if (loanOBDto.MemberId > 0) { parms = new SqlParameter[] { new SqlParameter("@ID", loanOBDto.ID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@IsMemberDeposit", loanOBDto.IsMemberDeposit) { SqlDbType = System.Data.SqlDbType.Bit }, new SqlParameter("@MemberID", loanOBDto.MemberId) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@GroupID", loanOBDto.GroupId) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@SLAccountAHID", loanOBDto.SLAccountNumberAHID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@DepositAcmount", loanOBDto.DepositAmount) { SqlDbType = System.Data.SqlDbType.Decimal }, new SqlParameter("@ROI", loanOBDto.ROI) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@InterestMasterID", loanOBDto.InterestMasterID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@InterestRateID", loanOBDto.InterestRateID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@UserID", loanOBDto.UserID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@SlAccountNumber", loanOBDto.SLAccountNumber) { SqlDbType = System.Data.SqlDbType.VarChar } } } ; else { parms = new SqlParameter[] { new SqlParameter("@ID", loanOBDto.ID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@IsMemberDeposit", loanOBDto.IsMemberDeposit) { SqlDbType = System.Data.SqlDbType.Bit }, new SqlParameter("@GroupID", loanOBDto.GroupId) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@SLAccountAHID", loanOBDto.SLAccountNumberAHID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@DepositAcmount", loanOBDto.DepositAmount) { SqlDbType = System.Data.SqlDbType.Decimal }, new SqlParameter("@ROI", loanOBDto.ROI) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@InterestMasterID", loanOBDto.InterestMasterID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@InterestRateID", loanOBDto.InterestRateID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@UserID", loanOBDto.UserID) { SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter("@SlAccountNumber", loanOBDto.SLAccountNumber) { SqlDbType = System.Data.SqlDbType.VarChar } } }; SqlDataReader sdr = obj.ExecDataReaderProc("uspDepositInsertUpdate", parms); while (sdr.Read()) { result.ID = Convert.ToInt32(sdr["ID"]); if (sdr["SLAccountNumberAHID"] != DBNull.Value) { result.SLAccountNumberAHID = Convert.ToInt32(sdr["SLAccountNumberAHID"]); } } } catch (Exception ex) { throw ex; } return(result); }