public HttpResponseMessage UpdateJobTitle(JobTitle001Model model) { using (var trans = db.Database.BeginTransaction()) { try { var data = db.JobTitle.FirstOrDefault(u => u.JobTitleId.Equals(model.JobTitleId)); if (data != null) { data.Name = model.Name; data.Description = model.Description; trans.Commit(); db.SaveChanges(); } else { return(Request.CreateResponse(HttpStatusCode.OK, Constants.NOT_FOUND)); } return(Request.CreateResponse(HttpStatusCode.OK, Constants.OK)); } catch (Exception ex) { trans.Rollback(); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } } }
public HttpResponseMessage GetListJobTitle(JobTitle001Model model) { try { var listJobTitle = (from d in db.JobTitle.AsNoTracking() where d.Name.Contains(model.Name) orderby d.Name select new JobTitle001Model() { JobTitleId = d.JobTitleId, Name = d.Name, Description = d.Description }).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, listJobTitle)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }