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 + "'");
}
