public IEnumerable <tblEmployee> Get() { using (AngularWebAPIEntities dbcontext = new AngularWebAPIEntities()) { return(dbcontext.tblEmployees.ToList()); } }
public tblEmployee Get(string id) { using (AngularWebAPIEntities dbcontext = new AngularWebAPIEntities()) { return(dbcontext.tblEmployees.FirstOrDefault(x => x.Id == id)); } }
public HttpResponseMessage Put(int id, [FromBody] CORUSERMST user) { try { using (AngularWebAPIEntities entities = new AngularWebAPIEntities()) { var entity = entities.CORUSERMSTs.FirstOrDefault(e => e.User_ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id " + id.ToString() + " not found to update")); } else { entity.User_Address = user.User_Address; entity.User_EmailID = user.User_EmailID; entity.User_Name = user.User_Name; entity.User_Password = user.User_Password; entity.User_Username = user.User_Username; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (AngularWebAPIEntities entities = new AngularWebAPIEntities()) { var entity = entities.CORUSERMSTs.FirstOrDefault(e => e.User_ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " not found to delete")); } else { entities.CORUSERMSTs.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public CORUSERMST Get(int id) { using (AngularWebAPIEntities entities = new AngularWebAPIEntities()) { return(entities.CORUSERMSTs.SingleOrDefault(e => e.User_ID == id)); } }
public IEnumerable <CORUSERMST> Get() { using (AngularWebAPIEntities entities = new AngularWebAPIEntities()) { return((entities.CORUSERMSTs).ToList()); } }
public void Post([FromBody] CORUSERMST user) { using (AngularWebAPIEntities entities = new AngularWebAPIEntities()) { entities.CORUSERMSTs.Add(user); entities.SaveChanges(); } }