public List<EmployeeVacationPermit> GetAll()
{
EmployeeVacationPermitDAC _employeeVacationPermitComponent = new EmployeeVacationPermitDAC();
IDataReader reader = _employeeVacationPermitComponent.GetAllEmployeeVacationPermit().CreateDataReader();
List<EmployeeVacationPermit> _employeeVacationPermitList = new List<EmployeeVacationPermit>();
while(reader.Read())
{
if(_employeeVacationPermitList == null)
_employeeVacationPermitList = new List<EmployeeVacationPermit>();
EmployeeVacationPermit _employeeVacationPermit = new EmployeeVacationPermit();
if(reader["EmployeeVacationPermitID"] != DBNull.Value)
_employeeVacationPermit.EmployeeVacationPermitID = Convert.ToInt32(reader["EmployeeVacationPermitID"]);
if(reader["Name"] != DBNull.Value)
_employeeVacationPermit.Name = Convert.ToString(reader["Name"]);
if(reader["VacationTypeID"] != DBNull.Value)
_employeeVacationPermit.VacationTypeID = Convert.ToInt32(reader["VacationTypeID"]);
if(reader["PermitNumberinDays"] != DBNull.Value)
_employeeVacationPermit.PermitNumberinDays = Convert.ToInt32(reader["PermitNumberinDays"]);
if(reader["IsMonthly"] != DBNull.Value)
_employeeVacationPermit.IsMonthly = Convert.ToBoolean(reader["IsMonthly"]);
if(reader["IsYearly"] != DBNull.Value)
_employeeVacationPermit.IsYearly = Convert.ToBoolean(reader["IsYearly"]);
_employeeVacationPermit.NewRecord = false;
_employeeVacationPermitList.Add(_employeeVacationPermit);
} reader.Close();
return _employeeVacationPermitList;
}
public EmployeeVacationPermit GetByID(int _employeeVacationPermitID)
{
EmployeeVacationPermitDAC _employeeVacationPermitComponent = new EmployeeVacationPermitDAC();
IDataReader reader = _employeeVacationPermitComponent.GetByIDEmployeeVacationPermit(_employeeVacationPermitID);
EmployeeVacationPermit _employeeVacationPermit = null;
while(reader.Read())
{
_employeeVacationPermit = new EmployeeVacationPermit();
if(reader["EmployeeVacationPermitID"] != DBNull.Value)
_employeeVacationPermit.EmployeeVacationPermitID = Convert.ToInt32(reader["EmployeeVacationPermitID"]);
if(reader["Name"] != DBNull.Value)
_employeeVacationPermit.Name = Convert.ToString(reader["Name"]);
if(reader["VacationTypeID"] != DBNull.Value)
_employeeVacationPermit.VacationTypeID = Convert.ToInt32(reader["VacationTypeID"]);
if(reader["PermitNumberinDays"] != DBNull.Value)
_employeeVacationPermit.PermitNumberinDays = Convert.ToInt32(reader["PermitNumberinDays"]);
if(reader["IsMonthly"] != DBNull.Value)
_employeeVacationPermit.IsMonthly = Convert.ToBoolean(reader["IsMonthly"]);
if(reader["IsYearly"] != DBNull.Value)
_employeeVacationPermit.IsYearly = Convert.ToBoolean(reader["IsYearly"]);
_employeeVacationPermit.NewRecord = false; } reader.Close();
return _employeeVacationPermit;
}
public bool Insert(EmployeeVacationPermit employeevacationpermit)
{
int autonumber = 0;
EmployeeVacationPermitDAC employeevacationpermitComponent = new EmployeeVacationPermitDAC();
bool endedSuccessfuly = employeevacationpermitComponent.InsertNewEmployeeVacationPermit( ref autonumber, employeevacationpermit.Name, employeevacationpermit.VacationTypeID, employeevacationpermit.PermitNumberinDays, employeevacationpermit.IsMonthly, employeevacationpermit.IsYearly);
if(endedSuccessfuly)
{
employeevacationpermit.EmployeeVacationPermitID = autonumber;
}
return endedSuccessfuly;
}
public bool Update(EmployeeVacationPermit employeevacationpermit ,int old_employeeVacationPermitID)
{
EmployeeVacationPermitDAC employeevacationpermitComponent = new EmployeeVacationPermitDAC();
return employeevacationpermitComponent.UpdateEmployeeVacationPermit( employeevacationpermit.Name, employeevacationpermit.VacationTypeID, employeevacationpermit.PermitNumberinDays, employeevacationpermit.IsMonthly, employeevacationpermit.IsYearly, old_employeeVacationPermitID);
}
