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