public void GetPostAuditReport()
{
CommonDatabaseContext dataContext = CreateCommonDatabaseContext();
List <AuditReportsObject.PostAuditField> postAuditfields = new List <AuditReportsObject.PostAuditField>();
List <AuditReportsObject.PostAuditInventoryTotalsField> postAuditInventoryTotalsfields = new List <AuditReportsObject.PostAuditInventoryTotalsField>();
AuditReportsObject.PostAuditTempICNReconciliationField postAuditAdjustmentsfields = new AuditReportsObject.PostAuditTempICNReconciliationField();
AuditReportsProcedures.GetPostAuditReportFields(ref postAuditfields, ref postAuditInventoryTotalsfields, ref postAuditAdjustmentsfields, ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
AuditReportsObject ro = new AuditReportsObject();
ro.ReportNumber = 22;
ro.ReportStore = ADS.ActiveAudit.StoreName;
ro.ReportTitle = "Post Audit";
ro.StoreNumber = ADS.ActiveAudit.StoreNumber;
ro.InventoryAuditDate = DateTime.Today;
ro.ListPostAuditField = postAuditfields;
ro.ListPostAuditInventoryTotalsField = postAuditInventoryTotalsfields;
ro.PostAuditTempICNReconciliation = postAuditAdjustmentsfields;
ADS.ReportActiveAudit.DateCompleted = DateTime.Now;
ro.ActiveAudit = ADS.ReportActiveAudit;
ro.ReportTempFile = ReportDirectoryPath;
PostAuditReport rpt = new PostAuditReport();
rpt.ReportObject = ro;
rpt.CreateReport();
PrintAndStoreReport(ro, ro.ReportTitle);
}
public void GetTrakkerUploadReport(bool store, bool display)
{
CommonDatabaseContext dataContext = CreateCommonDatabaseContext();
List <AuditReportsObject.TrakkerUploadReportSinceLastInventory> fields = new List <AuditReportsObject.TrakkerUploadReportSinceLastInventory>();
AuditReportsProcedures.GetTrakkerUploadReportFields(ref fields, ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
AuditReportsObject ro = new AuditReportsObject();
ro.ReportNumber = 22;
ro.ReportStore = ADS.ActiveAudit.StoreName;
ro.ReportTitle = "Trakker Upload Report";
ro.StoreNumber = ADS.ActiveAudit.StoreNumber;
ro.InventoryAuditDate = DateTime.Today;
ro.ListTrakkerUploadReportField = fields;
ro.ActiveAudit = ADS.ActiveAudit;
ro.ReportTempFile = ReportDirectoryPath;
TrakkerUploadReport trpt = new TrakkerUploadReport();
trpt.ReportObject = ro;
trpt.CreateReport();
if (store)
{
PrintAndStoreReport(ro, ro.ReportTitle);
}
if (display)
{
AuditDesktopSession.ShowPDFFile(ro.ReportTempFileFullName, false);
}
}
private void btnPrintShortList_Click(object sender, EventArgs e)
{
var reportObject = new ReportObject(SecurityAccessor.Instance.EncryptConfig.ClientConfig.GlobalConfiguration.BaseLogPath);
DataSet outputDataSet;
//reportObject.ReportTempFile = "c:\\Program Files\\Audit\\logs\\";
reportObject.CreateTemporaryFullName("MissingItemsReport_");
string _storeName = ADS.ActiveAudit.StoreName;
reportObject.ReportStore = ADS.ActiveAudit.StoreNumber;
//reportObject.ReportParms.Add(DateTime.Now);
bool hasData = AuditReportsProcedures.GetMissingItemsData(ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, out outputDataSet);
if (hasData)
{
// Create Report
reportObject.ReportTitle = "Missing Items Short List";
reportObject.ReportStoreDesc = string.Format("{0} \n #{1}", _storeName, ADS.ActiveAudit.StoreNumber);
var MsgItemsReport = new MissingItemsReport("Missing Items Short List");
MsgItemsReport.reportObject = reportObject;
if (MsgItemsReport.CreateReport(outputDataSet.Tables[AuditReportsProcedures.MISSING_ITEMS]))
{
AuditDesktopSession.ShowPDFFile(System.IO.Path.GetFullPath(MsgItemsReport.reportObject.ReportTempFileFullName)
, false);
}
}
}
public void SetInventorySummaryCACCData()
{
CommonDatabaseContext dataContext = CreateCommonDatabaseContext();
List <AuditReportsObject.InventorySummaryChargeOffsField> fieldsCacc = new List <AuditReportsObject.InventorySummaryChargeOffsField>();
AuditReportsProcedures.GetInventorySummaryReportFieldsCACC(ref fieldsCacc, ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
ADS.InventorySummaryReportFieldsCACC = fieldsCacc;
}
private void updateStats(InventoryAuditVO audit, bool isNewAudit)
{
if (_CurrentlyInUpdateStatus)
{
// Prevent update stats from being called twice.
return;
}
try
{
if (AuditReportsProcedures.getAuditStatusSummary(audit.StoreNumber, audit.AuditId, isNewAudit, out dsAuditStatusSummary))
{
if (dsAuditStatusSummary.Tables.Contains("OUTPUT") && dsAuditStatusSummary.Tables["OUTPUT"].Rows.Count == 3)
{
lblItemsMissingQty.Text = dsAuditStatusSummary.Tables["OUTPUT"].Rows[0][1].ToString();
lblCaccItemsMissingQty.Text = dsAuditStatusSummary.Tables["OUTPUT"].Rows[2][1].ToString();
ItemsUnexpectedQty.Text = dsAuditStatusSummary.Tables["OUTPUT"].Rows[1][1].ToString();
}
// perhaps label20 ||
bool isCACCActual = InventoryAuditProcedures.setCaccTotals(audit, dsAuditStatusSummary.Tables[AuditReportsProcedures.PREAUDIT_CACC_SMRY].Rows, label20.Text != ACTUAL_CACC && isNewAudit);
if (isCACCActual)
{
label20.Text = ACTUAL_CACC;
}
lblCompactDiscsCost.Text = audit.CompactDiscSummary.Cost.ToString("c");
lblCompactDiscsQty.Text = audit.CompactDiscSummary.Quantity.ToString();
lblVideoTapesCost.Text = audit.VideoTapeSummary.Cost.ToString("c");
lblVideoTapesQty.Text = audit.VideoTapeSummary.Quantity.ToString();
lblStandardVideoGamesCost.Text = audit.StandardVideoGameSummary.Cost.ToString("c");
lblStandardVideoGamesQty.Text = audit.StandardVideoGameSummary.Quantity.ToString();
lblPremiumVideoGamesCost.Text = audit.PremiumVideoGameSummary.Cost.ToString("c");
lblPremiumVideoGamesQty.Text = audit.PremiumVideoGameSummary.Quantity.ToString();
lblDvdDiscsCost.Text = audit.DvdDiscSummary.Cost.ToString("c");
lblDvdDiscsQty.Text = audit.DvdDiscSummary.Quantity.ToString();
lblExpectedCaccCost.Text = audit.GetTotalCaccCost().ToString("c");
lblExpectedCaccQty.Text = audit.GetTotalCaccQty().ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace, "ERROR " + ex.Message);
}
}
public void GetInventorySummaryReport()
{
CommonDatabaseContext dataContext = CreateCommonDatabaseContext();
List <AuditReportsObject.InventorySummaryChargeOffsField> fields = new List <AuditReportsObject.InventorySummaryChargeOffsField>();
//List<AuditReportsObject.InventorySummaryChargeOffsField> fieldsCacc = new List<AuditReportsObject.InventorySummaryChargeOffsField>();
List <AuditReportsObject.InventorySummaryHistoryField> invHistoryfields = new List <AuditReportsObject.InventorySummaryHistoryField>();
StringBuilder employeesPresent = new StringBuilder();
StringBuilder termEmployees = new StringBuilder();
//AuditReportsProcedures.GetInventorySummaryReportFields(ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
AuditReportsProcedures.GetInventorySummaryReportFields(ref fields, ref invHistoryfields, ref employeesPresent, ref termEmployees, ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
//AuditReportsProcedures.GetInventorySummaryReportFieldsCACC(ref fieldsCacc, ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, dataContext);
List <AuditReportsObject.InventoryQuestion> listQuestions = new List <AuditReportsObject.InventoryQuestion>();
foreach (InventoryQuestion question in ADS.InventoryQuestionsWithResponses)
{
AuditReportsObject.InventoryQuestion roQuestion = new AuditReportsObject.InventoryQuestion()
{
Question = question.Question,
QuestionNumber = question.QuestionNumber,
Response = question.Response,
};
listQuestions.Add(roQuestion);
}
var newListQuestions = listQuestions.OrderBy(x => x.QuestionNumber);
AuditReportsObject ro = new AuditReportsObject();
ro.InventoryQuestionsAdditionalComments = ADS.InventoryQuestionsAdditionalComments;
ro.ReportNumber = 22;
ro.ReportStore = ADS.ActiveAudit.StoreName;
//ro.StoreNumber = ADS.ActiveAudit.StoreNumber;
ro.StoreNumber = ADS.ActiveAudit.StoreNumber;
ro.InventoryAuditDate = DateTime.Today;
ro.ListInventorySummaryChargeOffsField = fields;
ro.ListInventorySummaryChargeOffsFieldCACC = ADS.InventorySummaryReportFieldsCACC;
ro.ListInventorySummaryHistoryField = invHistoryfields;
ro.ListInventoryQuestions = newListQuestions.ToList();
ro.StringbuilderInvSummEmployeesPresent = employeesPresent;
ro.StringbuilderInvSummTermEmployees = termEmployees;
ro.ActiveAudit = ADS.ReportActiveAudit;
ro.ReportTempFile = ReportDirectoryPath;
InventorySummaryReport invRpt = new InventorySummaryReport();
invRpt.ReportObject = ro;
invRpt.CreateReport();
PrintAndStoreReport(ro, "Inventory Summary");
}
public void GetPreAuditReport(bool store, bool display)
{
var reportObject = new ReportObject();
DataSet outputDataSet;
reportObject.ReportTempFile = SecurityAccessor.Instance.EncryptConfig.ClientConfig.GlobalConfiguration.BaseLogPath;
//reportObject.ReportTempFileFullName = "PreAuditReport_" + DateTime.Now.Ticks + ".pdf";
reportObject.CreateTemporaryFullName("PreAuditReport_");
string _storeName = ADS.ActiveAudit.StoreName;
reportObject.ReportStore = ADS.ActiveAudit.StoreNumber;
//reportObject.ReportParms.Add(DateTime.Now);
bool hasData = (ADS.ActiveAudit.PreAuditData != null && ADS.ActiveAudit.PreAuditData.Tables.Count == 3);
if (hasData)
{
outputDataSet = ADS.ActiveAudit.PreAuditData;
}
else
{
AuditReportsProcedures.GetPreAuditData(ADS.ActiveAudit.StoreNumber, ADS.ActiveAudit.AuditId, out outputDataSet, ref _storeName);
}
if (hasData)
{
// Create Report
reportObject.ReportTitle = "Full Pre-Audit";
reportObject.ReportStoreDesc = string.Format("{0} \n #{1}", _storeName, ADS.ActiveAudit.StoreNumber);
var preReport = new PreAuditReport("Full Pre-Audit");
preReport.reportObject = reportObject;
if (preReport.CreateReport(outputDataSet))
{
//string fullPath = System.IO.Path.GetFullPath(preReport.reportObject.ReportTempFileFullName);
if (display)
{
AuditDesktopSession.ShowPDFFile(reportObject.ReportTempFileFullName, false);
}
}
if (store)
{
PrintAndStoreReport(reportObject, "Pre-Audit");
}
}
}
