public IHttpActionResult PutRetailReview(string id, Retail_Promotions retailPromo)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != retailPromo.Promotion_ID)
            {
                return(BadRequest());
            }

            db.Entry(retailPromo).State = System.Data.Entity.EntityState.Modified;

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult PostRetailPromo(Retail_Promotions retailPromo)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            db.Retail_Promotions.Add(retailPromo);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = retailPromo.Promotion_ID }, retailPromo));
        }
        public IHttpActionResult GetRetailPromo(string id)
        {
            Retail_Promotions retailPromo = db.Retail_Promotions.Find(id, 1, "OPTIK CND");

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

            return(Ok(retailPromo));
        }
        public IHttpActionResult DeleteRetailPromo(string id)
        {
            Retail_Promotions retailPromo = db.Retail_Promotions.Find(id);

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

            db.Retail_Promotions.Remove(retailPromo);
            db.SaveChanges();

            return(Ok(retailPromo));
        }