public ActionResult Add(user userModel)
{
using (deviceManagementEntities1 dbModel = new deviceManagementEntities1())
{
if (dbModel.users.Any(x => x.userName == userModel.userName))
{
ViewBag.DuplicateMessage = "Username Already Exists.";
return(View("Index", userModel));
}
userModel.isAdmin = false;
dbModel.users.Add(userModel);
dbModel.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "Registeration Successful.";
return(View("Index", new user()));
}
public ActionResult Autherize(CustomLogin.Models.user userModel)
{
using (deviceManagementEntities1 db = new deviceManagementEntities1())
{
var userDetails = db.users.Where(x => x.userName == userModel.userName && x.password == userModel.password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Wrong Username or Password.";
return(View("Index", userModel));
}
else
{
Session["userID"] = userDetails.userID;
Session["isAdmin"] = userDetails.isAdmin;
Session["userName"] = userDetails.userName;
return(RedirectToAction("Index", "Home"));
}
}
}
// GET: Home
public ActionResult Index(String sortBy)
{
using (deviceManagementEntities1 dbModel = new deviceManagementEntities1())
{
if (Session["userID"] != null)
{
int sessionUserID = (int)Session["userID"];
ViewBag.SortNameParameter = String.IsNullOrEmpty(sortBy) ? "Name desc" : "";
ViewBag.SortTypeParameter = sortBy == "Type" ? "Type desc" : "Type";
ViewBag.SortManufacturerParameter = sortBy == "Manufacturer" ? "Manufacturer desc" : "Manufacturer";
ViewBag.SortOwnerParameter = sortBy == "Owner" ? "Owner desc" : "Owner";
var devices = db.devices.AsQueryable();
if (dbModel.devices.Any(x => x.UserID != sessionUserID))
{
devices = db.devices.Where(x => x.UserID != sessionUserID && x.UserID != null);
switch (sortBy)
{
case "Name desc":
devices = devices.OrderByDescending(x => x.DName);
break;
case "Type desc":
devices = devices.OrderByDescending(x => x.DType);
break;
case "Type":
devices = devices.OrderBy(x => x.DType);
break;
case "Manufacturer desc":
devices = devices.OrderByDescending(x => x.DManufacturer);
break;
case "Manufacturer":
devices = devices.OrderBy(x => x.DManufacturer);
break;
case "Owner desc":
devices = devices.OrderByDescending(x => x.user.userName);
break;
case "Owner":
devices = devices.OrderBy(x => x.user.userName);
break;
default:
devices = devices.OrderBy(x => x.DName);
break;
}
return(View("Index", devices.ToList()));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
}
