public List <OrderItem> getTodayOrderItems()
{
List <OrderItem> orderItems = new List <OrderItem>();
DataTable table = new DataTable();
String query = "SELECT * FROM history WHERE date ='" + DateTime.Now.ToString("MM/dd/yyyy") + "'";
try
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter(query, dbConnection.getConnection());
adapter.Fill(table);
}
catch (SQLiteException ex)
{
String v = ex.Message;
return(orderItems);
}
OrderItem currentOrder = new OrderItem();
foreach (DataRow row in table.Rows)
{
if (currentOrder.kebabs.Count != 0)
{
int orderNumber = (int)row.Field <Int64>("orderNumber");
DateTime orderTime = DateTime.Parse(row.Field <String>("date") + " " + row.Field <String>("time"), culture);
if (currentOrder.orderNumber == orderNumber && currentOrder.orderTime == orderTime)
{
currentOrder.AddNewKebabToOrder(new KebabItem(row));
}
else
{
orderItems.Add(currentOrder);
currentOrder = new OrderItem();
currentOrder.orderNumber = (int)row.Field <Int64>("orderNumber");
currentOrder.orderTime = DateTime.Parse(row.Field <String>("date") + " " + row.Field <String>("time"), culture);
currentOrder.AddNewKebabToOrder(new KebabItem(row));
}
}
else
{
currentOrder.orderNumber = (int)row.Field <Int64>("orderNumber");
currentOrder.orderTime = DateTime.Parse(row.Field <String>("date") + " " + row.Field <String>("time"), culture);
currentOrder.AddNewKebabToOrder(new KebabItem(row));
}
}
if (currentOrder.kebabs.Count != 0)
{
orderItems.Add(currentOrder);
}
return(orderItems);
}
private void btAdd_Click(object sender, EventArgs e)
{
if (!checkInput())
{
return;
}
SizeTypeEnum size;
if (rbSmall.Checked)
{
size = SizeTypeEnum.small;
}
else if (rbStandart.Checked)
{
size = SizeTypeEnum.standart;
}
else
{
size = SizeTypeEnum.big;
}
PitaTypeEnum pitaType = (rbWheat.Checked ? PitaTypeEnum.wheaten : PitaTypeEnum.cheesy);
List <SauceTypeEnum> sauces = GetKebabSauces();
string comment = rtbComment.Text;
int quantity = int.Parse(tbCount.Text);
KebabItem kebab = new KebabItem(
size,
pitaType,
sauces,
comment,
quantity);
currentOrder.AddNewKebabToOrder(kebab);
Label newLabel = new Label();
newLabel.Name = "lbN" + labelCounter;
newLabel.Left = 10;
newLabel.Width = gbOrder.Width - 100;
newLabel.Height = 30;
if (lastLabel == null)
{
newLabel.Top = 20;
}
else
{
newLabel.Top = lastLabel.Bottom;
}
newLabel.Text = kebab.ToString();
gbOrder.Controls.Add(newLabel);
Label costLabel = new Label();
costLabel.Width = 60;
costLabel.Name = "costN" + labelCounter;
costLabel.Left = gbOrder.Width - 70;
costLabel.Top = newLabel.Top;
costLabel.Text = "=" + kebab.CountCost();
gbOrder.Controls.Add(costLabel);
labelCounter++;
lastLabel = newLabel;
clearErrorProvider(sender, e);
clearInput();
}