/***** Use EF to get the customer orders *****/ public CustomerOrders getCustomerOrdersEF(string custNo) { CustomerOrders customerOrders = new CustomerOrders(); OrderEntryDbContext db = new OrderEntryDbContext(); try { customerOrders.customer = db.customers.Find(custNo); var query = (from ot in db.orders where ot.CustNo == custNo select ot); customerOrders.orders = query.ToList(); // var quer2 = (from ot in db.orderLines where ot.OrdNo == select); // customerOrders.orderLines = quer2.ToList(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(customerOrders); }
/***** Use SQL to get the customer orders *****/ public CustomerOrders getCustomerOrdersSQL(string custNo) { CustomerOrders customerOrders = new CustomerOrders(); OrderEntryDbContext db = new OrderEntryDbContext(); List<SqlParameter> sqlParams = new List<SqlParameter>(); sqlParams.Add(new SqlParameter("@CustNo", custNo)); try { string sql = "SELECT * FROM Customer WHERE CustNo = @CustNo"; customerOrders.customer = db.customers.SqlQuery(sql, sqlParams.ToArray()).First(); sqlParams.Clear(); sqlParams.Add(new SqlParameter("@CustNo", custNo)); sql = "SELECT * FROM OrderTbl WHERE CustNo = @CustNo"; customerOrders.orders = db.orders.SqlQuery(sql, sqlParams.ToArray()).ToList(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return customerOrders; }