public static int DeleteBarSeat(BarSeat barSeat) { SqlConnection connection = RestaurantConnection.GetConnection(); SqlCommand command = new SqlCommand(); int success = 0; int barSeatNumber = barSeat.TableNumber; command.CommandText = "DELETE FROM barSeats " + "WHERE tableNumber = @barSeatNumber"; command.Parameters.AddWithValue("@barSeatNumber", barSeatNumber); command.CommandType = CommandType.Text; command.Connection = connection; try { connection.Open(); success = command.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(success); }
public static List <BarSeat> GetBarSeatLayout() { SqlConnection connection = RestaurantConnection.GetConnection(); List <BarSeat> barSeats = new List <BarSeat>(); SqlCommand command = new SqlCommand(); SqlDataReader reader = null; command.CommandText = "Select * FROM barSeats"; command.CommandType = CommandType.Text; command.Connection = connection; try { connection.Open(); reader = command.ExecuteReader(); while (reader.Read()) { BarSeat barSeat = new BarSeat(); //uncomment for sqldb //barSeat.NumberOfSeats = (int)reader["numberOfSeats"]; barSeat.TableNumber = (int)reader["tableNumber"]; barSeat.TablePositionX = (int)reader["tablePositionX"]; barSeat.TablePositionY = (int)reader["tablePositionY"]; barSeat.TableState = (string)reader["tableState"]; barSeats.Add(barSeat); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } return(barSeats); }
private void btnBarSeatClick(object sender, EventArgs e) { Button oButton = sender as Button; BarSeat oBarSeat = (BarSeat)oButton.Tag; string sErrorMess = ""; bool bIsValid = true; bool bReservationSelected = false; if (rdoAssignTable.Checked) { try { Convert.ToInt32(cboSeats.SelectedItem); } catch (Exception) { bIsValid = false; sErrorMess += "\nNumber of Seats is required and must be a number"; } if (bIsValid) { if (!(lstReservations.SelectedIndex == -1)) { bReservationSelected = true; int groupSize = ReservationDA.GetGroupSize((lstReservations.SelectedItem as DisplayData).Value); cboSeats.SelectedItem = groupSize.ToString(); } if (cboSeats.SelectedItem == null) { bIsValid = false; sErrorMess += "Number of seats must be provided"; } if (Convert.ToInt16(cboSeats.SelectedItem) <= 1 && Convert.ToInt16(cboSeats.SelectedItem) > 0 && bIsValid) { //Number of seats fit the amount to be seated if (oBarSeat.TableState.ToLower() == TableState.Occupied.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat is currently busy"; } else if (oBarSeat.TableState.ToLower() == TableState.Bussable.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat is not clean"; } } else { bIsValid = false; sErrorMess = "Error: That Bar Seat cannot seat that many customers"; } } } else if (rdoClearTable.Checked) { if (oBarSeat.TableState.ToLower() == TableState.Empty.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat has nothing to clear"; } else if (oBarSeat.TableState.ToLower() == TableState.Bussable.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat is not clean"; } } else if (rdoBusTable.Checked) { if (oBarSeat.TableState.ToLower() == TableState.Empty.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat is already clean"; } else if (oBarSeat.TableState.ToLower() == TableState.Occupied.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Bar Seat is currently busy"; } } if (bIsValid) { string sUpdatedState = oBarSeat.TableState; if (sUpdatedState.ToLower() == TableState.Empty.ToString().ToLower()) { if (bReservationSelected) { ReservationDA.DeleteReservation((lstReservations.SelectedItem as DisplayData).Value); lstReservations.ClearSelected(); } sUpdatedState = TableState.Occupied.ToString(); } else if (sUpdatedState.ToLower() == TableState.Occupied.ToString().ToLower()) { sUpdatedState = TableState.Bussable.ToString(); } else if (sUpdatedState.ToLower() == TableState.Bussable.ToString().ToLower()) { sUpdatedState = TableState.Empty.ToString(); } //Updating Table State BarSeatDA.UpdateBarSeatState(oBarSeat.TableNumber.ToString(), sUpdatedState); pnlRoom.Controls.Clear(); LoadTables(); LoadBarTable(); LoadBarSeats(); DisplayReservationList(); DisplayAssignments(); DisplayAvailableTables(); if (btnUse.Text == "Cancel") { lstReservations.Enabled = false; btnUse.Text = "Use Reservation"; } } else { MessageBox.Show(sErrorMess, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnAddBarSeat_Click(object sender, EventArgs e) { barSeat = new BarSeat(); assigned = new AssignedTable(); int startLeft = pnlRoom.Left; int startTop = pnlRoom.Top; string sErrorMess = ""; bool bIsValid = true; try { barSeat.TableNumber = Convert.ToInt32(txtBarSeatNumber.Text); assigned.TableNumber = barSeat.TableNumber; assigned.SectionNum = (int)AvailableSections.Section4; } catch (Exception) { bIsValid = false; sErrorMess += "TableNumber is required and must be a number"; } //try { // barSeat.NumberOfSeats = Convert.ToInt32(txtNumberOfSeats.Text); //} //catch (Exception) { // bIsValid = false; // sErrorMess += "\nNumber of Seats is required and must be a number"; //} if (bIsValid) { barSeat.TablePositionX = startLeft; barSeat.TablePositionY = startTop; barSeats.Add(barSeat); assignedList.Add(assigned); RoundButton button = new RoundButton(); button.Cursor = Cursors.Hand; button.Height = 30; button.Width = 30; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderSize = 0; button.BackColor = Color.Cyan; button.Tag = barSeat; button.Text = "B" + Convert.ToString(barSeat.TableNumber); button.Location = new Point(startLeft, startTop); pnlRoom.Controls.Add(button); button.MouseDown += button_MouseDown; button.MouseUp += button_MouseUp; button.MouseMove += button_MouseMove; txtBarSeatNumber.Text = Convert.ToString(BarSeat.TotalTables); btnSaveLayout.Enabled = true; lblMessage.Text = "BarSeat " + barSeat.TableNumber + " successfully added."; } else { MessageBox.Show(sErrorMess, "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
public void LoadTables() { // Load Tables tables = TableDA.GetTableLayout(); if (!(Utility.IsNullOrEmpty(tables))) { foreach (Table eachTable in tables) { table = eachTable; RoundButton button = new RoundButton(); button.Cursor = Cursors.Hand; button.Height = 50; button.Width = 50; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderSize = 0; button.BackColor = Color.Cyan; button.Tag = table; button.Text = Convert.ToString(table.TableNumber) + "\n" + Convert.ToString(table.NumberOfSeats) + " seats"; button.Location = new Point(table.TablePositionX, table.TablePositionY); pnlRoom.Controls.Add(button); button.MouseDown += button_MouseDown; button.MouseUp += button_MouseUp; button.MouseMove += button_MouseMove; } txtTableNumber.Text = Convert.ToString(Table.TotalTables); } //Load BarSeats. barSeats = BarSeatDA.GetBarSeatLayout(); if (!(Utility.IsNullOrEmpty(barSeats))) { foreach (BarSeat eachBarSeat in barSeats) { barSeat = eachBarSeat; RoundButton button = new RoundButton(); button.Cursor = Cursors.Hand; button.Height = 30; button.Width = 30; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderSize = 0; button.BackColor = Color.Cyan; button.Tag = barSeat; button.Text = "B" + Convert.ToString(barSeat.TableNumber); button.Location = new Point(barSeat.TablePositionX, barSeat.TablePositionY); pnlRoom.Controls.Add(button); button.MouseDown += button_MouseDown; button.MouseUp += button_MouseUp; button.MouseMove += button_MouseMove; } txtBarSeatNumber.Text = Convert.ToString(BarSeat.TotalTables); } // Load BarTable. barTable = BarTableDA.GetBarTableLayout(); if (barTable != null) { StayInsideButton button = new StayInsideButton(); button.Cursor = Cursors.Hand; button.Height = 30; button.Width = 200; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderSize = 0; button.BackColor = Color.Cyan; button.Tag = barTable; button.Text = "Bar"; button.Location = new Point(barTable.TablePositionX, barTable.TablePositionY); pnlRoom.Controls.Add(button); button.MouseDown += button_MouseDown; button.MouseUp += button_MouseUp; button.MouseMove += button_MouseMove; } lblMessage.Text = "Seating layout successfully loaded!"; }
public void button_MouseDown(object sender, MouseEventArgs e) { Button button = (Button)sender; if (deleteTable == true) { table = (Table)button.Tag; string tableNumber = Convert.ToString(table.TableNumber); table = TableDA.GetTableByID(tableNumber); TableDA.DeleteTable(table); pnlRoom.Controls.Remove(button); //UpdateView(); lblMessage.Text = "Table " + tableNumber + " successfully deleted."; btnDeleteTable.Text = "Delete Table"; // Set deleteTable back to false so it's ready to be used in another delete. deleteTable = false; } else if (deleteBarSeat == true) { barSeat = (BarSeat)button.Tag; string barSeatNumber = Convert.ToString(barSeat.TableNumber); //barSeat = BarSeatDA.DeleteBarSeat(barSeat); BarSeatDA.DeleteBarSeat(barSeat); pnlRoom.Controls.Remove(button); //UpdateView(); lblMessage.Text = "BarSeat " + barSeatNumber + " successfully deleted."; btnDeleteBarseat.Text = "Delete Barseat"; // Set deleteBarSeat back to false so it's ready to be used in another delete. deleteBarSeat = false; } else if (deleteBar == true) { //barTable = (BarTable)button.Tag; BarTableDA.DeleteBarTable(); pnlRoom.Controls.Remove(button); //UpdateView(); lblMessage.Text = "Bar successfully deleted."; btnDeleteBar.Text = "Delete Bar"; // Set deleteBar back to false so it's ready to be used in another delete. deleteBar = false; } else if (e.Button == MouseButtons.Left) { //xPos = e.X; //yPos = e.Y; mouseDownPoint = pnlRoom.PointToClient(button.PointToScreen(e.Location)); if (btnSaveLayout.Enabled == false) { btnSaveLayout.Enabled = true; } } }