protected override BaseEntity CreateModel(BaseEntity entity) { PlayerDb playerDb = new PlayerDb(); GameDb gameDb = new GameDb(); PlayerGameConnection con = entity as PlayerGameConnection; con.Id = (int)Reader["ID"]; con.Player = playerDb.GetPlayerById((int)Reader["player_id"]); con.Game = gameDb.GetGameById((int)Reader["game_id"]); return(con); }
public override void CreateDeleteSql(BaseEntity entity, OleDbCommand command) { PlayerGameConnection con = entity as PlayerGameConnection; command.CommandText = "DELETE FROM Player_Game_Table WHERE player_id = @player_id AND game_id = @game_id"; //parameters command.Parameters.Add(new OleDbParameter("@player_id", con.Player.Id)); command.Parameters.Add(new OleDbParameter("@game_id", con.Game.Id)); Console.WriteLine("PlayerGameConnection between player [" + con.Player.Id + "] and game [" + con.Game.Id + "] DELETED"); }
public override void CreateInsertSql(BaseEntity entity, OleDbCommand command) { PlayerGameConnection con = entity as PlayerGameConnection; command.CommandText = "INSERT INTO Player_Game_Table (player_id, game_id) VALUES (@player_id, @game_id)"; //parameters command.Parameters.Add(new OleDbParameter("@player_id", con.Player.Id)); command.Parameters.Add(new OleDbParameter("@game_id", con.Game.Id)); Console.WriteLine("PlayerGameConnection between player [" + con.Player.Id + "] and game [" + con.Game.Id + "] INSERTED"); }