public void BuildAuditReport(object sender, DoWorkEventArgs e)
{
/***********************************************************************************************************************
** Build the audit report excel file
***********************************************************************************************************************/
bool readOK = readEplexAuditFile();
if (readOK != true)
{
return;
}
(ParentForm.DataPath, ParentForm.DataPath2020, ParentForm.MUnitFolder, ParentForm.EplexAppPath) = ParentForm.GetRegistryInfo();
string[] dateParts = ParentForm.AuditDoor[0].AuditExtractTimestamp.Split();
// string auditExtractYYYY = AuditDoor[0].AuditExtractTimestamp.Substring(AuditDoor[0].AuditExtractTimestamp.Length - 4 - 1);
string auditExtractYYYY = dateParts[4];
string auditExtractMMMLit = dateParts[1];
string auditExtractDD = dateParts[2];
string auditExtractMM = Convert.ToDateTime(auditExtractMMMLit + " 01, 1900").Month.ToString("00");
string AuditDataPath = reportPath + @"Sites\" + SharedSiteData.site + @"\Lock Audit";
string auditFileName = auditExtractYYYY + "-" + auditExtractMM + "-" + auditExtractDD + " Audit Report.xlsx";
ParentForm.AuditDataPathAndFile = AuditDataPath + @"\" + auditFileName;
writeAuditFileToExcel(ParentForm.AuditDataPathAndFile);
}
