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 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 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 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 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 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 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 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 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 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 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 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 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 void DelFreeEvents()
{
using (fsbDB FSBDB = new fsbDB())
{
List <TEreignisse> el = (from s in FSBDB.TEreignisse
where s.Spiel == 0
select s).ToList();
for (int i = 0; i < el.Count; i++)
{
FSBDB.TEreignisse.Remove(el[i]);
FSBDB.SaveChanges();
}
}
}
/// <summary>
/// Speichert den dafaultwert für die Variable.
/// Für Tabellen ist der Default Wert die anzahl der Zeilen je Anzeigeseite
/// </summary>
/// <param name="Variable"></param>
/// <param name="Wert"></param>
public static void SaveDefault(string Variable, string Wert)
{
using (fsbDB FSBDB = new fsbDB())
{
DB.Variablen v = (from s in FSBDB.Variablen where s.Name == Variable select s).FirstOrDefault();
if (v == null)
{
return;
}
v.Default = Wert;
FSBDB.SaveChanges();
}
}
public static void DelEreignis(int EreignisID)
{
TEreignisse l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TEreignisse
where x.ID == EreignisID
select x).First();
FSBDB.TEreignisse.Remove(l);
FSBDB.SaveChanges();
}
}
/// <summary>
/// delets all objects, pages and the pageset itself
/// </summary>
/// <param name="DisplayPageSetID"></param>
public static void DelDisplayPageSet(long DisplayPageSetID)
{
using (fsbDB FSBDB = new fsbDB())
{
// del pages
DelDisplayPagesForPageSet(DisplayPageSetID);
// del pageset
DisplayPageSet el = (from s in FSBDB.DisplayPageSet
where s.ID == DisplayPageSetID
select s).FirstOrDefault();
FSBDB.DisplayPageSet.Remove(el);
FSBDB.SaveChanges();
}
}
public static void DelDisplayPage(long DisplayPageID)
{
using (fsbDB FSBDB = new fsbDB())
{
// del objects
DelDisplayObjectsForPage(DisplayPageID);
// del page
DisplayPage el = (from s in FSBDB.DisplayPage
where s.ID == DisplayPageID
select s).FirstOrDefault();
FSBDB.DisplayPage.Remove(el);
FSBDB.SaveChanges();
}
}
public static void AddDisplayObject(DisplayObject DisplayObject)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
FSBDB.DisplayObject.Add(DisplayObject);
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void AddStrafe(Strafen strafe)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.Strafen select x.ID).DefaultIfEmpty(0).Max() + 1;
strafe.ID = newID;
FSBDB.Strafen.Add(strafe);
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void AddAnzeigetabelle(Anzeigetabelle anzeigetabelle)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.Anzeigetabelle select x.ID).DefaultIfEmpty(0).Max() + 1;
anzeigetabelle.ID = newID;
FSBDB.Anzeigetabelle.Add(anzeigetabelle);
FSBDB.SaveChanges();
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
}
}
public static void DelTurnierKopf(int TurnierID)
{
List <TKopf> l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TKopf
where x.ID == TurnierID
select x).ToList();
foreach (TKopf x in l)
{
FSBDB.TKopf.Remove(x);
}
FSBDB.SaveChanges();
}
}
public static void DelRunden(int TurnierID)
{
List <TRunden> l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TRunden
where x.TurnierID == TurnierID
select x).ToList();
foreach (TRunden x in l)
{
FSBDB.TRunden.Remove(x);
}
FSBDB.SaveChanges();
}
}
public static void DelEreignisse(int TurnierID)
{
List <TEreignisse> l;
using (fsbDB FSBDB = new fsbDB())
{
l = (from x in FSBDB.TEreignisse
where x.TurnierID == TurnierID
select x).ToList();
foreach (TEreignisse x in l)
{
FSBDB.TEreignisse.Remove(x);
}
FSBDB.SaveChanges();
}
}
public static int AddTurnierKopf(TKopf turnier)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.TKopf select x.ID).DefaultIfEmpty(0).Max() + 1;
turnier.ID = newID;
FSBDB.TKopf.Add(turnier);
FSBDB.SaveChanges();
return((int)turnier.ID);
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(0);
}
}
public static int AddTimerEvent(Timerevent timerevent)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.Timerevent select x.ID).DefaultIfEmpty(0).Max() + 1;
timerevent.ID = newID;
FSBDB.Timerevent.Add(timerevent);
FSBDB.SaveChanges();
return((int)timerevent.ID);
}
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(0);
}
}
public static int AddRegistrierung(Registrierung registrierung)
{
try
{
using (fsbDB FSBDB = new fsbDB())
{
long newID = (from x in FSBDB.Registrierung select x.ID).DefaultIfEmpty(0).Max() + 1;
registrierung.ID = newID;
FSBDB.Registrierung.Add(registrierung);
FSBDB.SaveChanges();
}
return((int)registrierung.ID);
}
catch (Exception ex)
{
ClsError.CoreError(Name, MethodBase.GetCurrentMethod().ToString(), ex);
return(0);
}
}
