public CTableInfoMessageBox(Int64 inOrderID) { InitializeComponent(); COrderManager tempOrderManager = new COrderManager(); CResult oResult = tempOrderManager.OrderInfoByOrderID(inOrderID); COrderInfo oOrderInfo = new COrderInfo(); if (oResult.IsSuccess && oResult.Data != null) { oOrderInfo=(COrderInfo)oResult.Data; } COrderSeatTime oOrderSeatTime = new COrderSeatTime(); oResult = tempOrderManager.OrderSeatTimeByOrderID(inOrderID); if (oResult.IsSuccess && oResult.Data != null) { oOrderSeatTime = (COrderSeatTime)oResult.Data; } g_SeatedTimeLabel.Text = oOrderSeatTime.SeatTime.ToLongTimeString(); if (oOrderInfo.Status.Equals("Seated")) { } g_TableNumberLabel.Text = oOrderInfo.TableNumber.ToString(); g_GuestQuantityLabel.Text = oOrderInfo.GuestCount.ToString(); if (oOrderInfo.Status.Equals("Ordered") || oOrderInfo.Status.Equals("Billed")) { g_OrderedTimeCaptionLabel.Visible = true; g_OrderedTimeLabel.Visible = true; g_OrderedTimeLabel.Text = oOrderInfo.OrderTime.ToLongTimeString(); } }
private void FillBasciInfo() { COrderManager tempOrderManager = new COrderManager(); CResult oResult = tempOrderManager.OrderInfoByOrderID(m_orderID); COrderInfo oOrderInfo = new COrderInfo(); if (oResult.IsSuccess && oResult.Data != null) { oOrderInfo = (COrderInfo)oResult.Data; } COrderSeatTime oOrderSeatTime = new COrderSeatTime(); oResult = tempOrderManager.OrderSeatTimeByOrderID(m_orderID); if (oResult.IsSuccess && oResult.Data != null) { oOrderSeatTime = (COrderSeatTime)oResult.Data; } lblSeatTime.Text = oOrderSeatTime.SeatTime.ToString("hh:mm tt"); lblTableNumber.Text = oOrderInfo.TableNumber.ToString("00"); lblGuestQuantity.Text = oOrderInfo.GuestCount.ToString("00"); }
public CResult InsertOrderSeatTime(COrderSeatTime inOrderSeatTime) { try { Database.Instance.OrderInfo.InsertOrderSeatTime(inOrderSeatTime); m_oResult.IsSuccess = true; m_oResult.Message = "Data Inserted Successfully"; } catch (Exception ex) { System.Console.WriteLine("Exception occuer at InsertOrderSeatTime() : " + 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 InsertOrderSeatTime()", LogLevel.Error, "COrderManager"); } return m_oResult; }
//Changed private COrderSeatTime ReaderToOrderSeatTime(IDataReader inReader) { COrderSeatTime tempOrderSeatTime = new COrderSeatTime(); if (inReader["order_id"] != null) tempOrderSeatTime.OrderID = Int64.Parse(inReader["order_id"].ToString()); if (inReader["seat_time"] != null) //tempOrderSeatTime.SeatTime = DateTime.Parse(inReader["seat_time"].ToString()); tempOrderSeatTime.SeatTime = new DateTime(Int64.Parse(inReader["seat_time"].ToString())); return tempOrderSeatTime; }
public COrderSeatTime OrderSeatTimeByOrderID(Int64 inOrderID) { COrderSeatTime tempOrderSeatTime = new COrderSeatTime(); try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.OrderSeatTimeByOrderID), inOrderID); IDataReader oReader = this.ExecuteReader(sSql); if (oReader != null) { while (oReader.Read()) { tempOrderSeatTime = ReaderToOrderSeatTime(oReader); } } } catch (Exception ex) { Console.Write("###" + ex.ToString() + "###"); Logger.Write("Exception : " + ex + " in OrderSeatTimeByOrderID()", LogLevel.Error, "Database"); throw new Exception("Exception occure at OrderSeatTimeByOrderID()", ex); } finally { this.CloseConnection(); } return tempOrderSeatTime; }
public void InsertOrderSeatTime(COrderSeatTime inOrderSeatTime) { try { this.OpenConnection(); string sSql = string.Format(SqlQueries.GetQuery(Query.OrderSeatTimeInsert), inOrderSeatTime.OrderID, inOrderSeatTime.SeatTime.Ticks); this.ExecuteNonQuery(sSql); } catch (Exception ex) { Logger.Write("Exception : " + ex + " in InsertOrderSeatTime()", LogLevel.Error, "Database"); throw new Exception("Exception occure at InsertOrderSeatTime()", ex); } finally { this.CloseConnection(); } }
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 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) { } }