/***** 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;
}