public bool Insert(EducationType educationtype)
{
int autonumber = 0;
EducationTypeDAC educationtypeComponent = new EducationTypeDAC();
bool endedSuccessfuly = educationtypeComponent.InsertNewEducationType( ref autonumber, educationtype.EducationTypeName);
if(endedSuccessfuly)
{
educationtype.EducationTypeId = autonumber;
}
return endedSuccessfuly;
}
public EducationType GetByID(int _educationTypeId)
{
EducationTypeDAC _educationTypeComponent = new EducationTypeDAC();
IDataReader reader = _educationTypeComponent.GetByIDEducationType(_educationTypeId);
EducationType _educationType = null;
while(reader.Read())
{
_educationType = new EducationType();
if(reader["EducationTypeId"] != DBNull.Value)
_educationType.EducationTypeId = Convert.ToInt32(reader["EducationTypeId"]);
if(reader["EducationTypeName"] != DBNull.Value)
_educationType.EducationTypeName = Convert.ToString(reader["EducationTypeName"]);
_educationType.NewRecord = false; } reader.Close();
return _educationType;
}
public List<EducationType> GetAll()
{
EducationTypeDAC _educationTypeComponent = new EducationTypeDAC();
IDataReader reader = _educationTypeComponent.GetAllEducationType().CreateDataReader();
List<EducationType> _educationTypeList = new List<EducationType>();
while(reader.Read())
{
if(_educationTypeList == null)
_educationTypeList = new List<EducationType>();
EducationType _educationType = new EducationType();
if(reader["EducationTypeId"] != DBNull.Value)
_educationType.EducationTypeId = Convert.ToInt32(reader["EducationTypeId"]);
if(reader["EducationTypeName"] != DBNull.Value)
_educationType.EducationTypeName = Convert.ToString(reader["EducationTypeName"]);
_educationType.NewRecord = false;
_educationTypeList.Add(_educationType);
} reader.Close();
return _educationTypeList;
}
public bool Update(EducationType educationtype ,int old_educationTypeId)
{
EducationTypeDAC educationtypeComponent = new EducationTypeDAC();
return educationtypeComponent.UpdateEducationType( educationtype.EducationTypeName, old_educationTypeId);
}
