Example #1
0
 public List<AbstractReviewer> GetAll()
 {
     AbstractReviewerDAC _abstractReviewerComponent = new AbstractReviewerDAC();
      IDataReader reader =  _abstractReviewerComponent.GetAllAbstractReviewer().CreateDataReader();
      List<AbstractReviewer> _abstractReviewerList = new List<AbstractReviewer>();
      while(reader.Read())
      {
      if(_abstractReviewerList == null)
          _abstractReviewerList = new List<AbstractReviewer>();
          AbstractReviewer _abstractReviewer = new AbstractReviewer();
          if(reader["AbstractReviewerId"] != DBNull.Value)
              _abstractReviewer.AbstractReviewerId = Convert.ToInt32(reader["AbstractReviewerId"]);
          if(reader["PersonId"] != DBNull.Value)
              _abstractReviewer.PersonId = Convert.ToInt32(reader["PersonId"]);
          if(reader["IsInternal"] != DBNull.Value)
              _abstractReviewer.IsInternal = Convert.ToBoolean(reader["IsInternal"]);
          if(reader["DateCreated"] != DBNull.Value)
              _abstractReviewer.DateCreated = Convert.ToDateTime(reader["DateCreated"]);
          if(reader["IsActive"] != DBNull.Value)
              _abstractReviewer.IsActive = Convert.ToBoolean(reader["IsActive"]);
      _abstractReviewer.NewRecord = false;
      _abstractReviewerList.Add(_abstractReviewer);
      }             reader.Close();
      return _abstractReviewerList;
 }
Example #2
0
 public bool Insert(AbstractReviewer abstractreviewer)
 {
     int autonumber = 0;
     AbstractReviewerDAC abstractreviewerComponent = new AbstractReviewerDAC();
     bool endedSuccessfuly = abstractreviewerComponent.InsertNewAbstractReviewer( ref autonumber,  abstractreviewer.PersonId,  abstractreviewer.IsInternal,  abstractreviewer.DateCreated,  abstractreviewer.IsActive);
     if(endedSuccessfuly)
     {
         abstractreviewer.AbstractReviewerId = autonumber;
     }
     return endedSuccessfuly;
 }
Example #3
0
 public AbstractReviewer GetByID(int _abstractReviewerId)
 {
     AbstractReviewerDAC _abstractReviewerComponent = new AbstractReviewerDAC();
      IDataReader reader = _abstractReviewerComponent.GetByIDAbstractReviewer(_abstractReviewerId);
      AbstractReviewer _abstractReviewer = null;
      while(reader.Read())
      {
          _abstractReviewer = new AbstractReviewer();
          if(reader["AbstractReviewerId"] != DBNull.Value)
              _abstractReviewer.AbstractReviewerId = Convert.ToInt32(reader["AbstractReviewerId"]);
          if(reader["PersonId"] != DBNull.Value)
              _abstractReviewer.PersonId = Convert.ToInt32(reader["PersonId"]);
          if(reader["IsInternal"] != DBNull.Value)
              _abstractReviewer.IsInternal = Convert.ToBoolean(reader["IsInternal"]);
          if(reader["DateCreated"] != DBNull.Value)
              _abstractReviewer.DateCreated = Convert.ToDateTime(reader["DateCreated"]);
          if(reader["IsActive"] != DBNull.Value)
              _abstractReviewer.IsActive = Convert.ToBoolean(reader["IsActive"]);
      _abstractReviewer.NewRecord = false;             }             reader.Close();
      return _abstractReviewer;
 }
Example #4
0
 public bool Update(AbstractReviewer abstractreviewer ,int old_abstractReviewerId)
 {
     AbstractReviewerDAC abstractreviewerComponent = new AbstractReviewerDAC();
     return abstractreviewerComponent.UpdateAbstractReviewer( abstractreviewer.PersonId,  abstractreviewer.IsInternal,  abstractreviewer.DateCreated,  abstractreviewer.IsActive,  old_abstractReviewerId);
 }