public void Save(DTL.DTLGame game) { _cnn.Open(); _command.Parameters.Add("@ID", SqlDbType.Int); _command.Parameters["@ID"].Value = game.Id; _command.Parameters.Add("@MONEY", SqlDbType.Int); _command.Parameters["@MONEY"].Value = game.Money; _command.CommandText = "IF EXISTS (SELECT * FROM Games WHERE Id = @ID)" + "UPDATE Games SET Timesaved = (SELECT GETDATE())" + ", Money = @MONEY WHERE Id = @ID " + "ELSE INSERT INTO Games (Id, Timesaved, Money) " + "VALUES (@ID,(SELECT GETDATE()),@MONEY);"; _adapter.UpdateCommand = _command; int success = _adapter.UpdateCommand.ExecuteNonQuery(); //_command.Parameters.Add("@NAME", SqlDbType.Text); //foreach(var shop in game.DTLShops) //{ // _command.CommandText = AddShopToSQLCommand(shop); // success = _adapter.UpdateCommand.ExecuteNonQuery(); //} _command.CommandText = AddShopsToSQLCommand(game.DTLShops); success = _adapter.UpdateCommand.ExecuteNonQuery(); _command.Dispose(); _cnn.Close(); }
public DTL.DTLGame Read(int gameid) { _cnn.Open(); var list = new List <DTL.DTLShop>(); var game = new DTL.DTLGame(); _command.Parameters.Add("@ID", SqlDbType.Int); _command.Parameters["@ID"].Value = gameid; _command.CommandText = "SELECT g.Id, g.Timesaved, g.Money, s.id, s.Upgradelvl, s.Income, s.Upgradecost," + "s.Renovatecost, s.Millisecondsuntilready, s.Name, s.Baselvl, s.Beingrenovated" + " FROM Games g, Shops s " + "WHERE s.Gameid = @ID" + " AND g.Id = @ID"; _reader = _command.ExecuteReader(); while (_reader.Read()) { game.Id = _reader.GetInt32(0); game.LastUpdated = _reader.GetDateTime(1); game.Money = _reader.GetInt32(2); var shopid = _reader.GetInt32(3); var upgradelvl = _reader.GetInt32(4); var income = _reader.GetInt32(5); var upgradecost = _reader.GetInt32(6); var renovatecost = _reader.GetInt32(7); var msuntilready = _reader.GetInt32(8); var name = _reader.GetString(9); var baselvl = _reader.GetInt32(10); var renovated = false; if (_reader.GetInt32(11) == 1) { renovated = true; } var shop = new DTL.DTLShop(shopid, gameid, upgradelvl, baselvl, income, upgradecost, renovatecost, msuntilready, name, renovated); list.Add(shop); } _command.Dispose(); _cnn.Close(); game.DTLShops = list; return(game); }