public static List <ORDERDETAILS> CustomerOrderDetails(int custid) { List <ORDERS> orders = ORDERSDAL.GetOrders(custid); List <ORDERDETAILS> orderdetails = ORDERDETAILSDAL.GetAll(); List <ORDERDETAILS> details = new List <ORDERDETAILS>(); foreach (ORDERS o in orders) { foreach (ORDERDETAILS detail in orderdetails) { if (o.ORDERNUM == detail.ORDERNUM) { details.Add(detail); } } } return(details); }
//special operations public static CUSTOMERS CustomerAllData(int id) { CUSTOMERS customer = null; try { customer = CUSTOMERSDAL.Get(id); customer.ADDRESS = CUSTOMERADDRESSDAL.GetAddress(id); customer.ORDERS = ORDERSDAL.GetOrders(id); } catch (NullReferenceException nex) { customer.ADDRESS = new List <CUSTOMERADDRESS>(); customer.ORDERS = new List <ORDERS>(); } catch (Exception ex) { throw ex; } return(customer); }
//crudoperations //1 get customer details using name public static List <ORDERS> GetOrders(int custID) => ORDERSDAL.GetOrders(custID);