public void BindProductsHistoryDataGrid(DataGridView productsHistoryDataGridView, string productId)
{
int productID;
if (!int.TryParse(productId, out productID))
{
return;
}
openConnectionIfClosed();
string query =
"SELECT LABEL AS PRODUCT, LAST_NAME AS ORDERED_BY, PAYMENT_METHOD, SELLING_PRICE AS UNIT_PRICE, AMOUNT FROM ORDERS " +
"INNER JOIN ORDERS_PRODUCTS " +
"ON ORDERS_PRODUCTS.ID_ORDER = ORDERS.ORDER_ID " +
"INNER JOIN PRODUCTS " +
"ON PRODUCTS.PRODUCT_ID = ORDERS_PRODUCTS.ID_PRODUCT " +
"INNER JOIN CUSTOMERS " +
"ON CUSTOMERS.CUSTOMER_ID = ORDERS.CUSTOMER_ID " +
"WHERE ORDERS.ORDER_ID = " + productId;
try
{
SqlDataAdapter adapter = new SqlDataAdapter(query, Conn);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = dataset.Tables[0].DefaultView;
productsHistoryDataGridView.DataSource = bindingSource;
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
Conn.Close(); // Close Connection
}
protected override void Serialize(IDictionary <string, object> json)
{
if (Today != DefaultToday)
{
json["today"] = Today;
}
if (Save != DefaultSave)
{
json["save"] = Save;
}
if (Cancel != DefaultCancel)
{
json["cancel"] = Cancel;
}
if (Destroy != DefaultDestroy)
{
json["destroy"] = Destroy;
}
if (Event != DefaultEvent)
{
json["event"] = Event;
}
if (Date != DefaultDate)
{
json["date"] = Date;
}
if (Time != DefaultTime)
{
json["time"] = Time;
}
if (AllDay != DefaultAllDay)
{
json["allDay"] = AllDay;
}
//TODO: CHECK IF THERE IS DATA BEFORE ASSIGN:
IDictionary <string, object> viewMessages = ViewMessages.ToJson();
if (viewMessages.Count > 0)
{
json["views"] = viewMessages;
}
IDictionary <string, object> recurrenceMessages = RecurrenceMessages.ToJson();
if (recurrenceMessages.Count > 0)
{
json["recurrenceMessages"] = recurrenceMessages;
}
IDictionary <string, object> editorMessages = EditorMessages.ToJson();
if (editorMessages.Count > 0)
{
json["editor"] = editorMessages;
}
IDictionary <string, object> recurrenceEditorMessages = RecurrenceEditorMessages.ToJson();
if (recurrenceEditorMessages.Count > 0)
{
json["recurrenceEditor"] = recurrenceEditorMessages;
}
}
