public void DeleteUserStorePolicy(string userName, StoreManagerPolicy policy) { dbConnection.CheckInput(policy.Store); dbConnection.CheckInput(policy.Action.ToString()); int idOfDemoted = GetIDFromUserName(userName); dbConnection.DeleteFromTable("StoreManagerPolicy", "SystemID = " + idOfDemoted + " AND Store = '" + policy.Store + "' AND Action = '" + policy.Action + "'"); }
public void RemovePolicy(PurchasePolicy policy) { string subjectString = "NULL"; if (!policy.Subject.IsNullOrEmpty()) { subjectString = policy.Subject; } dbConnection.CheckInput(subjectString); dbConnection.CheckInput(PurchasePolicy.PrintEnum(policy.Type)); dbConnection.DeleteFromTable("ComplexPolicies", "PolicyType = '" + PurchasePolicy.PrintEnum(policy.Type) + "' AND Subject = '" + subjectString + "'"); dbConnection.DeleteFromTable("SimplePolicies", "PolicyType = '" + PurchasePolicy.PrintEnum(policy.Type) + "' AND Subject = '" + subjectString + "'"); }
public void RemoveOrder(int orderId) { List <OrderItem> items = GetAllItems(orderId); foreach (OrderItem item in items) { dbConnection.CheckInput(item.Name); dbConnection.CheckInput(item.Store); dbConnection.DeleteFromTable("PurchaseHistory", "Product = '" + item.Name + "' AND Store = '" + item.Store + "'"); } dbConnection.DeleteFromTable("OrderItem", "OrderID = " + orderId); dbConnection.DeleteFromTable("Orders", "OrderID = " + orderId); }
public void DeleteFromTable(string table, string deleteCondition) { try { realMarketDB.DeleteFromTable(table, deleteCondition); } catch (InvalidOperationException e) { if (!IsConnected(e.Message) || MarketDB.ToDisable) { throw new DataException(); } throw; } catch (SqlException e) { if (!IsConnected(e.Message) || MarketDB.ToDisable) { throw new DataException(); } throw; } }
public void RemoveProductFromCategory(string categoryid, string productid) { dbConnection.CheckInput(categoryid); dbConnection.CheckInput(productid); dbConnection.DeleteFromTable("CategoryProductConnection", "ProductID = '" + productid + "' AND CategoryID = '" + categoryid + "'"); }
public void DeleteUser(string userName) { dbConnection.CheckInput(userName); dbConnection.DeleteFromTable("Users", "Name = '" + userName + "'"); }