public MVCResult <Order_Details> GetOrderDetailByCustomerId(Customers customer)
            {
                MVCResult <Order_Details> result = new MVCResult <Order_Details>();

                result.PayLoad = new List <Order_Details>();
                try
                {
                    NorthWindEntities    entity          = new NorthWindEntities();
                    List <Order_Details> orderDetailList = entity.Order_Details.Where(x => x.Orders.CustomerID == customer.CustomerID).ToList();

                    result.PayLoad = orderDetailList;
                    result.SetSuccess(orderDetailList.Count(), SQLType.Select);
                    return(result);
                }
                catch (Exception ex)
                {
                    result.SetError(ex.Message);
                    return(result);
                }
            }
Beispiel #2
0
            public MVCResult <Orders> GetOrders(Orders Orders)
            {
                MVCResult <Orders> orders = CRUD <Orders> .Get(Orders);

                return(orders);
            }