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