public int AddNewProduct(string ProductName, int ProductPrice, string Colour, string Quantity, string type, string Description, string image)
        {
            var NewProduct = new ProductTable
            {
                ProductName = ProductName,
                Price       = ProductPrice,
                Colour      = Colour,
                Quantity    = Quantity,
                Desc        = Description,
                Type        = type,
                ImgUrl      = image
            };

            db.ProductTables.InsertOnSubmit(NewProduct);

            try
            {
                db.SubmitChanges();
                return(1);
            }
            catch (Exception ex)
            {
                ex.GetBaseException();
                return(-1);
            }
        }
 partial void DeleteProductTable(ProductTable instance);
 partial void UpdateProductTable(ProductTable instance);
 partial void InsertProductTable(ProductTable instance);