private void AddButton_Click(object sender, RoutedEventArgs e)
{
using (MyDBContext db = new MyDBContext())
{
if (!String.IsNullOrWhiteSpace(CountBox.Text))
{
Order_list order_List = new Order_list
{
ID = db.Order_Lists.Count() + 1,
Count = CountBox.Text,
Order = GetOrder(db.Orders.ToList()),
Dish = GetDish(db.Dishes.ToList())
};
if (EditID == -1)
{
db.Order_Lists.Add(order_List);
}
else
{
var result = db.Order_Lists.Find(EditID);
result.Count = CountBox.Text;
result.Dish = GetDish(db.Dishes.ToList());
result.Order = GetOrder(db.Orders.ToList());
}
}
else
{
MessageBox.Show("Заполнены не все поля");
}
db.SaveChanges();
this.Close();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MyDBContext db = new MyDBContext())
{
Order_list EditOrder_List = db.Order_Lists.Find(EditID);
var orders = db.Orders.ToList();
var dishes = db.Dishes.ToList();
List <string> orderList = new List <string>();
List <string> dishList = new List <string>();
foreach (var item in orders)
{
orderList.Add($"{item.Date.ToShortDateString()} {item.Place} {item.Time.ToShortTimeString()}");
}
foreach (var item in dishes)
{
dishList.Add(item.Name);
}
OrderCombo.ItemsSource = orderList;
DishCombo.ItemsSource = dishList;
if (EditID != -1)
{
AddButton.Content = "Сохранить";
CountBox.Text = EditOrder_List.Count;
DishCombo.SelectedItem = EditOrder_List.Dish.Name;
OrderCombo.SelectedItem = $"{EditOrder_List.Order.Date} {EditOrder_List.Order.Place} {EditOrder_List.Order.Time}";
}
}
}
private void DisplayOrderData()
{
ordList.Clear();
Order_list.Items.Clear();
Order_list.ClearSelected();
//Order_list.Refresh();
try
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("Select * from [Orders] where Users_id = '" + user.Id + "'", conn))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
long len = reader.GetBytes(3, 0, null, 0, 0);
Byte[] buffer = new Byte[len];
reader.GetBytes(3, 0, buffer, 0, (int)len);
Proudects prd = new Proudects()
{
Name = reader.GetString(1).ToString(),
Price = reader.GetDouble(2),
Image = dth.byteArrayToImage(buffer),
Description = reader.GetString(9).ToString()
};
ordList.Add(prd);
}
}
}
foreach (var item in ordList)
{
Order_list.Items.Add(new exListBoxItem(idd, item.Name, item.Description, item.Price.ToString() + "$", item.Image));
idd++;
}
timer1.Start();
Console.WriteLine(ordList.Count);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
timer1.Stop();
}
}
