private CTableInfo ReaderToAvailableTable(IDataReader oReader) { CTableInfo tempAvailableTable = new CTableInfo(); if (oReader["table_number"] != null) { tempAvailableTable.TableNumber = int.Parse(oReader["table_number"].ToString()); } if (oReader["capacity"] != null) { tempAvailableTable.Capacity = int.Parse(oReader["capacity"].ToString()); } if (oReader["status"] != null) { tempAvailableTable.Status = int.Parse(oReader["status"].ToString()); } if (oReader["table_type"] != null) { tempAvailableTable.TableType = oReader["table_type"].ToString(); } return tempAvailableTable; }
public CResult UpdateTableInfo(CTableInfo inTableInfo) { try { CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo = inTableInfo; Database.Instance.TableInfo.UpdateTableInfo(inTableInfo); m_oResult.IsSuccess = true; m_oResult.Message = "Data Updated Successfully"; } catch (Exception ex) { System.Console.WriteLine("Exception occuer at UpdateTableInfo() : " + ex.Message); m_oResult.IsException = true; m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE; //m_oResult.SetParams(ex.Message); m_oResult.Message = ex.Message; Logger.Write("Exception : " + ex + " in UpdateTableInfo()", LogLevel.Error, "COrderManager"); } return m_oResult; }
public CTableInfo TableInfoGetByTableNumber(int inTableNumber, string inTableType) { CTableInfo tempTableInfo = new CTableInfo(); try { inTableType = inTableType.Replace("''", "'"); inTableType = inTableType.Replace("'", "''"); this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.TableInfoGetByTableNumber), inTableNumber, inTableType); IDataReader oReader = this.ExecuteReader(sSql); if (oReader != null) { while (oReader.Read()) { tempTableInfo = ReaderToAvailableTable(oReader); } } } catch (Exception ex) { Console.Write("###" + ex + "###"); Logger.Write("Exception : " + ex + " in TableInfoGetByTableNumber()", LogLevel.Error, "Database"); if (ex.GetType().Equals(typeof(SqlException))) { SqlException oSQLEx = ex as SqlException; if (oSQLEx.Number != 7619) throw new Exception("Exception occure at TableInfoGetByTableNumber()", ex); } else { throw new Exception("Exception occure at TableInfoGetByTableNumber()", ex); } } finally { this.CloseConnection(); } return tempTableInfo; }
public void UpdateTableInfo(CTableInfo inTableInfo) { inTableInfo.TableType = inTableInfo.TableType.Replace("''", "'"); inTableInfo.TableType = inTableInfo.TableType.Replace("'", "''"); try { this.OpenConnection(); String sSql = string.Format(SqlQueries.GetQuery(Query.UpdateTableInfo), inTableInfo.Capacity, inTableInfo.Status, inTableInfo.TableNumber, inTableInfo.TableType); this.ExecuteNonQuery(sSql); } catch (Exception ex) { Console.Write("###" + ex + "###"); Logger.Write("Exception : " + ex + " in UpdateTableInfo()", LogLevel.Error, "Database"); if (ex.GetType().Equals(typeof(SqlException))) { SqlException oSQLEx = ex as SqlException; if (oSQLEx.Number != 7619) throw new Exception("Exception occure at UpdateTableInfo()", ex); } else { throw new Exception("Exception occure at UpdateTableInfo()", ex); } } finally { this.CloseConnection(); } }
private void FinishButton_Click(object sender, EventArgs e) { CResult objResultant = new CResult(); try { if (!CheckEmpty() && m_orderIndex == 1) { CMessageBox tempMessageBox = new CMessageBox("Error", "Please enter all the mandatory values."); tempMessageBox.ShowDialog(); return; } CCustomerManager tempCustomerManager = new CCustomerManager(); CCustomerInfo tempCustomerInfo = new CCustomerInfo(); if (txtPhoneNumber.Text.Trim().Equals(String.Empty)) { CResult oResult5 = tempCustomerManager.CustomerInfoGetByName(txtCustomerName.Text.Trim()); if (oResult5.IsSuccess && oResult5.Data != null) { tempCustomerInfo = (CCustomerInfo)oResult5.Data; } } else { CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(txtPhoneNumber.Text.Trim()); if (oResult.IsSuccess && oResult.Data != null) { tempCustomerInfo = (CCustomerInfo)oResult.Data; } } if (txtCustomerName.Text.Length == 0 && (m_orderIndex == 2 || m_orderIndex == 3)) { txtCustomerName.Text = m_order_name; } tempCustomerInfo.CustomerName = txtCustomerName.Text.Trim(); tempCustomerInfo.CustomerPhone = txtPhoneNumber.Text.Trim(); if (m_orderIndex == 1) //If only delivery type order is considered { tempCustomerInfo.CustomerPostalCode = txtPostalCode.Text.Trim(); tempCustomerInfo.FloorAptNumber = txtFloorAptNumber.Text.Trim(); tempCustomerInfo.HouseNumber = txtHouseNumber.Text.Trim(); tempCustomerInfo.StreetName = txtStreetName.Text.Trim() + "-" + txtStreet2.Text.Trim(); tempCustomerInfo.BuildingName = txtBuildingName.Text.Trim(); tempCustomerInfo.CustomerTown = txtTown.Text.Trim(); tempCustomerInfo.CustomerCountry = cmbCountry.Text; tempCustomerInfo.UserName = RMSGlobal.LoginUserName; tempCustomerInfo.TerminalId = RMSGlobal.Terminal_Id; Int64 currentdateTime = DateTime.Now.Ticks; tempCustomerInfo.InsertDate = currentdateTime; } if (tempCustomerInfo.CustomerID == 0) { CResult oResult6 = tempCustomerManager.InsertCustomerInfo(tempCustomerInfo); if (oResult6.IsSuccess && oResult6.Data != null) tempCustomerInfo = (CCustomerInfo)oResult6.Data; } else { tempCustomerManager.UpdateCustomerInfo(tempCustomerInfo); } #region "Older" if (m_customerEditStatus == false) { if (m_iOrderID == 0) { COrderManager tempOrderManager = new COrderManager(); COrderInfo tempOrderInfo = new COrderInfo(); tempOrderInfo.CustomerID = tempCustomerInfo.CustomerID; tempOrderInfo.OrderType = "TakeAway"; tempOrderInfo.OrderTime = System.DateTime.Now; tempOrderInfo.TableNumber = GetValidTableNumber("TakeAway"); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = tempOrderInfo.TableNumber; tempTableInfo.TableType = "TakeAway"; tempOrderManager.InsertTableInfo(tempTableInfo); if (m_orderIndex==1) { tempOrderInfo.Status = "Delivery"; } else if (m_orderIndex ==2 ) { tempOrderInfo.Status = "Collection"; } else if (m_orderIndex == 3) { tempOrderInfo.Status = "Waiting"; } m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); tempOrderInfo.UserID = m_oCommonConstants.UserInfo.UserID; objResultant = tempOrderManager.InsertOrderInfo(tempOrderInfo); //New Order COrderInfo tempOrderInfoNew = (COrderInfo)objResultant.Data;//Taking the order ID m_iOrderID = tempOrderInfoNew.OrderID; #region " Inserting Order details info if items are selected from the previous orders" //Developed by baruri List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>(); if (m_htOrderInfo.Count > 0) //If item is selected from the previous order { tempOrderDetailsList = (List<COrderDetails>)m_htOrderInfo["orderdetail"]; } if (tempOrderDetailsList.Count > 0) //Insert details for the new order { for (int itemDetailIndex = 0; itemDetailIndex < tempOrderDetailsList.Count; itemDetailIndex++) { COrderDetails objOrderDetails = (COrderDetails)tempOrderDetailsList[itemDetailIndex]; objOrderDetails.OrderID = tempOrderInfo.OrderID; tempOrderManager.InsertOrderDetails(objOrderDetails); } m_htOrderInfo = new Hashtable();//Clearing the previous items from the order if there is any. } #endregion //insert delivery time if (tempOrderInfo.Status.Equals("Delivery")) { CDelivery tempDelivery = new CDelivery(); tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID; string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text; tempDelivery.DeliveryTime = deliveryTime;// DeliveryTimeTextBox.Text.Trim(); tempOrderManager.InsertDeliveryInfo(tempDelivery); } //OLD Code //Form tempForm = CFormManager.Forms.Pop(); //tempForm.Show(); try { WaiterForm waiterForm = new WaiterForm(); waiterForm.UserList = userList; waiterForm.ShowDialog(); if (waiterForm.DialogResult == DialogResult.OK) { COrderWaiterDao orderwaiterDao = new COrderWaiterDao(); COrderwaiter orderwaiter = new COrderwaiter(); orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID); if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.UpdateOrderwaiter(orderwaiter); } else if (orderwaiter.ID == 0) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.InsertOrderwaiter(orderwaiter); } } } catch (Exception ex) { } m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); CTableOrderForm tempForm = new CTableOrderForm(m_iOrderID, m_oCommonConstants.TakeAwayType, tempOrderInfo.TableNumber); tempForm.m_orderUserName = RMSGlobal.LoginUserName; tempForm.Show(); this.Close(); } else { COrderManager tempOrderManager = new COrderManager(); CResult oResult7 = tempOrderManager.OrderInfoByOrderID(m_iOrderID); COrderInfo tempOrderInfo = new COrderInfo(); if (oResult7.IsSuccess && oResult7.Data != null) { tempOrderInfo = (COrderInfo)oResult7.Data; } tempOrderInfo.OrderType = "TakeAway"; tempOrderInfo.Status = "TakeAway"; tempOrderInfo.GuestCount = 0; tempOrderInfo.TableName = ""; tempOrderInfo.CustomerID = tempCustomerInfo.CustomerID; tempOrderInfo.TableNumber = GetValidTableNumber("TakeAway"); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = tempOrderInfo.TableNumber; tempTableInfo.TableType = "TakeAway"; tempOrderManager.InsertTableInfo(tempTableInfo); if (m_orderIndex == 1) { tempOrderInfo.Status = "Delivery"; } else if (m_orderIndex == 3) { tempOrderInfo.Status = "Waiting"; } else if (m_orderIndex == 2) { tempOrderInfo.Status = "Collection"; } tempOrderManager.UpdateOrderInfo(tempOrderInfo); //insert delivery time if (tempOrderInfo.Status.Equals("Delivery")) { CDelivery tempDelivery = new CDelivery(); tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID; string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text; tempDelivery.DeliveryTime = deliveryTime;// DeliveryTimeTextBox.Text.Trim(); tempOrderManager.InsertDeliveryInfo(tempDelivery); } try { WaiterForm waiterForm = new WaiterForm(); waiterForm.UserList = userList; waiterForm.ShowDialog(); if (waiterForm.DialogResult == DialogResult.OK) { COrderWaiterDao orderwaiterDao = new COrderWaiterDao(); COrderwaiter orderwaiter = new COrderwaiter(); orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID); if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.UpdateOrderwaiter(orderwaiter); } else if (orderwaiter.ID == 0) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.InsertOrderwaiter(orderwaiter); } } } catch (Exception ex) { } m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); CTableOrderForm tempForm = (CTableOrderForm)CFormManager.Forms.Pop(); tempForm.m_iType = m_oCommonConstants.TakeAwayType; tempForm.Show(); this.Close(); } } #endregion else //Edit order information.As here is reached from order details screen. { COrderInfo tempOrderInfo = new COrderInfo(); COrderManager tempOrderManager = new COrderManager(); CDelivery tempDelivery = null; tempOrderInfo.OrderID = m_iOrderID; tempOrderManager.DeleteDeliveryInfo(m_iOrderID);//Delete previous record from delivery information table if (m_orderIndex==2) { tempOrderInfo.Status = "Collection"; } else if (m_orderIndex==3) { tempOrderInfo.Status = "Waiting"; } else { tempOrderInfo.Status = "Delivery"; tempDelivery = new CDelivery(); tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID; string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text; tempDelivery.DeliveryTime = deliveryTime;// tempOrderManager.InsertDeliveryInfo(tempDelivery);//Update delivery information } tempOrderManager.UpdateTakeawayOrderInfo(tempOrderInfo);//Update order information try { WaiterForm waiterForm = new WaiterForm(); waiterForm.UserList = userList; waiterForm.ShowDialog(); if (waiterForm.DialogResult == DialogResult.OK) { COrderWaiterDao orderwaiterDao = new COrderWaiterDao(); COrderwaiter orderwaiter = new COrderwaiter(); orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID); if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.UpdateOrderwaiter(orderwaiter); } else if (orderwaiter.ID == 0) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.InsertOrderwaiter(orderwaiter); } } } catch (Exception ex) { } m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); CTableOrderForm tempForm = (CTableOrderForm)CFormManager.Forms.Pop(); tempForm.m_iType = m_oCommonConstants.TakeAwayType; tempForm.Show(); this.Close(); } m_phoneNumber = String.Empty; } catch (Exception exp) { Console.Write(exp.Message); } }
public CResult GetCurentWaitingNumber(long currentDate, int orderIndex) { CResult tempResult = new CResult(); try { CTableInfo tempTable = new CTableInfo(); this.OpenConnection(); string sqlCommand = ""; if (orderIndex == 3) { sqlCommand = string.Format(SqlQueries.GetQuery(Query.CurrentWaitingNumber), currentDate); } else if (orderIndex == 2) { sqlCommand = string.Format(SqlQueries.GetQuery(Query.CurrentCollectionNumber), currentDate); } IDataReader oReader = this.ExecuteReader(sqlCommand); if (oReader != null) { while (oReader.Read()) { if (orderIndex == 3) { tempTable.WaitingNumber = Convert.ToInt64("0" + oReader["waiting_number_today"]); } else if (orderIndex == 2) { tempTable.WaitingNumber = Convert.ToInt64("0" + oReader["collection_number_today"]); } } } tempResult.Data = tempTable; tempResult.IsSuccess = true; } catch (Exception ex) { tempResult.IsException = true; Console.Write("###" + ex + "###"); Logger.Write("Exception : " + ex + " in GetCurentWaitingNumber()", LogLevel.Error, "Database"); if (ex.GetType().Equals(typeof(SqlException))) { SqlException oSQLEx = ex as SqlException; if (oSQLEx.Number != 7619) throw new Exception("Exception occure at GetCurentWaitingNumber()", ex); } else { throw new Exception("Exception occure at GetCurentWaitingNumber()", ex); } } finally { this.CloseConnection(); } return tempResult; }
private void functionalButton1_Click(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); CResult oResult = tempOrderManager.OrderInfoByOrderID(orderID); COrderInfo tempOrderInfo = new COrderInfo(); if (oResult.IsSuccess && oResult.Data != null) { tempOrderInfo = (COrderInfo)oResult.Data; } List<COrderShow> tempOrderShowList = new List<COrderShow>(); oResult = tempOrderManager.OrderListShowByStatus("Paid"); if (oResult.IsSuccess && oResult.Data != null) { tempOrderShowList = (List<COrderShow>)oResult.Data; } if (tempOrderInfo.OrderType.Equals("Table")) { tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, "Table"); CTakeAwayForm tempTakeAway = new CTakeAwayForm(orderID); tempTakeAway.Show(); CFormManager.Forms.Push(this); this.Hide(); } else if (tempOrderInfo.OrderType.Equals("TakeAway")) { CCalculatorForm tableNumberForm = new CCalculatorForm("Table Information", "Table Number"); tableNumberForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) return; if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } string tableNumber = ""; tableNumber = CCalculatorForm.inputResult; bool found = false; for (int counter = 0; counter < tempOrderShowList.Count; counter++) { if (int.Parse(tableNumber) == tempOrderShowList[counter].TableNumber && tempOrderShowList[counter].OrderType.Equals("Table")) found = true; } if (found) { CMessageBox tempMessageBox = new CMessageBox("Error", "Table already opened. Please select another table number."); tempMessageBox.ShowDialog(); return; } CCalculatorForm tableGuestForm = new CCalculatorForm("Table Information", "Guest Quantity"); tableGuestForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) return; if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } string tableGuest = ""; tableGuest = CCalculatorForm.inputResult; tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, "TakeAway"); tempOrderInfo.OrderType = "Table"; tempOrderInfo.Status = "Seated"; tempOrderInfo.TableNumber = int.Parse(tableNumber); //tempOrderInfo.TableName = "Table " + tableNumber; tempOrderInfo.GuestCount = int.Parse(tableGuest); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = tempOrderInfo.TableNumber; tempTableInfo.TableType = "Table"; tempOrderManager.InsertTableInfo(tempTableInfo); ////g_ConvertButton.Text = "Convert to Take Away"; tempOrderManager.UpdateOrderInfo(tempOrderInfo); } } catch (Exception exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void g_ExitButton_Click(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = m_iTableNumber; tempTableInfo.Status = 0; string tableType = ""; if (m_iType == m_cCommonConstants.TableType) tableType = "Table"; else if (m_iType == m_cCommonConstants.TakeAwayType) tableType = "TakeAway"; tempTableInfo.TableType = tableType; //tempTableInfo.TableType = m_TerminalName; tempOrderManager.UpdateTableInfo(tempTableInfo); CMainForm tempMainForm = (CMainForm)CFormManager.Forms.Pop(); tempMainForm.Show(); this.Close(); } catch (Exception exp) { MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void NewOrder() { try { if (m_bOrderState) { return; } CCommonConstants tempCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); COrderManager tempOrderManager = new COrderManager(); COrderInfo tempOrderInfo = new COrderInfo(); tempOrderInfo.TableNumber = GetValidTableNumber("Tabs"); tempOrderInfo.GuestCount = 1; tempOrderInfo.TableName = "Tabs" + tempOrderInfo.TableNumber; tempOrderInfo.UserID = tempCommonConstants.UserInfo.UserID; tempOrderInfo.OrderTime = DateTime.Now; tempOrderInfo.OrderType = "Tabs"; //Status not used CResult oResult = tempOrderManager.InsertOrderInfo(tempOrderInfo); if (oResult.IsSuccess && oResult.Data != null) { tempOrderInfo = (COrderInfo)oResult.Data; } //insert new tab info CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableType = "Tabs"; tempTableInfo.TableNumber = tempOrderInfo.TableNumber; tempTableInfo.Status = 1; tempOrderManager.InsertTableInfo(tempTableInfo); m_iTableNumber = tempTableInfo.TableNumber; COrderSeatTime tempOrderSeatTime = new COrderSeatTime(); tempOrderSeatTime.OrderID = tempOrderInfo.OrderID; tempOrderSeatTime.SeatTime = System.DateTime.Now; tempOrderManager.InsertOrderSeatTime(tempOrderSeatTime); orderID = tempOrderInfo.OrderID; m_iType = tempCommonConstants.TabsType; m_bOrderState = true; LoadStatusBar(); } catch (Exception exp) { throw exp; } }
private void g_ExitButton_Click(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = m_iTableNumber; tempTableInfo.Status = 0; string tableType = "Tabs"; tempTableInfo.TableType = tableType; tempOrderManager.UpdateTableInfo(tempTableInfo); if (g_FoodDataGridView[0, 0].Value.ToString().Equals("")) { tempOrderManager.DeleteOrderInfo(orderID); tempOrderManager.DeleteTableInfo(m_iTableNumber, "Tabs"); } CMainForm tempMainForm = (CMainForm)CFormManager.Forms.Pop(); tempMainForm.Show(); this.Close(); } catch (Exception exp) { throw exp; } }
private void g_ConvertButton_Click(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); CResult oResult = tempOrderManager.OrderListShowByStatus("Paid"); List<COrderShow> tempOrderShowList= new List<COrderShow>(); if (oResult.IsSuccess && oResult.Data != null) { tempOrderShowList = (List<COrderShow>)oResult.Data; } CCalculatorForm tableNumberForm = new CCalculatorForm("Table Information", "Table Number"); tableNumberForm.ShowDialog(); string tableNumber = ""; if (CCalculatorForm.inputResult.Equals("Cancel")) return; if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } tableNumber = CCalculatorForm.inputResult; //check whether table already exists bool found = false; for (int orderCounter = 0; orderCounter < tempOrderShowList.Count; orderCounter++) { if (int.Parse(tableNumber) == tempOrderShowList[orderCounter].TableNumber && tempOrderShowList[orderCounter].OrderType.Equals("Table")) found = true; } if (found) { CMessageBox tempMessageBox = new CMessageBox("Error", "Table already opened. Please select another table number."); tempMessageBox.ShowDialog(); return; } CCalculatorForm tableGuestForm = new CCalculatorForm("Table Information", "Guest Quantity"); tableGuestForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) return; if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } string tableGuest = ""; tableGuest = CCalculatorForm.inputResult; //update order info table COrderInfo tempOrderInfo = new COrderInfo(); oResult = tempOrderManager.OrderInfoByOrderID(orderID); if (oResult.IsSuccess && oResult.Data != null) { tempOrderInfo = (COrderInfo)oResult.Data; } //delete previous tab number from table info if(tempOrderInfo.TableNumber!=0) tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, "Tabs"); //update order info tempOrderInfo.GuestCount = int.Parse(tableGuest); tempOrderInfo.Status = "Seated"; tempOrderInfo.OrderType = "Table"; tempOrderInfo.TableNumber = int.Parse(tableNumber); tempOrderInfo.TableName = ""; tempOrderManager.UpdateOrderInfo(tempOrderInfo); //insert new table number in table info CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = tempOrderInfo.TableNumber; tempTableInfo.TableType = "Table"; tempOrderManager.InsertTableInfo(tempTableInfo); CMainForm tempMainForm = (CMainForm)CFormManager.Forms.Pop(); tempMainForm.Show(); this.Close(); } catch (Exception eee) { //MessageBox.Show(eee.ToString()); } }
private void TableIcon_MouseClick(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); LobbyItemButton tempTableIcon = (LobbyItemButton)sender; CCommonConstants tempCommonConstants = ConfigManager.GetConfig<CCommonConstants>(); if (tempTableIcon.Type.Equals("Table") || tempTableIcon.Type.Equals("Tabs")) { if (m_bTableInfoClicked) { CTableInfoMessageBox tempTableInfoMessageBox = new CTableInfoMessageBox(tempTableIcon.OrderID); tempTableInfoMessageBox.Show(); m_bTableInfoClicked = false; return; } else if (m_bNameTableClicked) { CKeyBoardForm tempKeyBoardForm = new CKeyBoardForm("Table Naming", "Please Enter the Name of the Table"); tempKeyBoardForm.ShowDialog(); if (CKeyBoardForm.Content.Equals("Cancel") || CKeyBoardForm.Content.Equals("")) return; COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(tempTableIcon.OrderID).Data; tempOrderInfo.TableName = CKeyBoardForm.Content; tempOrderManager.UpdateOrderInfo(tempOrderInfo); tempTableIcon.TableName = CKeyBoardForm.Content; m_bNameTableClicked = false; TablePanel.Controls.Clear(); this.Init(); return; } else if (m_bChangeDetailsClicked) { CKeyBoardForm tempKeyBoardForm = new CKeyBoardForm("Change Details", "Please Enter the Name of the Table"); tempKeyBoardForm.ShowDialog(); if (CKeyBoardForm.Content.Equals("Cancel")) //If cancelled then exit. { return; } CCalculatorForm tempCalculatorForm = new CCalculatorForm("Change Details", "Guest Quantity"); tempCalculatorForm.ShowDialog(); COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(tempTableIcon.OrderID).Data; if (!CKeyBoardForm.Content.Equals("") && !CKeyBoardForm.Content.Equals("Cancel")) { tempOrderInfo.TableName = CKeyBoardForm.Content; } if(!CCalculatorForm.inputResult.Equals("") && !CCalculatorForm.inputResult.Equals("Cancel") && !(Int32.Parse(CCalculatorForm.inputResult)==0)) tempOrderInfo.GuestCount = Convert.ToInt32(CCalculatorForm.inputResult); tempOrderManager.UpdateOrderInfo(tempOrderInfo); m_bChangeDetailsClicked = false; TablePanel.Controls.Clear(); Init(); return; } } CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo = (CTableInfo)tempOrderManager.GetTableInfoByTableNumber(tempTableIcon.TableNumber, tempTableIcon.Type).Data; if (tempTableInfo!=null && tempTableInfo.Status == 1) { CMessageBox tempMessageBox = new CMessageBox("Table Information", "Someone else is using this table at this moment."); tempMessageBox.ShowDialog(); return; } tempTableInfo.TableNumber = tempTableIcon.TableNumber; tempTableInfo.TableType = tempTableIcon.Type; tempTableInfo.Status = 1; tempOrderManager.UpdateTableInfo(tempTableInfo); if (tempTableIcon.Type.Equals("Table")) { CTableOrderForm tempTableOrderForm = new CTableOrderForm(tempTableIcon.OrderID, tempCommonConstants.TableType, tempTableIcon.TableNumber); tempTableOrderForm.m_TerminalName = TerminalIDLabel.Text; tempTableOrderForm.m_orderUserName = tempTableIcon.User; tempTableOrderForm.Show(); } else if (tempTableIcon.Type.Equals("Tabs")) { CBarServiceForm tempBarServiceForm = new CBarServiceForm(tempTableIcon.OrderID, tempCommonConstants.TabsType, tempTableIcon.TableNumber); tempBarServiceForm.Show(); } else if (tempTableIcon.Type.Equals("TakeAway")) { CTableOrderForm tempTableOrderForm = new CTableOrderForm(tempTableIcon.OrderID, tempCommonConstants.TakeAwayType, tempTableIcon.TableNumber); //tempTableOrderForm.m_TerminalName = TerminalIDLabel.Text; tempTableOrderForm.m_orderUserName = tempTableIcon.User; tempTableOrderForm.Show(); } CFormManager.Forms.Push(this); this.Hide(); } catch (Exception ee) { MessageBox.Show(ee.ToString()); } }
private void NewTableButton_Click(object sender, EventArgs e) { try { COrderManager tempOrderManager = new COrderManager(); List<COrderShow> tempOrderShowList = (List<COrderShow>)tempOrderManager.OrderListShowByStatus("Paid").Data; CCalculatorForm tableNumberForm = new CCalculatorForm("Table Information", "Table Number"); tableNumberForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) return; if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } string tableNumber = ""; tableNumber = CCalculatorForm.inputResult; if (tableNumber.Equals("")) return; bool found = false; for (int recordCounter = 0; recordCounter < tempOrderShowList.Count; recordCounter++) { if (int.Parse(tableNumber) == tempOrderShowList[recordCounter].TableNumber && tempOrderShowList[recordCounter].OrderType.Equals("Table")) found = true; } if (found) { CMessageBox tempMessageBox = new CMessageBox("Error", "Table already opened. Please select another table number."); tempMessageBox.ShowDialog(); return; } if (tableNumber.Equals("Cancel")) { return; } CCalculatorForm tableGuestForm = new CCalculatorForm("Table Information", "Covers"); tableGuestForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) { return; } if (CCalculatorForm.inputResult.Equals("") || Int32.Parse(CCalculatorForm.inputResult) == 0) { CMessageBox tempMessageBox = new CMessageBox("Error", "Input invalid!"); tempMessageBox.ShowDialog(); return; } string tableGuest = ""; tableGuest = CCalculatorForm.inputResult; if (tableGuest.Equals("Cancel")) //If cancelled then exit. { return; } CCalculatorForm floorNumberForm = new CCalculatorForm("Floor Information", "Floor Number"); floorNumberForm.ShowDialog(); if (CCalculatorForm.inputResult.Equals("Cancel")) return; string floorNumber = ""; floorNumber = CCalculatorForm.inputResult; COrderInfo tempOrderInfo = new COrderInfo(); tempOrderInfo.TableNumber = int.Parse(tableNumber); //tempOrderInfo.TableName = "Table " + tableNumber; tempOrderInfo.UserID = m_oCommonConstants.UserInfo.UserID; tempOrderInfo.OrderTime = System.DateTime.Now; //needed now tempOrderInfo.OrderType = "Table"; tempOrderInfo.GuestCount = int.Parse(tableGuest); tempOrderInfo.Status = "Seated"; tempOrderInfo.FloorNo = floorNumber; //tempOrderInfo.InitialKitchenText = kitchenText; COrderManager tempOrderManager2 = new COrderManager(); tempOrderInfo = (COrderInfo)tempOrderManager2.InsertOrderInfo(tempOrderInfo).Data; COrderSeatTime tempOrderSeatTime = new COrderSeatTime(); tempOrderSeatTime.OrderID = tempOrderInfo.OrderID; tempOrderSeatTime.SeatTime = DateTime.Now; tempOrderManager2.InsertOrderSeatTime(tempOrderSeatTime); LobbyItemButton tableIcon = new LobbyItemButton(); tableIcon.OrderID = tempOrderInfo.OrderID; tableIcon.TableName = "Table " + tableNumber; tableIcon.GuestCount = tableGuest; tableIcon.User = m_oCommonConstants.UserInfo.UserName; tableIcon.SeatedTime = tempOrderSeatTime.SeatTime; // tableIcon.Icon = global::RMS.Properties.Resources.seated; tableIcon.ItemType = RMSUIConstants.ItemType.SeatedButNoOrdered; tableIcon.TableNumber = int.Parse(tableNumber); tableIcon.Click += new EventHandler(TableIcon_MouseClick); tableIconList.Add(tableIcon); CTableInfo tempTableInfo = new CTableInfo(); tempTableInfo.TableNumber = int.Parse(tableNumber); tempTableInfo.TableType = "Table"; tempTableInfo.Status = 0; tempOrderManager.InsertTableInfo(tempTableInfo); try { WaiterForm waiterForm = new WaiterForm(); waiterForm.UserList = userList; waiterForm.ShowDialog(); if (waiterForm.DialogResult == DialogResult.OK) { COrderWaiterDao orderwaiterDao = new COrderWaiterDao(); COrderwaiter orderwaiter = new COrderwaiter(); orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID); if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.UpdateOrderwaiter(orderwaiter); } else if (orderwaiter.ID == 0) { orderwaiter.OrderID = tempOrderInfo.OrderID; orderwaiter.WaiterID = waiterForm.UserInfoData.UserID; orderwaiter.WaiterName = waiterForm.UserInfoData.UserName; orderwaiterDao.InsertOrderwaiter(orderwaiter); } } } catch (Exception ex) { } #region "OLD Code" //TablePanel.Controls.Clear(); //Init(); #endregion #region "New code added by Baruri" CTableOrderForm objOrderDetailsForm = new CTableOrderForm(tempOrderInfo.OrderID, 0, tempTableInfo.TableNumber); objOrderDetailsForm.m_orderUserName = RMSGlobal.LoginUserName; objOrderDetailsForm.Show(); CFormManager.Forms.Push(this); this.Hide(); #endregion } catch (Exception ee) { } }