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);
}
