public bool DeleteUserTeamPick(int userTeamid, SqlConnection db) { try { bool rowsDeleted = false; var userTeamPick = new UserTeamPick(); userTeamPick = db.Get <UserTeamPick>(userTeamid); rowsDeleted = db.Delete(new UserTeamPick() { userteamid = userTeamid }); if (rowsDeleted == true) { Logger.Out("UserTeamPick: Position:" + Convert.ToString(userTeamPick.position) + " PlayerId: " + Convert.ToString(userTeamPick.element) + " - deleted"); return(true); } return(false); } catch (Exception ex) { Logger.Error("UserTeamPick Repository (DeleteUserTeamPick) error: " + ex.Message); throw ex; } }
public bool UpdateUserTeamPick(UserTeamPick userTeamPick, SqlConnection db) { try { bool rowsUpdated = false; rowsUpdated = db.Update(userTeamPick, commandTimeout: 0); if (rowsUpdated == true) { Logger.Out("UserTeamPick: Position:" + Convert.ToString(userTeamPick.position) + " PlayerId: " + Convert.ToString(userTeamPick.element) + " - updated"); return(true); } return(false); } catch (Exception ex) { Logger.Error("UserTeamPick Repository (update) error: " + ex.Message); throw ex; } }