//Methoden für Daten
public List <AnzeigeDatenFesteBuchung> GetGridDaten()
{
List <AnzeigeDatenFesteBuchung> lstDaten = new List <AnzeigeDatenFesteBuchung>();
using (TennisclubNeuEntities db = new TennisclubNeuEntities())
{
List <string> guids = new List <string>();
List <Buchungen> liste = (from Buchungen bu in db.Buchungen where bu.FesteBuchungGuid != null orderby bu.FesteBuchungGuid select bu).ToList();
foreach (Buchungen buchung in liste)
{
int[] plaetze = (from Buchungen bu in db.Buchungen where bu.FesteBuchungGuid.Equals(buchung.FesteBuchungGuid) select bu.PlatzId).ToArray();
DateTime[] wochentage = (from Buchungen bu in db.Buchungen where bu.FesteBuchungGuid.Equals(buchung.FesteBuchungGuid) select bu.Startzeit).ToArray();
DateTime _endzeit = (from Buchungen bu in db.Buchungen where bu.FesteBuchungGuid.Equals(buchung.FesteBuchungGuid) orderby bu.Endzeit descending select bu.Endzeit).FirstOrDefault();
if (!guids.Contains(buchung.FesteBuchungGuid))
{
guids.Add(buchung.FesteBuchungGuid);
AnzeigeDatenFesteBuchung daten = new AnzeigeDatenFesteBuchung();
daten.Von = buchung.Startzeit.ToLongTimeString();
daten.Bis = buchung.Endzeit.ToLongTimeString();
daten.Guid = buchung.FesteBuchungGuid;
daten.Titel = buchung.Titel;
daten.Enddatum = _endzeit;
daten.Startdatum = wochentage.OrderBy(x => x.Minute).First();
daten.Plätze = GetStringFromArray(plaetze);
daten.Wochentag = GetWochentag(wochentage);
lstDaten.Add(daten);
}
}
return(lstDaten);
}
}
private void DataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Reset();
DataGrid grid = (DataGrid)sender;
AnzeigeDatenFesteBuchung azdfb = (AnzeigeDatenFesteBuchung)grid.SelectedItem;
tbGuid.Text = azdfb.Guid;
cboStundenStart.SelectedItem = azdfb.Startdatum.ToShortTimeString().Split(':')[0];
cboMinutenStart.SelectedItem = azdfb.Startdatum.ToShortTimeString().Split(':')[1];
cboStundenEnde.SelectedItem = azdfb.Enddatum.ToShortTimeString().Split(':')[0];
cboMinutenEnde.SelectedItem = azdfb.Enddatum.ToShortTimeString().Split(':')[1];
dpStart.SelectedDate = azdfb.Startdatum;
dpEnde.SelectedDate = azdfb.Enddatum;
txtTitel.Text = azdfb.Titel;
string[] wochentage = azdfb.Wochentag.Split(';');
if (wochentage.Contains("Mo"))
{
chkMontag.IsChecked = true;
}
if (wochentage.Contains("Di"))
{
chkDienstag.IsChecked = true;
}
if (wochentage.Contains("Mi"))
{
chkMittwoch.IsChecked = true;
}
if (wochentage.Contains("Do"))
{
chkDonnerstag.IsChecked = true;
}
if (wochentage.Contains("Fr"))
{
chkFreitag.IsChecked = true;
}
if (wochentage.Contains("Sa"))
{
chkSamtag.IsChecked = true;
}
if (wochentage.Contains("So"))
{
chkSonntag.IsChecked = true;
}
string[] platzNummern = azdfb.Plätze.Split(';');
foreach (string id in platzNummern)
{
var checkBox = Helpers.FindChild <CheckBox>(grdMain, "chkPlatz" + id);
checkBox.IsChecked = true;
}
Buchungen buchung = FesteBuchungRepository.GetInstance().GetBuchung(azdfb.Guid);
tbZeile1.Text = buchung.Zeile1;
tbZeile2.Text = buchung.Zeile2;
tbZeile3.Text = buchung.Zeile3;
tbZeile4.Text = buchung.Zeile4;
tbZeile5.Text = buchung.Zeile5;
}
