public bool AddReview(REVIEWER_PAPER_ABSTRACT_RELATIONSHIP review)
{
try
{
db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP.Add(review);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public void assignedReviewerUpdate(decimal paperId, Int16 deadlineNumber)
{
var list = db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP.Where(x => x.PAPER_ID == paperId).ToList();
if (list.Count > 0)
{
foreach (REVIEWER_PAPER_ABSTRACT_RELATIONSHIP item in list)
{
var review = new REVIEWER_PAPER_ABSTRACT_RELATIONSHIP();
review.PERSON_ID = item.PERSON_ID;
review.CONFERENCE_BOARD_OF_REVIEW_ID = item.CONFERENCE_BOARD_OF_REVIEW_ID;
review.CONFERENCE_ID = item.CONFERENCE_ID;
review.PAPER_ID = paperId;
review.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER = deadlineNumber;
if (this.checkIsassignedReviewerUpdate(review.PERSON_ID, review.CONFERENCE_ID, review.PAPER_ID, review.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER) == false)
{
db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP.Add(review);
db.SaveChanges();
}
}
}
}
public bool ReviewPaperAbstract(
int PERSON_ID,
int CONFERENCE_BOARD_OF_REVIEW_ID,
int CONFERENCE_ID,
int PAPER_ID,
int PROPOSED_CONFERENCE_SESSION_TOPIC_ID,
String PROPOSED_CONFERENCE_SESSION_TOPIC_NAME,
String PROPOSED_CONFERENCE_SESSION_TOPIC_NAME_EN,
int PROPOSED_TYPE_OF_STUDY_ID,
String PROPOSED_TYPE_OF_STUDY_NAME,
String PROPOSED_TYPE_OF_STUDY_NAME_EN,
Boolean PROPOSED_FOR_PRESENTATION,
int PROPOSED_CONFERENCE_PRESENTATION_TYPE_ID,
String PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME,
String PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME_EN,
int PAPER_ABSTRACT_REVIEW_RATING_POINT,
String SIGNIFICANT_REVISION_OR_MINIMAL_REVISION_OR_REVISION_NEEDED_OR_NO_REVISION_NEEDED,
String REVIEW_TEXT,
String REVIEW_TEXT_EN,
bool APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT
)
{
try
{
var idx = from review in db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP
where review.PERSON_ID == PERSON_ID &&
review.CONFERENCE_BOARD_OF_REVIEW_ID == CONFERENCE_BOARD_OF_REVIEW_ID &&
review.CONFERENCE_ID == CONFERENCE_ID
select new { review.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER };
if (idx == null)
{
var item = new REVIEWER_PAPER_ABSTRACT_RELATIONSHIP();
item.PERSON_ID = PERSON_ID;
item.CONFERENCE_BOARD_OF_REVIEW_ID = CONFERENCE_BOARD_OF_REVIEW_ID;
item.CONFERENCE_ID = CONFERENCE_ID;
item.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER = 1;
item.REVIEWED_DATE = DateTime.Now;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_ID = PROPOSED_CONFERENCE_SESSION_TOPIC_ID;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_NAME = PROPOSED_CONFERENCE_SESSION_TOPIC_NAME;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_NAME_EN = PROPOSED_CONFERENCE_SESSION_TOPIC_NAME_EN;
item.PROPOSED_TYPE_OF_STUDY_ID = PROPOSED_TYPE_OF_STUDY_ID;
item.PROPOSED_TYPE_OF_STUDY_NAME = PROPOSED_TYPE_OF_STUDY_NAME;
item.PROPOSED_TYPE_OF_STUDY_NAME_EN = PROPOSED_TYPE_OF_STUDY_NAME_EN;
if (PROPOSED_FOR_PRESENTATION == true)
{
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_ID = PROPOSED_CONFERENCE_PRESENTATION_TYPE_ID;
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME = PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME;
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME_EN = PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME_EN;
}
item.PAPER_ABSTRACT_REVIEW_RATING_POINT = PAPER_ABSTRACT_REVIEW_RATING_POINT;
item.SIGNIFICANT_REVISION_OR_MINIMAL_REVISION_OR_REVISION_NEEDED_OR_NO_REVISION_NEEDED = SIGNIFICANT_REVISION_OR_MINIMAL_REVISION_OR_REVISION_NEEDED_OR_NO_REVISION_NEEDED;
item.REVIEW_TEXT = REVIEW_TEXT;
item.REVIEW_TEXT_EN = REVIEW_TEXT_EN;
item.APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT = APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT;
item.APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT_DATE = DateTime.Now;
db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP.Add(item);
db.SaveChanges();
return(true);
}
else
{
foreach (var t in idx)
{
var item = new REVIEWER_PAPER_ABSTRACT_RELATIONSHIP();
item.PERSON_ID = PERSON_ID;
item.CONFERENCE_BOARD_OF_REVIEW_ID = CONFERENCE_BOARD_OF_REVIEW_ID;
item.CONFERENCE_ID = CONFERENCE_ID;
item.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER = Convert.ToInt16(t.PAPER_ABSTRACT_SUBMISSION_DEADLINE_ORDER_NUMBER + 1);
item.REVIEWED_DATE = DateTime.Now;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_ID = PROPOSED_CONFERENCE_SESSION_TOPIC_ID;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_NAME = PROPOSED_CONFERENCE_SESSION_TOPIC_NAME;
item.PROPOSED_CONFERENCE_SESSION_TOPIC_NAME_EN = PROPOSED_CONFERENCE_SESSION_TOPIC_NAME_EN;
item.PROPOSED_TYPE_OF_STUDY_ID = PROPOSED_TYPE_OF_STUDY_ID;
item.PROPOSED_TYPE_OF_STUDY_NAME = PROPOSED_TYPE_OF_STUDY_NAME;
item.PROPOSED_TYPE_OF_STUDY_NAME_EN = PROPOSED_TYPE_OF_STUDY_NAME_EN;
if (PROPOSED_FOR_PRESENTATION == true)
{
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_ID = PROPOSED_CONFERENCE_PRESENTATION_TYPE_ID;
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME = PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME;
item.PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME_EN = PROPOSED_CONFERENCE_PRESENTATION_TYPE_NAME_EN;
}
item.PAPER_ABSTRACT_REVIEW_RATING_POINT = PAPER_ABSTRACT_REVIEW_RATING_POINT;
item.SIGNIFICANT_REVISION_OR_MINIMAL_REVISION_OR_REVISION_NEEDED_OR_NO_REVISION_NEEDED = SIGNIFICANT_REVISION_OR_MINIMAL_REVISION_OR_REVISION_NEEDED_OR_NO_REVISION_NEEDED;
item.REVIEW_TEXT = REVIEW_TEXT;
item.REVIEW_TEXT_EN = REVIEW_TEXT_EN;
item.APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT = APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT;
item.APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT_DATE = DateTime.Now;
db.REVIEWER_PAPER_ABSTRACT_RELATIONSHIP.Add(item);
db.SaveChanges();
//PAPER_ABSTRACT paper = db.PAPER_ABSTRACT.Find(PAPER_ID);
//paper.FINAL_APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT = APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT;
//paper.FINAL_APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT_DATE = DateTime.Now;
//paper.FINAL_APPROVAL_OR_REJECTION_OF_PAPER_ABSTRACT_REVIEWER_PERSON_ID = PERSON_ID;
//db.SaveChanges();
break;
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
