public bool DeleteUserTeamCup(int cupid, SqlConnection db)
{
try
{
bool rowsDeleted = false;
var cup = new UserTeamCupMatch();
cup = db.Get <UserTeamCupMatch>(cupid);
rowsDeleted = db.Delete(new UserTeamCupMatch()
{
id = cupid
});
if (rowsDeleted == true)
{
Logger.Out("Cup: " + cup.entry_1_name + " v " + cup.entry_2_name + " (" + Convert.ToString(cupid) + ") - deleted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamCup Repository (DeleteCup) error: " + ex.Message);
throw ex;
}
}
public bool DeleteUserTeamCup(int cupid, SqlConnection db)
{
try
{
bool rowsDeleted = false;
var cup = new UserTeamCupMatch();
//using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
//{
cup = db.Get <UserTeamCupMatch>(cupid);
rowsDeleted = db.Delete(new UserTeamCupMatch()
{
id = cupid
});
//}
if (rowsDeleted == true)
{
Logger.Out("Cup: " + cup.entry_1_name + " v " + cup.entry_2_name + " (" + Convert.ToString(cupid) + ") - deleted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("Cup Repository (DeleteCup) error: " + ex.Message);
throw ex;
}
}
public bool UpdateUserTeamCup(UserTeamCupMatch cup, SqlConnection db)
{
try
{
bool rowsUpdated = false;
rowsUpdated = db.Update(cup, commandTimeout: 0);
if (rowsUpdated == true)
{
Logger.Out("Cup: " + cup.entry_1_name + " v " + cup.entry_2_name + " - updated");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamCup Repository (update) error: " + ex.Message);
throw ex;
}
}
public bool UpdateUserTeamCup(UserTeamCupMatch cup, SqlConnection db)
{
try
{
bool rowsUpdated = false;
//using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
//{
rowsUpdated = db.Update(cup);
//}
if (rowsUpdated == true)
{
Logger.Out("Cup: " + cup.entry_1_name + " v " + cup.entry_2_name + " - updated");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("Cup Repository (update) error: " + ex.Message);
throw ex;
}
}
public bool InsertUserTeamCup(UserTeamCupMatch cup, SqlConnection db)
{
try
{
long rowsAffected = 0;
//using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
//{
rowsAffected = db.Insert(cup);
//}
if (rowsAffected > 0)
{
Logger.Out("Cup: " + cup.entry_1_name + " v " + cup.entry_2_name + " - inserted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("Cup Repository (insert) error: " + ex.Message);
throw ex;
}
}