public static void SaveToDatabase(List <ConfigNetplaySettings> Configs) { using (var db = new MyDbContext()) { // get current database context var current = db.ConfigNetplaySettings.AsNoTracking().ToList(); List <ConfigNetplaySettings> toAdd = new List <ConfigNetplaySettings>(); List <ConfigNetplaySettings> toUpdate = new List <ConfigNetplaySettings>(); // iterate through the games list and separete out games to be added and games to be updated foreach (var g in Configs) { ConfigNetplaySettings t = (from a in current where a.ConfigNPId == g.ConfigNPId select a).SingleOrDefault(); if (t == null) { toAdd.Add(g); } else { toUpdate.Add(g); } } db.ConfigNetplaySettings.UpdateRange(toUpdate); db.ConfigNetplaySettings.AddRange(toAdd); db.SaveChanges(); } }
public static void SaveNetplaySettings(TextBox Nickname, Slider LocalPlayers, Slider ConsoleLines, Slider ConsoleScale, RadioButton resOne, RadioButton resTwo, RadioButton resThree, RadioButton resFour, RadioButton resFive) { ConfigNetplaySettings nps = GetNetplay(); nps.netplay__nick = Nickname.Text; nps.netplay__localplayers = Convert.ToInt32(LocalPlayers.Value); nps.netplay__console__lines = Convert.ToInt32(ConsoleLines.Value); nps.netplay__console__scale = Convert.ToInt32(ConsoleScale.Value); if (resOne.IsChecked == true) { nps.netplay__console__font = "5x7"; } if (resTwo.IsChecked == true) { nps.netplay__console__font = "6x9"; } if (resThree.IsChecked == true) { nps.netplay__console__font = "6x12"; } if (resFour.IsChecked == true) { nps.netplay__console__font = "6x13"; } if (resFive.IsChecked == true) { nps.netplay__console__font = "9x18"; } SetNetplay(nps); }
public static void LoadNetplaySettings(TextBox Nickname, Slider LocalPlayers, Slider ConsoleLines, Slider ConsoleScale, RadioButton resOne, RadioButton resTwo, RadioButton resThree, RadioButton resFour, RadioButton resFive) { ConfigNetplaySettings nps = GetNetplay(); Nickname.Text = nps.netplay__nick; LocalPlayers.Value = Convert.ToDouble(nps.netplay__localplayers); ConsoleLines.Value = Convert.ToDouble(nps.netplay__console__lines); ConsoleScale.Value = Convert.ToDouble(nps.netplay__console__scale); if (nps.netplay__console__font == "5x7") { resOne.IsChecked = true; } if (nps.netplay__console__font == "6x9") { resTwo.IsChecked = true; } if (nps.netplay__console__font == "6x12") { resThree.IsChecked = true; } if (nps.netplay__console__font == "6x13") { resFour.IsChecked = true; } if (nps.netplay__console__font == "9x18") { resFive.IsChecked = true; } }
// write Global Settings object to DB public static void SetNetplay(ConfigNetplaySettings nps) { using (var context = new MyDbContext()) { context.ConfigNetplaySettings.Attach(nps); var entry = context.Entry(nps); entry.State = EntityState.Modified; context.SaveChanges(); } }
// return Netplay Settings entry from DB public static ConfigNetplaySettings GetNetplay() { ConfigNetplaySettings nps = new ConfigNetplaySettings(); using (var context = new MyDbContext()) { var query = from s in context.ConfigNetplaySettings where s.ConfigNPId == 1 select s; nps = query.FirstOrDefault(); } return(nps); }
public static ConfigNetplaySettings GetNetplayDefaults() { ConfigNetplaySettings npSettings = new ConfigNetplaySettings { netplay__console__font = "9x18", netplay__console__scale = 1, netplay__console__lines = 5, netplay__localplayers = 1, netplay__nick = "RetroPlayer" }; return(npSettings); }
public static void SaveNetplaySettings() { ConfigNetplaySettings nps = GetNetplay(); MainWindow mw = Application.Current.Windows.OfType <MainWindow>().FirstOrDefault(); TextBox tbNetplayNick = (TextBox)mw.FindName("tbNetplayNick"); Slider slLocalPlayersValue = (Slider)mw.FindName("slLocalPlayersValue"); Slider slConsoleLinesValue = (Slider)mw.FindName("slConsoleLinesValue"); Slider slConsoleScaleValue = (Slider)mw.FindName("slConsoleScaleValue"); RadioButton resOne = (RadioButton)mw.FindName("resOne"); RadioButton resTwo = (RadioButton)mw.FindName("resTwo"); RadioButton resThree = (RadioButton)mw.FindName("resThree"); RadioButton resFour = (RadioButton)mw.FindName("resFour"); RadioButton resFive = (RadioButton)mw.FindName("resFive"); nps.netplay__nick = tbNetplayNick.Text; nps.netplay__localplayers = Convert.ToInt32(slLocalPlayersValue.Value); nps.netplay__console__lines = Convert.ToInt32(slConsoleLinesValue.Value); nps.netplay__console__scale = Convert.ToInt32(slConsoleScaleValue.Value); if (resOne.IsChecked == true) { nps.netplay__console__font = "5x7"; } if (resTwo.IsChecked == true) { nps.netplay__console__font = "6x9"; } if (resThree.IsChecked == true) { nps.netplay__console__font = "6x12"; } if (resFour.IsChecked == true) { nps.netplay__console__font = "6x13"; } if (resFive.IsChecked == true) { nps.netplay__console__font = "9x18"; } SetNetplay(nps); }