public static Spieler Spieler(int id)
{
try
{
Spieler ss;
using (fsbDB FSBDB = new fsbDB())
{
ss = (from s in FSBDB.Spieler
where s.ID == id
select s).FirstOrDefault();
}
return(ss);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new Spieler());
}
}
public string GetBildVariableWert(string ID)
{
try
{
if (!string.IsNullOrEmpty(ID))
{
ClsBildVariabeln v = (from x in this.BildVariabelListe where x.ID == ID select x).FirstOrDefault();
if (v != null)
{
return(v.Wert);
}
}
return("");
}
catch (Exception ex)
{
ClsError.Error(this.Name, MethodBase.GetCurrentMethod().ToString(), ex);
return("");
}
}
public static TKopf Turnier(int TurnierID)
{
try
{
TKopf stl;
using (fsbDB FSBDB = new fsbDB())
{
stl = (from x in FSBDB.TKopf
where x.ID == TurnierID
select x).FirstOrDefault();
}
return(stl);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TKopf());
}
}
public static Options3 Options3(string option, string requestor = "")
{
try
{
Options3 o3;
using (fsbDB FSBDB = new fsbDB())
{
o3 = (from Options3 g2 in FSBDB.Options3
where g2.Prop == option
select g2).FirstOrDefault();
}
return(o3);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString() + " > " + requestor, ex);
return(new Options3());
}
}
public static TGruppen Gruppe(int TurnierID, string gruppe)
{
try
{
TGruppen l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TGruppen
where x.TurnierID == TurnierID && x.Gruppe == gruppe
select x).FirstOrDefault();
}
return(l);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TGruppen());
}
}
public static TabellenSort Tabellensortierung(string tabellenfeld)
{
try
{
TabellenSort ts;
using (fsbDB FSBDB = new fsbDB())
{
ts = (from x in FSBDB.TabellenSort
where x.Feld == tabellenfeld
select x).FirstOrDefault();
}
return(ts);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TabellenSort());
}
}
public static void DelMannschaft(long mannschaftsID)
{
try
{
DB.Mannschaften ma;
using (fsbDB anzeigeDB = new fsbDB())
{
ma = (from m in anzeigeDB.Mannschaften
where m.ID == mannschaftsID
select m).FirstOrDefault();
anzeigeDB.Mannschaften.Remove(ma);
anzeigeDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void DelStrafe(string bezeichnung)
{
try
{
Strafen st;
using (fsbDB FSBDB = new fsbDB())
{
st = (from x in FSBDB.Strafen
where x.Bezeichnung == bezeichnung
select x).FirstOrDefault();
FSBDB.Strafen.Remove(st);
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static DB.Mannschaften Mannschaft(long MannschaftsID)
{
try
{
DB.Mannschaften lst;
using (fsbDB FSBDB = new fsbDB())
{
lst = (from s in FSBDB.Mannschaften
where s.ID == MannschaftsID
select s).FirstOrDefault();
}
return(lst);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new DB.Mannschaften());
}
}
public static string Password(string Name)
{
try
{
User st;
using (fsbDB FSBDB = new fsbDB())
{
st = (from x in FSBDB.User
where x.Name == Name
select x).FirstOrDefault();
}
return(st.Password);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return("");
}
}
////-------------------------------------------------------------------------------
public static List <TabellenSort> Tabellensortierung()
{
try
{
List <TabellenSort> ts;
using (fsbDB FSBDB = new fsbDB())
{
ts = (from x in FSBDB.TabellenSort
orderby x.Prio
select x).ToList();
}
return(ts);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TabellenSort[0].ToList());
}
}
public static void DelSpieler(int id)
{
try
{
Spieler ss;
using (fsbDB FSBDB = new fsbDB())
{
ss = (from s in FSBDB.Spieler
where s.ID == id
select s).FirstOrDefault();
FSBDB.Spieler.Remove(ss);
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public ClsTabellenVariabeln GetTabellenVariable(string ID)
{
try
{
if (!string.IsNullOrEmpty(ID))
{
ClsTabellenVariabeln v = (from x in this.TabelleVariabelListe where x.ID == ID select x).Single();
if (v != null)
{
return(v);
}
}
return(new ClsTabellenVariabeln());
}
catch (Exception ex)
{
ClsError.Error(this.Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new ClsTabellenVariabeln());
}
}
public static List <TGruppen> Gruppen(int TurnierID, int runde)
{
try
{
List <TGruppen> l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TGruppen
where x.TurnierID == TurnierID && x.Runde == runde
select x).ToList();
}
return(l);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TGruppen[0].ToList());
}
}
public static void SaveRundenStatus(int TurnierID, int runde, int status)
{
try
{
TRunden e;
using (fsbDB FSBDB = new fsbDB())
{
e = (from g in FSBDB.TRunden
where g.TurnierID == TurnierID && g.Runde == runde
select g).FirstOrDefault();
e.status = status;
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
////public static void SaveFoul(TSpiele spiel)
////{
//// // es muss die datenbankklasse für Spiele erweitert werden
//// ////try
//// ////{
//// //// TSpiele e;
//// ////
//// //// using (fsbDB FSBDB = new fsbDB())
//// //// {
//// //// e = (from s in FSBDB.TSpiele where s.TurnierID == spiel.TurnierID && s.Spiel == spiel.Spiel select s).FirstOrDefault();
//// //// e.FoulA = Convert.ToInt32(ClsVariablen.Instance.Foul1);
//// //// e.FoulB = Convert.ToInt32(ClsVariablen.Instance.Foul2);
//// //// FSBDB.SaveChanges();
//// //// }
//// ////}
//// ////catch (Exception ex)
//// ////{
//// //// ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
//// ////}
////}
public static void SaveSpielStatus(TSpiele spiel, int status)
{
try
{
TSpiele e;
using (fsbDB FSBDB = new fsbDB())
{
e = (from s in FSBDB.TSpiele
where s.TurnierID == spiel.TurnierID && s.Spiel == spiel.Spiel
select s).Single();
e.Status = status;
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static List <TSpiele> Spiele(int TurnierID, string gruppe)
{
try
{
List <TSpiele> t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TSpiele
where x.TurnierID == TurnierID && x.Gruppe == gruppe
orderby x.Spiel
select x).ToList();
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TSpiele[0].ToList());
}
}
public static TSpiele Spiel(int spielID)
{
try
{
TSpiele t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TSpiele
where x.ID == spielID
orderby x.Spiel
select x).FirstOrDefault();
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TSpiele());
}
}
public static int EreignisseMenge(int TurnierID)
{
try
{
int t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TEreignisse
where x.TurnierID == TurnierID
orderby x.Spiel, x.CPUZeit
select x).Count();
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(0);
}
}
public static List <ClsTorschuetze> TorschuetzenList(int TurnierID)
{
try
{
List <ClsTorschuetze> ret = new List <ClsTorschuetze>();
using (fsbDB FSBDB = new fsbDB())
{
var x = (
from TEreignisse e
in FSBDB.TEreignisse
where e.TurnierID == TurnierID && e.Ereignistyp == "05"
group e by new { e.Mannschaft, e.Spieler } into grp
select new
{
grp.Key.Mannschaft,
grp.Key.Spieler,
Tore = grp.Select(e => e.Ereignistyp).Count()
}
).OrderByDescending(y => y.Tore).ToList();
for (int i = 0; i < x.Count; i++)
{
ClsTorschuetze nt = new ClsTorschuetze();
nt.Mannschaft = x[i].Mannschaft;
nt.Spieler = x[i].Spieler;
nt.Tore = x[i].Tore;
ret.Add(nt);
}
}
return(ret);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new ClsTorschuetze[0].ToList());
}
}
/// <summary>
/// Speichert nur das Feld DirekterErweiterterVergleich
/// </summary>
/// <param name="tabelle"></param>
/// <param name="dV"></param>
public static void SaveTabellenDVPV(TTabellen tabelle, int dV)
{
try
{
TTabellen l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TTabellen
where x.ID == tabelle.ID
select x).FirstOrDefault();
l.Direktererweitertervergleich = dV;
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static ClsTurnier TurnierKomplett(int TurnierID)
{
try
{
ClsTurnier turn = new ClsTurnier();
turn.Kopf = Turnier(TurnierID);
turn.Runden = Runden(TurnierID);
turn.Gruppen = Gruppen(TurnierID);
turn.Spiele = Spiele(TurnierID);
turn.Tabellen = Tabellen(TurnierID);
turn.Ereignisse = ClsEreignisControler.Ereignisse(TurnierID);
turn.Torschuetzen = TorschuetzenList(TurnierID);
return(turn);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new ClsTurnier());
}
}
public static List <TEreignisse> Ereignisse(int TurnierID, int spielNr)
{
try
{
List <TEreignisse> t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TEreignisse
where x.TurnierID == TurnierID && x.Spiel == spielNr
orderby x.Spiel, x.CPUZeit
select x).ToList();
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TEreignisse[0].ToList());
}
}
public static List <Anzeigetabelle> Anzeigetabelle(string tabelle)
{
try
{
List <Anzeigetabelle> l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from t in FSBDB.Anzeigetabelle
where t.Tabelle == tabelle
orderby t.Position
select t).ToList();
}
return(l);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new Anzeigetabelle[0].ToList());
}
}
public static List <TTabellen> Tabellen(int TurnierID, string gruppe)
{
try
{
List <TTabellen> t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TTabellen
where x.TurnierID == TurnierID && x.Gruppe == gruppe
orderby x.Platz, x.Mannschaft
select x).ToList();
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TTabellen[0].ToList());
}
}
/// <summary>
/// Return the Page properties.
/// </summary>
/// <param name="SetName"></param>
/// <param name="Title"></param>
public static DisplayPage Page(int SetID, int PageID)
{
try
{
List <DisplayPageSet> l = ClsDisplayControler.DisplayPageSets();
DisplayPageSet dps = (from x in l where x.ID == SetID select x).FirstOrDefault();
if (dps != null)
{
List <DisplayPage> pl = ClsDisplayControler.DisplayPagesForPageSet(dps.ID);
DisplayPage dp = (from x in pl where x.ID == PageID select x).FirstOrDefault();
return(dp);
}
return(new DisplayPage());
}
catch (Exception ex)
{
ClsError.Error(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new DisplayPage());
}
}
public static int AddSpieler(Spieler spieler)
{
try
{
int sid;
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.Spieler select x.ID).DefaultIfEmpty(0).Max() + 1;
spieler.ID = newID;
FSBDB.Spieler.Add(spieler);
FSBDB.SaveChanges();
sid = (int)spieler.ID;
}
return(sid);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(0);
}
}
public static int Uhr2sek(string uhr)
{
// Rechnet den angezeiget uhrenstring in einen interger wert um
int uhr2sek = 0;
try
{
int min;
int sek;
int minus = 0;
if (uhr.Substring(0, 1) == "-")
{
minus = 1;
uhr = uhr.Substring(1, uhr.Length - 1);
}
string[] uhrarr;
uhrarr = uhr.Split(':');
min = Convert.ToInt32(uhrarr[0]);
sek = Convert.ToInt32(uhrarr[1]);
uhr2sek = (min * 60) + sek;
if (minus == 1)
{
uhr2sek *= -1;
}
return(uhr2sek);
}
catch (Exception ex)
{
ClsError.Error(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(uhr2sek);
}
}
public static void PaintballMinus(string Team)
{
try
{
string sollBild = ClsOptionsControler.Options3("Paintball Bild2").Value;
if (Team == "A") // Team A
{
for (int i = 17; i < 22; i++)
{
string var = "B" + i;
if (ClsDBVariablen.Instance.GetBildVariableWert(var) != sollBild)
{
ClsDBVariablen.Instance.SetBildVariableWert(var, sollBild);
return;
}
}
}
else
{
// Team B
for (int i = 22; i < 27; i++)
{
string var = "B" + i;
if (ClsDBVariablen.Instance.GetBildVariableWert(var) != sollBild)
{
ClsDBVariablen.Instance.SetBildVariableWert(var, sollBild);
return;
}
}
}
}
catch (Exception ex)
{
ClsError.Error(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static List <TEreignisse> Ereignisse(int TurnierID)
{
try
{
List <TEreignisse> t;
using (fsbDB FSBDB = new fsbDB())
{
t = (from x in FSBDB.TEreignisse
where x.TurnierID == TurnierID
orderby x.Spiel, x.CPUZeit
select x).ToList();
}
if (t.Any())
{
for (int i = 0; i < t.Count; i++)
{
t[i].Ereignistyp = ClsTextControler.TextByNameAndNumber("Ereignis", t[i].Ereignistyp);
string opt_EreigniszeitGenau = ClsOptionsControler.Options3("EreigniszeitGenau").Value;
if (opt_EreigniszeitGenau == "False")
{
t[i].Spielzeit = ClsTabellenfunktionen.ConvertSpielzeitToKurzzeit(t[i].Spielzeit, t[i].Spielzeitrichtung);
}
}
}
return(t);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new TEreignisse[0].ToList());
}
}
