private void ReserveButton_Click(object sender, RoutedEventArgs e)
{
DateTime time = (DateTime)ReservationTimeDatePicker.Value;
int hour = time.Hour;
List <FieldReservation> reservationsAtTheSameTime = reservationsViewModel.FieldReservations.Where(fr => fr.ReservationTime.ToString() == time.ToString()).ToList();
if (hour < 10 || (hour > 13 && hour < 18) || hour > 20)
{
MessageBox.Show("Man kan kun spille imellem 10-14 og 18-21");
}
else if (reservationsAtTheSameTime.Count > 0)
{
MessageBox.Show("Tiden er allerede optaget");
}
else
{
FieldReservation fieldReservation = new FieldReservation()
{
Field = SelectFieldComboBox.SelectedItem as Field,
Member1 = Player1ComboBox.SelectedItem as Member,
Member2 = Player2ComboBox.SelectedItem as Member,
ReservationTime = (DateTime)ReservationTimeDatePicker.Value
};
reservationsViewModel.CreateFieldReservation(fieldReservation);
}
}
public void CreateFieldReservation(FieldReservation fr)
=> ExecuteNonQuery($"INSERT INTO FieldReservations VALUES ({fr.Member1.Id}, {fr.Member2.Id}, {fr.Field.Id}, '{fr.ReservationTime.ToString("yyyy-MM-dd HH")}:00:00')");
public void CreateFieldReservation(FieldReservation fieldReservation)
{
new FieldReservationRepository().CreateFieldReservation(fieldReservation);
}
