public int UpdateOrder(int orderID, OrdersModel order)
{
string query = @"UPDATE [CoroNacessitiesDB].dbo.Orders SET OrderID = @OrderID, UserID = @UserID, OrderStatusID = @OrderStatusID WHERE OrderID = @OrderID";
return(CoroNacessitiesDBContext.getConnection().Execute(query, new { OrderID = order.orderID, UserID = order.userID, OrderStatusID = order.orderStatusID }));
}
// Orders
public int AddOrder(OrdersModel order)
{
string query = @"INSERT INTO [CoroNacessitiesDB].dbo.Orders (UserID, OrderStatusID) VALUES (@UserID, @OrderStatusID); SELECT Orders.OrderID FROM [CoroNacessitiesDB].dbo.Orders WHERE Orders.UserID = @UserId AND Orders.OrderStatusID = @OrderStatusID SELECT SCOPE_IDENTITY()";
return(CoroNacessitiesDBContext.getConnection().Execute(query, new { UserID = order.userID, OrderStatusID = order.orderStatusID }));
}
