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);
}
