public EmployeesService()
{
string sqlconn = ConfigurationManager.ConnectionStrings["MachineProjectConnStr"].ConnectionString;
conn = new MySqlConnection(sqlconn);
conn.Open();
dac = new EmployeesDAC(conn);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
EmployeesDAC employeescomponent = new EmployeesDAC();
return(employeescomponent.UpdateDataset(dataset));
}
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 void Delete(int Original_EmployeeId)
{
EmployeesDAC employeesComponent = new EmployeesDAC();
employeesComponent.DeleteEmployees(Original_EmployeeId);
}
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));
}