private void orderEdit_OnSaveOrder(Order obj)
{
using (var context = new RestoranDbContext())
{
//context.Order.Add(obj);
//
//obj.Details.Clear();
context.Order.Update(obj);
//context.SaveChanges();
//obj.Details.Add(new Detail() { ItemsId = 1,Price = 10,Count = 2,Bill=20
//});
//context.Order.Add(obj);
context.SaveChanges();
}
RefreshGrid();
mainForm.Visibility = Visibility.Visible;
orderEdit.Visibility = Visibility.Collapsed;
}
private void orderEdit_OnSaveOrder(Order obj)
{
using (var context = new RestoranDbContext())
{
var connect = context.Database.GetDbConnection();
connect.BeginTransaction();
if (obj.Id == 0)
{
obj.Id = connect.ExecuteScalar <int>("SELECT IDENT_CURRENT('Order')");
connect.Execute("INSERT INTO [Order] (Id,[waiter_id],[abonent_id],[time_order],[Bill],[FixedSource]) VALUES(@Id, @waiter_id, @abonent_id, @time_order, @Bill, @FixedSource); ", new { Id = obj.Id, waiter_id = obj.WaiterId, abonent_id = obj.AbonentId, time_order = obj.TimeOrder, Bill = obj.Bill, FixedSource = obj.FixedSource });
}
else
{
connect.Execute("UPDATE [Order] SET waiter_id = @waiter_id, abonent_id = @abonent_id, time_order = @time_order, Bill = @Bill, FixedSource = @FixedSource,end_order = @end_order,Paid = @Paid) WHERE Id=@Id; ", new { Id = obj.Id, waiter_id = obj.WaiterId, abonent_id = obj.AbonentId, time_order = obj.TimeOrder, Bill = obj.Bill, FixedSource = obj.FixedSource, end_order = obj.EndOrder, Paid = obj.Paid });
}
foreach (var item in obj.Details)
{
if (item.Id == 0)
{
item.OrderId = obj.Id;
}
else
{
}
}
context.Order.Update(obj);
//context.SaveChanges();
//obj.Details.Add(new Detail() { ItemsId = 1,Price = 10,Count = 2,Bill=20
//});
//context.Order.Add(obj);
context.SaveChanges();
}
RefreshGrid();
mainForm.Visibility = Visibility.Visible;
orderEdit.Visibility = Visibility.Collapsed;
}