public HttpResponseMessage RemoveProduct(int id)
 {
     try
     {
         db.proc_Remove_Product(id);
         return(Request.CreateResponse(HttpStatusCode.OK, "valid"));
     }
     catch (Exception e)
     {
         return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
     }
 }