private async Task <List <Orders> > ReadOneAsync(DbDataReader reader)
{
var ordersList = new List <Orders>();
var orderDetails = new List <OrdersDetail>();
var orders = new Orders(Db);
using (reader)
{
while (await reader.ReadAsync())
{
orders.Id = reader.GetInt32(0);
orders.Name = reader.GetString(1);
orders.Description = reader.GetString(2);
orders.Date = reader.GetDateTime(3);
orders.OrdersD = orderDetails;
var orderItems = new OrdersDetail()
{
IdOrder = reader.GetInt32(4),
IdItem = reader.GetInt32(5),
Quantity = reader.GetInt32(6),
Item = new Items()
{
Id = reader.GetInt32(7),
Name = reader.GetString(8),
Description = reader.GetString(9),
},
};
orders.OrdersD.Add(orderItems);
ordersList.Add(orders);
}
}
return(ordersList);
}
private void BindParamsOrdersDetails(MySqlCommand cmd, OrdersDetail item)
{
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@id_order",
DbType = DbType.Int32,
Value = Id,
});
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@id_item",
DbType = DbType.Int32,
Value = item.IdItem,
});
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@quantity",
DbType = DbType.Int32,
Value = item.Quantity,
});
}
