public IHttpActionResult PuttblShopProduct(tblShopProduct tblShopProduct)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            var data = db.tblShops.Where(w => w.ID == tblShopProduct.ID).Count();
            if (data >= 0)
            {
                tblShopProduct ShopProduct = new tblShopProduct();
                ShopProduct.ID = tblShopProduct.ID;
                ShopProduct.ShopID = tblShopProduct.ShopID;
                ShopProduct.Name = tblShopProduct.Name;
                ShopProduct.Description = tblShopProduct.Description;
                ShopProduct.Discount = tblShopProduct.Discount;
                ShopProduct.Price = tblShopProduct.Price;
                ShopProduct.IsDisplayOnHomePage = tblShopProduct.IsDisplayOnHomePage;
                ShopProduct.DisplayOrder = tblShopProduct.DisplayOrder;
                ShopProduct.Created = System.DateTime.Now;
                ShopProduct.CreatedBy = tblShopProduct.CreatedBy;
                ShopProduct.Updated = System.DateTime.Now;
                ShopProduct.UpdatedBy = tblShopProduct.UpdatedBy;
                ShopProduct.Active = Convert.ToBoolean(tblShopProduct.Active);

                db.Entry(ShopProduct).State = EntityState.Modified;
                db.SaveChanges();

                return Ok(new { code = 0, data = "Shop Product updated successfully.", id = tblShopProduct.ID });
            }
            else
            {
                return Ok(new { code = 1, data = "Shop Product not found." });
            }
        }
        public IHttpActionResult PosttblShopProduct(tblShopProduct tblShopProduct)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.tblShopProducts.Add(tblShopProduct);
            db.SaveChanges();

            return Ok(new { code = 0, data = "Shop Product added successfully.", id = tblShopProduct.ID });
        }
        public IHttpActionResult DeletetblShopProduct(int id)
        {
            tblShopProduct tblShopProduct = db.tblShopProducts.Find(id);
            if (tblShopProduct == null)
            {
                return Ok(new { code = 2, data = "Shop Product not found" });
            }

            db.tblShopProducts.Remove(tblShopProduct);
            db.SaveChanges();

            return Ok(new { code = 0, message = "Record deleted successfully" });
        }
        public IHttpActionResult GettblShopProduct(int id)
        {
            try
            {
                //tblShopProduct tblShopProduct = db.tblShopProducts.Find(id);
                //if (tblShopProduct == null)
                //{
                //    return NotFound();
                //}
                //return Ok(tblShopProduct);
                var data = db.tblShopProducts.Where(w => w.ID == id).FirstOrDefault();

                if (data == null)
                {
                    return Ok(new { code = 1, data = "Not found" });
                }
                else
                {
                    tblShopProduct model = new tblShopProduct();
                    model.ID = data.ID;
                    model.ShopID = data.ShopID;
                    model.Name = data.Name;
                    model.Description = data.Description;
                    model.Discount = data.Discount;
                    model.Price = data.Price;
                    model.Created = System.DateTime.Now;
                    model.CreatedBy = data.CreatedBy;
                    model.Updated = System.DateTime.Now;
                    model.UpdatedBy = data.UpdatedBy;
                    model.Active = Convert.ToBoolean(data.Active);

                    return Ok(new { code = 0, data = model });
                }
            }
            catch (Exception ex)
            {
                return InternalServerError(ex);
            }
        }