public IEnumerable <Role> GetAll() { using (var objectDb = ObjectDbFactory.CreateInstance("GetAllRole")) { return(objectDb.Query <Role>()); } }
public IEnumerable <Tournament> GetTournamentNotHaveChild() { using (var objectDb = ObjectDbFactory.CreateInstance("GetTournamentNotHaveChild")) { return(objectDb.Query <Tournament>()); } }
public IEnumerable <Player> GetAll() { using (IObjectDb db = ObjectDbFactory.CreateInstance("GetAllPlayer")) { return(db.Query <Player>()); } }
public IEnumerable <Federation> GetAll() { using (var objectDb = ObjectDbFactory.CreateInstance("GetAllFederation")) { return(objectDb.Query <Federation>().OrderBy(x => x.Name)); } }
public Role GetRoleUser(int id) { var parameter = new { UserID = id }; using (var objectDb = ObjectDbFactory.CreateInstance("GetRoleOfUser")) { return(objectDb.Query <Role>(parameter).FirstOrDefault()); } }
public void Delete(int id) { var parameter = new { TourID = id }; using (var objectDb = ObjectDbFactory.CreateInstance("DeleteTournament")) { objectDb.Query <Tournament>(parameter); } }
public void Delete(int id) { var parameter = new { ID = id }; using (var objectDb = ObjectDbFactory.CreateInstance("DeletePlayer")) { objectDb.Query <Player>(parameter); } }
public User FindUserName(string userName) { var parameter = new { UserName = userName }; using (IObjectDb objectDb = ObjectDbFactory.CreateInstance("FindUserName")) { return(objectDb.Query <User>(parameter).FirstOrDefault()); } }
public IEnumerable <Federation> GetFederationInTournament(int id) { var parameter = new { TourId = id.ToString(), }; using (IObjectDb db = ObjectDbFactory.CreateInstance("GetFederationParticipate")) { return(db.Query <Federation>(parameter)); } }
public Federation GetById(int id) { var parameter = new { TourId = id.ToString(), }; using (IObjectDb db = ObjectDbFactory.CreateInstance("GetSingle")) { return(db.Query <Federation>(parameter).FirstOrDefault()); } }
public void Delete(int id) { var parameter = new { ID = id }; using (var objectDb = ObjectDbFactory.CreateInstance("DeleteFederation")) { objectDb.Query <Federation>(parameter); } }
public IEnumerable <Round> GetListRoundByTournament(int id) { var parameter = new { TourID = id.ToString(), }; using (IObjectDb db = ObjectDbFactory.CreateInstance("GetListRoundByTournament")) { return(db.Query <Round>(parameter)); } }
public IEnumerable <Tournament> GetAll() { using (var objectDb = ObjectDbFactory.CreateInstance("GetAllTournament")) { return(objectDb.Query <Tournament, Federation, Tournament>( (tournament, federation) => { tournament.Federation = federation; return tournament; }, "FederationID")); } }
public IEnumerable <Tournament> GetTournamentInProgress() { using (var objectDb = ObjectDbFactory.CreateInstance("GetTournamentInProgress")) { var x = objectDb.Query <Tournament, Federation, Tournament>( (tournament, federation) => { tournament.Federation = federation; return(tournament); }, "FederationID"); return(x); } }
public void Add(Federation entity) { var parameter = new { Name = entity.Name, Flag = entity.Flag, Acronym = entity.Acronym }; using (var objectDb = ObjectDbFactory.CreateInstance("CreateFederation")) { objectDb.Query <Federation>(parameter); } }
public IEnumerable <PairingDTO> GetListParingByTourAndRound(int tourID, int roundID) { var parameter = new { RoundID = roundID.ToString(), TourID = tourID.ToString() }; using (var objectDb = ObjectDbFactory.CreateInstance("GetListPairing")) { var y = objectDb.Query <PairingDTO>(parameter); return(y); } }
public IEnumerable <TourRank> GetTournamentRank(int id) { var parameter = new { TourID = id.ToString(), }; using (var objectDb = ObjectDbFactory.CreateInstance("GetStartingRank")) { var tourRanks = objectDb.Query <TourRank>(parameter).OrderByDescending(x => x.TotalMark); return(tourRanks); } }
public void Add(User entity) { var param = new { UserName = entity.UserName, Password = entity.Password, RoleID = RoleType.Normal, }; using (IObjectDb db = ObjectDbFactory.CreateInstance("CreateUser")) { db.ExecuteNonQuery(param); } }
public IEnumerable <Pairing> GetListPairingInTourRound(int roundID, int tourID) { var parameter = new { RoundID = roundID.ToString(), TourID = tourID.ToString() }; using (var objectDb = ObjectDbFactory.CreateInstance("GetListPairingInTourRound")) { var pairing = objectDb.Query <Pairing>(parameter); return(pairing); } }
public void Add(Player entity) { var param = new { Name = entity.Name, BirthDate = entity.BirthDate, Image = entity.Image, Sex = entity.Sex, FederationID = entity.Federation.ID, }; using (IObjectDb db = ObjectDbFactory.CreateInstance("CreatePlayer")) { db.ExecuteNonQuery(param); } }
public IEnumerable <Tournament> GetTournamentInProgressByFederation(int id) { var parameter = new { FederationId = id.ToString(), }; using (var objectDb = ObjectDbFactory.CreateInstance("GetTournamentInProgressByFederation")) { return(objectDb.Query <Tournament, Federation, Tournament>( (tournament, federation) => { tournament.Federation = federation; return tournament; }, "FederationID", parameter)); } }
public Tournament GetById(int id) { const string splitOn = "FederationID"; var parameter = new { Id = id.ToString(), }; using (var objectDb = ObjectDbFactory.CreateInstance("GetSingle")) { return(objectDb.Query <Tournament, Federation, Tournament>( (tournaments, federation) => { tournaments.Federation = federation; return tournaments; }, splitOn, parameter).FirstOrDefault()); } }
public IEnumerable <Tournament> GetAllChildTournament(int id) { const string splitOn = "TournamentID"; var parameter = new { TourID = id.ToString(), }; using (var objectDb = ObjectDbFactory.CreateInstance("GetChildTournament")) { return(objectDb.Query <Form, Tournament, Tournament>( (form, tournaments) => { tournaments.Form = form; return tournaments; }, splitOn, parameter)); } }
public IEnumerable <PlayerInPair> GetListPlayerInParing(int pairingID) { const string splitOn = "Name, Flag"; var parameter = new { PairingID = pairingID.ToString(), }; using (var objectDb = ObjectDbFactory.CreateInstance("GetListPlayerInPairByPairingID")) { return(objectDb.Query <PlayerInPair, Player, Federation, PlayerInPair>( (playerInPair, player, federation) => { playerInPair.Player = player; playerInPair.Player.Federation = federation; return playerInPair; }, splitOn, parameter)); } }
public Player GetById(int id) { const string splitOn = "FederationID"; var parameter = new { ID = id.ToString() }; using (var objectDb = ObjectDbFactory.CreateInstance("GetPlayerByID")) { return(objectDb.Query <Player, Federation, Player>( (player, federation) => { player.Federation = federation; return player; }, splitOn, parameter) .FirstOrDefault()); } }
public IEnumerable <Player> GetListPlayerOfFederationInTournament(int tourID, int federationID) { const string splitOn = "FederationID"; var parameter = new { TourID = tourID.ToString(), FederationID = federationID.ToString() }; using (var objectDb = ObjectDbFactory.CreateInstance("GetPlayerInTournamentByFederation")) { return(objectDb.Query <Player, Federation, Player>( (player, federation) => { player.Federation = federation; return player; }, splitOn, parameter)); } }
public void Update(Tournament entity) { var parameters = new { TourID = entity.ID, Name = entity.Name, FederationID = entity.FederationID, StartDate = entity.StartDate, EndDate = entity.EndDate, Location = entity.Location, Organizer = entity.Organizer, Director = entity.Director, Description = entity.Description, Status = 1 }; using (var objectDb = ObjectDbFactory.CreateInstance("UpdateTournament")) { objectDb.Query <Tournament>(parameters); } }
public void Add(Tournament entity) { var parameters = new { Name = entity.Name, FederationID = entity.FederationID, StartDate = entity.StartDate, EndDate = entity.EndDate, Location = entity.Location, Organizer = entity.Organizer, Director = entity.Director, Description = entity.Description, ParentTourID = entity.ParentTourID, Status = 1 }; using (var objectDb = ObjectDbFactory.CreateInstance("AddTournament")) { objectDb.ExecuteNonQuery(parameters); } }
public User CheckUser(string userName, string passWord) { const string splitOn = "Name"; var parameter = new { UserName = userName, PassWord = passWord }; using (IObjectDb objectDb = ObjectDbFactory.CreateInstance("CheckUser")) { return(objectDb.Query <User, Role, User>( (user, role) => { user.Role = role; return user; }, splitOn, parameter) .FirstOrDefault()); } }
public IEnumerable <Tournament> FindTournament(TournamentFilter filter) { const string splitOn = "FederationID"; var parameters = new { Name = filter.Name, StartDate = filter.StartDate, FederationID = filter.FederationID }; using (var objectDb = ObjectDbFactory.CreateInstance("SearchTournament")) { return(objectDb.Query <Tournament, Federation, Tournament>( (tournament, federation) => { tournament.Federation = federation; return tournament; }, splitOn, parameters)); } }