private void PopulateTimeSlotList()
{
//Create an allAttraction list that is opoulated from the database
List <TimeSlot> allTimeSlots = TimeSlotDb.GetAllTimeSlots();
//Clear the list before adding to avoid duplicates
TimeSlotCbox.Items.Clear();
//Add all the attractions in the attraction combo box
foreach (TimeSlot t in allTimeSlots)
{
TimeSlotCbox.Items.Add(t);
}
}
private void EditTimeSlotBtn_Click(object sender, EventArgs e)
{
if (IsDataValid() == true)
{
//Grab the newly inputted values
existingTimeSlot.StartTime = Convert.ToDateTime(StartTimeTxt.Text);
existingTimeSlot.EndTime = Convert.ToDateTime(EndTimeTxt.Text);
existingTimeSlot.TimeSlotLength = TimeSpan.Parse((Convert.ToDateTime(EndTimeTxt.Text) - Convert.ToDateTime(StartTimeTxt.Text)).ToString());
try
{
TimeSlotDb.Update(existingTimeSlot);
DialogResult = DialogResult.OK;
}
catch (ArgumentException)
{
MessageBox.Show("Time slot no longer exists");
}
}
}
private void DeleteTimeSlotBtn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TimeSlotCbox.Text))
{
MessageBox.Show("Please select a time slot to delete");
return;
}
//Grab the selected attraction
TimeSlot selectedTimeSlot = (TimeSlot)TimeSlotCbox.SelectedItem;
string message = $"Are you sure you want to delete {selectedTimeSlot.StartTime.ToShortTimeString()} - " +
$"{selectedTimeSlot.EndTime.ToShortTimeString()}?";
DialogResult result = MessageBox.Show(text: message,
caption: "Delete?",
buttons: MessageBoxButtons.YesNo,
icon: MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
//Remove in database
TimeSlotDb.Delete(selectedTimeSlot);
//Remove it from the list
TimeSlotCbox.Items.Remove(selectedTimeSlot);
MessageBox.Show("Time slot deleted");
PopulateTimeSlotList();
TimeSlotCbox.Text = "";
}
catch (Exception)
{
MessageBox.Show("No time slots deleted");
}
}
}
/// <summary>
/// Adds a single time slot to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddTimeSlotBtn_Click(object sender, EventArgs e)
{
if (IsDataValid() == true)
{
//Create a time slot object
TimeSlot time = new TimeSlot()
{
StartTime = Convert.ToDateTime(StartTimeTxt.Text),
EndTime = Convert.ToDateTime(EndTimeTxt.Text),
TimeSlotLength = TimeSpan.Parse((Convert.ToDateTime(EndTimeTxt.Text) - Convert.ToDateTime(StartTimeTxt.Text)).ToString())
};
try
{
TimeSlotDb.Add(time);
MessageBox.Show("Time slot successfully added");
DialogResult = DialogResult.OK;
}
catch
{
MessageBox.Show("We're currently having server issues");
}
}
}
