/// <summary>
/// Eric Walton
/// 2017/26/02
/// Retrieves a list of all commercial customers
/// If succesful returns list
/// If unsuccesful throws error
///
/// Update
/// Bobby Thorne
/// 5/7/2017
/// Adds an ApprovedByName to the CommercailCustomer
/// To fill the datagrid.
/// </summary>
/// <returns></returns>
public List <CommercialCustomer> RetrieveCommercialCustomers()
{
List <CommercialCustomer> commercialCustomers = null;
try
{
UserManager userManager = new UserManager();
EmployeeManager employeeManager = new EmployeeManager();
commercialCustomers = CustomerAccessor.RetrieveAllCommercialCustomers();
foreach (CommercialCustomer e in commercialCustomers)
{
e.name = userManager.RetrieveUser(e.UserId).LastName + ", " + userManager.RetrieveUser(e.UserId).FirstName;
if (e.ApprovedBy != null)
{
var approvalUser = userManager.RetrieveUser(e.ApprovedBy);
if (approvalUser.FirstName.Equals("") && approvalUser.LastName.Equals(""))
{
e.ApprovedByName = "";
}
else
{
e.ApprovedByName = approvalUser.LastName + ", " + approvalUser.FirstName;
}
}
}
}
catch (Exception)
{
throw;
}
return(commercialCustomers);
}
/// <summary>
/// Christian Lopez
/// Created 2017/03/03
///
/// Logic for returning a list of suppliers.
///
/// Update
/// Bobby Thorne
/// 5/10/2017
///
/// Added a foreach loop to fill an ApprovedByName
/// to be used in the supplier datagrid
/// </summary>
/// <returns></returns>
public List <Supplier> ListSuppliers()
{
List <Supplier> suppliers = null;
try
{
suppliers = SupplierAccessor.RetrieveSuppliers();
IEmployeeManager employeeManager = new EmployeeManager();
IUserManager userManager = new UserManager();
foreach (var supplier in suppliers)
{
if (supplier.ApprovedBy == null)
{
supplier.ApprovedByName = " ";
}
else
{
User user = userManager.RetrieveUser((int)employeeManager.RetrieveEmployee((int)supplier.ApprovedBy).UserId);
supplier.ApprovedByName = user.LastName + ", " + user.FirstName;
}
}
}
catch (SqlException ex)
{
throw new ApplicationException("There was a database error.", ex);
}
catch (Exception ex)
{
throw new ApplicationException("There was an unknown error.", ex);
}
return(suppliers);
}
/// <summary>
/// Daniel Brown
/// Created 02/08/2017
///
/// retrieve a list of all active employees
///
/// Update
/// Bobby Thorne
/// 5/7/2017
///
/// Foreach loop adds a first name, last name to the data object employee so
/// It can be used in the employee data grid in replace of the userId
/// </summary>
/// <returns>A list of Employee objects</returns>
public List <Employee> RetrieveEmployeeList()
{
UserManager userManager = new UserManager();
List <Employee> employees = null;
try
{
employees = EmployeeAccessor.RetrieveEmployeeList();
foreach (Employee e in employees)
{
e.EmployeeName = userManager.RetrieveUser(e.UserId).LastName + ", " + userManager.RetrieveUser(e.UserId).FirstName;
}
}
catch (Exception ex)
{
throw ex;
}
return(employees);
}
