//Convert Data to LUA Func private void SplitBossToLineArray(String Range, String ProfilName) { try { var foos = GoogleSheetLib.GetRowVal(Range); var fooArray = foos.Split('_'); // now you have an array of 3 strings foos = String.Join("_", fooArray); for (int i = 0; i <= fooArray.Length - 1; i++) { richTextBoxResult.AppendText(ReturnLUAStringFunc(ProfilName, fooArray.Length.ToString(), fooArray[i], i + 1) + "\r\n"); } } catch { toolStripStatusLbl.Text = "Erreur(s) lors de la récupération des Données."; } }
//Extract Data to .txt private void buttonExtractEvent_Click(object sender, EventArgs e) { String[] lines = { }; String PlayerPlace; if (!checkBoxUploadDataOnline.Checked) { if (listBoxDetailsEvent.Items.Count <= 0) { toolStripStatusLbl.Text = "Vous devez d'abord séléctionner un Evement dans la liste."; } else { for (Int32 i = 1; i <= FuncsLib.dump["GEM_Events"]["realms"]["Elysium"]["events"][listViewEventsList.Items[FuncsLib.EventSelected].Text]["titulars"].Count; i++) { if (GetStringPlayerInfoLUA(i, "name").ToString() != null) { if ((int)i <= 9) { PlayerPlace = "P0" + i.ToString(); } else { PlayerPlace = "P" + i.ToString(); } Array.Resize(ref lines, lines.Length + 1); lines[lines.Length - 1] = PlayerPlace + Properties.Settings.Default.SeparatorPattern + GetStringPlayerInfoLUA(i, "name"); } } for (Int32 f = FuncsLib.dump["GEM_Events"]["realms"]["Elysium"]["events"][listViewEventsList.Items[FuncsLib.EventSelected].Text]["titular_count"].GetInt(); f <= 100; f++) { Array.Resize(ref lines, lines.Length + 1); lines[lines.Length - 1] = Properties.Settings.Default.SeparatorPattern; } System.IO.File.WriteAllLines(AppDomain.CurrentDomain.BaseDirectory + "ExtractionEventGEM.txt", lines); toolStripStatusLbl.Text = "Les données ont été extraites en fichier .txt."; } } else { GoogleSheetLib.PlayerNum.Clear(); GoogleSheetLib.PlayerName.Clear(); if (listBoxDetailsEvent.Items.Count <= 0) { toolStripStatusLbl.Text = "Vous devez d'abord séléctionner un Evement dans la liste."; } else { for (Int32 i = 1; i <= FuncsLib.dump["GEM_Events"]["realms"]["Elysium"]["events"][listViewEventsList.Items[FuncsLib.EventSelected].Text]["titulars"].Count; i++) { if (GetStringPlayerInfoLUA(i, "name").ToString() != null) { if ((int)i <= 9) { PlayerPlace = "P0" + i.ToString(); } else { PlayerPlace = "P" + i.ToString(); } GoogleSheetLib.PlayerNum.Add(PlayerPlace); GoogleSheetLib.PlayerName.Add(GetStringPlayerInfoLUA(i, "name")); } } for (Int32 f = FuncsLib.dump["GEM_Events"]["realms"]["Elysium"]["events"][listViewEventsList.Items[FuncsLib.EventSelected].Text]["titular_count"].GetInt(); f <= 100; f++) { GoogleSheetLib.PlayerNum.Add(""); GoogleSheetLib.PlayerName.Add(""); } try { GoogleSheetLib.SendDataPlayerSub(GoogleSheetLib.ReturnValArray(GoogleSheetLib.PlayerNum), textBoxFeuilleGoogle.Text + "!A3"); GoogleSheetLib.SendDataPlayerSub(GoogleSheetLib.ReturnValArray(GoogleSheetLib.PlayerName), textBoxFeuilleGoogle.Text + "!B3"); toolStripStatusLbl.Text = "Les données ont été Upload sur le Docs.Google."; } catch { toolStripStatusLbl.Text = "Erreur(s) lors de l'envoie des Données sur le Docs.Google."; } } } }