//---------------------Add Edit------------------------------- public ActionResult AddEdit(int Id) { AllDropDowns(); //initialize the viewModel responsible for the Editing //To get the record that is to be edited ExpensesViewModel Model = new ExpensesViewModel(); if (Id > 0) { tb_Expenses Expenses = db.tb_Expenses.SingleOrDefault(x => x.Id == Id && x.tb_Status.Status == true); Model.Id = Expenses.Id; Model.Date = Expenses.Date; Model.Exp_SN = Expenses.Exp_SN; Model.Description = Expenses.Description; Model.Inv_No = Expenses.Inv_No; Model.Amount = Expenses.Amount; Model.BranchId = Expenses.BranchId; Model.StatusId = Expenses.StatusId; } //returning resultclass (string viewName, Object Model) // return View(); return(PartialView("AddEditViewPartialView", Model)); }
//-DELETE EXPENSES public JsonResult DeleteExpenses(int Id) { bool result = false; tb_Expenses Expenses = db.tb_Expenses.SingleOrDefault (x => x.tb_Status.Status == true && x.Id == Id); if (Expenses != null) { Expenses.StatusId = 2; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(ExpensesViewModel Model) { try { AllDropDowns(); //TO UPDATE EXISITING RECORD if (Model.Id > 0) { tb_Expenses ExpensesData = db.tb_Expenses.SingleOrDefault(x => x.Id == Model.Id && x.tb_Status.Status == true); ExpensesData.Id = Model.Id; ExpensesData.Date = Model.Date; ExpensesData.Exp_SN = Model.Exp_SN; ExpensesData.Description = Model.Description; ExpensesData.Inv_No = Model.Inv_No; ExpensesData.Amount = Model.Amount; ExpensesData.BranchId = Model.BranchId; ExpensesData.StatusId = Model.StatusId; db.SaveChanges(); } else { //TO INSERT NEW EXPENSES DATA tb_Expenses ExpensesData = new tb_Expenses(); ExpensesData.Id = Model.Id; ExpensesData.Date = Model.Date; ExpensesData.Exp_SN = Model.Exp_SN; ExpensesData.Description = Model.Description; ExpensesData.Inv_No = Model.Inv_No; ExpensesData.Amount = Model.Amount; ExpensesData.BranchId = Model.BranchId; ExpensesData.StatusId = Model.StatusId; db.tb_Expenses.Add(ExpensesData); db.SaveChanges(); } return(View(Model)); } catch (Exception ex) { throw ex; } }