private void AddBIO_Click(object sender, RoutedEventArgs e)
{
Entities.OrderInTime order = new Entities.OrderInTime();
order.WaiterID = waiterid;
order.TableID = 1;
order = Requests.MethodsWaiter.InsertOrderInTime(context, order);
//Context contextnew = new Context();
Entities.BludoInOrder bio = new Entities.BludoInOrder();
try
{
bio.BludoAmount = int.Parse(AmountB.Text);
bio.BludoStatus = (Status.SelectedItem).ToString();
bio.OrderID = order.OrderID;
var bludo = Requests.MethodsOrder.GetBludoByName(context, (ChooseB.SelectedItem).ToString());
bio.BludoID = bludo.BludoID;
bio.OrderTime = DateTime.Now;
}
catch (Exception ex)
{
MessageBox.Show("Проверьте правильность ввода данных.");
}
Requests.MethodsWaiter.InsertBludoInOrder(context, bio);
ChooseB.SelectedItem = null;
Status.SelectedItem = null;
AmountB.Text = "";
(App.Current.Windows[1]).IsEnabled=true;
}
public static void UpdateBludoInOrder(Context context, Entities.BludoInOrder bludo)
{
var bludoio = (from c in context.BludosInOrder
where (c.BludoID == bludo.BludoID) && (c.OrderID == bludo.OrderID)
select c).First();
bludoio.BludoStatus = bludo.BludoStatus;
}
public static void InsertBludoInOrder(Context context, Entities.BludoInOrder bludoIO)
{
//foreach (var b in context.Bludos.Where(b => b.BludoID == bludoIO.BludoID))
//{
// var bID = b.BludoID;
// foreach (var o in context.OrdersInTime.Where(o => o.OrderID == bludoIO.OrderID))
// {
// var oID = o.OrderID;
// context.BludosInOrder.Add(new Entities.BludoInOrder { BludoID = bID, BludoAmount = bludoIO.BludoAmount, BludoStatus = bludoIO.BludoStatus, OrderID = oID, OrderTime = DateTime.Now });
// context.SaveChanges();
// }
//}
context.BludosInOrder.Add(bludoIO);
context.SaveChanges();
}
public List<Entities.BludoInOrder> GetAllBludosInOrder()
{
List<Entities.BludoInOrder> listBludosIO = new List<Entities.BludoInOrder>();
using (TeamProjectEntities6 entities = new TeamProjectEntities6())
{
var bludosIO = from r in entities.BludoInOrder
select r;
foreach (BludoInOrder singleBludoIO in bludosIO)
{
Entities.BludoInOrder bo = new Entities.BludoInOrder();
bo.OrderID = singleBludoIO.id;
bo.BludoID = int.Parse(singleBludoIO.id_Bludo.ToString());
bo.BludoAmount = int.Parse(singleBludoIO.number_Bludo.ToString());
bo.BludoStatus = singleBludoIO.status;
bo.OrderTime = DateTime.Parse(singleBludoIO.ordertime.ToString());
listBludosIO.Add(bo);
}
}
return listBludosIO;
}
