public wndw_OrderHistory(DatabaseConnection conn, string username)
{
InitializeComponent();
this.conn = conn;
userID = GetUserID(username);
dataGrid.IsReadOnly = true;
list = conn.ReadData("SELECT Date, Orders.ID FROM Orders WHERE Orders.Users_ID = " + userID);
int counter = 1;
for (int i = 0; i < list.Count; i += 2)
{
comboBox.Items.Add(counter + ". " + list[i].Substring(0, list[i].IndexOf(" ")));
counter++;
}
}
public void Init(DatabaseConnection conn)
{
this.conn = conn;
shipmnetsList = new List<Shipment>();
List<string> list = conn.ReadData("select ID, Name, Price from Shipping_methods");
for (int i = 0; i < list.Count; i += 3)
{
decimal result = decimal.Parse(list[i + 2], CultureInfo.InvariantCulture);
Shipment s = new Shipment(Convert.ToInt32(list[i]), list[i + 1], result);
shipmnetsList.Add(s);
}
foreach (Shipment s in shipmnetsList)
comboBox.Items.Add(s.Name);
}