public static void SaveToDatabase(ConfigServerSettings Config)
{
using (var db = new MyDbContext())
{
// get current database context
var current = db.ConfigServerSettings.AsNoTracking().ToList();
List <ConfigServerSettings> toAdd = new List <ConfigServerSettings>();
List <ConfigServerSettings> toUpdate = new List <ConfigServerSettings>();
// iterate through the games list and separete out games to be added and games to be updated
ConfigServerSettings t = (from a in current
where a.ConfigServerId == Config.ConfigServerId
select a).SingleOrDefault();
if (t == null)
{
toAdd.Add(Config);
}
else
{
toUpdate.Add(Config);
}
db.ConfigServerSettings.UpdateRange(toUpdate);
db.ConfigServerSettings.AddRange(toAdd);
db.SaveChanges();
}
}
private static void SetCustomServer(ConfigServerSettings srv)
{
using (var context = new MyDbContext())
{
context.ConfigServerSettings.Attach(srv);
var entry = context.Entry(srv);
entry.State = EntityState.Modified;
context.SaveChanges();
}
}
public static void DeleteServer(int id)
{
using (var cont = new MyDbContext())
{
// get the record
ConfigServerSettings c = (from a in cont.ConfigServerSettings
where a.ConfigServerId == id
select a).FirstOrDefault();
if (c == null)
{
return;
}
cont.ConfigServerSettings.Remove(c);
cont.SaveChanges();
}
}
public static void SaveCustomServerSettings(TextBox tbServerDesc, TextBox tbHostname, Slider slServerPort, TextBox tbPassword, TextBox tbGameKey)
{
ConfigServerSettings sSet = new ConfigServerSettings();
var servers = GetServers();
sSet = (from s in servers
where s.ConfigServerId == 100
select s).SingleOrDefault();
sSet.ConfigServerId = 100;
sSet.ConfigServerDesc = tbServerDesc.Text;
sSet.netplay__host = tbHostname.Text;
sSet.netplay__password = tbPassword.Text;
sSet.netplay__gamekey = tbGameKey.Text;
sSet.netplay__port = Convert.ToInt32(slServerPort.Value);
SetCustomServer(sSet);
}