public List<AbstractReview> GetAll()
{
AbstractReviewDAC _abstractReviewComponent = new AbstractReviewDAC();
IDataReader reader = _abstractReviewComponent.GetAllAbstractReview().CreateDataReader();
List<AbstractReview> _abstractReviewList = new List<AbstractReview>();
while(reader.Read())
{
if(_abstractReviewList == null)
_abstractReviewList = new List<AbstractReview>();
AbstractReview _abstractReview = new AbstractReview();
if(reader["AbstractReviewId"] != DBNull.Value)
_abstractReview.AbstractReviewId = Convert.ToInt32(reader["AbstractReviewId"]);
if(reader["AbstractReviewerAssignmentId"] != DBNull.Value)
_abstractReview.AbstractReviewerAssignmentId = Convert.ToInt32(reader["AbstractReviewerAssignmentId"]);
if(reader["AbstractStatusId"] != DBNull.Value)
_abstractReview.AbstractStatusId = Convert.ToInt32(reader["AbstractStatusId"]);
if(reader["ReviewerFeedback"] != DBNull.Value)
_abstractReview.ReviewerFeedback = Convert.ToString(reader["ReviewerFeedback"]);
if(reader["DateSubmitted"] != DBNull.Value)
_abstractReview.DateSubmitted = Convert.ToDateTime(reader["DateSubmitted"]);
_abstractReview.NewRecord = false;
_abstractReviewList.Add(_abstractReview);
} reader.Close();
return _abstractReviewList;
}
public AbstractReview GetByID(int _abstractReviewId)
{
AbstractReviewDAC _abstractReviewComponent = new AbstractReviewDAC();
IDataReader reader = _abstractReviewComponent.GetByIDAbstractReview(_abstractReviewId);
AbstractReview _abstractReview = null;
while(reader.Read())
{
_abstractReview = new AbstractReview();
if(reader["AbstractReviewId"] != DBNull.Value)
_abstractReview.AbstractReviewId = Convert.ToInt32(reader["AbstractReviewId"]);
if(reader["AbstractReviewerAssignmentId"] != DBNull.Value)
_abstractReview.AbstractReviewerAssignmentId = Convert.ToInt32(reader["AbstractReviewerAssignmentId"]);
if(reader["AbstractStatusId"] != DBNull.Value)
_abstractReview.AbstractStatusId = Convert.ToInt32(reader["AbstractStatusId"]);
if(reader["ReviewerFeedback"] != DBNull.Value)
_abstractReview.ReviewerFeedback = Convert.ToString(reader["ReviewerFeedback"]);
if(reader["DateSubmitted"] != DBNull.Value)
_abstractReview.DateSubmitted = Convert.ToDateTime(reader["DateSubmitted"]);
_abstractReview.NewRecord = false; } reader.Close();
return _abstractReview;
}
public bool Update(AbstractReview abstractreview ,int old_abstractReviewId)
{
AbstractReviewDAC abstractreviewComponent = new AbstractReviewDAC();
return abstractreviewComponent.UpdateAbstractReview( abstractreview.AbstractReviewId, abstractreview.AbstractReviewerAssignmentId, abstractreview.AbstractStatusId, abstractreview.ReviewerFeedback, abstractreview.DateSubmitted, old_abstractReviewId);
}
public bool Insert(AbstractReview abstractreview)
{
AbstractReviewDAC abstractreviewComponent = new AbstractReviewDAC();
return abstractreviewComponent.InsertNewAbstractReview( abstractreview.AbstractReviewId, abstractreview.AbstractReviewerAssignmentId, abstractreview.AbstractStatusId, abstractreview.ReviewerFeedback, abstractreview.DateSubmitted);
}
