//
// GET: /Account/
public ActionResult Login()
{
IList <User> oUser = null;
using (team07Entities oteam07Entities = new team07Entities())
{
oUser = (from User in oteam07Entities.Users orderby User.deptCode select User).ToList(); //putting the table User into variable called oUser ---- query called linq
}
return(View(oUser));
}
public ActionResult ViewRequest()
{
IList <Request> oRequestID = null;
using (team07Entities oteam07ViewRequest = new team07Entities())
{
oRequestID = (from Request in oteam07ViewRequest.Requests orderby Request.requestID select Request).ToList(); //putting the table User into variable called oUser ---- query called linq
}
return(View(oRequestID));
}
public ActionResult Login(UserDetails model)
{
if (ModelState.IsValid)
{
using (team07Entities oteam07Entities = new team07Entities())
{
string username = model.deptCode;
string password = model.password;
bool userValid = oteam07Entities.Users.Any(user => user.deptCode == username && user.password == password);
if (userValid)
{
return(RedirectToAction("MakeRequest", "Request"));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
}
return(View());
}
