private void GenerateSpreadsheetUserButton_Click(object sender, EventArgs e)
{
SaveSpreadsheetFileDialog.Filter = "database_user.csv|database_user.csv";
header = "Category\tMod\tDevURL";
//reset everything
sb = new StringBuilder();
packageName = "";
category = "";
packageDisplayName = "";
packageName = "";
zipfile = "";
devURL = "";
enabled = false;
//ask where to save the file
if (SaveSpreadsheetFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
//save it
sb.Append(header + "\n");
foreach (Category cat in parsedCatagoryList)
{
category = cat.Name;
foreach (SelectablePackage m in cat.Packages)
{
//remove the old devURL value if there
devURL = "";
packageDisplayName = m.Name;
devURL = string.IsNullOrWhiteSpace(m.DevURL) ? "" : "=HYPERLINK(\"" + m.DevURL + "\",\"link\")";
sb.Append(category + "\t" + packageDisplayName + "\t" + devURL + "\n");
if (m.Packages.Count > 0)
{
processConfigsSpreadsheetGenerateUser(m.Packages);
}
}
}
try
{
File.WriteAllText(SaveSpreadsheetFileDialog.FileName, sb.ToString());
SpreadsheetLocation.Text = "Saved in " + SaveSpreadsheetFileDialog.FileName;
}
catch (IOException)
{
SpreadsheetLocation.Text = "Failed to save in " + SaveSpreadsheetFileDialog.FileName + " (IOException, probably file open in another window)";
}
}
private void GenretateInternalSpreadsheetButton_Click(object sender, EventArgs e)
{
SaveSpreadsheetFileDialog.Filter = "database.csv|database.csv";
//reset everything
header = "PackageName\tCategory\tPackage\tLevel\tZip\tDevURL\tEnabled\tVisible";
sb = new StringBuilder();
packageDisplayName = "";
category = "";
packageName = "N/A";
zipfile = "";
devURL = "";
enabled = false;
visible = false;
//ask where to save the file
if (SaveSpreadsheetFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
//save it
sb.Append(header + "\n");
//first save globaldependencies
category = "globalDependencies";
foreach (Dependency d in globalDependencies)
{
packageName = d.PackageName;
zipfile = string.IsNullOrWhiteSpace(d.ZipFile) ? notApplicatable : d.ZipFile;
devURL = string.IsNullOrWhiteSpace(d.DevURL) ? "" : "=HYPERLINK(\"" + d.DevURL + "\",\"link\")";
enabled = d.Enabled;
sb.Append(packageName + "\t" + category + "\t" + packageDisplayName + "\t" + 0 + "\t" + zipfile + "\t" + devURL + "\t" + enabled + "\n");
}
//next save depenedneices
category = "dependencies";
foreach (Dependency d in dependencies)
{
packageName = d.PackageName;
zipfile = string.IsNullOrWhiteSpace(d.ZipFile) ? notApplicatable : d.ZipFile;
devURL = string.IsNullOrWhiteSpace(d.DevURL) ? "" : "=HYPERLINK(\"" + d.DevURL + "\",\"link\")";
enabled = d.Enabled;
sb.Append(packageName + "\t" + category + "\t" + packageDisplayName + "\t" + 0 + "\t" + zipfile + "\t" + devURL + "\t" + enabled + "\n");
}
//next save logicaldepenedneices
category = "logicalDependencies";
foreach (LogicalDependency d in logicalDependencies)
{
packageName = d.PackageName;
zipfile = string.IsNullOrWhiteSpace(d.ZipFile) ? notApplicatable : d.ZipFile;
devURL = string.IsNullOrWhiteSpace(d.DevURL) ? "" : "=HYPERLINK(\"" + d.DevURL + "\",\"link\")";
enabled = d.Enabled;
sb.Append(packageName + "\t" + category + "\t" + packageDisplayName + "\t" + 0 + "\t" + zipfile + "\t" + devURL + "\t" + enabled + "\n");
}
foreach (Category cat in parsedCatagoryList)
{
category = cat.Name;
foreach (SelectablePackage m in cat.Packages)
{
packageName = m.PackageName;
packageDisplayName = m.Name;
zipfile = string.IsNullOrWhiteSpace(m.ZipFile) ? notApplicatable : m.ZipFile;
enabled = m.Enabled;
visible = m.Visible;
devURL = string.IsNullOrWhiteSpace(m.DevURL) ? "" : "=HYPERLINK(\"" + m.DevURL + "\",\"link\")";
//header = "Index,Category,Mod,Config,Level,Zip,Enabled";
sb.Append(packageName + "\t" + category + "\t" + packageDisplayName + "\t" + m.Level + "\t" + zipfile + "\t" + devURL + "\t" + enabled + "\t" + visible + "\n");
if (m.Packages.Count > 0)
{
processConfigsSpreadsheetGenerate(m.Packages);
}
}
}
try
{
File.WriteAllText(SaveSpreadsheetFileDialog.FileName, sb.ToString());
SpreadsheetLocation.Text = "Saved in " + SaveSpreadsheetFileDialog.FileName;
}
catch (IOException)
{
SpreadsheetLocation.Text = "Failed to save in " + SaveSpreadsheetFileDialog.FileName + " (IOException, probably file open in another window)";
}
}
