public void Execute() { if (viewModel.StartDate > viewModel.EndDate) { notify.ShowNotify(Program.LanguageManager.GetString(StringResources.Message_FailureReportDate), Program.LanguageManager.GetString(StringResources.Message_FailureReportDateHeader)); } try { if (viewModel.SelectedReportType == MillReportType.ByProducing) { data = repo.GetPipes(viewModel.StartDate, viewModel.EndDate); AdditionToTheReport report = new AdditionToTheReport(); BindingList <double> counts = repo.CountPipe(viewModel.StartDate, viewModel.EndDate); report.PipesCount = counts[0]; report.PipesLength = counts[1]; report.PipesWeight = counts[2]; report.DataSource = data; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.General) { data = repo.CountWeldInf(viewModel.StartDate, viewModel.EndDate); GeneralInformationXtraReport report = new GeneralInformationXtraReport(); report.DataSource = data; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.ByShipped) { LoadingXtraReport report = new LoadingXtraReport(); report.DataSource = repo.GetReleaseNotes(viewModel.StartDate, viewModel.EndDate); SubReportShippingRailCar report2 = new SubReportShippingRailCar(); report.RequestParameters = false; report.xrSubreport1.ReportSource = report2; report.CreateDocument(); viewModel.PreviewSource = report; } else { data = repo.GetPipesByStatus(viewModel.StartDate, viewModel.EndDate, viewModel.SearchIds, viewModel.SelectedReportType, viewModel.SearchStatuses, true); MillReportsXtraReport report = new MillReportsXtraReport(); report.DataSource = data; report.CreateDocument(); viewModel.PreviewSource = report; } } catch (RepositoryException ex) { log.Error(string.Concat(ex.InnerException.Message, ex.Message)); notify.ShowFailure(ex.InnerException.Message, ex.Message); } }
public void Execute() { if (Prizm.Main.Common.DateExtension.CheckDiapason(viewModel.StartDate, viewModel.EndDate)) { try { if (viewModel.SelectedReportType == MillReportType.ByProducing) { data = repo.GetPipes(viewModel.StartDate, viewModel.EndDate); AdditionToTheReport report = new AdditionToTheReport(); BindingList<decimal> counts = repo.CountPipe(viewModel.StartDate, viewModel.EndDate); report.PipesCount = counts[0]; report.PipesLength = counts[1]; report.PipesWeight = counts[2]; SetDataSortByColumn("number"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.General) { data = repo.CountWeldInf(viewModel.StartDate, viewModel.EndDate); GeneralInformationXtraReport report = new GeneralInformationXtraReport(); SetDataSortByColumn("productionDate"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.ByShipped) { data = repo.GetReleaseNotes(viewModel.StartDate, viewModel.EndDate); LoadingXtraReport report = new LoadingXtraReport(); SetDataSortByColumn("releaseNote"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else { data = repo.GetPipesByStatus(viewModel.StartDate, viewModel.EndDate, viewModel.SearchIds, viewModel.SelectedReportType, viewModel.SearchStatuses, true); MillReportsXtraReport report = new MillReportsXtraReport(); SetDataSortByColumn("number"); data.TranslateStatus<PipeMillStatus>(SQLProvider.TableNameForMillReport, SQLProvider.ColumnNameForMillReport, viewModel.localizedPipeStatus); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } } catch (RepositoryException ex) { log.Error(string.Concat(ex.InnerException.Message, ex.Message)); notify.ShowFailure(ex.InnerException.Message, ex.Message); } } else { notify.ShowInfo(Program.LanguageManager.GetString(StringResources.Message_FailureReportDate), Program.LanguageManager.GetString(StringResources.Message_FailureReportDateHeader)); log.Warn("Date limits not valid!" + "Diapason: start date= " + viewModel.StartDate.ToString() + " end date= " + viewModel.EndDate.ToString()); } }
public void Execute() { if (Prizm.Main.Common.DateExtension.CheckDiapason(viewModel.StartDate, viewModel.EndDate)) { try { if (viewModel.SelectedReportType == MillReportType.ByProducing) { data = repo.GetPipes(viewModel.StartDate, viewModel.EndDate); AdditionToTheReport report = new AdditionToTheReport(); BindingList <decimal> counts = repo.CountPipe(viewModel.StartDate, viewModel.EndDate); report.PipesCount = counts[0]; report.PipesLength = counts[1]; report.PipesWeight = counts[2]; SetDataSortByColumn("number"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.General) { data = repo.CountWeldInf(viewModel.StartDate, viewModel.EndDate); GeneralInformationXtraReport report = new GeneralInformationXtraReport(); SetDataSortByColumn("productionDate"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else if (viewModel.SelectedReportType == MillReportType.ByShipped) { data = repo.GetReleaseNotes(viewModel.StartDate, viewModel.EndDate); LoadingXtraReport report = new LoadingXtraReport(); SetDataSortByColumn("releaseNote"); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } else { data = repo.GetPipesByStatus(viewModel.StartDate, viewModel.EndDate, viewModel.SearchIds, viewModel.SelectedReportType, viewModel.SearchStatuses, true); MillReportsXtraReport report = new MillReportsXtraReport(); SetDataSortByColumn("number"); data.TranslateStatus <PipeMillStatus>(SQLProvider.TableNameForMillReport, SQLProvider.ColumnNameForMillReport, viewModel.localizedPipeStatus); report.DataSource = data; report.FootersVisibility = viewModel.IsFooterVisible; report.CreateDocument(); viewModel.PreviewSource = report; } } catch (RepositoryException ex) { log.Error(string.Concat(ex.InnerException.Message, ex.Message)); notify.ShowFailure(ex.InnerException.Message, ex.Message); } } else { notify.ShowInfo(Program.LanguageManager.GetString(StringResources.Message_FailureReportDate), Program.LanguageManager.GetString(StringResources.Message_FailureReportDateHeader)); log.Warn("Date limits not valid!" + "Diapason: start date= " + viewModel.StartDate.ToString() + " end date= " + viewModel.EndDate.ToString()); } }