public static void GetUserTeamPickAutomaticSubJson(int userTeamId, int gameweekId, UserTeamPickAutomaticSubs userTeamPickAutomaticSubsInsert, UserTeamPickData userTeamPickData, SqlConnection db) { try { //Logger.Out("GetUserTeamPickAutomaticSubJson: Gameweek " + Convert.ToString(gameweekId) + " - starting"); //Load UserTeamPickAutomaticSub data UserTeamPickAutomaticSubRepository userTeamPickAutomaticSubRepository = new UserTeamPickAutomaticSubRepository(); //List<int> UserTeamPickAutomaticSubIds = userTeamPickAutomaticSubRepository.GetAllUserTeamPickAutomaticSubIdsForUserTeamIdAndGameweekId(userTeamId, gameweekId, db); foreach (UserTeamPickAutomaticSub userTeamPickAutomaticSub in userTeamPickData.automatic_subs) { //needed if want to assign value from parent to add into db table //if (!UserTeamPickAutomaticSubIds.Contains(userTeamPickAutomaticSub.element_in) && !userTeamPickAutomaticSubsInsert.Contains(userTeamPickAutomaticSub)) if (!userTeamPickAutomaticSubsInsert.Contains(userTeamPickAutomaticSub)) { userTeamPickAutomaticSubsInsert.Add(userTeamPickAutomaticSub); } //else //{ // userTeamPickAutomaticSubRepository.UpdateUserTeamPickAutomaticSub(userTeamPickAutomaticSub); //} } //Logger.Out("GetUserTeamPickAutomaticSubJson: Gameweek " + Convert.ToString(gameweekId) + " - completed"); } catch (Exception ex) { Logger.Error("GetUserTeamPickAutomaticSubJson data exception (UserTeamId: " + userTeamId.ToString() + "): " + ex.Message); //throw new Exception("GetUserTeamPickAutomaticSubJson data exception (UserTeamId: " + userTeamId.ToString() + "): " + ex.Message); //GetUserTeamPickAutomaticSubJson(userTeamId, gameweekId, userTeamPickAutomaticSubsInsert, userTeamPickData, db); } }
public static void WriteUserTeamPickAutomaticSubsToDB(int pageId, UserTeamPickAutomaticSubs userTeamPickAutomaticSubsInsert, SqlConnection db) { try { UserTeamPickAutomaticSubRepository userTeamPickAutomaticSubRepository = new UserTeamPickAutomaticSubRepository(); //Write UserTeamPickAutomaticSub to the db Globals.UserTeamPickAutomaticSubsRowsInserted = userTeamPickAutomaticSubRepository.InsertUserTeamPickAutomaticSubs(userTeamPickAutomaticSubsInsert, db); Logger.Out("UserTeamPickAutomaticSub bulk insert complete (PageId: " + Convert.ToString(pageId) + ")"); userTeamPickAutomaticSubsInsert.Clear(); } catch (Exception ex) { Logger.Error("Program WriteUserTeamPickAutomaticSubsToDB error: " + ex.Message); } }