public HttpResponseMessage Get(int id)
 {
     try
     {
         Products product = ProductsData.Select_Record(new Products()
         {
             ProductId = id
         });
         if (product == null)
         {
             return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with given Id does not exist!"));
         }
         return(Request.CreateResponse(HttpStatusCode.OK, product));
     }
     catch (Exception ex)
     {
         return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
     }
 }
        public HttpResponseMessage Delete(int id)
        {
            try
            {
                Products product = ProductsData.Select_Record(new Products()
                {
                    ProductId = id
                });
                if (product == null)
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound, "Product with Given Id does not exist!"));
                }

                ProductsData.Delete(product);
                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
        public HttpResponseMessage Put(int id, [FromBody] Products newProduct)
        {
            try
            {
                Products existingProduct = ProductsData.Select_Record(new Products()
                {
                    ProductId = id
                });
                if (existingProduct == null)
                {
                    return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with Given Id does not exist!"));
                }
                ProductsData.Update(existingProduct, newProduct);

                return(Request.CreateResponse(HttpStatusCode.OK, newProduct));
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
        public ActionResult DeleteConfirmed(
            Int32?ProductId
            )
        {
            Products Products = new Products();

            Products.ProductId = System.Convert.ToInt32(ProductId);
            Products           = ProductsData.Select_Record(Products);

            bool bSucess = false;

            bSucess = ProductsData.Delete(Products);
            if (bSucess == true)
            {
                return(RedirectToAction("Index"));
            }
            else
            {
                ModelState.AddModelError("", "Can Not Delete");
            }
            return(null);
        }
        // GET: /Products/Delete/<id>
        public ActionResult Delete(
            Int32?ProductId
            )
        {
            if (
                ProductId == null
                )
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }


            Products Products = new Products();

            Products.ProductId = System.Convert.ToInt32(ProductId);
            Products           = ProductsData.Select_Record(Products);

            if (Products == null)
            {
                return(HttpNotFound());
            }
            return(View(Products));
        }
        public ActionResult Edit(Products Products)
        {
            Products oProducts = new Products();

            oProducts.ProductId = System.Convert.ToInt32(Products.ProductId);
            oProducts           = ProductsData.Select_Record(Products);

            if (ModelState.IsValid)
            {
                bool bSucess = false;
                bSucess = ProductsData.Update(oProducts, Products);
                if (bSucess == true)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError("", "Can Not Update");
                }
            }

            return(View(Products));
        }