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 void Delete(int Original_PersonWorkExperienceId) { PersonWorkExperienceDAC personworkexperienceComponent = new PersonWorkExperienceDAC(); personworkexperienceComponent.DeletePersonWorkExperience(Original_PersonWorkExperienceId); }
public int UpdateDataset(System.Data.DataSet dataset) { PersonWorkExperienceDAC personworkexperiencecomponent = new PersonWorkExperienceDAC(); return personworkexperiencecomponent.UpdateDataset(dataset); }
public bool Update( int PersonId, string Employer, string PositionHeld, string Responsibilities, DateTime StartDate, DateTime EndDate, int Original_PersonWorkExperienceId) { PersonWorkExperienceDAC personworkexperienceComponent = new PersonWorkExperienceDAC(); return personworkexperienceComponent.UpdatePersonWorkExperience( PersonId, Employer, PositionHeld, Responsibilities, StartDate, EndDate, Original_PersonWorkExperienceId); }
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); }
public bool Insert( int PersonId, string Employer, string PositionHeld, string Responsibilities, DateTime StartDate, DateTime EndDate) { PersonWorkExperienceDAC personworkexperienceComponent = new PersonWorkExperienceDAC(); int PersonWorkExperienceId = 0; return personworkexperienceComponent.InsertNewPersonWorkExperience( ref PersonWorkExperienceId, PersonId, Employer, PositionHeld, Responsibilities, StartDate, EndDate); }