public OnTheSpot.Models.Customer GetCustomerInfo(int WorkOrderNumber)
{
//Order order = dbStore.Orders.Where(o => o.OrderID == WorkOrderNumber).SingleOrDefault();
//if (order == null)
//{
// MessageBox("Work order {0} not found in database", WorkOrderNumber);
//}
//Customer cust = dbStore.Customers.Where(c => c.CustomerID == order.CustomerID).SingleOrDefault();
OnTheSpot.Models.Customer customer = null;
try
{
customer = (from o in dbStore.Orders
where o.OrderID == WorkOrderNumber
join cust in dbStore.Customers on o.CustomerID equals cust.CustomerID
select new OnTheSpot.Models.Customer()
{
FirstName = cust.FirstName, LastName = cust.LastName, Starch = cust.Starch
}).SingleOrDefault();
}
catch (Exception e)
{
}
return(customer);
}
public OnTheSpot.Models.Customer GetCustomer(int id)
{
OnTheSpot.Models.Customer cust1 = (from cust in dbStore.Customers
where cust.CustomerID == id
select new OnTheSpot.Models.Customer()
{
FirstName = cust.FirstName, LastName = cust.LastName, Starch = cust.Starch
}).SingleOrDefault();
//cannot do a join across databases
cust1.Note = db.CustomerNotes.Where(c => c.CustID == id).Select(c => c.note).SingleOrDefault();
return(cust1);
}