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); }