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