public SemesterSales[] GetSalesPrSemester()
{
using (AdomdConnection conn = new AdomdConnection("DataSource = localhost; Initial Catalog = FClubCube"))
{
conn.Open();
AdomdCommand cmd = conn.CreateCommand();
cmd.CommandText = @"
SELECT [Measures].[Fact Sale Count] ON COLUMNS,
NONEMPTY([Dim Member].[Semester].[Semester]*[Dim Product].[Sub Sub Category].[Sub Sub Category]) ON ROWS
FROM [F Club DW]";
AdomdDataReader dr = cmd.ExecuteReader();
List <SemesterSales> semesters = new List <SemesterSales>();
while (dr.Read())
{
SemesterSales semester = new SemesterSales
{
semester = dr[0].ToString(),
SubSubCategory = dr[1].ToString(),
saleCount = int.Parse(dr[2].ToString())
};
semesters.Add(semester);
}
dr.Close();
SemesterSales[] semesterSales = semesters.FindAll(FindBeer).ToArray();
conn.Close();
return(semesterSales);
}
}
private static bool FindBeer(SemesterSales ss)
{
if (ss.SubSubCategory == "Beer")
{
return(true);
}
else
{
return(false);
}
}
