public override void Delete(BaseEntity entity) { User u = entity as User; if (u.Id > 0)// check if user is not table! { PlayerDb playerDb = new PlayerDb(); PlayerList temp = playerDb.GetPlayersByUserId(u.Id);// get a lidst with all players of this user foreach (Player p in temp) { playerDb.Delete(p); } FriendDb friendDb = new FriendDb(); ConnectionList friends = friendDb.SelectByUserId(u.Id); foreach (Friendship f in friends) { friendDb.Delete(f); } if (u != null) { Updated.Add(new ChangeEntity(CreateDeleteSql, entity)); } } }
protected override BaseEntity CreateModel(BaseEntity entity) { PlayerDb playerDb = new PlayerDb(); CardDb cardDb = new CardDb(); PlayerCardConnection con = entity as PlayerCardConnection; con.Id = (int)Reader["ID"]; con.Player = playerDb.GetPlayerById((int)Reader["player_id"]); con.Card = cardDb.SelectById((int)Reader["card_id"]); return(con); }
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); }
protected override BaseEntity CreateModel(BaseEntity entity) { PlayerDb db = new PlayerDb(); Game game = entity as Game; game.Id = (int)Reader["ID"]; game.Players.Add((Player)db.GetPlayerById((int)Reader["player_1_id"])); game.Players.Add((Player)db.GetPlayerById((int)Reader["player_2_id"])); game.Players.Add((Player)db.GetPlayerById((int)Reader["player_3_id"])); game.Players.Add((Player)db.GetPlayerById((int)Reader["player_4_id"])); game.Players.Add((Player)db.GetPlayerById((int)Reader["table_id"])); game.StartTime = (DateTime)Reader["start_date"]; game.EndTime = (DateTime)Reader["end_date"]; game.Loser = (int)Reader["losser_id"]; return(game); }