public void AddToDB(GCDBContext _dbc) { using (_dbc = new GCDBContext(ConString)) { _dbc.Cheats.Add(CurCheat); _dbc.SaveChanges(); } }
public void DBSave() { using (GCDBContext dbc = new GCDBContext(CfgData2.ConStr)) { Cheat cheat = new Cheat() { FileName = @"c:\test" }; dbc.Cheats.Add(cheat); dbc.SaveChanges(); } }
public void RemoveGame() { /*var rreq = from game in Cheats * where game.GameName == SelectGameName * select game;*/ using (GCDBContext _dbc = new GCDBContext(ConString)) { var RR = _dbc.Cheats.FirstOrDefault(c => c.GameName == SelectGameName); if (RR != null) { _dbc.Cheats.Remove(RR); _dbc.SaveChanges(); RefreshGameLB(); } } }
public void ClearDB(GCDBContext _dbc) { using (_dbc = new GCDBContext(ConString)) { var all = _dbc.Cheats;//.Where(c => c.Id > -1); if (all.Any()) { /* using (SqlConnection s1=new SqlConnection(ConString)) * { * * using (SqlCommand cmd = new SqlCommand()) * { * * cmd.Connection = s1; * cmd.CommandType = CommandType.Text; * cmd.CommandText = "DELETE FROM Cheats"; * * } * * * }*/ _dbc.Database.ExecuteSqlCommand("DELETE FROM Cheats"); /*foreach (var cheat in all) * { * _dbc.Cheats.Remove(cheat); * }*/ _dbc.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Cheats', RESEED, -1)"); _dbc.SaveChanges(); MessageBox.Show("Game cheat база очищена"); } else { MessageBox.Show("Game cheat база пустая"); } } }
public void EditGame() { if (CCFName.Length != 0) { using (GCDBContext _dbc = new GCDBContext(ConString)) { var EGR = _dbc.Cheats.FirstOrDefault(c => c.GameName == SelectGameName); if (EGR != null) { EGR.GameName = GameNameTB.Text; CurCheat.FileName = CCFName; EGR.FileName = CurCheat.FileName; EGR.Genre = GenreCB.SelectedIndex; } _dbc.SaveChanges(); RefreshGameLB(); } } else { MessageBox.Show("Необходимо привязать cheat file"); return; } }
public void AddToDB(GCDBContext _dbc) { using (_dbc=new GCDBContext(ConString)) { _dbc.Cheats.Add(CurCheat); _dbc.SaveChanges(); } }
public void RemoveGame() { /*var rreq = from game in Cheats where game.GameName == SelectGameName select game;*/ using (GCDBContext _dbc = new GCDBContext(ConString)) { var RR = _dbc.Cheats.FirstOrDefault(c => c.GameName == SelectGameName); if (RR != null) { _dbc.Cheats.Remove(RR); _dbc.SaveChanges(); RefreshGameLB(); } } }
public void DBSave() { using (GCDBContext dbc=new GCDBContext(CfgData2.ConStr)) { Cheat cheat = new Cheat() { FileName = @"c:\test" }; dbc.Cheats.Add(cheat); dbc.SaveChanges(); } }
public void ClearDB(GCDBContext _dbc) { using (_dbc=new GCDBContext(ConString)) { var all = _dbc.Cheats;//.Where(c => c.Id > -1); if (all.Any()) { /* using (SqlConnection s1=new SqlConnection(ConString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = s1; cmd.CommandType = CommandType.Text; cmd.CommandText = "DELETE FROM Cheats"; } }*/ _dbc.Database.ExecuteSqlCommand("DELETE FROM Cheats"); /*foreach (var cheat in all) { _dbc.Cheats.Remove(cheat); }*/ _dbc.Database.ExecuteSqlCommand("DBCC CHECKIDENT('Cheats', RESEED, -1)"); _dbc.SaveChanges(); MessageBox.Show("Game cheat база очищена"); } else { MessageBox.Show("Game cheat база пустая"); } } }