public bool Insert(VacationType vacationtype)
{
int autonumber = 0;
VacationTypeDAC vacationtypeComponent = new VacationTypeDAC();
bool endedSuccessfuly = vacationtypeComponent.InsertNewVacationType( ref autonumber, vacationtype.Name);
if(endedSuccessfuly)
{
vacationtype.VacationTypeID = autonumber;
}
return endedSuccessfuly;
}
public VacationType GetByID(int _vacationTypeID)
{
VacationTypeDAC _vacationTypeComponent = new VacationTypeDAC();
IDataReader reader = _vacationTypeComponent.GetByIDVacationType(_vacationTypeID);
VacationType _vacationType = null;
while(reader.Read())
{
_vacationType = new VacationType();
if(reader["VacationTypeID"] != DBNull.Value)
_vacationType.VacationTypeID = Convert.ToInt32(reader["VacationTypeID"]);
if(reader["Name"] != DBNull.Value)
_vacationType.Name = Convert.ToString(reader["Name"]);
_vacationType.NewRecord = false; } reader.Close();
return _vacationType;
}
public List<VacationType> GetAll()
{
VacationTypeDAC _vacationTypeComponent = new VacationTypeDAC();
IDataReader reader = _vacationTypeComponent.GetAllVacationType().CreateDataReader();
List<VacationType> _vacationTypeList = new List<VacationType>();
while(reader.Read())
{
if(_vacationTypeList == null)
_vacationTypeList = new List<VacationType>();
VacationType _vacationType = new VacationType();
if(reader["VacationTypeID"] != DBNull.Value)
_vacationType.VacationTypeID = Convert.ToInt32(reader["VacationTypeID"]);
if(reader["Name"] != DBNull.Value)
_vacationType.Name = Convert.ToString(reader["Name"]);
_vacationType.NewRecord = false;
_vacationTypeList.Add(_vacationType);
} reader.Close();
return _vacationTypeList;
}
public bool Update(VacationType vacationtype ,int old_vacationTypeID)
{
VacationTypeDAC vacationtypeComponent = new VacationTypeDAC();
return vacationtypeComponent.UpdateVacationType( vacationtype.Name, old_vacationTypeID);
}
