public int Post(Models.Sector Value) { try { Data.TrnSector NewSector = new Data.TrnSector(); NewSector.Sector = Value.SectorCode; NewSector.Definition = Value.SectorDefinition; db.TrnSectors.InsertOnSubmit(NewSector); db.SubmitChanges(); return(NewSector.Id); } catch { return(0); } }
public HttpResponseMessage Delete(int Id) { Data.TrnSector DeleteSector = db.TrnSectors.Where(d => d.Id == Id).First(); if (DeleteSector != null) { db.TrnSectors.DeleteOnSubmit(DeleteSector); try { db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } }