public IHttpActionResult PutProductGroup(int id, ProductGrp productGroup)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

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

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

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult GetProductGroup(int id)
        {
            ProductGrp productGroup = db.ProductGrps.Find(id);

            if (productGroup == null)
            {
                return(NotFound());
            }
            return(Ok(productGroup));
        }
        public IHttpActionResult PostProductGroup(ProductGrp productGroup)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.ProductGrps.Add(productGroup);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = productGroup.ID }, productGroup));
        }
        public IHttpActionResult DeleteProductGroup(int id)
        {
            ProductGrp productGroup = db.ProductGrps.Find(id);

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

            db.ProductGrps.Remove(productGroup);
            db.SaveChanges();

            return(Ok(productGroup));
        }
        public ProductGrp GetCode(string sku)
        {
            ProductGrp model = new ProductGrp();
            bool       data  = db.ProductGrps.Any(x => x.GroupName == sku && x.IsActive == true);

            if (data == true)
            {
                model = db.ProductGrps.Where(x => x.IsActive == true && x.GroupName == sku).FirstOrDefault();
            }
            else
            {
                model.GroupName = sku;
                model.IsActive  = true;
                model.CreatedOn = System.DateTime.UtcNow;
                model.UpdatedOn = System.DateTime.UtcNow;
                db.ProductGrps.Add(model);
                db.SaveChanges();
                var list = db.ProductGrps.Where(x => x.IsActive == true).ToList();
                model = list.LastOrDefault();
            }
            return(model);
        }