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