public bool DeleteUserTeamChip(int userTeamid, int gamweekid, int chipid, SqlConnection db) { try { bool rowsDeleted = false; var userTeamChip = new UserTeamChip(); userTeamChip = db.Get <UserTeamChip>(chipid); rowsDeleted = db.Delete(new UserTeamChip() { userteamid = userTeamid }); if (rowsDeleted == true) { Logger.Out("UserTeamChip: " + userTeamChip.name + " (" + Convert.ToString(chipid) + ") - deleted"); return(true); } return(false); } catch (Exception ex) { Logger.Error("UserTeamChip Repository (DeleteUserTeamChip) error: " + ex.Message); throw ex; } }
//public class UserTeamChipRepository : IUserTeamChip //{ // public bool InsertUserTeamChip(UserTeamChip userTeamChip) // { // try // { // int rowsAffected = 0; // using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString)) // { // rowsAffected = (int)db.Insert(userTeamChip); // } // if (rowsAffected > 0) // { // Logger.Out("UserTeamChip: " + userTeamChip.name + " - inserted"); // return true; // } // return false; // } // catch (Exception ex) // { // Logger.Error("UserTeamChip Repository (insert) error: " + ex.Message); // Logger.Error("UserTeamChip Repository (insert) error: " + ex.InnerException); // throw ex; // } // } public bool UpdateUserTeamChip(UserTeamChip userTeamChip, SqlConnection db) { try { bool rowsUpdated = false; rowsUpdated = db.Update(userTeamChip, commandTimeout: 0); if (rowsUpdated == true) { Logger.Out("UserTeamChip: " + userTeamChip.name + " - updated"); return(true); } return(false); } catch (Exception ex) { Logger.Error("UserTeamChip Repository (update) error: " + ex.Message); throw ex; } }