public GameInfoIGDBDAO(string getKey, string getConnection) { //Setting values that get passed thru the constructor to set up our class apiKey = getKey; connectionString = getConnection; daoPushRating = new GameRatingSQLDAO(connectionString); }
public override void Setup() { base.Setup(); dao = new GameRatingSQLDAO(ConnectionString); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"insert into Ratings (popularity,hype,rating,rating_count) values (100,200,5,7) select scope_identity()"; rtingID = Convert.ToInt32(cmd.ExecuteScalar()); } }
public virtual void Setup() { daoCovers = new CoversSQLDAO(ConnectionString); daoGameInfo = new GameInfoSQLDAO(ConnectionString); daoRatings = new GameRatingSQLDAO(ConnectionString); daoFranchises = new FranchisesSQLDAO(ConnectionString); daoGameRatings = new GameRatingSQLDAO(ConnectionString); transaction = new TransactionScope(); using (SqlConnection conn = new SqlConnection(ConnectionString)) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"delete from UserGameInfo delete from UserInfo delete from Games delete from Ratings delete from Covers delete from Platforms delete from Genres delete from Franchises"; conn.Open(); cmd.ExecuteNonQuery(); } using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @" insert into Franchises (franchise_id,franchise_name) values(0,'No Franchise') insert into Covers (cover_id,cover_url) values(0,'testurl.com') insert into Genres (genre_id,genre_name) values(0,'Test Genre') insert into Platforms (platform_id,platform_name) values (0,'PizzaPiGameRunner') insert into Ratings (popularity,hype,rating,rating_count) values (100,200,5,7) select scope_identity()"; rtingID = Convert.ToInt32(cmd.ExecuteScalar()); cmd.CommandText = @"insert into Games(game_id, game_name, rating_id, platform_id_array, cover_id, genre_id_array, franchise_id, game_description) values(200, 'CW 01', @ratingId, 0, 0, 0, 0, 'Coder wars the start!'),(300,'Faja',@ratingId,0,0,0,0,'Mr Taco presents')"; cmd.Parameters.AddWithValue("@ratingId", rtingID); cmd.ExecuteNonQuery(); cmd.CommandText = @"insert into UserInfo (userName,password,salt) values ('testUser','password','salt')"; cmd.ExecuteNonQuery(); cmd.CommandText = @"insert into UserGameInfo (userName,game_id,progress,owned,wishlist) values ('testUser',200,0,1,0)"; cmd.ExecuteNonQuery(); } }
public DataBaseMediator() { platformsSQLDAO = new PlatformsSQLDAO(ConnectionString); coverSQLDAO = new CoversSQLDAO(ConnectionString); franchiseSQLDAO = new FranchisesSQLDAO(ConnectionString); gameInfoSQLDAO = new GameInfoSQLDAO(ConnectionString); gameRatingSQLDAO = new GameRatingSQLDAO(ConnectionString); genresSQLDAO = new GenresSQLDAO(ConnectionString); userGameInfoSQLDAO = new UserGameInfoSQLDAO(ConnectionString); userLoginSQLDAO = new UserLoginSqlDao(ConnectionString, hash); genresIGDBDAO = new GenresIGDBDAO(UserApiKey); platformsInfoIGDBDAO = new PlatformsIGDBDAO(UserApiKey); gameInfoIGDBDAO = new GameInfoIGDBDAO(UserApiKey, ConnectionString); coversIGDBDAO = new CoversIGDBDAO(UserApiKey); franchisesIGDBDAO = new FranchisesIGDBDAO(UserApiKey); }