private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmSalesInventory", "Preview"))
{
return;
}
try
{
DataTable _dtByDate = loPOSTransactionDetail.getSalesInventory(dtpFromDate.Value, dtpToDate.Value);
if (_dtByDate.Rows.Count > 0)
{
loSalesInventoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSalesInventoryRpt.Database.Tables[1].SetDataSource(_dtByDate);
loSalesInventoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSalesInventoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSalesInventoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSalesInventoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSalesInventoryRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loSalesInventoryRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loSalesInventoryRpt.SetParameterValue("Title", "Sales Inventory - By Date");
loSalesInventoryRpt.SetParameterValue("SubTitle", "Sales Inventory - By Date");
crvByDate.ReportSource = loSalesInventoryRpt;
}
DataTable _dtBy = loPOSTransactionDetail.getSalesInventoryBy(dtpFromDate.Value, dtpToDate.Value);
if (_dtBy.Rows.Count > 0)
{
loSalesInventoryByCustomerRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSalesInventoryByCustomerRpt.Database.Tables[1].SetDataSource(_dtBy);
loSalesInventoryByCustomerRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSalesInventoryByCustomerRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSalesInventoryByCustomerRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSalesInventoryByCustomerRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSalesInventoryByCustomerRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loSalesInventoryByCustomerRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loSalesInventoryByCustomerRpt.SetParameterValue("Title", "Sales Inventory - By Customer");
loSalesInventoryByCustomerRpt.SetParameterValue("SubTitle", "Sales Inventory - By Customer");
crvByCustomer.ReportSource = loSalesInventoryByCustomerRpt;
}
if (_dtBy.Rows.Count > 0)
{
loSalesInventoryByCategoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSalesInventoryByCategoryRpt.Database.Tables[1].SetDataSource(_dtBy);
loSalesInventoryByCategoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSalesInventoryByCategoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSalesInventoryByCategoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSalesInventoryByCategoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSalesInventoryByCategoryRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loSalesInventoryByCategoryRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loSalesInventoryByCategoryRpt.SetParameterValue("Title", "Sales Inventory - By Category");
loSalesInventoryByCategoryRpt.SetParameterValue("SubTitle", "Sales Inventory - By Category");
crvByCategory.ReportSource = loSalesInventoryByCategoryRpt;
}
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnRefresh_Click");
em.ShowDialog();
return;
}
}
public DataTable getSalesInventory(DateTime pStartDate, DateTime pEndDate)
{
return(loPOSTransactionDetail.getSalesInventory(pStartDate, pEndDate));
}
