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; }
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; }
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; }
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); }