public HttpResponseMessage updateUnit(String id, Models.MstUnit unit) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var units = from d in db.MstUnits where d.Id == Convert.ToInt32(id) select d; if (units.Any()) { var updateUnit = units.FirstOrDefault(); updateUnit.Unit = unit.Unit; updateUnit.IsLocked = unit.IsLocked; updateUnit.UpdatedById = userId; updateUnit.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertUnit(Models.MstUnit unit) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); Data.MstUnit newUnit = new Data.MstUnit(); newUnit.Unit = unit.Unit; newUnit.IsLocked = unit.IsLocked; newUnit.CreatedById = userId; newUnit.CreatedDateTime = DateTime.Now; newUnit.UpdatedById = userId; newUnit.UpdatedDateTime = DateTime.Now; db.MstUnits.InsertOnSubmit(newUnit); db.SubmitChanges(); return(newUnit.Id); } catch { return(0); } }