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