private void PrintPreview(bool IsPrint)
{
string strDateFrom = bllUtility.FormatDate(dtpFrom);
string strDateTo = bllUtility.FormatDate(dtpTo);
string sql = "";
string ReportType = "";
if (rptDetails.Checked == true)
{
ReportType = "Details";
}
else
{
ReportType = "Summary";
}
Hashtable ht = new Hashtable();
ht.Add("paramCompany", bllUtility.LoggedInSystemInformation.CompanyName);
ht.Add("paramComAddress", bllUtility.LoggedInSystemInformation.CompanyAddress);
ht.Add("paramComContact", bllUtility.LoggedInSystemInformation.CompanyContactNo);
ht.Add("paramRptTitle", "Sales Statement");
ht.Add("paramDateFrom", strDateFrom);
ht.Add("paramDateTo", strDateTo);
sql = "[dbo].[USP_RptProductSalesStatement] '" + strDateFrom.Trim() + "','" + strDateTo.Trim() + "','" + ReportType + "'";
if (rptDetails.Checked == true)
{
rptSalesStatement irptSalesStatement = new rptSalesStatement();
iReportUtility.PrintPreview(irptSalesStatement, sql, ht, IsPrint);
}
else
{
rptSalesStatementSummary irptSalesStatementSummary = new rptSalesStatementSummary();
iReportUtility.PrintPreview(irptSalesStatementSummary, sql, ht, IsPrint);
}
}
private void PrintPreview(bool IsPrint)
{
string customer_id = "";
string product_id = "";
string isPivot = "0";
string param_customer = "Customer : All";
string strDateFrom = bllUtility.FormatDate(dtpFrom);
string strDateTo = bllUtility.FormatDate(dtpTo);
string sql = "";
string ReportType = "";
if (rptDetails.Checked == true)
{
ReportType = "Details";
}
else if (rptSummary.Checked == true)
{
ReportType = "Summary";
}
if (chk_pivot.Checked == true)
{
isPivot = "1";
}
//if (rptDetails.Checked == true)
//{
if (rptDetails.Checked == true && chk_all_product.Checked == false)
{
if (cmb_product.EditValue == null || cmb_product.EditValue.ToString() == "")
{
MessageBox.Show("Please select product code.");
return;
}
product_id = cmb_product.EditValue.ToString();
}
if (chk_all_customer.Checked == false)
{
if (cmb_customer.EditValue == null || cmb_customer.EditValue.ToString() == "")
{
MessageBox.Show("Please select Customer.");
return;
}
customer_id = cmb_customer.EditValue.ToString();
param_customer = "Customer : " + cmb_customer.Text;
}
//}
sql = "[dbo].[USP_RptProductSalesStatement] '" + strDateFrom.Trim() + "','" + strDateTo.Trim() + "','" + ReportType + "','" + customer_id + "','" + product_id + "','" + isPivot + "'";
if (chk_pivot.Checked == true)
{
DataTable dt = bllUtility.GetDataBySP(sql);
grd_details_report.Visible = false;
grd_summary_report.Visible = false;
if (rptSummary.Checked)
{
//summary
grd_summary_report.DataSource = dt;
grd_summary_report.Dock = DockStyle.Fill;
grd_summary_report.Visible = true;
}
else
{
//details
grd_details_report.DataSource = dt;
grd_details_report.Dock = DockStyle.Fill;
grd_details_report.Visible = true;
}
grp_report.Visible = true;
}
else
{
Hashtable ht = new Hashtable();
ht.Add("paramCompany", bllUtility.LoggedInSystemInformation.CompanyName);
ht.Add("paramComAddress", bllUtility.LoggedInSystemInformation.CompanyAddress);
ht.Add("paramComContact", bllUtility.LoggedInSystemInformation.CompanyContactNo);
ht.Add("paramRptTitle", "Sales Statement");
ht.Add("paramDateFrom", strDateFrom);
ht.Add("paramDateTo", strDateTo);
Cursor = Cursors.WaitCursor;
if (rptDetails.Checked == true)
{
ht.Add("manufacturer", param_customer);
rptSalesStatement irptSalesStatement = new rptSalesStatement();
iReportUtility.PrintPreview(irptSalesStatement, sql, ht, IsPrint);
}
else
{
rptSalesStatementSummary irptSalesStatementSummary = new rptSalesStatementSummary();
iReportUtility.PrintPreview(irptSalesStatementSummary, sql, ht, IsPrint);
}
Cursor = Cursors.Default;
}
}