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