private void Form1_Load(object sender, EventArgs e)
{
StagingEntities stagingEntities = new StagingEntities();
foreach (UserAccount userAccount in stagingEntities.UserAccounts)
{
if (this.uxCollectionTreeView.Nodes.Find(userAccount.Region.Name, false).Count() == 0)
{
TreeNode regionNode = new TreeNode(userAccount.Region.Name);
regionNode.Name = userAccount.Region.Name;
this.uxCollectionTreeView.Nodes.Add(regionNode);
}
TreeNode usersRegionNode = this.uxCollectionTreeView.Nodes.Find(userAccount.Region.Name, false)[0];
if (usersRegionNode.Nodes.Find(userAccount.SBU.Name, false).Count() == 0)
{
TreeNode sbuNode = new TreeNode(userAccount.SBU.Name);
sbuNode.Name = userAccount.SBU.Name;
usersRegionNode.Nodes.Add(sbuNode);
}
TreeNode usersSBUNode = usersRegionNode.Nodes.Find(userAccount.SBU.Name, false)[0];
if (usersSBUNode.Nodes.Find(userAccount.Username, false).Count() == 0)
{
TreeNode userAccountNode = new TreeNode(userAccount.Username);
userAccountNode.Name = userAccount.Username;
userAccountNode.Tag = userAccount;
usersSBUNode.Nodes.Add(userAccountNode);
}
TreeNode usersUserAccountNode = usersSBUNode.Nodes.Find(userAccount.Username, false)[0];
usersUserAccountNode.Nodes.Add("");
}
}
private void testMethodToolStripMenuItem_Click(object sender, EventArgs e)
{
StagingEntities stagingEntities = new StagingEntities();
int totalFormulationCount = stagingEntities.Formulations.Count();
int formulationCounter = 0;
Console.WriteLine("Formulation Count: " + totalFormulationCount);
if (Directory.Exists(_xmlDirectory))
Directory.Delete(_xmlDirectory, true);
foreach (Formulation formulation in stagingEntities.Formulations.Where(w => w.CreatedBy == "STRAITKM").Take(100))
{
string a = formulation.RequestedByUserAccount.Region.Name;
a = formulation.RequestedByUserAccount.SBU.Name;
XDocument formulationDocument = GetFormulationDocument(formulation);
if (!Directory.Exists(_xmlDirectory + formulation.CreatedBy))
{
Directory.CreateDirectory(_xmlDirectory + formulation.CreatedBy);
}
formulationDocument.Save(_xmlDirectory + formulation.CreatedBy + @"\" + formulation.MaterialName + @".xml");
formulationCounter++;
Console.WriteLine(formulationCounter + " out of " + totalFormulationCount + " exported. " + ((float)formulationCounter/totalFormulationCount) + "% complete.");
}
}
