public HttpResponseMessage Get(int id) { using (CoreDBEntities entities = new CoreDBEntities()) { var entity = entities.EMPLOYEEDETAILS.FirstOrDefault(e => e.ID == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.Found, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Employee not found")); } } }
public HttpResponseMessage Post([FromBody] EMPLOYEEDETAIL employee) { using (CoreDBEntities ent = new CoreDBEntities()) { try { ent.EMPLOYEEDETAILS.Add(employee); ent.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 type = "All") { using (CoreDBEntities entities = new CoreDBEntities()) { switch (type.ToLower()) { case "all": return(Request.CreateResponse(HttpStatusCode.OK, entities.EMPLOYEEDETAILS.ToList())); case "male": return(Request.CreateResponse(HttpStatusCode.OK, entities.EMPLOYEEDETAILS.Where(e => e.Gender.ToLower() == "m").ToList())); case "female": return(Request.CreateResponse(HttpStatusCode.OK, entities.EMPLOYEEDETAILS.Where(e => e.Gender.ToLower() == "f").ToList())); default: return(Request.CreateResponse(HttpStatusCode.BadRequest, "Invalid query string")); } //return entities.EMPLOYEEDETAILS.ToList(); } }