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));
            }
        }