// 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());
}
}
