public HttpResponseMessage UpdateEmplyee(int id, [FromBody] Employee employee) { try { using (PlayDBEntities entities = new PlayDBEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID" + id.ToString() + "not found to update")); } else { entity.FirstName = employee.FirstName; entity.LastName = employee.LastName; entity.Gender = employee.Gender; entity.Salary = employee.Salary; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public static bool Login(string username, string password) { using (PlayDBEntities entities = new PlayDBEntities()) { //if there is a problem in loading entities then right click on employeedatamodel1.edmx and click run custom tools return(entities.Users.Any(Users => Users.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && Users.Password == password)); } }
public HttpResponseMessage EmployeeById(int id) { using (PlayDBEntities entities = new PlayDBEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id=" + id.ToString() + "Not Found")); } } }
public HttpResponseMessage AddNewEmployee([FromBody] Employee employee) { try { using (PlayDBEntities entities = new PlayDBEntities()) { entities.Employees.Add(employee); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, employee); message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Get(string gender = "All") { //username value comes from basicAuthenticationAttribute.cs line 37 string username = Thread.CurrentPrincipal.Identity.Name; using (PlayDBEntities entities = new PlayDBEntities()) { //switch(gender.ToLower()) switch (username.ToLower()) { //case "all": return Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList()); case "male": return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "male").ToList())); case "female": return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "female").ToList())); default: return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Value of Gender be Male, Female or All " + gender + " is invalid")); } } }
public HttpResponseMessage DeletEmployee(int id) { try { using (PlayDBEntities entities = new PlayDBEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID" + id.ToString() + "not found to delete")); } else { entities.Employees.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }