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