private void generateFrontPage(byte[] templateLocation, WordInterface wordInterface, Document wordDocument, DataRow projectInfoRow)
{
lock (this.threadLock)
{
try
{
//Open the template
String tempTemplateFile = Path.GetTempFileName();
File.WriteAllBytes(tempTemplateFile, templateLocation);
Document frontPageTemplate = wordInterface.app.Documents.Open(tempTemplateFile);
//Copy document to main document.
wordInterface.copyDocumentToOtherDocument(frontPageTemplate, wordDocument, true);
wordDocument.Activate();
//Set template data.
wordInterface.searchAndReplace(wordDocument, "<CustomerName>", projectInfoRow["Customer"].ToString());
wordInterface.searchAndReplace(wordDocument, "<MachineNumber>", projectInfoRow["MachineNumber"].ToString());
wordInterface.searchAndReplace(wordDocument, "<OrderNumber>", projectInfoRow["OrderNumber"].ToString());
wordInterface.searchAndReplace(wordDocument, "<MachineType>", projectInfoRow["MachineType"].ToString());
wordInterface.searchAndReplace(wordDocument, "<CurrentDate>", ARA_Globals.ARa_Date);
//Remove template from memory.
if (frontPageTemplate != null)
{
((_Document)frontPageTemplate).Close(ref paramFalse, ref missing,
ref missing);
File.Delete(tempTemplateFile);
frontPageTemplate = null;
}
}
catch (Exception ex)
{
throw;
}
finally
{
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}
}
}
private void generateRiskPages(byte[] templateLocation, WordInterface wordInterface, Document wordDocument, DataView riskDataRows, DataRow projectInfoRow)
{
lock (this.threadLock)
{
int currentRisk = 0;
try
{
//Open template document.
String tempTemplateFile = Path.GetTempFileName();
File.WriteAllBytes(tempTemplateFile, templateLocation);
Document riskTemplate = wordInterface.app.Documents.Open(tempTemplateFile);
PLCalculator plCalculator = new PLCalculator();
foreach (DataRowView riskDataRow in riskDataRows)
{
//Set generating process
backgroundWorker1.ReportProgress(
33 + (Int32)((float)currentRisk / (float)riskDataRows.Count * 33),
(object)string.Format("Generating page {0} of {1}.", currentRisk + 1, riskDataRows.Count)
);
currentRisk++;
//Get the risk data id and set some variables.
int riskDataID = riskDataRow["ProjectRiskDataID"] != DBNull.Value ? (Int32)riskDataRow["ProjectRiskDataID"] : (Int32)riskDataRow["DefaultRiskDataID"];
Color[] riskEstimationColors = { ARA_Colors.ARA_Green, ARA_Colors.ARA_Orange, ARA_Colors.ARA_Red };
//Get some more info about the risk.
DataRow riskData = this.tbl_Risk_DataTableAdapter.GetData().FindByRiskDataID(riskDataID);
DataView riskEstimationBeforeView = new DataView(this.get_RiskEstimation_In_RiskData_BeforeTableAdapter.GetData(riskDataID));
DataView riskEstimationAfterView = new DataView(this.get_RiskEstimation_In_RiskData_AfterTableAdapter.GetData(riskDataID));
DataView appliedRiskReductionMeasures = new DataView(this.get_RiskReduction_In_RiskDataTableAdapter.GetData(riskDataID));
DataView minimalAdditionMeasures = new DataView(this.get_MinimalAddition_In_RiskDataTableAdapter.GetData(riskDataID));
//Set some value's before copying document.
riskTemplate.Activate();
foreach (DataRow exposedPersonRow in this.get_ExposedPersons_In_RiskDataTableAdapter.GetData(riskDataID).Rows)
{
ContentControls personCheckbox = riskTemplate.SelectContentControlsByTitle(exposedPersonRow["PersonDescription"].ToString());
if (personCheckbox.Count > 0)
{
personCheckbox[(object)1].Checked = exposedPersonRow["InProject"].ToString() == "1";
}
}
//Copy template.
wordInterface.copyDocumentToOtherDocument(riskTemplate, wordDocument, true);
wordDocument.Activate();
//Sets the risk hazard specifications.
generateHazardIndentification(wordInterface, wordDocument, (Int32)riskData["DangerID"], (Int32)riskData["DangerSourceID"]);
//Search and replace headerinfo.
wordInterface.searchAndReplace(wordDocument, "<CustomerName>", projectInfoRow["Customer"].ToString());
wordInterface.searchAndReplace(wordDocument, "<MachineInfo>", string.Format("{0}/{1}", projectInfoRow["MachineNumber"].ToString(), projectInfoRow["OrderNumber"].ToString()));
wordInterface.searchAndReplace(wordDocument, "<RiskID>", riskDataRow["RiskID"].ToString());
wordInterface.searchAndReplace(wordDocument, "<BriefActionDescription>", riskDataRow["HazardSituation"].ToString(), ARA_Colors.ARA_Red);
//Search and replace riskdata.
wordInterface.searchAndReplace(wordDocument, "<RiskGroup>", string.Format("{0} - {1}", riskDataRow["GroupName"].ToString(), riskDataRow["TypeName"].ToString()));
wordInterface.searchAndReplace(wordDocument, "<ActionEvent>", riskData["HazardEvent"].ToString());
wordInterface.searchAndReplace(wordDocument, "<RiskReductionInfo>", riskData["RiskReductionInfo"].ToString());
wordInterface.searchAndReplace(wordDocument, "<MinimalAdditionInfo>", riskData["MinimalAdditionInfo"].ToString());
//Set the riskestimation fields.
ARA_EditRiskRiskEstimation temp = new ARA_EditRiskRiskEstimation();
temp.setControlData(riskEstimationBeforeView);
riskEstimationBeforeView.RowFilter = "InProject = '1'";
if (riskEstimationBeforeView.Count != 4)
{
throw new Exception("Cant generate report, because risk " + riskDataID.ToString() + " isn't correctly filled in.");
}
wordInterface.searchAndReplace(wordDocument, "<SEWeightB>", riskEstimationBeforeView[0]["ItemWeight"].ToString());
wordInterface.searchAndReplace(wordDocument, "<FRWeightB>", riskEstimationBeforeView[1]["ItemWeight"].ToString());
wordInterface.searchAndReplace(wordDocument, "<PRWeightB>", riskEstimationBeforeView[2]["ItemWeight"].ToString());
wordInterface.searchAndReplace(wordDocument, "<AVWeightB>", riskEstimationBeforeView[3]["ItemWeight"].ToString());
//Find riskReduction en minimalAddition tables and fill them.
Microsoft.Office.Interop.Word.Table appliedRiskReductionMeasuresTable = wordInterface.findTableWithTitle(wordDocument, "AppliedRiskReductionMeasures");
appliedRiskReductionMeasures.RowFilter = "InProject = '1'";
wordInterface.fillTableWithRiskReducingMeasures(wordDocument, appliedRiskReductionMeasuresTable, appliedRiskReductionMeasures, "MeasureSubGroup", "InProject");
appliedRiskReductionMeasuresTable.Title = "";
Microsoft.Office.Interop.Word.Table minimalAdditionMeasuresTable = wordInterface.findTableWithTitle(wordDocument, "MinimalAdditionMeasures");
minimalAdditionMeasures.RowFilter = "InProject = '1'";
wordInterface.fillTableWithRiskReducingMeasures(wordDocument, minimalAdditionMeasuresTable, minimalAdditionMeasures, "MeasureSubGroup", "InProject");
minimalAdditionMeasuresTable.Title = "";
//Calculated PL.
wordInterface.searchAndReplace(wordDocument, "<SEWeightPL>", plCalculator.plSeverityText((Int32)riskEstimationBeforeView[0]["ItemWeight"]));
wordInterface.searchAndReplace(wordDocument, "<FRWeightPL>", plCalculator.plFrequencyText((Int32)riskEstimationBeforeView[2]["ItemWeight"]));
wordInterface.searchAndReplace(wordDocument, "<AVWeightPL>", plCalculator.plPossabilityOfAvoidingText((Int32)riskEstimationBeforeView[3]["ItemWeight"]));
char PLr = plCalculator.calculatePerformanceLevel((Int32)riskEstimationBeforeView[0]["ItemWeight"], (Int32)riskEstimationBeforeView[2]["ItemWeight"], (Int32)riskEstimationBeforeView[3]["ItemWeight"]);
wordInterface.searchAndReplace(wordDocument, "<PerformanceLevel>", PLr.ToString());
//Clear some memory.
temp.Dispose();
temp = null;
}
//Do we need to cancel execution?
if (backgroundWorker1.CancellationPending)
{
return;
}
//Remove template from memory.
if (riskTemplate != null)
{
((_Document)riskTemplate).Close(ref paramFalse, ref missing,
ref missing);
File.Delete(tempTemplateFile);
riskTemplate = null;
//Remove plCalculator from memory
plCalculator = null;
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ARA_Constants.messageBoxSomethingWrongWhileGenerating + ex.Message, ARA_Constants.messageBoxSomethingWrongWhileGeneratingHeader, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}