public static void Delete(int OrderID)

        {
            OrdersDetails result = GetAllRecords().Where(o => o.OrderID == OrderID).FirstOrDefault();

            GetAllRecords().Remove(result);
        }
        public static void Update(OrdersDetails order)

        {
            OrdersDetails result = GetAllRecords().Where(o => o.OrderID == order.OrderID).FirstOrDefault();

            if (result != null)

            {
                result.OrderID = order.OrderID;

                result.OrderDate = order.OrderDate;

                result.CustomerID = order.CustomerID;

                result.EmployeeID = order.EmployeeID;

                result.Freight = order.Freight;

                result.ShipAddress = order.ShipAddress;

                result.ShipCity = order.ShipCity;

                result.ShipName = order.ShipName;

                result.ShipCountry = order.ShipCountry;

                result.Verified = order.Verified;
            }
        }
        public static void Add(OrdersDetails order)

        {
            int?id = GetAllRecords().Max(o => o.OrderID);

            order.OrderID = id + 1;

            GetAllRecords().Insert(0, order);
        }