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