public List<Employees> GetAll()
{
EmployeesDAC _employeesComponent = new EmployeesDAC();
IDataReader reader = _employeesComponent.GetAllEmployees().CreateDataReader();
List<Employees> _employeesList = new List<Employees>();
while(reader.Read())
{
if(_employeesList == null)
_employeesList = new List<Employees>();
Employees _employees = new Employees();
if(reader["EmployeeId"] != DBNull.Value)
_employees.EmployeeId = Convert.ToInt32(reader["EmployeeId"]);
if(reader["EmployeeNumber"] != DBNull.Value)
_employees.EmployeeNumber = Convert.ToString(reader["EmployeeNumber"]);
if(reader["DepartmentId"] != DBNull.Value)
_employees.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if(reader["DivisionId"] != DBNull.Value)
_employees.DivisionId = Convert.ToInt32(reader["DivisionId"]);
if(reader["FormalSiteUrl"] != DBNull.Value)
_employees.FormalSiteUrl = Convert.ToString(reader["FormalSiteUrl"]);
if(reader["NationalIdNumber"] != DBNull.Value)
_employees.NationalIdNumber = Convert.ToString(reader["NationalIdNumber"]);
if(reader["NationalIdType"] != DBNull.Value)
_employees.NationalIdType = Convert.ToString(reader["NationalIdType"]);
if(reader["ManagerId"] != DBNull.Value)
_employees.ManagerId = Convert.ToInt32(reader["ManagerId"]);
if(reader["BirthDate"] != DBNull.Value)
_employees.BirthDate = Convert.ToDateTime(reader["BirthDate"]);
if(reader["MaritalStatus"] != DBNull.Value)
_employees.MaritalStatus = Convert.ToString(reader["MaritalStatus"]);
if(reader["Gender"] != DBNull.Value)
_employees.Gender = Convert.ToString(reader["Gender"]);
if(reader["HireDate"] != DBNull.Value)
_employees.HireDate = Convert.ToDateTime(reader["HireDate"]);
if(reader["SalariedFlag"] != DBNull.Value)
_employees.SalariedFlag = Convert.ToBoolean(reader["SalariedFlag"]);
if(reader["VacationHours"] != DBNull.Value)
_employees.VacationHours = Convert.ToInt16(reader["VacationHours"]);
if(reader["SickLeaveHours"] != DBNull.Value)
_employees.SickLeaveHours = Convert.ToInt16(reader["SickLeaveHours"]);
if(reader["CurrentFlag"] != DBNull.Value)
_employees.CurrentFlag = Convert.ToBoolean(reader["CurrentFlag"]);
if(reader["RowGuid"] != DBNull.Value)
_employees.RowGuid = new Guid(reader["RowGuid"].ToString());
if(reader["ModifiedDate"] != DBNull.Value)
_employees.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if(reader["Position"] != DBNull.Value)
_employees.Position = Convert.ToString(reader["Position"]);
_employees.NewRecord = false;
_employeesList.Add(_employees);
} reader.Close();
return _employeesList;
}
public List<Employees> GetAllView(int LanguageID)
{
EmployeesDAC _employeesComponent = new EmployeesDAC();
IDataReader reader = _employeesComponent.GetAllEmployeesView("LanguageID = " + LanguageID).CreateDataReader();
List<Employees> _employeesList = new List<Employees>();
while (reader.Read())
{
if (_employeesList == null)
_employeesList = new List<Employees>();
Employees _employees = new Employees();
#region Employee Info
if (reader["EmployeeId"] != DBNull.Value)
_employees.EmployeeId = Convert.ToInt32(reader["EmployeeId"]);
if (reader["EmployeeNumber"] != DBNull.Value)
_employees.EmployeeNumber = Convert.ToString(reader["EmployeeNumber"]);
if (reader["DepartmentId"] != DBNull.Value)
_employees.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if (reader["DivisionId"] != DBNull.Value)
_employees.DivisionId = Convert.ToInt32(reader["DivisionId"]);
if (reader["FormalSiteUrl"] != DBNull.Value)
_employees.FormalSiteUrl = Convert.ToString(reader["FormalSiteUrl"]);
if (reader["NationalIdNumber"] != DBNull.Value)
_employees.NationalIdNumber = Convert.ToString(reader["NationalIdNumber"]);
if (reader["NationalIdType"] != DBNull.Value)
_employees.NationalIdType = Convert.ToString(reader["NationalIdType"]);
if (reader["ManagerId"] != DBNull.Value)
_employees.ManagerId = Convert.ToInt32(reader["ManagerId"]);
if (reader["BirthDate"] != DBNull.Value)
_employees.BirthDate = Convert.ToDateTime(reader["BirthDate"]);
if (reader["MaritalStatus"] != DBNull.Value)
_employees.MaritalStatus = Convert.ToString(reader["MaritalStatus"]);
if (reader["Gender"] != DBNull.Value)
_employees.Gender = Convert.ToString(reader["Gender"]);
if (reader["HireDate"] != DBNull.Value)
_employees.HireDate = Convert.ToDateTime(reader["HireDate"]);
if (reader["SalariedFlag"] != DBNull.Value)
_employees.SalariedFlag = Convert.ToBoolean(reader["SalariedFlag"]);
if (reader["VacationHours"] != DBNull.Value)
_employees.VacationHours = Convert.ToInt16(reader["VacationHours"]);
if (reader["SickLeaveHours"] != DBNull.Value)
_employees.SickLeaveHours = Convert.ToInt16(reader["SickLeaveHours"]);
if (reader["CurrentFlag"] != DBNull.Value)
_employees.CurrentFlag = Convert.ToBoolean(reader["CurrentFlag"]);
if (reader["EmployeeRowGuid"] != DBNull.Value)
_employees.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["EmployeeModifiedDate"] != DBNull.Value)
_employees.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["Position"] != DBNull.Value)
_employees.Position = Convert.ToString(reader["Position"]);
_employees.NewRecord = false;
#endregion
#region Person Info
BusinessLogicLayer.Entities.Persons.Person _person = new BusinessLogicLayer.Entities.Persons.Person();
#region Main Info
if (reader["EmployeeId"] != DBNull.Value)
_person.BusinessEntityId = Convert.ToInt32(reader["EmployeeId"]);
if (reader["NameStyle"] != DBNull.Value)
_person.NameStyle = Convert.ToBoolean(reader["NameStyle"]);
if (reader["EmailPromotion"] != DBNull.Value)
_person.EmailPromotion = Convert.ToInt32(reader["EmailPromotion"]);
if (reader["RowGuid"] != DBNull.Value)
_person.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_person.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["CreatedDate"] != DBNull.Value)
_person.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
if (reader["NationalityCode"] != DBNull.Value)
_person.NationalityCode = Convert.ToString(reader["NationalityCode"]);
if (reader["Gender"] != DBNull.Value)
_person.Gender = Convert.ToString(reader["Gender"]);
if (reader["DateofBirth"] != DBNull.Value)
_person.DateofBirth = Convert.ToDateTime(reader["DateofBirth"]);
if (reader["PersonImage"] != DBNull.Value)
_person.PersonImage = Convert.ToString(reader["PersonImage"]);
#endregion
#region Person Languages
BusinessLogicLayer.Entities.Persons.PersonLanguages _personLanguages = new BusinessLogicLayer.Entities.Persons.PersonLanguages();
if (reader["PersonLanguageId"] != DBNull.Value)
_personLanguages.PersonLanguageId = Convert.ToInt32(reader["PersonLanguageId"]);
if (reader["EmployeeId"] != DBNull.Value)
_personLanguages.PersonId = Convert.ToInt32(reader["EmployeeId"]);
if (reader["LanguageId"] != DBNull.Value)
_personLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["Title"] != DBNull.Value)
_personLanguages.Title = Convert.ToString(reader["Title"]);
if (reader["FirstName"] != DBNull.Value)
_personLanguages.FirstName = Convert.ToString(reader["FirstName"]);
if (reader["MiddleName"] != DBNull.Value)
_personLanguages.MiddleName = Convert.ToString(reader["MiddleName"]);
if (reader["LastName"] != DBNull.Value)
_personLanguages.LastName = Convert.ToString(reader["LastName"]);
if (reader["Suffix"] != DBNull.Value)
_personLanguages.Suffix = Convert.ToString(reader["Suffix"]);
if (reader["DisplayName"] != DBNull.Value)
_personLanguages.DisplayName = Convert.ToString(reader["DisplayName"]);
_person.PersonLanguages.Add(_personLanguages);
#endregion
#region Credentials
BusinessLogicLayer.Entities.Persons.Credential _credential = new BusinessLogicLayer.Entities.Persons.Credential();
if (reader["EmployeeId"] != DBNull.Value)
_credential.BusinessEntityId = Convert.ToInt32(reader["EmployeeId"]);
if (reader["Username"] != DBNull.Value)
_credential.Username = Convert.ToString(reader["Username"]);
if (reader["IsActivated"] != DBNull.Value)
_credential.IsActivated = Convert.ToBoolean(reader["IsActivated"]);
if (reader["IsActive"] != DBNull.Value)
_credential.IsActive = Convert.ToBoolean(reader["IsActive"]);
_person.Credentials = _credential;
#endregion
_employees.EmployeePerson = _person;
#endregion
#region Departments
Departments _departments = new Departments();
#region Department Info
if (reader["DepartmentId"] != DBNull.Value)
_departments.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if (reader["OrganizationId"] != DBNull.Value)
_departments.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if (reader["DepartmentName"] != DBNull.Value)
_departments.DepartmentName = Convert.ToString(reader["DepartmentName"]);
if (reader["DepartmentDescription"] != DBNull.Value)
_departments.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
#endregion
#region Organization
Organizations _organizations = new Organizations();
if (reader["OrganizationId"] != DBNull.Value)
_organizations.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if (reader["OrganizationName"] != DBNull.Value)
_organizations.OrganizationName = Convert.ToString(reader["OrganizationName"]);
if (reader["OrganizationDescription"] != DBNull.Value)
_organizations.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]);
_departments.Organization = _organizations;
#endregion
_employees.Department = _departments;
#endregion
#region Division
Divisions _divisions = new Divisions();
if (reader["DivisionId"] != DBNull.Value)
_divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]);
if (reader["DepartmentId"] != DBNull.Value)
_divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if (reader["DivisionName"] != DBNull.Value)
_divisions.DivisionName = Convert.ToString(reader["DivisionName"]);
if (reader["DivisionDescription"] != DBNull.Value)
_divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]);
_employees.Division = _divisions;
#endregion
_employeesList.Add(_employees);
} reader.Close();
return _employeesList;
}
public int UpdateDataset(System.Data.DataSet dataset)
{
EmployeesDAC employeescomponent = new EmployeesDAC();
return employeescomponent.UpdateDataset(dataset);
}
public bool Update( int EmployeeId, string EmployeeNumber, int DepartmentId, int DivisionId, string FormalSiteUrl, string NationalIdNumber, string NationalIdType, int ManagerId, DateTime BirthDate, string MaritalStatus, string Gender, DateTime HireDate, bool SalariedFlag, short VacationHours, short SickLeaveHours, bool CurrentFlag, Guid RowGuid, DateTime ModifiedDate, string Position, int Original_EmployeeId)
{
EmployeesDAC employeesComponent = new EmployeesDAC();
return employeesComponent.UpdateEmployees( EmployeeId, EmployeeNumber, DepartmentId, DivisionId, FormalSiteUrl, NationalIdNumber, NationalIdType, ManagerId, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, RowGuid, ModifiedDate, Position, Original_EmployeeId);
}
public bool Update(Employees employees ,int old_employeeId)
{
EmployeesDAC employeesComponent = new EmployeesDAC();
return employeesComponent.UpdateEmployees( employees.EmployeeId, employees.EmployeeNumber, employees.DepartmentId, employees.DivisionId, employees.FormalSiteUrl, employees.NationalIdNumber, employees.NationalIdType, employees.ManagerId, employees.BirthDate, employees.MaritalStatus, employees.Gender, employees.HireDate, employees.SalariedFlag, employees.VacationHours, employees.SickLeaveHours, employees.CurrentFlag, employees.RowGuid, employees.ModifiedDate, employees.Position, old_employeeId);
}
public void Delete(int Original_EmployeeId)
{
EmployeesDAC employeesComponent = new EmployeesDAC();
employeesComponent.DeleteEmployees(Original_EmployeeId);
}
