public List<PersonInternship> GetAll()
{
PersonInternshipDAC _personInternshipComponent = new PersonInternshipDAC();
IDataReader reader = _personInternshipComponent.GetAllPersonInternship().CreateDataReader();
List<PersonInternship> _personInternshipList = new List<PersonInternship>();
while(reader.Read())
{
if(_personInternshipList == null)
_personInternshipList = new List<PersonInternship>();
PersonInternship _personInternship = new PersonInternship();
if(reader["PersonInternshipId"] != DBNull.Value)
_personInternship.PersonInternshipId = Convert.ToInt32(reader["PersonInternshipId"]);
if(reader["PersonId"] != DBNull.Value)
_personInternship.PersonId = Convert.ToInt32(reader["PersonId"]);
if(reader["Service"] != DBNull.Value)
_personInternship.Service = Convert.ToString(reader["Service"]);
if(reader["Institution"] != DBNull.Value)
_personInternship.Institution = Convert.ToString(reader["Institution"]);
if(reader["Evaluation"] != DBNull.Value)
_personInternship.Evaluation = Convert.ToString(reader["Evaluation"]);
if(reader["StartDate"] != DBNull.Value)
_personInternship.StartDate = Convert.ToDateTime(reader["StartDate"]);
if(reader["EndDate"] != DBNull.Value)
_personInternship.EndDate = Convert.ToDateTime(reader["EndDate"]);
_personInternship.NewRecord = false;
_personInternshipList.Add(_personInternship);
} reader.Close();
return _personInternshipList;
}
public PersonInternship GetByID(int _personInternshipId)
{
PersonInternshipDAC _personInternshipComponent = new PersonInternshipDAC();
IDataReader reader = _personInternshipComponent.GetByIDPersonInternship(_personInternshipId);
PersonInternship _personInternship = null;
while(reader.Read())
{
_personInternship = new PersonInternship();
if(reader["PersonInternshipId"] != DBNull.Value)
_personInternship.PersonInternshipId = Convert.ToInt32(reader["PersonInternshipId"]);
if(reader["PersonId"] != DBNull.Value)
_personInternship.PersonId = Convert.ToInt32(reader["PersonId"]);
if(reader["Service"] != DBNull.Value)
_personInternship.Service = Convert.ToString(reader["Service"]);
if(reader["Institution"] != DBNull.Value)
_personInternship.Institution = Convert.ToString(reader["Institution"]);
if(reader["Evaluation"] != DBNull.Value)
_personInternship.Evaluation = Convert.ToString(reader["Evaluation"]);
if(reader["StartDate"] != DBNull.Value)
_personInternship.StartDate = Convert.ToDateTime(reader["StartDate"]);
if(reader["EndDate"] != DBNull.Value)
_personInternship.EndDate = Convert.ToDateTime(reader["EndDate"]);
_personInternship.NewRecord = false; } reader.Close();
return _personInternship;
}
public bool Insert(PersonInternship personinternship)
{
int autonumber = 0;
PersonInternshipDAC personinternshipComponent = new PersonInternshipDAC();
bool endedSuccessfuly = personinternshipComponent.InsertNewPersonInternship( ref autonumber, personinternship.PersonId, personinternship.Service, personinternship.Institution, personinternship.Evaluation, personinternship.StartDate, personinternship.EndDate);
if(endedSuccessfuly)
{
personinternship.PersonInternshipId = autonumber;
}
return endedSuccessfuly;
}
public bool Update(PersonInternship personinternship ,int old_personInternshipId)
{
PersonInternshipDAC personinternshipComponent = new PersonInternshipDAC();
return personinternshipComponent.UpdatePersonInternship( personinternship.PersonId, personinternship.Service, personinternship.Institution, personinternship.Evaluation, personinternship.StartDate, personinternship.EndDate, old_personInternshipId);
}
