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; } }