protected static List <TopProducts> GetDTOListJSON <T>(ref SqlCommand command) where T : CommonBase
{
List <TopProducts> dtoList = new List <TopProducts>();
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
TopProducts item = new TopProducts()
{
IdProduct = (long)reader["idProduct"],
Name = reader["name"].ToString(),
Description = reader["description"].ToString(),
IdEntertainment = (long)reader["idEntertainment"],
Cantidad = (int)reader["cantidad"]
};
dtoList.Add(item);
}
reader.Close();
}
catch (SqlException oEx)
{
throw oEx;
}
finally
{
command.Connection.Close();
command.Connection.Dispose();
}
return(dtoList);
}
public void Initialize()
{
StaffList = new ObservableCollection <Staff>(Database.GetAllStaffs());
// Monthly Sales
ProductsSold = Database.GetAllProductsOnMonth(DateTime.Now);
ProductsSoldShown = new ObservableCollection <Item>(ProductsSold.Select(x => new Item(x)));
MonthlySalesDate = DateTime.Now;
var list = Enum.GetNames(typeof(ProductCategory));
FilterCollection = new ObservableCollection <string>(list);
// Product Sales
TopProducts = Database.GetTopProductsOnMonth(DateTime.Now);
for (int i = 0; i < TopProducts.Count; i++)
{
TopProducts[i].Brush = Mains.GetBrushFromList[i];
}
TotalTopSales = TopProducts.Sum(x => x.TotalSale);
DrawPieChart();
}
