public List <OrderInforDTO> GetListOrderPerYear(DateTime Year)
{
string query = "EXEC SP_TotalRevenuePerYear @Year = '" + Year + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
List <OrderInforDTO> OrderList = new List <OrderInforDTO>();
foreach (DataRow item in data.Rows)
{
OrderInforDTO order = new OrderInforDTO(item);
OrderList.Add(order);
}
return(OrderList);
}
public List <OrderInforDTO> GetListOrder()
{
string query = "EXEC SP_OrderInfor";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
List <OrderInforDTO> OrderList = new List <OrderInforDTO>();
foreach (DataRow item in data.Rows)
{
OrderInforDTO order = new OrderInforDTO(item);
OrderList.Add(order);
}
return(OrderList);
}
