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