public static void WriteUserTeamCupToDB(int pageId, UserTeamCupMatches userTeamCupInsert, SqlConnection db) { try { UserTeamCupRepository userTeamCupRepository = new UserTeamCupRepository(); //Write UserTeamCup to the db Globals.UserTeamCupRowsInserted = userTeamCupRepository.InsertUserTeamCup(userTeamCupInsert, db); Logger.Out("UserTeamCup bulk insert complete (PageId: " + Convert.ToString(pageId) + ")"); userTeamCupInsert.Clear(); } catch (Exception ex) { Logger.Error("Program WriteUserTeamCupToDB error: " + ex.Message); } }
public static void GetUserTeamCupJson(int userTeamId, UserTeam userTeam, SqlConnection db) { try { //Load Cup data UserTeamCupRepository cupRepository = new UserTeamCupRepository(); List <int> CupIds = cupRepository.GetAllCupIdsForUserId(userTeamId, db); int cupid, gameweekid; foreach (UserTeamCupMatch match in userTeam.leagues.cup.matches) { match.fromuserteamid = userTeamId; if (!CupIds.Contains(match.id)) { cupRepository.InsertUserTeamCup(match, db); } else { cupRepository.UpdateUserTeamCup(match, db); } if (match.tiebreak != null) { cupid = match.id; gameweekid = match.@event; //GetUserTeamCupTiebreakJson(userTeamId, cupid, gameweekid, cup); } } } catch (Exception ex) { Logger.Error("GetUserTeamCupJson data exception (UserTeamId: " + userTeamId.ToString() + "): " + ex.Message); throw new Exception("GetUserTeamCupJson data exception (UserTeamId: " + userTeamId.ToString() + "): " + ex.Message); //GetUserTeamCupJson(userTeamId, userTeamHistoryData); } }