public ActionResult Class() { try { using (Test2Entities db = new Test2Entities()) { var oClass = (from c in db.@class join s in db.subject on c.id_subject equals s.id join p in db.professor on c.id_professor equals p.id join d in db.day on c.id_day equals d.id select new Classroom() { Subject = s.name, ProfessorName = p.name, ProfessorSurname = p.surname, Day = d.name, StartTime = c.start_time.ToString(), EndTime = c.end_time.ToString(), Capacity = c.capacity }); return(View(oClass.ToList())); } } catch (Exception e) { ViewBag.Error = e.Message; return(RedirectToAction("Login", "Access")); } }
public HttpResponseMessage PutEmployee(int id, [FromBody] Employee emp) { try { using (Test2Entities _db = new Test2Entities()) { var data = _db.Employees.Where(e => e.id == id).SingleOrDefault(); if (data != null) { data.id = emp.id; data.Name = emp.Name; data.Salary = emp.Salary; data.Gender = emp.Gender; data.City = emp.City; _db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id " + id.ToString() + " is not found")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <Employee> GetEmployees() { using (Test2Entities _db = new Test2Entities()) { return(_db.Employees.ToList()); } }
public static bool Login(string username, string password) { using (Test2Entities _db = new Test2Entities()) { return(_db.Users.Any(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && u.Password == password)); } }
public HttpResponseMessage GetEmployee(int id) { using (Test2Entities _db = new Test2Entities()) { var data = _db.Employees.FirstOrDefault(e => e.id == id); if (data != null) { return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id " + id + " is not found")); } } }
public HttpResponseMessage Post([FromBody] Employee emp) { try { using (Test2Entities _db = new Test2Entities()) { _db.Employees.Add(emp); _db.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, emp); message.Headers.Location = new Uri(Request.RequestUri + emp.id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult Login(string User, string Pass) { Session["User"] = null; int userRole; int adminRole = 1; try { using (Test2Entities db = new Test2Entities()) { var oUser = (from d in db.user where d.dni == User.Trim() && d.file_number.ToString() == Pass select d).FirstOrDefault(); if (oUser == null) { ViewBag.Error = "Usuario o password invalido"; return(View()); } userRole = oUser.id_role; Session["User"] = oUser; } if (userRole == adminRole) { return(RedirectToAction("Index", "Admin")); } else { return(RedirectToAction("Class", "Student")); } } catch (Exception e) { ViewBag.Error = e.Message; return(View()); } }
public HttpResponseMessage GetEmployees(string gender = "All") { string username = Thread.CurrentPrincipal.Identity.Name; using (Test2Entities _db = new Test2Entities()) { switch (username.ToLower()) { case "all": return(Request.CreateResponse(HttpStatusCode.OK, _db.Employees.ToList())); case "male": return(Request.CreateResponse(HttpStatusCode.OK, _db.Employees.Where(e => e.Gender.ToLower() == "male").ToList())); case "female": return(Request.CreateResponse(HttpStatusCode.OK, _db.Employees.Where(e => e.Gender.ToLower() == "female").ToList())); default: return(Request.CreateResponse(HttpStatusCode.BadGateway, "Value of Gender must be All, Male or Female. " + gender + " is invalid")); } } }
public HttpResponseMessage DeleteEmployee(int id) { try { using (Test2Entities _db = new Test2Entities()) { var data = _db.Employees.FirstOrDefault(e => e.id == id); if (data != null) { _db.Employees.Remove(data); _db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id " + id.ToString() + " is not found")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }