private void btnModeofPaymentReportExport_Click(object sender, RoutedEventArgs e) { try { if (!DateValidated(dpFromDatePayment, dpToDatePayment)) { var messageBoxResult = WpfMessageBox.Show(StatusMessages.AppTitle, "Please select FROM DATE grater than or equal to TO DATE", MessageBoxButton.OK, EnumUtility.MessageBoxImage.Warning); return; } CommonMethods commonMethods = new CommonMethods(); string path = string.Empty, firstLine = string.Empty; CustomerOrderViewModel customerOrderViewModel = new CustomerOrderViewModel(); List <ModeofPaymentReportModel> modeofPaymentReportModel = new List <ModeofPaymentReportModel>(); modeofPaymentReportModel = customerOrderViewModel.GetModOfPaymentReport(dpFromDatePayment.SelectedDate.Value.ToString(CommonMethods.DateFormat), dpToDatePayment.SelectedDate.Value.ToString(CommonMethods.DateFormat)); string fileName = "ModeOfPaymentReport_" + DateTime.Now.ToString("MM-dd-yyyy_HHmmss"); var saveFileDialog = new SaveFileDialog { FileName = fileName != "" ? fileName : "gpmfca-exportedDocument", DefaultExt = ".xlsx", Filter = "Common Seprated Documents (.xlsx)|*.xlsx" }; if (saveFileDialog.ShowDialog() == true) { path = saveFileDialog.FileName; firstLine = LoginDetail.ClientName; DataTable dtData = new DataTable(); DataTable dtDataResult = new DataTable(); dtData = commonMethods.ConvertToDataTable(modeofPaymentReportModel); //X axis column: PaymentMethodName //Y axis column: BillDate //Z axis column: BillAmount //Null value: "-"; //Sum of values: true dtDataResult = commonMethods.GetInversedDataTable(dtData, "PaymentMethodName", "BillDate", "BillAmount", " ", true); commonMethods.WriteExcelModeOfPaymentFile(dtDataResult, path, firstLine); } } catch (Exception ex) { SystemError.Register(ex); } }
public void ReportLoad(string reportName) { _reportName = reportName; if (reportName == "ModeOfPayment") { modeofPaymentReportModel = customerOrderViewModel.GetModOfPaymentReport(ReportDetail.ReportFromDate, ReportDetail.ReportToDate); dtData = commonMethods.ConvertToDataTable(modeofPaymentReportModel); dtDataResult = commonMethods.GetInversedDataTable(dtData, "PaymentMethodName", "BillDate", "BillAmount", " ", true); reportTitle = "Mode Of Payment Report"; } //common call DataTable mockDataTable = wPFPrintHelper.CreateMockDataTableForTest(); wPFPrintHelper.CreateAndVisualizeDataTable(flowDocument, dtDataResult, reportTitle, reportFooter, null); }