Mutation.cs

using System.Linq;
using GraphQLAdaptor.Models;

namespace GraphQLAdaptor.GraphQL
{
    public class OrdersDetailsInput
    {
        [GraphQLName("OrderID")]
        public int? OrderID { get; set; }
        [GraphQLName("CustomerID")]
        public string? CustomerID { get; set; }
        [GraphQLName("EmployeeID")]
        public int? EmployeeID { get; set; }
        [GraphQLName("Freight")]
        public double? Freight { get; set; }
    }

    public class Mutation
    {
        public OrdersDetails AddOrder(OrdersDetailsInput input)
        {
            var newOrder = new OrdersDetails
            {
                OrderID = input.OrderID,
                CustomerID = input.CustomerID,
                EmployeeID = input.EmployeeID,
                Freight = input.Freight
            };
            OrdersDetails.GetAllRecords().Insert(0, newOrder);
            return newOrder;
        }

        public OrdersDetails? UpdateOrder(int key, string? keyColumn, OrdersDetailsInput input)
        {
            // Find the order by the key (OrderID)
            var existing = OrdersDetails.GetAllRecords().FirstOrDefault(o => o.OrderID == key);
            if (existing == null) return null;

            // Update only the fields that are provided
            if (input.CustomerID != null)
                existing.CustomerID = input.CustomerID;
            if (input.EmployeeID.HasValue)
                existing.EmployeeID = input.EmployeeID;
            if (input.Freight != null)
                existing.Freight = input.Freight;

            return existing;
        }

        public bool DeleteOrder(int orderID)
        {
            var existing = OrdersDetails.GetAllRecords().FirstOrDefault(o => o.OrderID == orderID);
            if (existing == null) return false;
            OrdersDetails.GetAllRecords().Remove(existing);
            return true;
        }
    }
}