public DisbursementVoucherDto GetDisbursementVoucher(int LoanMasterID) { DisbursementVoucherDto objDisbursementVoucherDto = new DisbursementVoucherDto(); AdoHelper obj = new AdoHelper(); SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@LoanMasterID", LoanMasterID); parms[0].SqlDbType = System.Data.SqlDbType.Int; SqlDataReader Dr = obj.ExecDataReaderProc("uspGetDisbursementVoucher", parms); if (Dr.Read()) { objDisbursementVoucherDto.Amount = Convert.ToDecimal(Dr["Amount"]); objDisbursementVoucherDto.VoucherNumber = Convert.ToString(Dr["VoucherNumber"]); objDisbursementVoucherDto.TransactionMode = Convert.ToString(Dr["TransactionMode"]); objDisbursementVoucherDto.TransactionDate = Convert.ToDateTime(Dr["TransactionDate"]); if (objDisbursementVoucherDto.TransactionMode == "B") { objDisbursementVoucherDto.ChequeDate = Convert.ToDateTime(Dr["ChequeDate"]); objDisbursementVoucherDto.ChequeNumber = Convert.ToString(Dr["ChequeNumber"]); objDisbursementVoucherDto.BankID = Convert.ToInt32(Dr["AHID"]); objDisbursementVoucherDto.BankName = Convert.ToString(Dr["BankName"]); } } return(objDisbursementVoucherDto); }
public ActionResult GenerateVoucher(int LoanMasterId) { BankMasterViewDto objBank = new BankMasterViewDto(); List <BankMasterViewDto> lstFedBanks = _groupReceiptService.GetGroupBanks(); SelectList lstFederationBanks = new SelectList(lstFedBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID); ViewBag.federationbanks = lstFederationBanks; GroupLoanDisbursementService objGLDS = new GroupLoanDisbursementService(); DisbursementVoucherDto voucherDto = objGLDS.GetDisbursementVoucher(LoanMasterId); return(View("GenerateVoucher", voucherDto)); }