public void Update(OrderUpdatingData updatingData)
{
Order order = this.GetById(updatingData.OrderId);
order.Status = updatingData.Status;
order.Items = updatingData.Items.Select(x => x.ToOrderItem()).ToList();
}
public void Update(OrderUpdatingData order)
{
var database = MongoDbHelper.GetDatabase();
var filter = Builders <Order> .Filter.Where(x => x.Id == order.OrderId);
var update = Builders <Order> .Update
.Set(x => x.Status, order.Status)
.Set(x => x.Items, order.Items.Select(x => ToOrderItem(x)).ToList());
GetOrdersSet().UpdateOne(filter, update);
}
public void Update(OrderUpdatingData order)
{
using (IDbConnection db = new SqlConnection(MsSqlHelper.GetConnectionString()))
{
string updateOrderQuery = @"UPDATE [dbo].[Orders] SET [Status] = @Status WHERE [Id] = @OrderId";
db.Execute(updateOrderQuery, new
{
Status = order.Status,
OrderId = order.OrderId
});
string deleteItemsQuery = "DELETE FROM [dbo].[OrderItems] WHERE [OrderId] = @OrderId";
db.Execute(deleteItemsQuery, new
{
OrderId = order.OrderId
});
InsertOrderItems(db, order.Items, order.OrderId);
}
}
