public IHttpActionResult Putwaterrate(int id, waterrate waterrate)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != waterrate.ID)
            {
                return(BadRequest());
            }

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

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult Getwaterrate(int id)
        {
            waterrate waterrate = db.waterrates.Find(id);

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

            return(Ok(waterrate));
        }
        public IHttpActionResult Postwaterrate(waterrate waterrate)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.waterrates.Add(waterrate);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = waterrate.ID }, waterrate));
        }
        public IHttpActionResult Deletewaterrate(int id)
        {
            waterrate waterrate = db.waterrates.Find(id);

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

            db.waterrates.Remove(waterrate);
            db.SaveChanges();

            return(Ok(waterrate));
        }