public ActionResult Entrar(string usuario, string password)
{
try
{
using (BD_PracticaEntities db = new BD_PracticaEntities())
{
var lst = (from d in db.Usuario
where d.Email == usuario && d.Password == password && d.IdEstado == 1
select d);
if (lst.Count() > 0)
{
Usuario oUser = lst.First();
Session["User"] = oUser;
return(Content("1"));
}
else
{
return(Content("usuario incorrecto"));
}
}
}
catch (Exception ep)
{
return(Content("ocurrio un error " + ep.Message));
}
}
public ActionResult Delete(int id)
{
using (var db = new BD_PracticaEntities())
{
var oUser = db.Usuario.Find(id);
oUser.IdEstado = 3;
db.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Content("1"));
}
public ActionResult Edit(int id)
{
EditUsuarioViewModel model = new EditUsuarioViewModel();
using (var db = new BD_PracticaEntities())
{
var oUser = db.Usuario.Find(id);
model.Edad = (int)oUser.Edad;
model.Email = oUser.Email;
model.IdUsuario = oUser.IdUsuario;
}
return(View(model));
}
// GET: Usuario
public ActionResult Inicio()
{
List <UsuarioTableViewModel> lst = null;
using (BD_PracticaEntities db = new BD_PracticaEntities())
{
lst = (from d in db.Usuario
where d.IdEstado == 1
orderby d.Email
select new UsuarioTableViewModel
{
Email = d.Email,
IdUsuario = d.IdUsuario,
Edad = d.Edad
}).ToList();
}
return(View(lst));
}
public ActionResult Add(UsuarioViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new BD_PracticaEntities())
{
Usuario oUser = new Usuario();
oUser.IdEstado = 1;
oUser.Email = model.Email;
oUser.Edad = model.Edad;
oUser.Password = model.Password;
db.Usuario.Add(oUser);
db.SaveChanges();
}
return(Redirect(Url.Content("~/Usuario/Inicio")));
}
public ActionResult Edit(EditUsuarioViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new BD_PracticaEntities())
{
var oUser = db.Usuario.Find(model.IdUsuario);
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("~/Usuario/Inicio")));
}
