public bool InsertBankDepositCashVoucher(BankDepositCashVoucher model) { try { int status = 0; using (SqlConnection connection = DataAccess.CreateConnection()) { SqlCommand command = DataAccess.CreateCommand(connection); DataAccess.CreateStoredprocedure(command, "InsertBankDepositCashVoucher_SP"); DataAccess.AddInParameter(command, "@Amount", SqlDbType.Float, model.Amount); DataAccess.AddInParameter(command, "@Notes", SqlDbType.VarChar, model.Notes); DataAccess.AddInParameter(command, "@UserId", SqlDbType.VarChar, model.UserID); DataAccess.AddInParameter(command, "@BankAccountId", SqlDbType.Int, model.BankAccountId); DataAccess.AddInParameter(command, "@LedgerDate", SqlDbType.VarChar, model.LedgerDate); DataAccess.AddInParameter(command, "@BankLedgerHeadId", SqlDbType.Int, model.BankLedgerHeadId); status = DataAccess.ExecuteNonQuery(command); return(status < 0 ? false : true); } } catch (Exception ex) { return(false); } }
public ActionResult BankDeposit(BankDepositViewModel model) { if (!ModelState.IsValid) { return(RedirectToAction("BankDeposit", "Banks")); } if (model == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { try { bool status = false; int TransactionMethod = (int)model.TransactionMethod; #region Bank Deposit - Payment Method * Cash if (TransactionMethod == 1) { BankDepositCashVoucher Obj = new BankDepositCashVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; status = new BankDA().InsertBankDepositCashVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Cheque else if (TransactionMethod == 2) { BankDepositChequeVoucher Obj = new BankDepositChequeVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankOfChequeId = (int)model.BankOfChequeId; Obj.ChequeNo = model.ChequeNo; Obj.AccountNo = model.AccountNo; Obj.SortCode = model.SortCode; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; Obj.ChequeStauts = (int)ChequeStatus.Floating; status = new BankDA().InsertBankDepositChequeVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Credit Card else if (TransactionMethod == 3) { BankDepositCreditCardVoucher Obj = new BankDepositCreditCardVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankDate = model.BankDate; Obj.CardHolder = model.CardHolderName; Obj.CardNo = model.CreditCardNo; Obj.ExtraAmount = model.ExtraAmount; Obj.LedgerDate = model.LedgerDate; Obj.LedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); status = new BankDA().InsertBankDepositCreditCardVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Debit Card else if (TransactionMethod == 4) { BankDepositDebitCardVoucher Obj = new BankDepositDebitCardVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankDate = model.BankDate; Obj.CardHolder = model.CardHolderName; Obj.CardNo = model.CreditCardNo; Obj.ExtraAmount = model.ExtraAmount; Obj.LedgerDate = model.LedgerDate; Obj.LedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); status = new BankDA().InsertBankDepositDebitCardVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Direct Deposit else if (TransactionMethod == 5) { BankDepositDirectDepositVoucher Obj = new BankDepositDirectDepositVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; status = new BankDA().InsertBankDepositDirectDepositVoucher(Obj); } #endregion return(RedirectToAction("BankLedger", "Banks", new { @id = model.BankAccountId, @BankName = model.BankNames })); } catch (Exception ex) { return(RedirectToAction("BankDeposit", "Banks")); } } }