public ActionResult Enter(string username, string password) { try { using (aspcrudEntities db = new aspcrudEntities()) { var lst = from d in db.user where d.name == username && d.password == password && d.idState == 1 select d; if (lst.Count() > 0) { user oUser = lst.First(); Session["User"] = oUser; return(Content("1")); } else { return(Content("Usuario Invalido")); } } } catch (Exception) { return(Content("Ocurrio un error")); } }
public ActionResult Delete(int Id) { using (var db = new aspcrudEntities()) { var oUser = db.user.Find(Id); oUser.idState = 3; //eliminaremos db.Entry(oUser).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(Content("1")); }
// GET: User public ActionResult Index() { List <UserTable> lst = null; using (aspcrudEntities db = new aspcrudEntities()) { lst = (from d in db.user where d.idState != 3 orderby d.id select new UserTable { id = d.id, name = d.name, idState = d.idState }).ToList(); } return(View(lst)); }
public ActionResult Edit(int Id) { EditUserModel model = new EditUserModel(); using (var db = new aspcrudEntities()) { var oUser = db.user.Find(Id); model.name = oUser.name; model.Id = oUser.id; model.idState = oUser.idState; var states = (from d in db.cstate select d).ToList(); var statesLists = new SelectList(states, "id", "name", oUser.idState); ViewData["states"] = statesLists; } return(View(model)); }
public ActionResult Add(UserModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new aspcrudEntities()) { user oUser = new user(); oUser.name = model.name; oUser.password = model.password; oUser.idState = 1; db.user.Add(oUser); db.SaveChanges(); } return(Redirect(Url.Content("~/User/Index"))); }
public ActionResult Edit(EditUserModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new aspcrudEntities()) { var oUser = db.user.Find(model.Id); oUser.name = model.name; oUser.idState = model.idState; if (model.password != null && model.password.Trim() != "") { oUser.password = model.password; } db.Entry(oUser).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(Redirect(Url.Content("~/User/"))); }