// get list of DTO employees
public List <EmployeeDTOTable> getEmployees()
{
using (var context = new hctDBEntities())
{
List <Employee> cl = context.Employees.OrderBy(i => i.Id).ToList();
List <EmployeeDTOTable> dl = new List <EmployeeDTOTable>();
foreach (Employee c in cl)
{
EmployeeDTOTable cdt = new EmployeeDTOTable();
cdt.EmployeeID = c.empID;
cdt.FirstName = c.fname;
cdt.LastName = c.lname;
cdt.Status = c.status;
cdt.Email1 = c.email1;
cdt.HomePhone = c.homePhone;
cdt.MobilePhone = c.mobilePhone;
cdt.Rate = String.Format("{0:0.00}", c.rate);
;
dl.Add(cdt);
}
return(dl);
}
}
public List <QuoteDTOTable> getQuotes()
{
using (var context = new hctDBEntities())
{
List <Quote> q = context.Quotes.OrderBy(i => i.Id).ToList();
List <QuoteDTOTable> ql = new List <QuoteDTOTable>();
foreach (Quote i in q)
{
QuoteDTOTable cdt = new QuoteDTOTable();
cdt.QuoteCode = i.quoteCode;
cdt.Price = i.totalPrice.ToString();
cdt.Time = i.totalTime.ToString();
ql.Add(cdt);
}
return(ql);
}
}
public List<InvoiceDTOTable> getInvoices()
{
using (var context = new hctDBEntities())
{
List<Invoice> inv = context.Invoices.OrderBy(i => i.Id).ToList();
List<InvoiceDTOTable> il = new List<InvoiceDTOTable>();
foreach (Invoice i in inv)
{
InvoiceDTOTable cdt = new InvoiceDTOTable();
cdt.InvoiceID = i.InvoiceID;
cdt.DateCreated = i.dateCreated.ToString();
cdt.Name = i.name;
cdt.PaymentStatus = i.paymentStatus;
cdt.JobStatus = i.jobStatus;
il.Add(cdt);
}
return il;
}
}
public List <InvoiceDTOTable> getInvoices()
{
using (var context = new hctDBEntities())
{
List <Invoice> inv = context.Invoices.OrderBy(i => i.Id).ToList();
List <InvoiceDTOTable> il = new List <InvoiceDTOTable>();
foreach (Invoice i in inv)
{
InvoiceDTOTable cdt = new InvoiceDTOTable();
cdt.InvoiceID = i.InvoiceID;
cdt.DateCreated = i.dateCreated.ToString();
cdt.Name = i.name;
cdt.PaymentStatus = i.paymentStatus;
cdt.JobStatus = i.jobStatus;
il.Add(cdt);
}
return(il);
}
}
// 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);
}
}
public List<QuoteDTOTable> getQuotes()
{
using (var context = new hctDBEntities())
{
List<Quote> q = context.Quotes.OrderBy(i => i.Id).ToList();
List<QuoteDTOTable> ql = new List<QuoteDTOTable>();
foreach (Quote i in q)
{
QuoteDTOTable cdt = new QuoteDTOTable();
cdt.QuoteCode = i.quoteCode;
cdt.Price = i.totalPrice.ToString();
cdt.Time = i.totalTime.ToString();
ql.Add(cdt);
}
return ql;
}
}
// get list of DTO employees
public List<EmployeeDTOTable> getEmployees()
{
using (var context = new hctDBEntities())
{
List<Employee> cl = context.Employees.OrderBy(i => i.Id).ToList();
List<EmployeeDTOTable> dl = new List<EmployeeDTOTable>();
foreach (Employee c in cl)
{
EmployeeDTOTable cdt = new EmployeeDTOTable();
cdt.EmployeeID = c.empID;
cdt.FirstName = c.fname;
cdt.LastName = c.lname;
cdt.Status = c.status;
cdt.Email1 = c.email1;
cdt.HomePhone = c.homePhone;
cdt.MobilePhone = c.mobilePhone;
cdt.Rate = String.Format("{0:0.00}", c.rate);
;
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;
}
}
