// GET METHOD // Default Name Get //public IEnumerable<Employee> Get() //{ // using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) // // create instance // { // return entities.Employees.ToList(); // // employee entity // } //} // respond to http get (read) verb (without parameter) // Custom Name LoadEmployees //[HttpGet] //public IEnumerable<Employee> LoadingAllEmployees() //{ // using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) // { // return entities.Employees.ToList(); // } //} // With Filtering Function //[DisableCors] //[BasicAuthentication] public HttpResponseMessage Get(string gender = "All") { string username = Thread.CurrentPrincipal.Identity.Name; using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { switch (gender.ToLower()) { case "all": return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList())); case "male": return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList())); case "female": return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList())); default: return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Value for gender must be male, female or all" + gender + " is invalid request. Please try again")); } } }
// PUT ver1 //public void Put(int id,[FromBody]Employee updatedEmployeeInfo) //{ // using(InterviewPracticeEntities entities = new InterviewPracticeEntities()) // { // var entity = entities.Employees.FirstOrDefault(e => e.ID == id); // entity.FirstName = updatedEmployeeInfo.FirstName; // entity.LastName = updatedEmployeeInfo.LastName; // entity.Gender = updatedEmployeeInfo.Gender; // entity.Salary = updatedEmployeeInfo.Salary; // entities.SaveChanges(); // } //} // PUT ver 2 public HttpResponseMessage Put([FromBody] int id, [FromUri] Employee employee) { try { using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id " + id.ToString() + " not exist, please try again")); } else { entity.FirstName = employee.FirstName; entity.LastName = employee.LastName; entity.Gender = employee.Gender; entity.Salary = employee.Salary; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// DELETE METHOD VER 1 //public void Delete(int id) //{ // using(InterviewPracticeEntities entities = new InterviewPracticeEntities()) // { // entities.Employees.Remove(entities.Employees.FirstOrDefault(e => e.ID == id)); // entities.SaveChanges(); // } //} // DELETE METHOD VER2 public HttpResponseMessage Delete(int id) { try { using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " is not exist")); } else { entities.Employees.Remove(entity); 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 (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { return(entities.Users.Any(user => user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password == password)); } }
public HttpResponseMessage Get(int id) { using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { 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() + " is not exist, please check again")); } } }
// Respond to http get verb(with id parameter) // POST METHOD // made by Dodam //public IHttpActionResult Post(Employee person) //{ // using (var p = new InterviewPracticeEntities()) // { // p.Employees.Add(new Employee() // { // ID = person.ID, // FirstName = person.FirstName, // LastName = person.LastName, // Gender = person.Gender, // Salary = person.Salary // }); // p.SaveChanges(); // } // return Ok(); //} // made from Youtube lecture // ver1 //public void Post([FromBody]Employee newemployeeinfo) //{ // using(InterviewPracticeEntities entities = new InterviewPracticeEntities()) // { // entities.Employees.Add(newemployeeinfo); // entities.SaveChanges(); // } //} // ver2 //[HttpPost] public HttpResponseMessage Post([FromBody] Employee newemployeeinfo) { try { using (InterviewPracticeEntities entities = new InterviewPracticeEntities()) { entities.Employees.Add(newemployeeinfo); entities.SaveChanges(); var msg = Request.CreateResponse(HttpStatusCode.Created, newemployeeinfo); msg.Headers.Location = new Uri(Request.RequestUri + newemployeeinfo.ID.ToString()); return(msg); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }