/// <summary>
/// Binds the report.
/// </summary>
private void BindReport()
{
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = String.Format("SELECT E.[Name], I.* from [Inventory] I INNER JOIN [CatalogEntry] E ON E.Code = I.SkuId INNER JOIN Catalog C ON C.CatalogId = E.CatalogId WHERE (I.InstockQuantity - I.ReservedQuantity) < 20 AND I.InventoryStatus <> 0 AND C.ApplicationId = '{0}';", OrderConfiguration.Instance.ApplicationId);
cmd.CommandType = CommandType.Text;
cmd.Parameters = new DataParameters();
cmd.TableMapping = DataHelper.MapTables("EntryStock");
cmd.DataSet = new ProductDataSet();
DataResult results = DataService.LoadDataSet(cmd);
ReportDataSource source = new ReportDataSource();
source.Name = "EntryStock";
source.Value = ((ProductDataSet)results.DataSet).EntryStock;
MyReportViewer.LocalReport.DataSources.Add(source);
MyReportViewer.DataBind();
}
/// <summary>
/// Binds the report.
/// </summary>
private void BindReport()
{
DataCommand cmd = OrderDataHelper.CreateTranDataCommand();
cmd.CommandText = "[ecf_reporting_CustomerNumOrders]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters = new DataParameters();
cmd.Parameters.Add(new DataParameter("ApplicationId", CatalogConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier));
cmd.Parameters.Add(new DataParameter("interval", GroupBy.SelectedValue, DataParameterType.VarChar));
cmd.Parameters.Add(new DataParameter("startdate", StartDate.Value.ToUniversalTime(), DataParameterType.DateTime));
cmd.Parameters.Add(new DataParameter("enddate", EndDate.Value.ToUniversalTime(), DataParameterType.DateTime));
cmd.TableMapping = DataHelper.MapTables("CustomerNumOrdersReport");
cmd.DataSet = new CustomersDataSet();
DataResult results = DataService.LoadDataSet(cmd);
ReportDataSource source = new ReportDataSource();
source.Name = "CustomerNumOrdersReport";
source.Value = ((CustomersDataSet)results.DataSet).CustomerNumOrdersReport;
MyReportViewer.LocalReport.DataSources.Clear();
MyReportViewer.LocalReport.DataSources.Add(source);
MyReportViewer.DataBind();
}
