//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."; }
}
}
}
