public List<PersonWorkExperience> GetAll() { PersonWorkExperienceDAC _personWorkExperienceComponent = new PersonWorkExperienceDAC(); IDataReader reader = _personWorkExperienceComponent.GetAllPersonWorkExperience().CreateDataReader(); List<PersonWorkExperience> _personWorkExperienceList = new List<PersonWorkExperience>(); while(reader.Read()) { if(_personWorkExperienceList == null) _personWorkExperienceList = new List<PersonWorkExperience>(); PersonWorkExperience _personWorkExperience = new PersonWorkExperience(); if(reader["PersonWorkExperienceId"] != DBNull.Value) _personWorkExperience.PersonWorkExperienceId = Convert.ToInt32(reader["PersonWorkExperienceId"]); if(reader["PersonId"] != DBNull.Value) _personWorkExperience.PersonId = Convert.ToInt32(reader["PersonId"]); if(reader["Employer"] != DBNull.Value) _personWorkExperience.Employer = Convert.ToString(reader["Employer"]); if(reader["PositionHeld"] != DBNull.Value) _personWorkExperience.PositionHeld = Convert.ToString(reader["PositionHeld"]); if(reader["Responsibilities"] != DBNull.Value) _personWorkExperience.Responsibilities = Convert.ToString(reader["Responsibilities"]); if(reader["StartDate"] != DBNull.Value) _personWorkExperience.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _personWorkExperience.EndDate = Convert.ToDateTime(reader["EndDate"]); _personWorkExperience.NewRecord = false; _personWorkExperienceList.Add(_personWorkExperience); } reader.Close(); return _personWorkExperienceList; }
public PersonWorkExperience GetByID(int _personWorkExperienceId) { PersonWorkExperienceDAC _personWorkExperienceComponent = new PersonWorkExperienceDAC(); IDataReader reader = _personWorkExperienceComponent.GetByIDPersonWorkExperience(_personWorkExperienceId); PersonWorkExperience _personWorkExperience = null; while(reader.Read()) { _personWorkExperience = new PersonWorkExperience(); if(reader["PersonWorkExperienceId"] != DBNull.Value) _personWorkExperience.PersonWorkExperienceId = Convert.ToInt32(reader["PersonWorkExperienceId"]); if(reader["PersonId"] != DBNull.Value) _personWorkExperience.PersonId = Convert.ToInt32(reader["PersonId"]); if(reader["Employer"] != DBNull.Value) _personWorkExperience.Employer = Convert.ToString(reader["Employer"]); if(reader["PositionHeld"] != DBNull.Value) _personWorkExperience.PositionHeld = Convert.ToString(reader["PositionHeld"]); if(reader["Responsibilities"] != DBNull.Value) _personWorkExperience.Responsibilities = Convert.ToString(reader["Responsibilities"]); if(reader["StartDate"] != DBNull.Value) _personWorkExperience.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _personWorkExperience.EndDate = Convert.ToDateTime(reader["EndDate"]); _personWorkExperience.NewRecord = false; } reader.Close(); return _personWorkExperience; }
public bool Insert(PersonWorkExperience personworkexperience) { int autonumber = 0; PersonWorkExperienceDAC personworkexperienceComponent = new PersonWorkExperienceDAC(); bool endedSuccessfuly = personworkexperienceComponent.InsertNewPersonWorkExperience( ref autonumber, personworkexperience.PersonId, personworkexperience.Employer, personworkexperience.PositionHeld, personworkexperience.Responsibilities, personworkexperience.StartDate, personworkexperience.EndDate); if(endedSuccessfuly) { personworkexperience.PersonWorkExperienceId = autonumber; } return endedSuccessfuly; }
public bool Update(PersonWorkExperience personworkexperience ,int old_personWorkExperienceId) { PersonWorkExperienceDAC personworkexperienceComponent = new PersonWorkExperienceDAC(); return personworkexperienceComponent.UpdatePersonWorkExperience( personworkexperience.PersonId, personworkexperience.Employer, personworkexperience.PositionHeld, personworkexperience.Responsibilities, personworkexperience.StartDate, personworkexperience.EndDate, old_personWorkExperienceId); }