public static List <ClsTurnier> TurniereKomplett(string Turniertyp)
{
try
{
List <ClsTurnier> turnList = new List <ClsTurnier>();
using (fsbDB FSBDB = new fsbDB())
{
List <TKopf> stl;
if (Turniertyp == "")
{
stl = (from stk in FSBDB.TKopf select stk).ToList();
}
else
{
stl = (from stk in FSBDB.TKopf where stk.Turniertyp == Turniertyp select stk).ToList();
}
for (int i = 0; i < stl.Count; i++)
{
turnList.Add(TurnierKomplett((int)stl[i].ID));
}
}
return(turnList);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new ClsTurnier[0].ToList());
}
}
public static void SaveHotKey(HotKey hotkey)
{
try
{
HotKey ma;
using (fsbDB FSBDB = new fsbDB())
{
ma = (from s in FSBDB.HotKey
where s.ID == hotkey.ID
select s).FirstOrDefault();
foreach (PropertyInfo pi in hotkey.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ma, pi.GetValue(hotkey, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveTKopf(TKopf TurnierKopf)
{
try
{
TKopf l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TKopf
where x.ID == TurnierKopf.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in TurnierKopf.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(l, pi.GetValue(TurnierKopf, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveWebKontrol(WebKontrols Kontrol)
{
try
{
WebKontrols ma;
using (fsbDB FSBDB = new fsbDB())
{
ma = (from s in FSBDB.WebKontrols
where s.ID == Kontrol.ID
select s).FirstOrDefault();
foreach (PropertyInfo pi in Kontrol.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ma, pi.GetValue(Kontrol, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveEreignissTyp(EreignissTyp Ereignisstyp)
{
try
{
EreignissTyp ma;
using (fsbDB FSBDB = new fsbDB())
{
ma = (from s in FSBDB.EreignissTyp
where s.ID == Ereignisstyp.ID
select s).FirstOrDefault();
foreach (PropertyInfo pi in Ereignisstyp.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ma, pi.GetValue(Ereignisstyp, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveDisplayPageSet(DisplayPageSet DisplayPageSet)
{
try
{
DisplayPageSet ma;
using (fsbDB FSBDB = new fsbDB())
{
ma = (from s in FSBDB.DisplayPageSet
where s.ID == DisplayPageSet.ID
select s).FirstOrDefault();
foreach (PropertyInfo pi in DisplayPageSet.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ma, pi.GetValue(DisplayPageSet, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveAnzeigetabelle(Anzeigetabelle anzeigetabelle)
{
try
{
Anzeigetabelle at;
using (fsbDB FSBDB = new fsbDB())
{
at = (from x in FSBDB.Anzeigetabelle
where x.ID == anzeigetabelle.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in anzeigetabelle.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(at, pi.GetValue(anzeigetabelle, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static int SavePassword(string Name, string Password)
{
try
{
User st;
using (fsbDB FSBDB = new fsbDB())
{
st = (from x in FSBDB.User
where x.Name == Name
select x).FirstOrDefault();
st.Password = Password;
FSBDB.SaveChanges();
}
return(0);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(1);
}
}
public static void SaveTabellensortierung(TabellenSort sortierung)
{
try
{
TabellenSort ts;
using (fsbDB FSBDB = new fsbDB())
{
ts = (from x in FSBDB.TabellenSort
where x.ID == sortierung.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in sortierung.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ts, pi.GetValue(sortierung, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveOptions3(Options3 option)
{
try
{
Options3 o3;
using (fsbDB FSBDB = new fsbDB())
{
o3 = (from Options3 g2 in FSBDB.Options3
where g2.ID == option.ID
select g2).FirstOrDefault();
if (o3 != null)
{
foreach (PropertyInfo pi in option.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(o3, pi.GetValue(option, null), null);
}
}
}
else
{
FSBDB.Options3.Add(option);
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveStrafe(Strafen strafe)
{
try
{
Strafen st;
using (fsbDB FSBDB = new fsbDB())
{
st = (from x in FSBDB.Strafen
where x.ID == strafe.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in strafe.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(st, pi.GetValue(strafe, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveSpieler(Spieler spieler)
{
try
{
Spieler ss;
using (fsbDB FSBDB = new fsbDB())
{
ss = (from s in FSBDB.Spieler
where s.ID == spieler.ID
select s).FirstOrDefault();
foreach (PropertyInfo pi in spieler.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(ss, pi.GetValue(spieler, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveEreigniss(TEreignisse ereignis)
{
try
{
TEreignisse l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TEreignisse
where x.ID == ereignis.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in ereignis.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(l, pi.GetValue(ereignis, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static List <DB.Timer> Timers()
{
try
{
List <DB.Timer> tel;
using (fsbDB FSBDB = new fsbDB())
{
tel = (from x in FSBDB.Timer select x).ToList();
}
if (tel == null)
{
return(new DB.Timer[0].ToList());
}
else
{
return(tel);
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new DB.Timer[0].ToList());
}
}
public static void Executesqlspript(string filename)
{
try
{
string script = string.Empty;
if (File.Exists(filename))
{
script = File.ReadAllText(filename);
// split script on GO command
IEnumerable <string> commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);
using (fsbDB FSBDB = new fsbDB())
{
foreach (string commandString in commandStrings)
{
if (commandString.Trim() != string.Empty)
{
int a = commandString.IndexOf("Anzeigeobjekt", StringComparison.Ordinal);
FSBDB.Database.ExecuteSqlCommand(commandString);
}
}
}
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void SaveRegistrierung(Registrierung registrierung)
{
try
{
Registrierung rg;
using (fsbDB FSBDB = new fsbDB())
{
rg = (from x in FSBDB.Registrierung
where x.ID == registrierung.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in registrierung.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(rg, pi.GetValue(registrierung, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static List <Timerevent> AktiveTimerEvents(int TimerNr, string order = "ASC")
{
try
{
List <Timerevent> tel;
using (fsbDB FSBDB = new fsbDB())
{
if (order == "DESC")
{
tel = (from x in FSBDB.Timerevent where x.TimerNr == TimerNr && x.Active == true orderby x.Sekunden descending, x.Eventtype descending select x).ToList();
}
else
{
tel = (from x in FSBDB.Timerevent where x.TimerNr == TimerNr && x.Active == true orderby x.Sekunden ascending, x.Eventtype descending select x).ToList();
}
}
if (tel == null)
{
return(new Timerevent[0].ToList());
}
else
{
return(tel);
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new Timerevent[0].ToList());
}
}
public static void SaveTimerEvent(Timerevent timerevent)
{
try
{
Timerevent te;
using (fsbDB FSBDB = new fsbDB())
{
te = (from x in FSBDB.Timerevent
where x.ID == timerevent.ID
select x).FirstOrDefault();
foreach (PropertyInfo pi in timerevent.GetType().GetProperties())
{
if (pi.CanWrite)
{
pi.SetValue(te, pi.GetValue(timerevent, null), null);
}
}
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static List <Timerevent> TimerEvents(int TimerNr)
{
try
{
List <Timerevent> tel;
using (fsbDB FSBDB = new fsbDB())
{
tel = (from x in FSBDB.Timerevent where x.TimerNr == TimerNr select x).ToList();
}
if (tel == null)
{
return(new Timerevent[0].ToList());
}
else
{
return(tel);
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new Timerevent[0].ToList());
}
}
public static List <Spieler> Spielers(int mannschaftsID)
{
try
{
List <Spieler> sl;
using (fsbDB FSBDB = new fsbDB())
{
long mid = (from s in FSBDB.Mannschaften
where s.ID == mannschaftsID
select s.ID).FirstOrDefault();
sl = (from s in FSBDB.Spieler
where s.MannschaftsID == mid
select s).ToList();
}
return(sl);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(new Spieler[0].ToList());
}
}
public static void DelEvent(int ID)
{
using (fsbDB FSBDB = new fsbDB())
{
TEreignisse e = (from s in FSBDB.TEreignisse
where s.ID == 0
select s).FirstOrDefault();
FSBDB.TEreignisse.Remove(e);
FSBDB.SaveChanges();
}
}
public static List <DB.Variablen> Variablen()
{
List <DB.Variablen> lst = new List <DB.Variablen>();
using (fsbDB FSBDB = new fsbDB())
{
lst = (from s in FSBDB.Variablen
select s).ToList();
}
return(lst);
}
public static void DelDisplayObjectsForPage(long PageID)
{
using (fsbDB FSBDB = new fsbDB())
{
List <DisplayObject> ol = DisplayObjectsForPage(PageID);
for (int i = 0; i < ol.Count; i++)
{
DelDisplayObject((int)ol[i].ID);
}
}
}
public static void DelDisplayObject(long DisplayObjectID)
{
using (fsbDB FSBDB = new fsbDB())
{
// del object
DisplayObject el = (from s in FSBDB.DisplayObject
where s.ID == DisplayObjectID
select s).FirstOrDefault();
FSBDB.DisplayObject.Remove(el);
FSBDB.SaveChanges();
}
}
public static List <WebKontrols> WebKontrols()
{
List <WebKontrols> lst = new List <WebKontrols>();
using (fsbDB FSBDB = new fsbDB())
{
lst = (from s in FSBDB.WebKontrols
select s).ToList();
}
return(lst);
}
public static DisplayPageSet DisplayPageSet(int id)
{
DisplayPageSet res = new DisplayPageSet();
using (fsbDB FSBDB = new fsbDB())
{
res = (from s in FSBDB.DisplayPageSet
where s.ID == id
select s).FirstOrDefault();
}
return(res);
}
public static DisplayObject DisplayObject(long id)
{
DisplayObject res = new DisplayObject();
using (fsbDB FSBDB = new fsbDB())
{
res = (from s in FSBDB.DisplayObject
where s.ID == id
select s).FirstOrDefault();
}
return(res);
}
public static void DelDisplayPagesForPageSet(long PageSetID)
{
using (fsbDB FSBDB = new fsbDB())
{
List <DisplayPage> ol = DisplayPagesForPageSet(PageSetID);
for (int i = 0; i < ol.Count; i++)
{
// del DisplayPage
DelDisplayPage((int)ol[i].ID);
}
}
}
// PageSet
public static List <DisplayPageSet> DisplayPageSets()
{
List <DisplayPageSet> lst = new List <DisplayPageSet>();
using (fsbDB FSBDB = new fsbDB())
{
lst = (from s in FSBDB.DisplayPageSet
orderby s.Sort
select s).ToList();
}
return(lst);
}
public static string TextByNameAndNumber(string KeyName, string KeyNumber, string Langu = "DE")
{
string ret = "";
using (fsbDB FSBDB = new fsbDB())
{
ret = (from s in FSBDB.A_Text
where s.Key == KeyName + "_" + KeyNumber && s.Language == Langu
select s.Text).FirstOrDefault();
}
return(ret);
}