private string AddShopToSQLCommand(DTL.DTLShop shop)
{
_command.Parameters["@NAME"].Value = shop.Name;
return(String.Format("IF EXISTS (SELECT * FROM shops WHERE Id ={0})" +
"UPDATE shops SET Upgradelvl ={1}, Income = {2}, Upgradecost = {3}, " +
"Renovatecost = {4}, Millisecondsuntilready = {5}, Baselvl = {6}, Beingrenovated = {7} " +
"WHERE Id ={0} " +
"ELSE INSERT INTO shops (Id, Gameid, Upgradelvl, Income, Upgradecost, Renovatecost, " +
"Millisecondsuntilready, Name, Baselvl, Beingrenovated) " +
"VALUES ({0}, {8}, {1}, {2}, {3}, {4}, {5}, @NAME, {6}, {7});",
shop.Id, shop.UpgradeLevel, shop.IncomePerMinute, shop.CostToUpgrade, shop.CostToRenovate,
shop.MillisecondsUntilReady, shop.BaseLevel, shop.BeingRenovated, shop.GameId));
}
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);
}
