public void AddProductToCategory(string categoryid, string productid)
{
dbConnection.CheckInput(categoryid); dbConnection.CheckInput(productid);
string[] paramsNames = { "@categoryParam", "@productParam" };
object[] values = { categoryid, productid };
dbConnection.InsertTable("CategoryProductConnection", "CategoryID, ProductID",
paramsNames, values);
}
public void InsertTable(string table, string tableColumns, string[] valuesNames, object[] values)
{
try
{
realMarketDB.InsertTable(table, tableColumns, valuesNames, values);
}
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 AddOrder(Order order)
{
string[] valuesNames = { "@orderidParam", "@nameParam", "@addressParam", "@priceParam", "@dateParam" };
object[] values = order.ToData();
foreach (object val in values)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("Orders", "OrderID,UserName,ShippingAddress,TotalPrice,Date", valuesNames, values);
foreach (OrderItem item in order.GetItems())
{
string[] valuesNames2 = { "@orderidParam", "@storeParam", "@nameParam", "@priceParam", "@quantityParam" };
object[] values2 = { order.GetOrderID(), item.Store, item.Name, item.Price, item.Quantity };
foreach (object val in values2)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("OrderItem", "OrderID,Store,Name,Price,Quantity", valuesNames2, values2);
string[] valuesNames3 = { "@usernameParam", "@productParam", "@storeParam", "@saleParam", "@quantityParam", "@priceParam", "@dateParam" };
object[] values3 = { order.GetUserName(), item.Name, item.Store, "Immediate", item.Quantity, item.Price, order.GetDate() };
foreach (object val in values3)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("PurchaseHistory", "UserName,Product,Store,SaleType,Quantity,Price,Date", valuesNames3, values3);
}
}
public void SaveUnreadNotification(Notification notification)
{
foreach (object val in notification.ToData())
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("Notifications", "NotificationID,Receiver,Message,Status",
new[] { "@id", "@receiver", "@msg", "@status" }, notification.ToData());
}
public void AddCategory(Category category)
{
foreach (object val in category.GetCategoryValuesArray())
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("Category", "SystemID, name",
new[] { "@idParam", "@nameParam" }, category.GetCategoryValuesArray());
}
private void WritePolicyToDB(Operator policy)
{
string fields = "SystemID,Operator,PolicyType,Subject,Cond1,Cond2,Root";
object[] policyVals = GetPolicyValues(policy);
foreach (object val in policyVals)
{
dbConnection.CheckInput(val.ToString());
}
dbConnection.InsertTable("ComplexPolicies", fields,
new[]
{
"@idParam", "@typeParam", "@policyParam", "@subjectParam", "@cond1Param", "@cond2Param",
"@rootParam"
},
policyVals);
SavePolicy(policy._cond1);
SavePolicy(policy._cond2);
}
public void SaveUserStatePolicy(int userID, StatePolicy policy)
{
dbConnection.CheckInput(policy.GetStateString());
string [] valuesNames = { "@idParam", "@stateParam" };
object[] values = { userID, policy.GetStateString() };
dbConnection.InsertTable("StatePolicy", "SystemID,State", valuesNames, values);
}
