// get a DTO of customer depending on required "displayable" data public List <CustomerDTOTable> getCustomers() { using (var context = new hctDBEntities()) { List <Customer> cl = context.Customers.OrderBy(i => i.Id).ToList(); List <CustomerDTOTable> dl = new List <CustomerDTOTable>(); foreach (Customer c in cl) { Person p = context.People.Where(pp => pp.Customer_Id == c.Id).FirstOrDefault(); CustomerDTOTable cdt = new CustomerDTOTable(); cdt.CustomerID = c.custID; cdt.FirstName = p.fname; cdt.LastName = p.lname; cdt.JoinDate = c.joinDate.ToString(); cdt.Status = c.status; dl.Add(cdt); } return(dl); } }
// get a DTO of customer depending on required "displayable" data public List<CustomerDTOTable> getCustomers() { using (var context = new hctDBEntities()) { List<Customer> cl = context.Customers.OrderBy(i => i.Id).ToList(); List<CustomerDTOTable> dl = new List<CustomerDTOTable>(); foreach (Customer c in cl) { Person p = context.People.Where(pp => pp.Customer_Id == c.Id).FirstOrDefault(); CustomerDTOTable cdt = new CustomerDTOTable(); cdt.CustomerID = c.custID; cdt.FirstName = p.fname; cdt.LastName = p.lname; cdt.JoinDate = c.joinDate.ToString(); cdt.Status = c.status; dl.Add(cdt); } return dl; } }