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