private void mnuUnregisterRestaurant_Click(object sender, EventArgs e) { DialogResult button = MessageBox.Show( "Are you sure you want to delete the entire restaurant layout?", "Confirm Layout Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (button == DialogResult.Yes) { ReservationDA.DeleteAllReservations(); TableDA.DeleteAllTables(); BarSeatDA.DeleteAllBarSeats(); BarTableDA.DeleteBarTable(); ServerDA.DeleteAllServers(); RestaurantDA.DeleteRestaurant(); NoCurrentRestaurant(); if (mnuRegisterRestaurant.Enabled == false) { mnuRegisterRestaurant.Enabled = true; } MessageBox.Show("Restaurant has been unregistered!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void DisplayListBoxData() { List <Server> oServers = ServerDA.GetAllServers(); List <DisplayData> oDataDisplay = new List <DisplayData>(); foreach (Server oServer in oServers) { oDataDisplay.Add(new DisplayData() { Value = oServer.Id.ToString(), Text = oServer.FirstName + " " + oServer.LastName }); } lstServers.DisplayMember = "Text"; lstServers.DataSource = oDataDisplay; }
private void btnDeleteServer_Click(object sender, EventArgs e) { string sID = (lstServers.SelectedItem as DisplayData).Value; int nSuccess = ServerDA.DeleteServer(sID); if (nSuccess == 1) { MessageBox.Show("Server Deleted", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); //1 row deleted DisplayListBoxData(); } else { //no row deleted MessageBox.Show("Error: Server was not deleted", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnClearTable_Click(object sender, EventArgs e) { //clear table from assigned table list foreach (var item in lstAssignments.SelectedItems) { ServerDA.FreeTable(((DisplayData)item).Value); TableDA.UpdateTableState(((DisplayData)item).Value, TableState.Bussable.ToString()); } pnlRoom.Controls.Clear(); DisplayAssignments(); DisplayAvailableTables(); LoadTables(); LoadBarTable(); LoadBarSeats(); btnClearTable.Visible = false; lstAssignments.ClearSelected(); }
private void DisplayAssignments() { List <Assignments> oAssignments = ServerDA.GetAllTableAssignments(); List <DisplayData> oDataDisplay = new List <DisplayData>(); foreach (Assignments oAssignment in oAssignments) { Server oServer = ServerDA.GetServerbyID(oAssignment.ServerID.ToString()); oAssignment.ServerName = oServer.FirstName + " " + oServer.LastName; oDataDisplay.Add(new DisplayData() { Value = oAssignment.TableNumber.ToString(), Text = "Section: " + oAssignment.SectionNumber + " Table: " + oAssignment.TableNumber + " Server: " + oAssignment.ServerName }); } lstAssignments.DisplayMember = "Text"; lstAssignments.DataSource = oDataDisplay; lstAssignments.ClearSelected(); }
private void btnAddServer_Click(object sender, EventArgs e) { string sFirstName = txtFirstName.Text.Trim(); string sLastName = txtLastName.Text.Trim(); string sErrorMess = ""; Server oServer = new Server(); bool bIsValid = true; if (String.IsNullOrEmpty(sFirstName)) { bIsValid = false; sErrorMess += "Please enter a First Name"; } if (String.IsNullOrEmpty(sLastName)) { bIsValid = false; sErrorMess += "\nPlease enter a Last Name"; } //valid input if (bIsValid) { //add server to database oServer.FirstName = sFirstName; oServer.LastName = sLastName; //Might need to come back and add a try catch here bool bSuccess = ServerDA.AddServer(oServer); if (bSuccess) { MessageBox.Show(sFirstName + " " + sLastName + " " + "has been Added!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show(sErrorMess, "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnMerge_Click(object sender, EventArgs e) { bool bIsValid = true; string sErrorMess = ""; if (!(lstServers.SelectedIndex == -1)) { if (!(lstAvailable.SelectedIndex == -1)) { List <Table> oTables = new List <Table>(); int seatNum = 0; bool bReservationSelected = false; foreach (var item in lstAvailable.SelectedItems) { Table oTable = new Table(); string sAssign = ((DisplayData)item).Value; oTable = TableDA.GetTableByID(sAssign); oTables.Add(oTable); } foreach (Table oTable in oTables) { seatNum += oTable.NumberOfSeats; } 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; } if (seatNum >= Convert.ToInt16(cboSeats.SelectedItem) && bIsValid) { //assign here foreach (Table oTable in oTables) { string sServerID = (lstServers.SelectedItem as DisplayData).Value; int nSectionNumber = SectionDA.GetAssignedSection(oTable.TableNumber.ToString()); ServerDA.AssignServerToTable(oTable.TableNumber.ToString(), sServerID, nSectionNumber.ToString()); TableDA.UpdateTableState(oTable.TableNumber.ToString(), TableState.Occupied.ToString()); } if (bReservationSelected) { ReservationDA.DeleteReservation((lstReservations.SelectedItem as DisplayData).Value); lstReservations.ClearSelected(); } pnlRoom.Controls.Clear(); LoadTables(); LoadBarTable(); LoadBarSeats(); DisplayReservationList(); DisplayAssignments(); DisplayAvailableTables(); } else { bIsValid = false; if (cboSeats.SelectedItem == null) { sErrorMess += "Error: Number of seats must be provided"; } else { sErrorMess += "Error: Those tables cannot seat that many customers"; } } } else { bIsValid = false; sErrorMess = "Error: No tables selected to merge"; } } else { bIsValid = false; sErrorMess = "Error: Those tables cannot seat that many customers"; } if (!bIsValid) { MessageBox.Show(sErrorMess, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnSeatClick(object sender, EventArgs e) { Button oButton = sender as Button; string sTableNumber = oButton.Tag.ToString(); string sErrorMess = ""; bool bIsValid = true; bool bReservationSelected = false; //get table by id to check/update state Table oSpecificTable = TableDA.GetTableByID(sTableNumber); int nSectionNumber = SectionDA.GetAssignedSection(sTableNumber); if (rdoAssignTable.Checked) { //makes sure a server is selected in the list box if (!(lstServers.SelectedIndex == -1)) { 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 (oSpecificTable.NumberOfSeats >= Convert.ToInt16(cboSeats.SelectedItem) && bIsValid) { //Number of seats fit the amount to be seated if (oSpecificTable.TableState.ToLower() == TableState.Occupied.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table is currently busy"; } else if (oSpecificTable.TableState.ToLower() == TableState.Bussable.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table is not clean"; } } else { bIsValid = false; sErrorMess = "Error: That table cannot seat that many customers"; } } } else { bIsValid = false; sErrorMess = "Error: You have to select a server"; } } else if (rdoClearTable.Checked) { if (oSpecificTable.TableState.ToLower() == TableState.Empty.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table has nothing to clear"; } else if (oSpecificTable.TableState.ToLower() == TableState.Bussable.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table is not clean"; } } else if (rdoBusTable.Checked) { if (oSpecificTable.TableState.ToLower() == TableState.Empty.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table is already clean"; } else if (oSpecificTable.TableState.ToLower() == TableState.Occupied.ToString().ToLower()) { bIsValid = false; sErrorMess = "Error: Table is currently busy"; } } if (bIsValid) { string sUpdatedState = oSpecificTable.TableState; if (sUpdatedState.ToLower() == TableState.Empty.ToString().ToLower()) { //assign server here string sServerID = (lstServers.SelectedItem as DisplayData).Value; ServerDA.AssignServerToTable(sTableNumber, sServerID, nSectionNumber.ToString()); if (bReservationSelected) { ReservationDA.DeleteReservation((lstReservations.SelectedItem as DisplayData).Value); lstReservations.ClearSelected(); } sUpdatedState = TableState.Occupied.ToString(); } else if (sUpdatedState.ToLower() == TableState.Occupied.ToString().ToLower()) { ServerDA.FreeTable(sTableNumber); DisplayAssignments(); sUpdatedState = TableState.Bussable.ToString(); } else if (sUpdatedState.ToLower() == TableState.Bussable.ToString().ToLower()) { sUpdatedState = TableState.Empty.ToString(); } //Updating Table State TableDA.UpdateTableState(oSpecificTable.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); } }