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)
{
}
}
