public ActionResult Enter(string user, string password)
{
try
{
using (Example001Entities dbContext = new Example001Entities())
{
var lst = from d in dbContext.users
join s in dbContext.cstates on d.idState equals s.id
where d.username.Equals(user) && d.password.Equals(password) && s.name.Equals("Active")
select d;
if (lst.Count() == 1)
{
Session["User"] = lst.First();
return(Content("1"));
}
}
return(Content("Invalid user."));
}
catch (Exception ex)
{
return(Content("Ocurred an error: " + ex.Message));
}
finally
{
}
}
public ActionResult Add(UserViewModel userViewModel)
{
if (!ModelState.IsValid)
{
return(View(userViewModel));
}
using (var dbContext = new Example001Entities())
{
var idState = (from s in dbContext.cstates where s.name.Equals("Active") select s.id).FirstOrDefault();
var oUser = new user()
{
username = userViewModel.UserName,
password = userViewModel.Password,
name = userViewModel.Name,
idState = idState
};
dbContext.users.Add(oUser);
dbContext.SaveChanges();
}
return(Redirect(Url.Content("~/User/")));
}
public ActionResult Delete(int id)
{
using (var dbContext = new Example001Entities())
{
var oUser = dbContext.users.Find(id);
var oState = dbContext.cstates.Where(s => s.name.Equals("Deleted")).FirstOrDefault();
oUser.cstate = oState;
dbContext.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
return(Content("1"));
}
public ActionResult Edit(int id)
{
EditUserViewModel model = new EditUserViewModel();
using (var dbContext = new Example001Entities())
{
var oUser = dbContext.users.Find(id);
model.Id = oUser.id;
model.Name = oUser.name;
model.UserName = oUser.username;
}
return(View(model));
}
// GET: User
public ActionResult Index()
{
List <UserTableViewModel> lst = new List <UserTableViewModel>();
using (Example001Entities dbContext = new Example001Entities())
{
lst = (from d in dbContext.users
join s in dbContext.cstates on d.idState equals s.id
where s.name.Equals("Active")
select new UserTableViewModel
{
Id = d.id,
Name = d.name,
UserName = d.username,
Password = d.password
}).ToList();
}
return(View(lst));
}
public ActionResult Edit(EditUserViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var dbContext = new Example001Entities())
{
var oUser = dbContext.users.Find(model.Id);
oUser.name = model.Name;
oUser.username = model.UserName;
if (model.Password != null && model.Password.Trim() != "")
{
oUser.password = model.Password;
}
dbContext.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
return(Redirect(Url.Content("~/User/")));
}
