public ActionResult EditStaff(Staff staff) { using (var context = new StaffDbContext()) { if (staff.Id > 0) { // Edit var val = context.Staffs.Where(data => data.Id == staff.Id).FirstOrDefault(); if (val != null) { val.Name = staff.Name; val.Age = staff.Age; val.City = staff.City; } } else { //Save context.Staffs.Add(staff); } context.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult CreateStaff(Staff new_staff) { using (var context = new StaffDbContext()) { context.Staffs.Add(new_staff); //saving changes context.SaveChanges(); } return(RedirectToAction("Index")); }
//------------------------- // Editing //------------------------- public ActionResult EditStaff(int?id) { if (id == null) { return(HttpNotFound()); } using (var context = new StaffDbContext()) { var staff = context.Staffs.Where(data => data.Id == id).FirstOrDefault(); return(View(staff)); } }
// GET: Staff public ActionResult Index() { // The Using Statement used using (var context = new StaffDbContext()) { //selecting all data input in the database var allstaff = (from data in context.Staffs select data).ToList(); return(View(allstaff)); } }
public ActionResult ConfirmDeleteStaff(int?id) { if (id == null) { return(HttpNotFound()); } using (var context = new StaffDbContext()) { var value = context.Staffs.Where(data => data.Id == id).FirstOrDefault(); context.Staffs.Remove(value); context.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Login(Staff objUser) { if (ModelState.IsValid) { using (StaffDbContext db = new StaffDbContext()) { var obj = db.Staffs.Where(a => a.StaffUsername.Equals(objUser.StaffUsername) && a.StaffPassword.Equals(objUser.StaffPassword)).FirstOrDefault(); if (obj != null) { Session["StaffId"] = obj.StaffId.ToString(); Session["StaffUsername"] = obj.StaffUsername.ToString(); return(RedirectToAction("Menu")); } } } return(View(objUser)); }
public StaffService(StaffDbContext context) { this.context = context; }
public HomeController(StaffDbContext context) { _context = context; }
public StaffRepository(StaffDbContext db) { dbCpntext = db; entities = dbCpntext.Set <T>(); }