Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 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;
 }
Ejemplo n.º 3
0
 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;
 }
Ejemplo n.º 4
0
 public void Delete(int Original_PersonInternshipId)
 {
     PersonInternshipDAC personinternshipComponent = new PersonInternshipDAC();
     personinternshipComponent.DeletePersonInternship(Original_PersonInternshipId);
 }
Ejemplo n.º 5
0
 public int UpdateDataset(System.Data.DataSet dataset)
 {
     PersonInternshipDAC personinternshipcomponent = new PersonInternshipDAC();
     return personinternshipcomponent.UpdateDataset(dataset);
 }
Ejemplo n.º 6
0
 public bool Update( int PersonId,  string Service,  string Institution,  string Evaluation,  DateTime StartDate,  DateTime EndDate,  int Original_PersonInternshipId)
 {
     PersonInternshipDAC personinternshipComponent = new PersonInternshipDAC();
     return personinternshipComponent.UpdatePersonInternship( PersonId,  Service,  Institution,  Evaluation,  StartDate,  EndDate,  Original_PersonInternshipId);
 }
Ejemplo n.º 7
0
 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);
 }
Ejemplo n.º 8
0
        public bool Insert( int PersonId,  string Service,  string Institution,  string Evaluation,  DateTime StartDate,  DateTime EndDate)
        {
            PersonInternshipDAC personinternshipComponent = new PersonInternshipDAC();
            int PersonInternshipId = 0;

            return personinternshipComponent.InsertNewPersonInternship( ref PersonInternshipId,  PersonId,  Service,  Institution,  Evaluation,  StartDate,  EndDate);
        }