protected virtual void DbConnExec(Action <IDbConnection> dbConnFn)
{
using (var dbCon = DbConnectionFactory.OpenDbConnection())
{
dbConnFn(dbCon);
}
}
public MatchResponse Post(Match request)
{
request.DateTime = DateTime.Now;
request.UserAuthId = UserSession.UserAuthId;
using (var db = DbConnectionFactory.OpenDbConnection())
{
db.Save(request, true);
foreach (var teamMatch in request.TeamMatches)
{
teamMatch.Team = TryGetExistingTeam(db, teamMatch);
db.Save(teamMatch.Team);
teamMatch.TeamId = teamMatch.Team.Id;
db.Save(teamMatch, true);
foreach (var playerMatch in teamMatch.PlayerMatches)
{
playerMatch.Player = TryGetExistingPlayer(db, playerMatch);
db.Save(playerMatch.Player);
playerMatch.PlayerId = playerMatch.Player.Id;
db.Save(playerMatch, true);
}
}
}
return(Get(request));
}
protected virtual T DbConnExec <T>(Func <IDbConnection, T> dbConnFn)
{
using (var dbCon = DbConnectionFactory.OpenDbConnection())
{
return(dbConnFn(dbCon));
}
}
private IDbCommand CreateCommand(){
if(dbCmd==null)
{
dbConn = DbConnectionFactory.OpenDbConnection();
dbCmd = dbConn.CreateCommand();
}
return dbCmd;
}
protected object WithDB(Func <IDbConnection, object> operation)
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
logic.Init(db, GetSession(), Request);
return(operation(db));
}
}
public PreferencesResponse Put(Preferences request)
{
ValidateUserRequest(request);
using (var db = DbConnectionFactory.OpenDbConnection())
{
db.Save(request);
return(Get(request));
}
}
public PreferencesResponse Get(Preferences request)
{
ValidateUserRequest(request);
using (var db = DbConnectionFactory.OpenDbConnection())
{
var userPrefs = db.LoadSelect <Preferences>(p => p.UserId == request.UserId);
var userPref = userPrefs.Count == 1 ? userPrefs.First()
: new Preferences {
UserId = request.UserId, UserName = Session.UserAuthName
};
return(new PreferencesResponse {
Result = userPref
});
}
}
public MatchResponse Get(Match request)
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
var matches = request.Id == 0 ?
db.LoadSelect <Match>()
: db.LoadSelect <Match>(t => t.Id == request.Id);
foreach (var match in matches)
{
if (!string.IsNullOrEmpty(UserSession.Id))
{
match.UserAuthName = db.SingleById <UserAuth>(match.UserAuthId).UserName;
}
match.TeamMatches = db.LoadSelect <TeamMatch>(tm => tm.MatchId == match.Id);
foreach (var teamMatch in match.TeamMatches)
{
teamMatch.PlayerMatches = db.LoadSelect <PlayerMatch>(pm => pm.TeamMatchId == teamMatch.Id);
foreach (var playerMatch in teamMatch.PlayerMatches)
{
playerMatch.Player = db.SingleById <Player>(playerMatch.PlayerId);
}
teamMatch.Team = db.SingleById <Team>(teamMatch.TeamId);
teamMatch.Team.Name = string.Join("/", GetTeamNames(teamMatch));
}
}
if (!string.IsNullOrWhiteSpace(request.PlayerName))
{
var returnMatches =
matches.Where(
p => p.TeamMatches.Any(q => q.PlayerMatches.Any(r => r.Player.Name.Equals(request.PlayerName))));
matches = returnMatches.ToList();
}
return(new MatchResponse {
Total = matches.Count, Results = matches.OrderByDescending(m => m.DateTime).ToList()
});
}
}
protected virtual void DbConnExecTransaction(Action <IDbConnection> dbConnFn)
{
using (var dbCon = DbConnectionFactory.OpenDbConnection())
{
using (var trans = dbCon.OpenTransaction())
{
try
{
dbConnFn(dbCon);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
}
