public ActionResult Enter(string user, string password)
{
try
{
//return Content("1");
using (cmvcEntities db = new cmvcEntities())
{
var ls = from d in db.user
where d.email == user && d.password == password && d.idState == 1
select d;
if (ls.Count() > 0)
{
user oUser = ls.First();
Session["User"] = oUser;
return(Content("1"));
//Session["User"] = ls.First();
}
else
{
return(Content("Usuario o contraseña incorrecto"));
}
}
}
catch (Exception ex)
{
return(Content("Ocurrio un error :( " + ex.Message));
}
//return View();
}
public ActionResult Edit(int Id)
{
EditUserViewModel model = new EditUserViewModel();
using (var db = new cmvcEntities())
{
var oUser = db.user.Find(Id);
model.Edad = (int)oUser.edad;
model.Email = oUser.email;
model.Id = oUser.id;
}
return(View(model));
}
public ActionResult Delete(int Id)
{
using (var db = new cmvcEntities())
{
var oUser = db.user.Find(Id);
//1 active
//2 inactive
//3 deleted
oUser.idState = 3;
db.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Content("1"));
}
// GET: User
public ActionResult Index()
{
List <UserTableVM> lst = null;
using (cmvcEntities db = new cmvcEntities())
{
lst = (from d in db.user
where d.idState == 1
orderby d.id
select new UserTableVM
{
Email = d.email,
Id = d.id,
Edad = d.edad
}).ToList();
}
return(View(lst));
}
public ActionResult Add(UserViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new cmvcEntities())
{
user oUser = new user();
oUser.idState = 1;
oUser.email = model.Email;
oUser.edad = model.Edad;
oUser.password = model.Password;
db.user.Add(oUser);
db.SaveChanges();
}
return(Redirect(Url.Content("~/User/")));
}
public ActionResult Edit(EditUserViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new cmvcEntities())
{
var oUser = db.user.Find(model.Id);
oUser.email = model.Email;
oUser.edad = model.Edad;
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/")));
}
