public static Configuration AddConfigurationTypeEntry(
EnlistmentDC dc,
bool submit,
short id,
User u,
Email e,
PhoneSKU p,
Command c,
BuildXml b,
Enlistment1 en,
BuildType bt)
{
Configuration o = new Configuration
{
ID = id,
User = u,
Email = e,
PhoneSKU = p,
Command = c,
BuildXml = b,
Enlistment1 = en,
BuildType = bt
};
dc.Configurations.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static void PopulateDbSmall(EnlistmentDC dc, bool submit)
{
BuildType bt = AddBuildTypeEntry(dc, submit, 1, "Full Build 1");
AddBuildTypeEntry(dc, submit, 2, "Full Build 2");
BuildXml bx = AddBuildXmlTypeEntry(dc, submit, 1, @"C:\FilePath1\Config.xml");
AddBuildXmlTypeEntry(dc, submit, 2, @"C:\FilePath1\Config.xml");
Command c = AddCommandTypeEntry(dc, submit, 1, "Rebuild", "Wm Rebuild");
AddCommandTypeEntry(dc, submit, 2, "Build", "Wm Build");
User u = AddUserTypeEntry(dc, submit, 1, "Dave", "Hoover");
AddUserTypeEntry(dc, submit, 2, "John", "Wang");
Email e = AddEmailTypeEntry(dc, submit, 1, 2, true, "*****@*****.**");
AddEmailTypeEntry(dc, submit, 2, u, true, "*****@*****.**");
Enlistment1 en = AddEnlistmentTypeEntry(dc, submit, 1, @"F:\Enlistment1");
AddEnlistmentTypeEntry(dc, submit, 2, @"F:\Enlistment2");
PhoneSKU p = AddPhoneSkuTypeEntry(dc, submit, 1, "CEPC");
AddPhoneSkuTypeEntry(dc, submit, 2, "XDE");
Configuration cfg = AddConfigurationTypeEntry(dc, submit, 1, 2, 2, 2, 2, 2, 2, 2);
AddConfigurationTypeEntry(dc, submit, 2, u, e, p, c, bx, en, bt);
}
internal override void ModifyItem(string pathValue)
{
BuildXml en = (from c in dc.BuildXmls
where c.FileID == CurrentItemToEdit.FileID
select c).First();
en.FilePath = pathValue;
dc.SubmitChanges();
}
private void Start()
{
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkbook;
try
{
xlApp = new Microsoft.Office.Interop.Excel.Application();
xlWorkbook = xlApp.Workbooks.Open(dExcelPath.Text);
}
catch
{
MessageBox.Show(SharedStrings.MISSING_MS_EXCEL_COMPONENTS + "\n\r\n\rhttps://www.microsoft.com/en-us/download/details.aspx?id=3508", SharedStrings.MISSING_COMPONENTS, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1, 0, "https://www.microsoft.com/en-us/download/details.aspx?id=3508", "");
return;
}
try
{
BuildXml BuildXml = new BuildXml();
XmlDocument RootXml = new XmlDocument();
string currentPath = Environment.CurrentDirectory;
RootXml.Load("./Excel/RootTemplate.xml");
XDocument XRoot = BuildXml.ToXDocument(RootXml);
XDocument NewXmlDoc = new XDocument(XRoot);
List <Card> PageList = SetCardValues(xlWorkbook);
string filename = Path.GetFileNameWithoutExtension(dExcelPath.Text);
_template = BuildXml.BuildNewXml(PageList, NewXmlDoc, FormName);
this.DialogResult = DialogResult.OK;
}
catch
{
MessageBox.Show(SharedStrings.INVALID_INPUT);
this.DialogResult = DialogResult.Abort;
}
finally
{
// Close the Workbook.
xlWorkbook.Close(false);
// Relase COM Object by decrementing the reference count.
Marshal.ReleaseComObject(xlWorkbook);
// Close Excel application.
xlApp.Quit();
// Release COM object.
Marshal.FinalReleaseComObject(xlApp);
}
if (this.DialogResult == DialogResult.OK)
{
this.Close();
}
}
internal override void AddItem()
{
short maxId = (from c in dc.BuildXmls select c.FileID).Max();
BuildXml en = new BuildXml {
FileID = (short)(maxId + 1), FilePath = @"C:\MyPbXml.xml"
};
dc.BuildXmls.InsertOnSubmit(en);
base.AddItem();
}
public static BuildXml AddBuildXmlTypeEntry(EnlistmentDC dc, bool submit, short id, string filePath)
{
BuildXml o = new BuildXml {
FileID = id, FilePath = filePath
};
dc.BuildXmls.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
