internal StoreDataDlc GetDlcStoreData(int id)
{
StoreDataDlc game = new StoreDataDlc();
using (NpgsqlConnection conn = GetConnection())
{
conn.Open();
// Insert some data
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "select * from storedatadlc where parentid = @p";
cmd.Parameters.AddWithValue("p", id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
game = new StoreDataDlc()
{
Id = (long)reader["id"],
StoreName = reader["storename"].ToString(),
StoreUrl = reader["storeurl"].ToString(),
AppId = reader["appid"] == DBNull.Value ? -1 : (int)reader["appid"],
ParentId = reader["parentid"] == DBNull.Value ? -1 : (int)reader["parentid"]
};
}
}
}
}
return(game);
}
public int GetDlcAppId(string name)
{
Dlc game = new Dlc();
StoreDataDlc storeData = new StoreDataDlc();
using (NpgsqlConnection conn = GetConnection())
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "select * from dlc where name = @p";
cmd.Parameters.AddWithValue("p", name);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
game = new Dlc()
{
Id = (int)reader["id"],
ParentGameId = (long)reader["parentgameid"],
Name = reader["name"].ToString(),
Store = reader["store"].ToString(),
Price = (decimal)reader["price"],
Owned = (bool)reader["owned"],
Notes = reader["notes"].ToString(),
Ranking = reader["ranking"] == DBNull.Value ? (short)-1 : (short)reader["ranking"],
Rating = reader["rating"] == DBNull.Value ? (short)-1 : (short)reader["rating"]
};
}
}
}
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "select * from storedatadlc where parentid = @p";
cmd.Parameters.AddWithValue("p", game.Id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
storeData = new StoreDataDlc()
{
Id = (long)reader["id"],
StoreName = reader["storename"].ToString(),
StoreUrl = reader["storeurl"].ToString(),
AppId = (int)reader["appid"],
ParentId = (int)reader["parentid"]
};
}
}
}
if (storeData != null)
{
return(storeData.AppId);
}
else
{
return(0);
}
}
}
