/// <summary>
/// Sets the hazard parameters in a word template.
/// </summary>
/// <param name="wordInterface"></param>
/// <param name="dangerID"></param>
/// <param name="dangerSourceID"></param>
protected void generateHazardIndentification(WordInterface wordInterface, Document wordDocument, int dangerID, int dangerSourceID)
{
//Get some data from the database.
DataRow dangerRow = this.tbl_DangerTableAdapter.GetData().FindByDangerID(dangerID);
DataRow dangerSourceRow = this.tbl_Danger_SourceTableAdapter.GetData().FindByDangerSourceID(dangerSourceID);
//Set values form newly added document.
wordInterface.searchAndReplace(wordDocument, "<Hazard>", dangerRow["DangerGroupName"].ToString());
wordInterface.searchAndReplace(wordDocument, "<HazardSource>", dangerSourceRow["DangerSourceName"].ToString());
if (dangerSourceRow["DangerResultID1"] != DBNull.Value)
{
DataRow dangerResult = this.tbl_Danger_ResultTableAdapter.GetData().FindByDangerResultID((Int32)dangerSourceRow["DangerResultID1"]);
wordInterface.searchAndReplace(wordDocument, "<HazardResult1>", string.Format("{0}", dangerResult["DangerResultName"].ToString()));
}
else
{
wordInterface.searchAndReplace(wordDocument, "<HazardResult1>", "");
}
if (dangerSourceRow["DangerResultID2"] != DBNull.Value)
{
DataRow dangerResult = this.tbl_Danger_ResultTableAdapter.GetData().FindByDangerResultID((Int32)dangerSourceRow["DangerResultID2"]);
wordInterface.searchAndReplace(wordDocument, "<HazardResult2>", string.Format("{0}", dangerResult["DangerResultName"].ToString()));
}
else
{
wordInterface.searchAndReplace(wordDocument, "<HazardResult2>", "");
}
}
private bool hasWord2013OrLater()
{
WordInterface word = new WordInterface();
float version = word.getWordVersion();
Console.WriteLine(version);
word.Quit();
return(version > 14.99);
}
/// <summary>
/// Sets the documents watermark based on the projectstate.
/// </summary>
/// <param name="wordInterface"></param>
/// <param name="wordDocument"></param>
/// <param name="projectState"></param>
protected void setWaterMark(WordInterface wordInterface, Document wordDocument, string projectState, string draftVersion = "")
{
//Set watermark text based on project state.
if (projectState == ARA_Constants.draft)
{
wordInterface.insertWatermarkText(wordDocument, "DRAFT-" + draftVersion);
}
else if (projectState == ARA_Constants.forReview)
{
wordInterface.insertWatermarkText(wordDocument, "REVIEW ");
}
else if (projectState == ARA_Constants.finalDraft)
{
wordInterface.insertWatermarkText(wordDocument, "FINAL DRAFT");
}
}
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();
}
}
}
protected override void generateReport(object sender, DoWorkEventArgs args)
{
GeneratePerformanceLevelReportEvent e = args as GeneratePerformanceLevelReportEvent;
if (e == null)
{
throw new Exception("No generate performance level report event args parsed");
}
Document wordDocument = null;
//Create a word interface so we can talk easilie to word.
WordInterface wordInterface = new WordInterface();
try
{
// Open a new document.
FileStream newDocument = File.Create((string)e.newDocumentLocation + ".docx");
newDocument.Close();
newDocument = null;
//Create our output document.
wordDocument = wordInterface.app.Documents.Open(e.newDocumentLocation + ".docx");
//Get some data out of the database.
DataRow projectInfoRow = tbl_Risk_AnalysisTableAdapter.GetData().FindByProjectID(e.projectID);
DataView riskDataRows = new DataView(this.get_Risks_With_PL_In_ProjectTableAdapter.GetData(e.projectID));
riskDataRows.Sort = ARA_Globals.RiskSortingOptions[e.sortingKey];
//Set generating process.
backgroundWorker1.ReportProgress(5, (object)"Generating front page.");
generateFrontPage(e.frontPageTemplateLocation, wordInterface, wordDocument, projectInfoRow);
backgroundWorker1.ReportProgress(15, (object)"Generating PL pages.");
generateRiskPages(e.riskPageTemplateLocation, wordInterface, wordDocument, riskDataRows, projectInfoRow);
backgroundWorker1.ReportProgress(68, (object)"Adding watermarks(if needed).");
setWaterMark(wordInterface, wordDocument, projectInfoRow["StateName"].ToString(), projectInfoRow["DraftVersion"].ToString());
backgroundWorker1.ReportProgress(70, (object)"Saving the document.");
wordInterface.saveDocument(wordDocument, (string)e.newDocumentLocation);
backgroundWorker1.ReportProgress(90, (object)"Converting document to pdf.");
wordInterface.saveDocumentAsPdf(wordDocument, (string)e.newDocumentLocation);
backgroundWorker1.ReportProgress(100, (object)"Done generating.");
//Do we need to cancel the backgroundworker?
if (backgroundWorker1.CancellationPending)
{
args.Cancel = true;
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ARA_Constants.messageBoxSomethingWrongWhileGenerating + ex.Message, ARA_Constants.messageBoxSomethingWrongWhileGeneratingHeader, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}
// Close and release the Document object.
if (wordDocument != null)
{
wordDocument.Close();
wordDocument = null;
}
//Clean the word interface.
wordInterface.Quit();
wordInterface = null;
}
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);
}
}
}
