public IHttpActionResult PutGEOGRAPHY(int id, GEOGRAPHY gEOGRAPHY)
        {
            if (id != gEOGRAPHY.GEO_ID)
            {
                return(BadRequest());
            }

            db.Entry(gEOGRAPHY).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!GEOGRAPHYExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult GetGEOGRAPHY(int id)
        {
            GEOGRAPHY gEOGRAPHY = db.GEOGRAPHY.Find(id);

            if (gEOGRAPHY == null)
            {
                return(NotFound());
            }

            return(Ok(gEOGRAPHY));
        }
        public IHttpActionResult DeleteGEOGRAPHY(int id)
        {
            GEOGRAPHY gEOGRAPHY = db.GEOGRAPHY.Find(id);

            if (gEOGRAPHY == null)
            {
                return(NotFound());
            }

            db.GEOGRAPHY.Remove(gEOGRAPHY);
            db.SaveChanges();

            return(Ok(gEOGRAPHY));
        }
        public IHttpActionResult PostGEOGRAPHY(GEOGRAPHY gEOGRAPHY)
        {
            db.GEOGRAPHY.Add(gEOGRAPHY);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (GEOGRAPHYExists(gEOGRAPHY.GEO_ID))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = gEOGRAPHY.GEO_ID }, gEOGRAPHY));
        }