public bool InsertBankWithdrawalForPettyCash(BankWithdrawalChequeVoucher model) { try { int status = 0; using (SqlConnection connection = DataAccess.CreateConnection()) { SqlCommand command = DataAccess.CreateCommand(connection); DataAccess.CreateStoredprocedure(command, "InsertBankWithdrawalForPettyCash_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, "@BankLedgerHeadId", SqlDbType.Int, model.BankLedgerHeadId); DataAccess.AddInParameter(command, "@LedgerDate", SqlDbType.VarChar, model.LedgerDate); status = DataAccess.ExecuteNonQuery(command); return(status < 0 ? false : true); } } catch (Exception ex) { return(false); } }
public ActionResult PettyCashWithdrawal(BankWithdrawalViewModel model) { bool status = false; if (!ModelState.IsValid) { return(RedirectToAction("PettyCashWithdrawal", "Banks")); } if (model == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { BankWithdrawalChequeVoucher Obj = new BankWithdrawalChequeVoucher(); Obj.Amount = model.Amount; Obj.Notes = model.Notes; Obj.BankAccountId = model.BankAccountId; Obj.UserID = User.Identity.GetUserId(); Obj.BankAccountId = model.BankAccountId; Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId; Obj.BankId = (int)model.BankNames; Obj.LedgerDate = model.LedgerDate; status = new BankDA().InsertBankWithdrawalForPettyCash(Obj); } return(RedirectToAction("PettyCashWithdrawal", "Banks")); }