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); }