public bool Insert(AbstractReviewerAssignment abstractreviewerassignment) { int autonumber = 0; AbstractReviewerAssignmentDAC abstractreviewerassignmentComponent = new AbstractReviewerAssignmentDAC(); bool endedSuccessfuly = abstractreviewerassignmentComponent.InsertNewAbstractReviewerAssignment(ref autonumber, abstractreviewerassignment.AbstractReviewerId, abstractreviewerassignment.AbstractId, abstractreviewerassignment.HasAcceptedReview, abstractreviewerassignment.DateAssigned, abstractreviewerassignment.DateAccepted); if (endedSuccessfuly) { abstractreviewerassignment.AbstractReviewerAssignmentId = autonumber; } return(endedSuccessfuly); }
public List <AbstractReviewerAssignment> GetAllByAbstractId(int AbstractId) { AbstractReviewerAssignmentDAC _abstractReviewerAssignmentComponent = new AbstractReviewerAssignmentDAC(); IDataReader reader = _abstractReviewerAssignmentComponent.GetAllAbstractReviewerAssignment("AbstractId = " + AbstractId).CreateDataReader(); List <AbstractReviewerAssignment> _abstractReviewerAssignmentList = new List <AbstractReviewerAssignment>(); while (reader.Read()) { if (_abstractReviewerAssignmentList == null) { _abstractReviewerAssignmentList = new List <AbstractReviewerAssignment>(); } AbstractReviewerAssignment _abstractReviewerAssignment = new AbstractReviewerAssignment(); if (reader["AbstractReviewerAssignmentId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractReviewerAssignmentId = Convert.ToInt32(reader["AbstractReviewerAssignmentId"]); } if (reader["AbstractReviewerId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractReviewerId = Convert.ToInt32(reader["AbstractReviewerId"]); } if (reader["AbstractId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractId = Convert.ToInt32(reader["AbstractId"]); } if (reader["HasAcceptedReview"] != DBNull.Value) { _abstractReviewerAssignment.HasAcceptedReview = Convert.ToBoolean(reader["HasAcceptedReview"]); } if (reader["DateAssigned"] != DBNull.Value) { _abstractReviewerAssignment.DateAssigned = Convert.ToDateTime(reader["DateAssigned"]); } if (reader["DateAccepted"] != DBNull.Value) { _abstractReviewerAssignment.DateAccepted = Convert.ToDateTime(reader["DateAccepted"]); } _abstractReviewerAssignment.NewRecord = false; _abstractReviewerAssignmentList.Add(_abstractReviewerAssignment); } reader.Close(); return(_abstractReviewerAssignmentList); }
public AbstractReviewerAssignment GetByID(int _abstractReviewerAssignmentId) { AbstractReviewerAssignmentDAC _abstractReviewerAssignmentComponent = new AbstractReviewerAssignmentDAC(); IDataReader reader = _abstractReviewerAssignmentComponent.GetByIDAbstractReviewerAssignment(_abstractReviewerAssignmentId); AbstractReviewerAssignment _abstractReviewerAssignment = null; while (reader.Read()) { _abstractReviewerAssignment = new AbstractReviewerAssignment(); if (reader["AbstractReviewerAssignmentId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractReviewerAssignmentId = Convert.ToInt32(reader["AbstractReviewerAssignmentId"]); } if (reader["AbstractReviewerId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractReviewerId = Convert.ToInt32(reader["AbstractReviewerId"]); } if (reader["AbstractId"] != DBNull.Value) { _abstractReviewerAssignment.AbstractId = Convert.ToInt32(reader["AbstractId"]); } if (reader["HasAcceptedReview"] != DBNull.Value) { _abstractReviewerAssignment.HasAcceptedReview = Convert.ToBoolean(reader["HasAcceptedReview"]); } if (reader["DateAssigned"] != DBNull.Value) { _abstractReviewerAssignment.DateAssigned = Convert.ToDateTime(reader["DateAssigned"]); } if (reader["DateAccepted"] != DBNull.Value) { _abstractReviewerAssignment.DateAccepted = Convert.ToDateTime(reader["DateAccepted"]); } _abstractReviewerAssignment.NewRecord = false; } reader.Close(); return(_abstractReviewerAssignment); }
public bool Update(AbstractReviewerAssignment abstractreviewerassignment, int old_abstractReviewerAssignmentId) { AbstractReviewerAssignmentDAC abstractreviewerassignmentComponent = new AbstractReviewerAssignmentDAC(); return(abstractreviewerassignmentComponent.UpdateAbstractReviewerAssignment(abstractreviewerassignment.AbstractReviewerId, abstractreviewerassignment.AbstractId, abstractreviewerassignment.HasAcceptedReview, abstractreviewerassignment.DateAssigned, abstractreviewerassignment.DateAccepted, old_abstractReviewerAssignmentId)); }