public void CreateOrderHistory(int orderId, OrderHistory orderHistory)
{
DBConnection connection = new DBConnection();
connection.Connect();
connection.SetCommand(OrderHistorySQLMapper.InsertOrderHistorySQL(orderId, orderHistory));
connection.Execute();
connection.CloseConnection();
}
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);
}
