|
using System;
using System.Data;
using System.Configuration;
using ASPNET.StarterKit.Reports.DataAccessLayer;
using System.Collections;
namespace ASPNET.StarterKit.Reports.Components
{
//*********************************************************************
//
// VisualReport Class
//
// The VisualReport class is used to represent a data item for Visual
// Report.
//
//*********************************************************************
public class VisualReport
{
private string _categoryName;
private decimal _sales;
public string CategoryName
{
get { return _categoryName; }
set { _categoryName = value; }
}
public decimal Sales
{
get { return _sales; }
set { _sales = value; }
}
//*********************************************************************
//
// GetCategorySales method retrieves the total of all category sales
// from the database and transforms the result to a VisualReportCollection
// custom colletion before returning it to the calling function
//
//*********************************************************************
public static VisualReportCollection GetCategorySales()
{
DataSet dsData = DatabaseHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetCategorySales");
VisualReportCollection items = new VisualReportCollection();
foreach(DataRow row in dsData.Tables[0].Rows)
{
VisualReport item = new VisualReport();
item.CategoryName = row["CategoryName"].ToString();
item.Sales = Convert.ToDecimal(row["Sales"]);
items.Add(item);
}
return items;
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.