protected void ReservationSummaryListView_OnItemCommand(object sender, ListViewCommandEventArgs e)
{
// Check the command name and add the reservation for the specified seats.
if (e.CommandName.Equals("Seat"))
{
MessageUserControl.TryRun(() =>
{
// Get the data
var reservationId = int.Parse(e.CommandArgument.ToString());
var selectedItems = new List <byte>();
foreach (ListItem item in ReservationTableListBox.Items)
{
if (item.Selected)
{
selectedItems.Add(byte.Parse(item.Text.Replace("Table ", "")));
}
}
var when = DateTime.Parse(SearchDate.Text).Add(TimeSpan.Parse(SearchTime.Text));
// Seat the reservation customer
var controller = new eRestaurantController();
controller.SeatCustomer(when, reservationId, selectedItems, int.Parse(WaiterDropDownList.SelectedValue));
// Refresh the gridview
SeatingGridView.DataBind();
ReservationsRepeater.DataBind();
}, "Customer Seated", "Reservation customer has arrived and has been seated");
}
}
public void InsertWaiterInfo()
{
//the code that exsits withen this method is a standered CRUD insert form AppDev1
eRestaurantController controller = new eRestaurantController();
//load an instance of contorller
Waiter item = new Waiter();
item.WaiterID = 0;//identity feild for SQL therefore set to 0
item.FirstName = FirstName.Text;
item.LastName = LastName.Text;
item.Phone = Phone.Text;
item.Address = Address.Text;
item.HireDate = DateTime.Parse(HiredDate.Text);
if (string.IsNullOrEmpty(ReleaseDate.Text))
{
item.ReleaseDate = null;
}
else
{
item.ReleaseDate = DateTime.Parse(ReleaseDate.Text);
}
//call the controller's add method for the waiter
controller.Waiter_Add(item);
//rebind the drop down list (WaiterList) so the new waiter will appear in the list
WaiterList.DataBind();
}
//UPDATE
public void UpdateWaiterInfo()
{
//The code that exists within this method is a standard CRUD update.
//Similar to what was learned in APPDEV 1
eRestaurantController controller = new eRestaurantController();
//Load an instance of Waiter.
Waiter updateWaiter = new Waiter();
updateWaiter.WaiterID = int.Parse(WaiterList.SelectedValue);
updateWaiter.FirstName = FirstName.Text;
updateWaiter.LastName = LastName.Text;
updateWaiter.Phone = Phone.Text;
updateWaiter.Address = Address.Text;
updateWaiter.HireDate = DateTime.Parse(HiredDate.Text);
//Check if the release date is Null/Empty
if (string.IsNullOrEmpty(ReleaseDate.Text))
{
updateWaiter.ReleaseDate = null; //This can be null becuase in the database it is set to "Nullable"
}
else
{
updateWaiter.ReleaseDate = DateTime.Parse(ReleaseDate.Text);
}
//Add waiter to the database.
controller.Waiter_Update(updateWaiter);
//Rebind the dropdown (WaiterList) so the new entry will appear in the list.
WaiterList.DataBind();
}
private void SetMockLastBillingDateTime()
{
var controller = new eRestaurantController();
var info = controller.GetLastBillDateTime();
SearchDate.Text = info.ToString("yyyy-MM-dd");
SearchTime.Text = info.ToString("HH:mm:ss");
}
public void GetWaiterInfo()
{
eRestaurantController controller = new eRestaurantController();
var waiter = controller.GetWaiter(int.Parse(WaiterList.SelectedValue));
WaiterID.Text = waiter.WaiterID.ToString();
FirstName.Text = waiter.FirstName;
LastName.Text = waiter.LastName;
Phone.Text = waiter.Phone;
Address.Text = waiter.Address;
HiredDate.Text = waiter.HireDate.ToShortDateString();
if (waiter.ReleaseDate.HasValue)
{
ReleaseDate.Text = waiter.ReleaseDate.Value.ToShortDateString();
}
}
protected void SeatingGridView_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
// Seat walk-in customers
MessageUserControl.TryRun(() =>
{
// TODO: There are a lot of assumptions in parsing the input, and it would be better
// to break this into chunks an display appropriate "usage" messages to the end-user.
// Get the controls
GridViewRow row = SeatingGridView.Rows[e.NewSelectedIndex];
var tableControl = row.FindControl("TableNumber") as Label;
var numberInPartyControl = row.FindControl("NumberInParty") as TextBox;
var waiterListControl = row.FindControl("WaiterList") as DropDownList;
var when = DateTime.Parse(SearchDate.Text).Add(TimeSpan.Parse(SearchTime.Text));
// Seat the customer
var controller = new eRestaurantController();
controller.SeatCustomer(when, byte.Parse(tableControl.Text), int.Parse(numberInPartyControl.Text), int.Parse(waiterListControl.SelectedValue));
// Refresh the gridview
SeatingGridView.DataBind();
}, "Customer Seated", "New walk-in customer has been seated");
}
