// GET: Usuari/ muestra el listado public ActionResult Index() { CRUDEntities db = new CRUDEntities(); // consulta LinQ para mostrar el listado de los usuarios. return(View(db.Registro.ToList())); }
public ActionResult Save(MVCCRUD.Models.Empployee emp) { bool status = false; if (ModelState.IsValid) { using (CRUDEntities dc = new CRUDEntities()) { if (emp.EmployeeID > 0) { //Edit var v = dc.Empployees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault(); if (v != null) { v.FirstName = emp.FirstName; v.LastName = emp.LastName; v.EmailID = emp.EmailID; v.City = emp.City; v.Country = emp.Country; } } else { //save dc.Empployees.Add(emp); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Save(int id) { using (CRUDEntities dc = new CRUDEntities()) { var v = dc.Empployees.Where(a => a.EmployeeID == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetEmployees() { using (CRUDEntities dc = new CRUDEntities()) { var employee = dc.Empployees.OrderBy(a => a.FirstName).ToList(); return(Json(new { data = employee }, JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true CRUDEntities DC = new CRUDEntities(); var user = DC.AspNetUsers.Where(x => x.UserName == model.UserID).FirstOrDefault(); if (user != null) { var result = await SignInManager.PasswordSignInAsync(user.UserName, model.Password, model.RememberMe, shouldLockout : false); switch (result) { case SignInStatus.Success: return(RedirectToLocal(returnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe })); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return(View(model)); } } else { ModelState.AddModelError("", "Invalid login attempt."); return(View(model)); } //string str = db.Users.Any(x => x.Emaill == model.Email && x.Password == model.Password).ToString(); //string str = db.Users.Any(x => x.UserID == model.UserID && x.Password == model.Password).ToString(); //if (str == "True") //{ // // User user = db.Users.First(a => a.Emaill == model.Email); // // TempData["CustList"] = db.Callings.Where(z => z.Email == user.Emaill).ToList(); // return RedirectToAction("Index", "Home"); //} //else //{ // return View(model); //} }
public JsonResult Detail() { using (var db = new CRUDEntities()) { var data = db.Customer.Select(x => new { id = x.Id, name = x.Name, addr = x.Address }).ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (CRUDEntities dc = new CRUDEntities()) { var v = dc.Empployees.Where(a => a.EmployeeID == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult DeleteEmployee(int id) { bool status = false; using (CRUDEntities dc = new CRUDEntities()) { var v = dc.Empployees.Where(a => a.EmployeeID == id).FirstOrDefault(); if (v != null) { dc.Empployees.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Agregar(Registro r) { if (!ModelState.IsValid) { return(View()); } try { using (var db = new CRUDEntities()) //para que no quede una conexion abrierta y consuma recursos { db.Registro.Add(r); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("Error al agregar usuario", ex); return(View()); } }