public override void ExecutePrint(object obj)
{
GlobalClass.ReportName = "Goods Received Detail";
GlobalClass.ReportParams = string.Format("From Date : {0} To {1}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy"));
Report.PrintSettings.PrintPageMargin = new Thickness(30);
Report.PrintSettings.AllowColumnWidthFitToPrintPage = false;
Report.PrintSettings.PrintPageOrientation = PrintOrientation.Landscape;
Report.Print();
}
public override void ExecuteExport(object obj)
{
GlobalClass.ReportName = "Goods Received Detail";
GlobalClass.ReportParams = string.Format("From Date : {0} To {1}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy"));
wExportFormat ef = new wExportFormat(Report);
ef.ShowDialog();
}
private void LoadReport(object param)
{
string strSql = string.Empty;
try
{
if (ReportFlag == 0)
{
strSql = string.Format(@"SELECT SETTLEMENT_ID REPRINTNO, U.UserName PRINTED_BY, CS.TRNDATE BILL_DATE, CS.TRNTIME PRINTED_TIME, CS.AMOUNT, CS.CollectionAmount TAXABLE_AMOUNT, CS.AMOUNT - CS.CollectionAmount TAX_AMOUNT
FROM CashSettlement CS
JOIN TERMINALS T ON CS.TERMINAL_CODE = T.TERMINAL_CODE
JOIN USERS U ON U.UID = CS.SETTLED_UID WHERE CS.TRNDATE BETWEEN '{0}' AND '{1}'{2}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy"),
((SelectedUser > 0) ? " AND CS.SETTLED_UID = " + SelectedUser : string.Empty));
}
LoadColumns();
var data = GetDataTable(strSql);
if (data != null && data.Count() == 0)
{
MessageBox.Show("NoData");
}
else
{
ReportSource = new ObservableCollection <ReportModel>(data);
}
GlobalClass.SetUserActivityLog(GetReportName(), "View", string.Empty, string.Empty, string.Empty);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this.MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void ExecutePrint(object obj)
{
GlobalClass.ReportName = GetReportName();
GlobalClass.ReportParams = string.Format("From Date : {0} To {1}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy"));
Report.PrintSettings.PrintPageMargin = new Thickness(30);
Report.PrintSettings.AllowColumnWidthFitToPrintPage = false;
Report.Print();
}
private void ExecuteExport(object obj)
{
GlobalClass.ReportName = GetReportName();
GlobalClass.ReportParams = string.Format("From Date : {0} To {1}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy"));
wExportFormat ef = new wExportFormat(Report);
ef.ShowDialog();
}
private void LoadReport(object param)
{
string strSql = string.Empty;
try
{
//VOUCHER DISCOUNT REPORT - DETAILS
if (ReportFlag == 0)
{
strSql = string.Format(@"SELECT VSD.BillNo BILL_NO, CAST(CONVERT(VARCHAR(10),PV.ScannedTime, 101) AS DATETIME) BILL_DATE, RIGHT( CONVERT(VARCHAR, ScannedTime, 0),7) PRINTED_TIME, VSD.VoucherNo REF_NO, PV.VoucherName REMARKS, VSD.DiscountAmount DISCOUNT, PSV.BillTo CUSTOMER_NAME, U.UserName PRINTED_BY
FROM VoucherDiscountDetail VSD
JOIN ParkingVouchers PV ON VSD.VoucherNo = PV.VoucherNo --AND PV.FYID = VSD.FYID
LEFT JOIN ParkingSales PSV ON PV.BillNo = PSV.BillNo AND PSV.FYID = PV.FYID
JOIN USERS U ON U.UID = VSD.UID WHERE ScannedTime BETWEEN '{0}' AND '{1}'{2}", FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy") + " 23:59:59", (SelectedVoucher == 0)?string.Empty:" AND PV.VoucherId = " + SelectedVoucher);
}
//VOUCHER DISCOUNT REPORT - SUMMARY
else if (ReportFlag == 1)
{
strSql = string.Format(@"SELECT BILL_DATE, {0}, COUNT(*) REPRINTNO, SUM(DISCOUNT) DISCOUNT FROM
(
SELECT CAST(CONVERT(VARCHAR(10),PV.ScannedTime, 101) AS DATETIME) BILL_DATE, PV.VoucherName REMARKS, VSD.DiscountAmount DISCOUNT, PSV.BillTo CUSTOMER_NAME, U.UserName PRINTED_BY
FROM VoucherDiscountDetail VSD
JOIN ParkingVouchers PV ON VSD.VoucherNo = PV.VoucherNo -- AND PV.FYID = VSD.FYID
LEFT JOIN ParkingSales PSV ON PV.BillNo = PSV.BillNo AND PSV.FYID = PV.FYID
JOIN USERS U ON U.UID = VSD.UID WHERE ScannedTime BETWEEN '{1}' AND '{2}'{3}
) a GROUP BY BILL_DATE, {0} ORDER BY BILL_DATE", SummaryType, FDate.ToString("MM/dd/yyyy"), TDate.ToString("MM/dd/yyyy") + " 23:59:59", (SelectedVoucher == 0) ? string.Empty : " AND PV.VoucherId = " + SelectedVoucher);
}
LoadColumns();
var data = GetDataTable(strSql);
if (data != null && data.Count() == 0)
{
MessageBox.Show("NoData");
}
else
{
ReportSource = new ObservableCollection <ReportModel>(data);
}
GlobalClass.SetUserActivityLog(GetReportName(), "View", string.Empty, string.Empty, string.Empty);
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}