private void PrintPreview(bool IsPrint)
{
string strDateFrom = this.dtpFrom.Value.ToString("dd/MM/yyyy");;
string strDateTo = this.dtpTo.Value.ToString("dd/MM/yyyy");;
string sql = "";
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", "Purchase Statement Report");
ht.Add("paramDateFrom", strDateFrom);
ht.Add("paramDateTo", strDateTo);
sql = "[dbo].[USP_RptPurchaseStatement] '" + strDateFrom.Trim() + "','" + strDateTo.Trim() + "'";
rptPurchaseStatement irptPurchaseStatement = new rptPurchaseStatement();
iReportUtility.PrintPreview(irptPurchaseStatement, sql, ht, IsPrint);
}
private void PrintPreview(bool IsPrint)
{
string supplier_id = "";
string manufacturer_id = "";
string param_Supplier = "";
string param_Manufacturer = "";
if (cmb_supplier.EditValue == null || cmb_supplier.EditValue.ToString() == "")
{
supplier_id = "0";
param_Supplier = "Supplier : All";
}
else
{
supplier_id = cmb_supplier.EditValue.ToString();
param_Supplier = "Supplier : " + cmb_supplier.Text;
}
if (cmb_manufacturer.EditValue == null || cmb_manufacturer.EditValue.ToString() == "")
{
manufacturer_id = "0";
param_Manufacturer = "Manufacturer : All";
}
else
{
manufacturer_id = cmb_manufacturer.EditValue.ToString();
param_Manufacturer = "Manufacturer : " + cmb_manufacturer.Text;
}
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", "Purchase Statement Report");
ht.Add("paramDateFrom", strDateFrom);
ht.Add("paramDateTo", strDateTo);
sql = "[dbo].[USP_RptPurchaseStatement] '" + strDateFrom.Trim() + "','" + strDateTo.Trim() + "','" + ReportType + "','" + supplier_id + "','" + manufacturer_id + "'";
if (rptDetails.Checked == true)
{
ht.Add("supplier", param_Supplier);
ht.Add("manufacturer", param_Manufacturer);
rptPurchaseStatement irptPurchaseStatement = new rptPurchaseStatement();
iReportUtility.PrintPreview(irptPurchaseStatement, sql, ht, IsPrint);
}
else
{
rptPurchaseStatementSummary irptPurchaseStatementSummary = new rptPurchaseStatementSummary();
iReportUtility.PrintPreview(irptPurchaseStatementSummary, sql, ht, IsPrint);
}
}
