public List <OrderHistory> GetOrderHistoriesByDate(DateTime date) { DBConnection connection = new DBConnection(); connection.Connect(); connection.SetCommand(OrderHistorySQLMapper.GetOrderHistoryByDate(date.ToString("yyyy-MM-dd"))); MySqlDataReader reader = connection.ExecuteQuery(); List <OrderHistory> orderHistories = new List <OrderHistory>(); while (reader.Read()) { OrderHistory orderHistory = OrderHistory.Map(reader); orderHistories.Add(orderHistory); } connection.CloseConnection(); return(orderHistories); }
public List <OrderHistory> GetOrderHistories() { DBConnection connection = new DBConnection(); connection.Connect(); connection.SetCommand(OrderHistorySQLMapper.GetOrderHistoriesSQL); MySqlDataReader reader = connection.ExecuteQuery(); List <OrderHistory> orderHistories = new List <OrderHistory>(); while (reader.Read()) { OrderHistory orderHistory = OrderHistory.Map(reader); orderHistories.Add(orderHistory); } connection.CloseConnection(); return(orderHistories); }