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 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 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 Update(AbstractReviewer abstractreviewer, int old_abstractReviewerId) { AbstractReviewerDAC abstractreviewerComponent = new AbstractReviewerDAC(); return(abstractreviewerComponent.UpdateAbstractReviewer(abstractreviewer.PersonId, abstractreviewer.IsInternal, abstractreviewer.DateCreated, abstractreviewer.IsActive, old_abstractReviewerId)); }