//Remove product from inventory public bool removeProduct(ProductProperties productId) { bool result = false; try { string deleteQueryString = "DELETE FROM PRODUCT WHERE PRODUCT_ID=@PRODUCTID"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@PRODUCTID", productId.Product_Id)); result = DatabaseConnectionHandler.executeDeleteQuery(deleteQueryString, tableQueryData); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(result); }
public bool removeDiscountData(string discountId) { bool result = false; if (discountId != null) { string deleteQueryString = "DELETE FROM DISCOUNT WHERE DISCOUNT_ID=@DISCOUNT_ID"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >(); parameters.Add(new KeyValuePair <string, string>("@DISCOUNT_ID", discountId)); result = DatabaseConnectionHandler.executeDeleteQuery(deleteQueryString, parameters); } return(result); }