|
using System;
using System.Data;
using System.Configuration;
using ASPNET.StarterKit.Reports.DataAccessLayer;
using System.Collections;
namespace ASPNET.StarterKit.Reports.Components
{
//*********************************************************************
//
// CrossTabReport Class
//
// The CrossTabReport class is used to represent a data item for CrossTab Report
// and is mainly used to retrieve data from the database.
//
//*********************************************************************
public class CrossTabReport
{
private decimal _eastern;
private int _monthOfSales;
private DateTime _orderDate;
private decimal _northern;
private int _quarter;
private decimal _sales;
private decimal _southern;
private decimal _western;
public decimal Eastern
{
get { return _eastern; }
set { _eastern = value; }
}
public int MonthOfSales
{
get { return _monthOfSales; }
set { _monthOfSales = value; }
}
public DateTime OrderDate
{
get { return _orderDate; }
set { _orderDate = value; }
}
public int Quarter
{
get { return _quarter; }
set { _quarter = value; }
}
public decimal Northern
{
get { return _northern; }
set { _northern = value; }
}
public decimal Sales
{
get { return _sales; }
set { _sales = value; }
}
public decimal Southern
{
get { return _southern; }
set { _southern = value; }
}
public decimal Western
{
get { return _western; }
set { _western = value; }
}
//*********************************************************************
//
// GetRegionSales method retrieves all the necessary monthly regional sales
// from the database and transforms the result to a CrossTabReportCollection
// custom collection before returning it to the calling function
//
//*********************************************************************
public static CrossTabReportCollection GetRegionSales(int quarter, int year)
{
DataSet dsData = DatabaseHelper.ExecuteDataset(
ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetSalesByRegion", year, quarter);
CrossTabReportCollection items = new CrossTabReportCollection();
foreach(DataRow row in dsData.Tables[0].Rows)
{
CrossTabReport item = new CrossTabReport();
item.MonthOfSales = Convert.ToInt32(row["MonthOfSales"]);
item.OrderDate = new DateTime(year, item.MonthOfSales, 1);
item.Eastern = Convert.ToDecimal(row["Eastern"]);
item.Western = Convert.ToDecimal(row["Western"]);
item.Northern = Convert.ToDecimal(row["Northern"]);
item.Southern = Convert.ToDecimal(row["Southern"]);
item.Sales = Convert.ToDecimal(row["TotalMonth"]);
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.