public bool DeleteUserTeamClassicLeague(int userTeamid, int classicleagueid, SqlConnection db)
{
try
{
bool rowsDeleted = false;
var classicleague = new UserTeamClassicLeague();
classicleague = db.Get <UserTeamClassicLeague>(classicleagueid);
rowsDeleted = db.Delete(new UserTeamClassicLeague()
{
userteamid = userTeamid, id = classicleagueid
});
if (rowsDeleted == true)
{
Logger.Out("ClassicLeague: " + classicleague.name + " (" + Convert.ToString(classicleagueid) + ") - deleted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamClassicLeague Repository (DeleteClassicLeague) error: " + ex.Message);
throw ex;
}
}
public bool DeleteUserTeamClassicLeague(int userTeamid, int classicleagueid, SqlConnection db)
{
try
{
bool rowsDeleted = false;
var classicleague = new UserTeamClassicLeague();
//using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
//{
classicleague = db.Get <UserTeamClassicLeague>(classicleagueid);
rowsDeleted = db.Delete(new UserTeamClassicLeague()
{
userteamid = userTeamid, id = classicleagueid
});
//}
if (rowsDeleted == true)
{
Logger.Out("ClassicLeague: " + classicleague.name + " (" + Convert.ToString(classicleagueid) + ") - deleted");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamClassicLeague Repository (DeleteClassicLeague) error: " + ex.Message);
throw ex;
}
}
//public bool InsertUserTeamClassicLeague(UserTeamClassicLeague classicleague, SqlConnection db)
//{
// try
// {
// long rowsAffected = 0;
// //using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
// //{
// rowsAffected = db.Insert(classicleague, commandTimeout: 0);
// //}
// if (rowsAffected > 0)
// {
// Logger.Out("ClassicLeague: " + classicleague.name + " - inserted");
// return true;
// }
// return false;
// }
// catch (Exception ex)
// {
// Logger.Error("ClassicLeague Repository (insert) error: " + ex.Message);
// throw ex;
// }
//}
public bool UpdateUserTeamClassicLeague(UserTeamClassicLeague classicleague, SqlConnection db)
{
try
{
bool rowsUpdated = false;
rowsUpdated = db.Update(classicleague, commandTimeout: 0);
if (rowsUpdated == true)
{
Logger.Out("ClassicLeague: " + classicleague.name + " - updated");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamClassicLeague Repository (update) error: " + ex.Message);
throw ex;
}
}
//public bool InsertUserTeamClassicLeague(UserTeamClassicLeague classicleague, SqlConnection db)
//{
// try
// {
// long rowsAffected = 0;
// //using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
// //{
// rowsAffected = db.Insert(classicleague, commandTimeout: 300);
// //}
// if (rowsAffected > 0)
// {
// Logger.Out("ClassicLeague: " + classicleague.name + " - inserted");
// return true;
// }
// return false;
// }
// catch (Exception ex)
// {
// Logger.Error("ClassicLeague Repository (insert) error: " + ex.Message);
// throw ex;
// }
//}
public bool UpdateUserTeamClassicLeague(UserTeamClassicLeague classicleague, SqlConnection db)
{
try
{
bool rowsUpdated = false;
//using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString))
//{
rowsUpdated = db.Update(classicleague, commandTimeout: 300);
//}
if (rowsUpdated == true)
{
Logger.Out("ClassicLeague: " + classicleague.name + " - updated");
return(true);
}
return(false);
}
catch (Exception ex)
{
Logger.Error("UserTeamClassicLeague Repository (update) error: " + ex.Message);
throw ex;
}
}
