public ActionResult Add(UserViewModel userViewModel) { if (!ModelState.IsValid) { return(View(userViewModel)); } using (var dbContext = new Example001Entities()) { var idState = (from s in dbContext.cstates where s.name.Equals("Active") select s.id).FirstOrDefault(); var oUser = new user() { username = userViewModel.UserName, password = userViewModel.Password, name = userViewModel.Name, idState = idState }; dbContext.users.Add(oUser); dbContext.SaveChanges(); } return(Redirect(Url.Content("~/User/"))); }
public ActionResult Delete(int id) { using (var dbContext = new Example001Entities()) { var oUser = dbContext.users.Find(id); var oState = dbContext.cstates.Where(s => s.name.Equals("Deleted")).FirstOrDefault(); oUser.cstate = oState; dbContext.Entry(oUser).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } return(Content("1")); }
public ActionResult Edit(EditUserViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var dbContext = new Example001Entities()) { var oUser = dbContext.users.Find(model.Id); oUser.name = model.Name; oUser.username = model.UserName; if (model.Password != null && model.Password.Trim() != "") { oUser.password = model.Password; } dbContext.Entry(oUser).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } return(Redirect(Url.Content("~/User/"))); }