public static void InsertFollowers(ChannelO channel) { int offset = 0; List <Follow> followers = new List <Follow>(); FollowerO followersO = ChannelD.GetChannelFollowers(offset, channel); int total = followersO._total; while (offset < total) { foreach (Follow follow in followersO.follows) { followers.Add(follow); offset += 1; } followersO = ChannelD.GetChannelFollowers(offset, channel); } try { string connectionString = ConfigurationManager.ConnectionStrings["MysqlMoonBotDataBase"].ConnectionString; using (MySqlConnection mySqlConnection = new MySqlConnection(connectionString)) { mySqlConnection.Open(); using (MySqlCommand cmdUpdateUser = new MySqlCommand()) { cmdUpdateUser.CommandText = "UpdateUser"; cmdUpdateUser.Connection = mySqlConnection; cmdUpdateUser.CommandType = CommandType.StoredProcedure; foreach (Follow follow in followers) { if (cmdUpdateUser.Parameters.Contains("twitchId")) { cmdUpdateUser.Parameters["twitchId"].Value = follow.user._id; } else { cmdUpdateUser.Parameters.AddWithValue("twitchId", follow.user._id); } if (cmdUpdateUser.Parameters.Contains("displayName")) { cmdUpdateUser.Parameters["displayName"].Value = follow.user.display_name; } else { cmdUpdateUser.Parameters.AddWithValue("displayName", follow.user.display_name); } if (cmdUpdateUser.Parameters.Contains("name")) { cmdUpdateUser.Parameters["name"].Value = follow.user.name; } else { cmdUpdateUser.Parameters.AddWithValue("name", follow.user.name); } MySqlDataReader result = cmdUpdateUser.ExecuteReader(); result.Close(); } } using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "InsertFollower"; cmd.Connection = mySqlConnection; cmd.CommandType = CommandType.StoredProcedure; foreach (Follow follow in followers) { if (cmd.Parameters.Contains("createdAt")) { cmd.Parameters["createdAt"].Value = follow.created_at; } else { cmd.Parameters.AddWithValue("createdAt", follow.created_at); } if (cmd.Parameters.Contains("twitchId")) { cmd.Parameters["twitchId"].Value = follow.user._id; } else { cmd.Parameters.AddWithValue("twitchId", follow.user._id); } MySqlDataReader result = cmd.ExecuteReader(); result.Close(); } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } }