public HttpResponseMessage updateTerm(String id, Models.MstTerm term) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var terms = from d in db.MstTerms where d.Id == Convert.ToInt32(id) select d; if (terms.Any()) { var updateTerm = terms.FirstOrDefault(); updateTerm.Term = term.Term; updateTerm.NumberOfDays = term.NumberOfDays; updateTerm.IsLocked = term.IsLocked; updateTerm.UpdatedById = userId; updateTerm.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertTerm(Models.MstTerm term) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); Data.MstTerm newTerm = new Data.MstTerm(); newTerm.Term = term.Term; newTerm.NumberOfDays = term.NumberOfDays; newTerm.IsLocked = term.IsLocked; newTerm.CreatedById = userId; newTerm.CreatedDateTime = DateTime.Now; newTerm.UpdatedById = userId; newTerm.UpdatedDateTime = DateTime.Now; db.MstTerms.InsertOnSubmit(newTerm); db.SubmitChanges(); return(newTerm.Id); } catch { return(0); } }