// GET: AreaApp/Delete/5 // GET: AreaApp/Delete/5 public ActionResult Delete(tblOperator detailsToEdit) { var d = obj.tblOperators.Where(x => x.id == detailsToEdit.id).FirstOrDefault(); obj.tblOperators.Remove(d); obj.SaveChanges(); return(RedirectToAction("OperatorDetails")); }
public ActionResult Create([Bind(Exclude = "Id")] tblOperator data) { if (!ModelState.IsValid) { return(View()); } obj.tblOperators.Add(data); obj.SaveChanges(); return(RedirectToAction("OperatorDetails")); }
public override string[] GetRolesForUser(string username) { db = new MyEntities(); tblOperator _tblOperator = (from prod in db.tblOperators where prod.Username == username select prod).FirstOrDefault(); var roles = _tblOperator.tblOperatorRights.Where(m => m.WorkCentreID == 1).ToArray(); return(roles.Select(m => m.tblRight.RightName).ToArray()); }
public ActionResult Edit(tblOperator detailsToEdit) { var orignalRecord = (from m in obj.tblOperators where m.id == detailsToEdit.id select m).First(); if (!ModelState.IsValid) { return(View(orignalRecord)); } obj.Entry(orignalRecord).CurrentValues.SetValues(detailsToEdit); obj.SaveChanges(); return(RedirectToAction("OperatorDetails")); }
public ActionResult Create(OperatorModel model) { try { tblOperator tb = new tblOperator(); int UserId = 0; if (model.operatorId == 0) { WebSecurity.CreateUserAndAccount(model.UserName, model.Password, new { Email = model.Email }); Roles.AddUserToRole(model.UserName, "Operator"); UserId = WebSecurity.GetUserId(model.UserName); } if (model.operatorId > 0) { tb = (from p in db.tblOperators where p.Operatorid.Equals(model.operatorId) select p).SingleOrDefault(); UpdateOperatorEmail(model.Email, model.UserId); } tb.Active = model.Active; tb.ContactNo = model.ContactNo; tb.Name = model.Name; tb.Type = model.Type; tb.OutletId = WebSecurity.CurrentUserId; if (model.operatorId == 0) { tb.UserId = UserId; } if (model.operatorId > 0) { db.SaveChanges(); TempData["optrerror"] = "Record Updated Successfully..."; TempData["Ok"] = "OK"; } else { db.tblOperators.Add(tb); db.SaveChanges(); TempData["optrerror"] = "Record Saved Successfully..."; TempData["Ok"] = "OK"; } } catch (Exception ex) { TempData["optrerror"] = ex.Message; TempData["Ok"] = "Wrong"; } return(RedirectToAction("Index", "Operator")); }