public HttpResponseMessage PurchaseProduct(string useremail, int productid, int retailerid, int orderquantity, float orderprice)
        {
            string date = DateTime.Now.ToString();

            entities.proc_Insert_Order(date, useremail, productid, retailerid, orderquantity, orderprice);
            return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
        }