public bool DeleteUserTeamCupTiebreak(int userteamcupid)
{
try
{
bool rowsDeleted = false;
var cupTiebreak = new UserTeamCupTiebreak();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
{
cupTiebreak = db.Get <UserTeamCupTiebreak>(userteamcupid, commandTimeout: 0);
rowsDeleted = db.Delete(new UserTeamCupTiebreak()
{
userteamcupid = userteamcupid
});
}
if (rowsDeleted == true)
{
Logger.Out("CupTiebreak: " + cupTiebreak.name + " (" + Convert.ToString(userteamcupid) + ") - deleted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("CupTiebreak Repository (DeleteCup) error: " + ex.Message);
throw ex;
}
}
public bool UpdateUserTeamCupTiebreak(UserTeamCupTiebreak cupTiebreak)
{
try
{
bool rowsUpdated = false;
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
{
rowsUpdated = db.Update(cupTiebreak, commandTimeout: 0);
}
if (rowsUpdated == true)
{
Logger.Out("CupTiebreak: " + cupTiebreak.name + " - updated");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("CupTiebreak Repository (update) error: " + ex.Message);
throw ex;
}
}
public bool InsertUserTeamCupTiebreak(UserTeamCupTiebreak cupTiebreak)
{
try
{
long rowsAffected = 0;
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
{
rowsAffected = db.Insert(cupTiebreak, commandTimeout: 0);
}
if (rowsAffected > 0)
{
Logger.Out("CupTiebreak: " + cupTiebreak.name + " - inserted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("CupTiebreak Repository (insert) error: " + ex.Message);
throw ex;
}
}
