public Table QueryTable(string tableNumber)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
Table aTable = null;
aTable = TableDao.GetTable(tableNumber);
return(aTable);
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
return(null);
}
catch (Exception ex)
{
raiseError(ex);
return(null);
}
}
public void UseTable(Dictionary <Table, DinningTable> tables)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
HCSMSLog.OnWarningLog(this, new NotifyEventArgs("Recieve use table Request"));
foreach (KeyValuePair <Table, DinningTable> pair in tables)
{
TableDao.InsertDinningTable(pair.Key.Number, pair.Value);
}
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
}
catch (Exception ex)
{
raiseError(ex);
}
}
private void btn_add_edit_table_Click(object sender, EventArgs e)
{
TableDao tableDao = new TableDao();
Table table = new Table();
table.Name = txt_table_name.Text;
table.Description = txt_table_desc.Text;
int returnId;
if (isUpdate)
{
table.Id = addEdittable.Id;
returnId = tableDao.updateTable(table);
}
else
{
returnId = tableDao.insertTable(table);
}
if (returnId != -1)
{
this.Close();
}
if (returnId == -9)
{
MessageBox.Show("Belə bir STOL adı mövcuddur");
}
}
public void tableListOnInterface()
{
flow_table.Controls.Clear();
//table flow layout
TableDao tableDao = new TableDao();
List <Table> tables = tableDao.getTableList();
foreach (Table table in tables)
{
CustomTable tableControl = new CustomTable();
tableControl.Tag = table;
tsm_table.Tag = table;
tableControl.setTable(table);
if (table.Total.Status)
{
tsm_table.Enabled = false;
tableControl.BackColor = Color.Green;
}
else
{
tsm_table.Enabled = true;
tableControl.BackColor = Color.Red;
}
tableControl.Click += customTableComponentClick;
tableControl.ContextMenuStrip = this.contextMenuStrip_open_table;
flow_table.Controls.Add(tableControl);
}
}
public void updateTableTest()
{
TableDao tableDao = new TableDao();
Table table = tableDao.GetTableById(1);
table.Status = "Dirty";
tableDao.updateTable(table);
Assert.IsTrue(tableDao.GetTableById(1).Status == "Dirty");
}
/// <summary>
/// Obsługa przycisku edycji
/// </summary>
/// <param name="sender">Obiekt wywołujący zdarzenie</param>
/// <param name="e">Obiekt zawierający parametry zdarzenia</param>
private void Edit_Click(object sender, RoutedEventArgs e)
{
MainWindow window = (MainWindow)Application.Current.MainWindow;
UserControl uc = new Forms.Settings();
TableModel model = TableDao.LoadById((long)(sender as Button).Tag);
model.Mode = "update";
uc.DataContext = model;
window.GridMain.Children.Clear();
window.GridMain.Children.Add(uc);
}
public Bill QueryBill(string tableNumber)
{
try
{
return(BillingDao.GetBill(TableDao.GetDinningTable(tableNumber).Id));
}
catch (HCSMSException ex)
{
raiseError(ex);
return(null);
}
}
public bool CreateOrder(OrderInfo orderInfo, List <ShoppingCartItem> cartItems, out string orderId)
{
orderId = String.Empty;
if (orderInfo == null)
{
return(false);
}
if (cartItems == null || cartItems.Count == 0)
{
return(false);
}
orderId = OrderIdHelper.NextBillNumber(1);
orderInfo.OrderId = orderId;
List <OrderDetail> orderDetails = new List <OrderDetail>();
foreach (var item in cartItems)
{
OrderDetail detail = new OrderDetail();
detail.OrderId = orderId;
detail.DishId = item.ItemID;
detail.DishEName = item.EName;
detail.DishOName = item.OName;
detail.UnitPrice = item.Price;
detail.Count = item.Qty;
orderDetails.Add(detail);
}
var monthStatus = String.Empty;
char[] charsList = null;
var tableDs = new TableDao().GetTableMonthStatusByTableNum(orderInfo.TableNum, orderInfo.MealTime.Month);
if (tableDs != null && tableDs.Tables != null && tableDs.Tables.Count > 0)
{
monthStatus = tableDs.Tables[0].Rows[0]["smn"].ToString();
charsList = monthStatus.ToCharArray();
charsList[orderInfo.MealTime.Day - 1] = '0';
}
dao.CreateOrder(orderInfo, orderDetails, new string(charsList));
return(true);
}
public void tableListViewOnInterface()
{
lv_table.Items.Clear();
//table flow layout
TableDao tableDao = new TableDao();
List <Table> tables = tableDao.getTableList();
foreach (Table table in tables)
{
var row = new String[] { table.Name, table.Id.ToString() };
var lvi = new ListViewItem(row);
lvi.Tag = table;
lv_table.Items.Add(lvi);
}
}
public void GetDinningTableTest()
{
string tableNumber = string.Empty; // TODO: 初始化为适当的值
DinningTable expected = new DinningTable(); // TODO: 初始化为适当的值
expected.Id = "003";
expected.GuestAmount = 5;
expected.ArrivedTime = DateTime.Parse("2010-6-5 20:05:57");
expected.Note = string.Empty;
DinningTable actual;
actual = TableDao.GetDinningTable("003");
Assert.AreEqual(expected.Id, actual.Id);
Assert.AreEqual(expected.GuestAmount, actual.GuestAmount);
Assert.AreEqual(expected.ArrivedTime.ToString(), actual.ArrivedTime.ToString());
Assert.AreEqual(expected.Note, actual.Note);
}
public static void Reset()
{
_dataApi = null;
_administratorDao = null;
_administratorsInRolesDao = null;
_areaDao = null;
_channelDao = null;
_channelGroupDao = null;
_configDao = null;
_contentCheckDao = null;
_contentDao = null;
_contentGroupDao = null;
_countDao = null;
_databaseDao = null;
_dbCacheDao = null;
_departmentDao = null;
_errorLogDao = null;
_keywordDao = null;
_logDao = null;
_permissionsInRolesDao = null;
_pluginConfigDao = null;
_pluginDao = null;
_recordDao = null;
_relatedFieldDao = null;
_relatedFieldItemDao = null;
_roleDao = null;
_siteDao = null;
_siteLogDao = null;
_sitePermissionsDao = null;
_specialDao = null;
_tableDao = null;
_tableMatchDao = null;
_tableMetadataDao = null;
_tableStyleDao = null;
_tableStyleItemDao = null;
_tagDao = null;
_templateDao = null;
_templateLogDao = null;
_templateMatchDao = null;
_userDao = null;
_userLogDao = null;
}
private void btn_delete_table_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show(table.Name + " silməyə əminsinizmi?", "STOL", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
TableDao tableDao = new TableDao();
int returnId = tableDao.deleteTable(table);
if (returnId != 0 && returnId != null)
{
//tableListOnInterface();
tableListViewOnInterface();
btn_edit_table.Enabled = false;
btn_delete_table.Enabled = false;
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
public void ChangeTable(string oldTableNumber, string newTableNumber)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
HCSMSLog.OnWarningLog(this, new NotifyEventArgs("Recieve change table Request"));
List <Table> tableList = TableDao.GetAvailableTable();
bool tableExist = false;
foreach (Table table in tableList)
{
if (table.Number == oldTableNumber)
{
tableExist = true;
break;
}
}
if (tableExist)
{
TableDao.ChangeTable(((DinningTable)TableDao.GetDinningTable(oldTableNumber)).Id, oldTableNumber, newTableNumber);
}
else
{
TableDao.MergeTable(((DinningTable)TableDao.GetDinningTable(oldTableNumber)).Id, ((DinningTable)TableDao.GetDinningTable(newTableNumber)).Id);
}
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
}
catch (Exception ex)
{
raiseError(ex);
}
}
public bool CancelOrder(int userId, int orderInfoId)
{
var result = true;
try
{
var ds = dao.GetOrderInfoByOrderInfoId(orderInfoId);
var tableNum = 0;
var monthNum = 0;
var dayInMonth = 0;
char[] charsList = null;
var monthStatus = String.Empty;
if (ds != null && ds.Tables != null && ds.Tables.Count > 0)
{
tableNum = Convert.ToInt32(ds.Tables[0].Rows[0]["tableNumber"].ToString());
var mealTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["mealTime"].ToString());
monthNum = mealTime.Month;
dayInMonth = mealTime.Day;
}
var tableDs = new TableDao().GetTableMonthStatusByTableNum(tableNum, monthNum);
if (tableDs != null && tableDs.Tables != null && tableDs.Tables.Count > 0)
{
monthStatus = tableDs.Tables[0].Rows[0]["smn"].ToString();
charsList = monthStatus.ToCharArray();
charsList[dayInMonth - 1] = '1';
}
dao.CancelOrder(userId, orderInfoId, tableNum, monthNum, new string(charsList));
}
catch
{
result = false;
}
return(result);
}
public List <Table> QueryTableList(QueryCriteria condition)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
return(TableDao.GetTable(condition));
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
return(null);
}
catch (Exception ex)
{
raiseError(ex);
return(null);
}
}
public List <Table> GetTable(DateTime date)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
return(TableDao.GetAvailablePreorderTable(date));
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
return(null);
}
catch (Exception ex)
{
raiseError(ex);
return(null);
}
}
/// <summary>
/// Wysłanie formularza
/// </summary>
/// <param name="sender">Obiekt wywołujący zdarzenie</param>
/// <param name="e">Obiekt zawierający parametry zdarzenia</param>
private void Submit_Click(object sender, RoutedEventArgs e)
{
// Pobranie modelu z formularza
TableModel model = DataContext as TableModel;
if (model.Mode == TableModel.UPDATE && TableDao.LoadById(model.Id) != null)
{
MessageBox.Show("Ten numer stolika jest już zajęty", "Dodawanie stolika");
return;
}
if (model.Mode == TableModel.INSERT)
{
TableDao.Insert(model);
MessageBox.Show("Stolik został dodany", "Dodawanie stolika");
}
else if (model.Mode == TableModel.UPDATE)
{
TableDao.Update(model);
MessageBox.Show("Zmiany zostały zapisane", "Edycja stolika");
}
Back();
}
public void GetTableListTest()
{
TableDao tableDao = new TableDao();
Assert.IsTrue(tableDao.GetTableList().Count() == 11);
}
/// <summary>
/// Odświeżanie danych
/// </summary>
private void RefreshGrid()
{
TablesDataGrid.ItemsSource = TableDao.LoadAll();
}
/// <summary>
/// Obsługa przycisku usuwania
/// </summary>
/// <param name="sender">Obiekt wywołujący zdarzenie</param>
/// <param name="e">Obiekt zawierający parametry zdarzenia</param>
private void Delete_Click(object sender, RoutedEventArgs e)
{
TableDao.Delete((long)(sender as Button).Tag);
RefreshGrid();
}
public void OrderItem(string tableNumber, List <Item> itemList)
{
FrontDeskRequest frontdesk = null;
try
{
HCSMSLog.OnWarningLog(this, new NotifyEventArgs("Recieve Order Request"));
//check if this table is really in use
DinningTable table = TableDao.GetDinningTable(tableNumber);
if (table == null)
{
throw new HCSMSException("餐桌是空的 ！");
}
// constructing order list
List <RequestHandleInfo> requestList = new List <RequestHandleInfo>();
foreach (Item ite in itemList)
{
RequestHandleInfo info = new RequestHandleInfo();
info.EntityId = tableNumber;
info.IsHandled = false;
info.RequestType = RequestType.OrderItem;
info.SourceId = ite.Id;
requestList.Add(info);
}
//check for response of cook at the kitchen
KitchenRequest handler = KitchenRequestControl.GetService();
if (handler == null)
{
requestList.Clear();
}
else
{
requestList = handler.OnOrderItem(requestList);
}
HCSMSLog.OnWarningLog(this, new NotifyEventArgs("Recieve Result order item"));
List <RequestHandleInfo> denyList = new List <RequestHandleInfo>();
foreach (RequestHandleInfo ite in requestList)
{
if (!ite.IsHandled)
{
denyList.Add(ite);
}
}
if (denyList.Count == 0 && requestList.Count > 0)
{
//save data to database
ItemDao.InsertItemOrder(table.Id, itemList);
}
else
{
frontdesk = FrontDeskRequestControl.GetService(callBackId);
if (frontdesk != null)
{
//means kitchen service is not up
if (requestList.Count == 0)
{
frontdesk.InformationMessage(new NotifyEventArgs("不存在厨房处理服务！"));
}
// notify front desk, the request is not satisfied
else
{
frontdesk.RequestDeny(denyList);
}
}
}
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("Order Item Not Success", ex));
}
}
catch (Exception ex)
{
raiseError(ex);
}
}
public void GetTableByIdTest()
{
TableDao tableDao = new TableDao();
Assert.IsTrue(tableDao.GetTableById(1).Id == 1);
}
