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