// GET: Transaction public ActionResult Index() { TranViewModel tvm; RoadsEntities dbCxt = new RoadsEntities(); tvm = new TranViewModel(); tvm.Machs = dbCxt.tblMaches.ToList(); tvm.Acts = dbCxt.tblActs.ToList(); tvm.Emps = dbCxt.tblEmps.ToList(); tvm.Roads = dbCxt.tblRoads.ToList(); tvm.Transactions = dbCxt.tblTransactions.ToList(); return(View("LoadTransaction", tvm)); }
public ActionResult AddTransaction(TranViewModel tvm) { using (RoadsEntities db = new RoadsEntities()) { tblTransaction tt = new tblTransaction(); tt.Trans_Date = tvm.Trans_Date; tt.Emp_No = tvm.Emp_no; tt.Mach_No = tvm.Mach_No; tt.BIA_No = tvm.BIA_No; tt.Activity_Code = tvm.Activity_Code; tt.Hours = tvm.Hours; tt.Lease_Chg = tvm.Lease_Chg; db.tblTransactions.Add(tt); db.SaveChanges(); ModelState.Clear(); } return(RedirectToAction("Index")); }
public ActionResult EditingInline_Update([DataSourceRequest] DataSourceRequest request, TranViewModel tran) { RoadsEntities db = new RoadsEntities(); var t = db.tblTransactions.Where(tr => tr.AutoNumber.Equals(tran.AutoNumber)).FirstOrDefault(); t.Hours = tran.Hours; t.Lease_Chg = tran.Lease_Chg; db.SaveChanges(); return(Json(new[] { tran }.ToDataSourceResult(request, ModelState))); }