public void RegisterPendingOrdr(Busy_tables _Tables, List <Pending_Orders> _Orders)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
using (DbContextTransaction transaction = en.Database.BeginTransaction())
{
try
{
en.Busy_tables.Add(_Tables);
en.SaveChanges();
foreach (Pending_Orders itemOrder in _Orders)
{
en.Pending_Orders.Add(itemOrder);
}
en.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
}
}
private void BtnInic_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
try
{
bool isBusyTable;
MessageBoxResult boxResult;
string ordenStr = SendToProduction();
int tableid = Convert.ToInt32(CboListBox.SelectedValue.ToString());
var itemProduct = new List <Pending_Orders>();
itemProduct = SaveOrdrTemp();
var setIdTable = new Busy_tables
{
Table_busy = tableid
};
isBusyTable = OrderBL.GetInstance().VerifyTable(setIdTable);
if (isBusyTable)
{
boxResult = MessageBoxRM.Show("Esta mesa está ocupada, desea agregar otro producto a esta mesa?", "Mesa ocupada", MessageBoxButtonRM.YesNo, MessageBoxIconRM.Question);
if (boxResult == MessageBoxResult.OK)
{
OrderBL.GetInstance().RegisterPendingOrdr2(itemProduct);
var card = new CardItemOrd();
card.Nombre = $"Mesa #{tableid}";
card.Orden = ordenStr;
GetOrdens = card;
sendOrder = true;
if (NtfIcon.Visibility == Visibility.Hidden)
{
NtfIcon.Visibility = Visibility.Visible;
}
NtfIcon.Badge = OrderBL.GetInstance().NofPOrder();
DtGridOrden.Items.Clear();
CalculateTotal();
}
}
else
{
OrderBL.GetInstance().RegisterPendingOrdr(setIdTable, itemProduct);
//MessageBoxRM.Show(ordenStr);
var card = new CardItemOrd();
card.Nombre = $"Mesa #{tableid}";
card.Orden = ordenStr;
GetOrdens = card;
sendOrder = true;
if (NtfIcon.Visibility == Visibility.Hidden)
{
NtfIcon.Visibility = Visibility.Visible;
}
NtfIcon.Badge = OrderBL.GetInstance().NofPOrder();
DtGridOrden.Items.Clear();
CalculateTotal();
}
}
catch (Exception ex)
{
MessageBoxRM.Show(ex.Message, "Error al iniciar orden", MessageBoxButtonRM.OK, MessageBoxIconRM.Error);
}
}
public bool VerifyTable(Busy_tables tables)
{
bool isBusy = false;
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = en.Busy_tables.FirstOrDefault(t => t.Table_busy == tables.Table_busy);
if (query != null)
{
isBusy = true;
}
return(isBusy);
}
}
