コード例 #1
0
 public List<PersonDependent> GetAll()
 {
     PersonDependentDAC _personDependentComponent = new PersonDependentDAC();
      IDataReader reader =  _personDependentComponent.GetAllPersonDependent().CreateDataReader();
      List<PersonDependent> _personDependentList = new List<PersonDependent>();
      while(reader.Read())
      {
      if(_personDependentList == null)
          _personDependentList = new List<PersonDependent>();
          PersonDependent _personDependent = new PersonDependent();
          if(reader["PersonDependentId"] != DBNull.Value)
              _personDependent.PersonDependentId = Convert.ToInt32(reader["PersonDependentId"]);
          if(reader["PersonId"] != DBNull.Value)
              _personDependent.PersonId = Convert.ToInt32(reader["PersonId"]);
          if(reader["DependentName"] != DBNull.Value)
              _personDependent.DependentName = Convert.ToString(reader["DependentName"]);
          if(reader["Gender"] != DBNull.Value)
              _personDependent.Gender = Convert.ToString(reader["Gender"]);
          if(reader["Age"] != DBNull.Value)
              _personDependent.Age = Convert.ToInt32(reader["Age"]);
          if(reader["DateOfBirth"] != DBNull.Value)
              _personDependent.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]);
          if(reader["Relation"] != DBNull.Value)
              _personDependent.Relation = Convert.ToString(reader["Relation"]);
          if(reader["DateModified"] != DBNull.Value)
              _personDependent.DateModified = Convert.ToDateTime(reader["DateModified"]);
      _personDependent.NewRecord = false;
      _personDependentList.Add(_personDependent);
      }             reader.Close();
      return _personDependentList;
 }
コード例 #2
0
 public PersonDependent GetByID(int _personDependentId)
 {
     PersonDependentDAC _personDependentComponent = new PersonDependentDAC();
      IDataReader reader = _personDependentComponent.GetByIDPersonDependent(_personDependentId);
      PersonDependent _personDependent = null;
      while(reader.Read())
      {
          _personDependent = new PersonDependent();
          if(reader["PersonDependentId"] != DBNull.Value)
              _personDependent.PersonDependentId = Convert.ToInt32(reader["PersonDependentId"]);
          if(reader["PersonId"] != DBNull.Value)
              _personDependent.PersonId = Convert.ToInt32(reader["PersonId"]);
          if(reader["DependentName"] != DBNull.Value)
              _personDependent.DependentName = Convert.ToString(reader["DependentName"]);
          if(reader["Gender"] != DBNull.Value)
              _personDependent.Gender = Convert.ToString(reader["Gender"]);
          if(reader["Age"] != DBNull.Value)
              _personDependent.Age = Convert.ToInt32(reader["Age"]);
          if(reader["DateOfBirth"] != DBNull.Value)
              _personDependent.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]);
          if(reader["Relation"] != DBNull.Value)
              _personDependent.Relation = Convert.ToString(reader["Relation"]);
          if(reader["DateModified"] != DBNull.Value)
              _personDependent.DateModified = Convert.ToDateTime(reader["DateModified"]);
      _personDependent.NewRecord = false;             }             reader.Close();
      return _personDependent;
 }
コード例 #3
0
 public bool Insert(PersonDependent persondependent)
 {
     int autonumber = 0;
     PersonDependentDAC persondependentComponent = new PersonDependentDAC();
     bool endedSuccessfuly = persondependentComponent.InsertNewPersonDependent( ref autonumber,  persondependent.PersonId,  persondependent.DependentName,  persondependent.Gender,  persondependent.Age,  persondependent.DateOfBirth,  persondependent.Relation,  persondependent.DateModified);
     if(endedSuccessfuly)
     {
         persondependent.PersonDependentId = autonumber;
     }
     return endedSuccessfuly;
 }
コード例 #4
0
 public bool Update(PersonDependent persondependent ,int old_personDependentId)
 {
     PersonDependentDAC persondependentComponent = new PersonDependentDAC();
     return persondependentComponent.UpdatePersonDependent( persondependent.PersonId,  persondependent.DependentName,  persondependent.Gender,  persondependent.Age,  persondependent.DateOfBirth,  persondependent.Relation,  persondependent.DateModified,  old_personDependentId);
 }