public HttpResponseMessage GetListAuthorOfPaperText(int paperId) { var paper = db.PAPER_TEXT.Find(paperId); var model = new PaperAbstractModel(); if (paper == null) { return(ResponseFail(StringResource.Paper_text_do_not_exist)); } else { var listAuthor = (from a in db.AUTHOR_PAPER_TEXT_RELATIONSHIP join au in db.AUTHORs on a.PERSON_ID equals au.PERSON_ID join p in db.People on a.PERSON_ID equals p.PERSON_ID where a.PAPER_ID == paperId && au.CONFERENCE_ID == a.CONFERENCE_ID select new { a, au, p }) .AsEnumerable() .Distinct() .Select(x => new { x.a.PERSON_ID, x.a.CONFERENCE_ID, x.a.PAPER_ID, x.au.CURRENT_FIRST_NAME, x.au.CURRENT_MIDDLE_NAME, x.au.CURRENT_LAST_NAME, FULL_NAME = Utils.GetFullName(x.au.CURRENT_FIRST_NAME, x.au.CURRENT_MIDDLE_NAME, x.au.CURRENT_LAST_NAME), x.p.CURRENT_PERSONAL_EMAIL }).Distinct(); return(ResponseSuccess(StringResource.Success, listAuthor)); } }
public HttpResponseMessage ListSubmitingHistoryPaperText(int paperId) { var paperText = db.PAPER_TEXT.Find(paperId); var paperAbstract = db.PAPER_ABSTRACT.Find(paperId); var model = new PaperAbstractModel(); var myPaperAbstract = model.getMyPaperAbstract(paperAbstract); if (paperText == null) { return(ResponseFail(StringResource.Paper_text_do_not_exist)); } else if (paperAbstract == null) { return(ResponseFail(StringResource.Paper_abstract_do_not_exist)); } else { var listObj = new List <ListPaperTextSubmit>(); if (!String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_1) || !String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_EN_1)) { var listPaperText = new ListPaperTextSubmit(); listPaperText.PAPER_TEXT_TITLE = paperText.PAPER_TEXT_TITLE_1; listPaperText.PAPER_TEXT_TITLE_EN = paperText.PAPER_TEXT_TITLE_EN_1; listPaperText.PAPER_TEXT = paperText.PAPER_TEXT_1; listPaperText.PAPER_TEXT_EN = paperText.PAPER_TEXT_EN_1; listPaperText.CONFERENCE_SESSION_TOPIC_ID = myPaperAbstract.CONFERENCE_SESSION_TOPIC_ID; listPaperText.CONFERENCE_SESSION_TOPIC_NAME = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME; listPaperText.CONFERENCE_SESSION_TOPIC_NAME_EN = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME_EN; listPaperText.TYPE_OF_STUDY_ID = myPaperAbstract.TYPE_OF_STUDY_ID; listPaperText.TYPE_OF_STUDY_NAME = myPaperAbstract.TYPE_OF_STUDY_NAME; listPaperText.TYPE_OF_STUDY_NAME_EN = myPaperAbstract.TYPE_OF_STUDY_NAME_EN; listPaperText.CONFERENCE_PRESENTATION_TYPE_ID = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_ID; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME_EN = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME_EN; listPaperText.PAPER_TEXT_ATTACHED_FILENAME = paperText.PAPER_TEXT_ATTACHED_FILENAME_1; listPaperText.NUMBER_OF_PAGES_OF_PAPER_TEXT = paperText.NUMBER_OF_PAGES_OF_PAPER_TEXT_1; listPaperText.FIRST_SUBMITTED_DATE = paperText.FIRST_SUBMITTED_DATE_1; listPaperText.LAST_REVISED_DATE = paperText.LAST_REVISED_DATE_1; listObj.Add(listPaperText); } if (!String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_2) || !String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_2)) { var listPaperText = new ListPaperTextSubmit(); listPaperText.PAPER_TEXT_TITLE = paperText.PAPER_TEXT_TITLE_2; listPaperText.PAPER_TEXT_TITLE_EN = paperText.PAPER_TEXT_TITLE_EN_2; listPaperText.PAPER_TEXT = paperText.PAPER_TEXT_2; listPaperText.PAPER_TEXT_EN = paperText.PAPER_TEXT_EN_2; listPaperText.CONFERENCE_SESSION_TOPIC_ID = myPaperAbstract.CONFERENCE_SESSION_TOPIC_ID; listPaperText.CONFERENCE_SESSION_TOPIC_NAME = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME; listPaperText.CONFERENCE_SESSION_TOPIC_NAME_EN = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME_EN; listPaperText.TYPE_OF_STUDY_ID = myPaperAbstract.TYPE_OF_STUDY_ID; listPaperText.TYPE_OF_STUDY_NAME = myPaperAbstract.TYPE_OF_STUDY_NAME; listPaperText.TYPE_OF_STUDY_NAME_EN = myPaperAbstract.TYPE_OF_STUDY_NAME_EN; listPaperText.CONFERENCE_PRESENTATION_TYPE_ID = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_ID; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME_EN = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME_EN; listPaperText.PAPER_TEXT_ATTACHED_FILENAME = paperText.PAPER_TEXT_ATTACHED_FILENAME_2; listPaperText.NUMBER_OF_PAGES_OF_PAPER_TEXT = paperText.NUMBER_OF_PAGES_OF_PAPER_TEXT_2; listPaperText.FIRST_SUBMITTED_DATE = paperText.FIRST_SUBMITTED_DATE_2; listPaperText.LAST_REVISED_DATE = paperText.LAST_REVISED_DATE_2; listObj.Add(listPaperText); } if (!String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_3) || !String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_3)) { var listPaperText = new ListPaperTextSubmit(); listPaperText.PAPER_TEXT_TITLE = paperText.PAPER_TEXT_TITLE_3; listPaperText.PAPER_TEXT_TITLE_EN = paperText.PAPER_TEXT_TITLE_EN_3; listPaperText.PAPER_TEXT = paperText.PAPER_TEXT_3; listPaperText.PAPER_TEXT_EN = paperText.PAPER_TEXT_EN_3; listPaperText.CONFERENCE_SESSION_TOPIC_ID = myPaperAbstract.CONFERENCE_SESSION_TOPIC_ID; listPaperText.CONFERENCE_SESSION_TOPIC_NAME = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME; listPaperText.CONFERENCE_SESSION_TOPIC_NAME_EN = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME_EN; listPaperText.TYPE_OF_STUDY_ID = myPaperAbstract.TYPE_OF_STUDY_ID; listPaperText.TYPE_OF_STUDY_NAME = myPaperAbstract.TYPE_OF_STUDY_NAME; listPaperText.TYPE_OF_STUDY_NAME_EN = myPaperAbstract.TYPE_OF_STUDY_NAME_EN; listPaperText.CONFERENCE_PRESENTATION_TYPE_ID = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_ID; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME_EN = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME_EN; listPaperText.PAPER_TEXT_ATTACHED_FILENAME = paperText.PAPER_TEXT_ATTACHED_FILENAME_3; listPaperText.NUMBER_OF_PAGES_OF_PAPER_TEXT = paperText.NUMBER_OF_PAGES_OF_PAPER_TEXT_3; listPaperText.FIRST_SUBMITTED_DATE = paperText.FIRST_SUBMITTED_DATE_3; listPaperText.LAST_REVISED_DATE = paperText.LAST_REVISED_DATE_3; listObj.Add(listPaperText); } if (!String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_4) || !String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_4)) { var listPaperText = new ListPaperTextSubmit(); listPaperText.PAPER_TEXT_TITLE = paperText.PAPER_TEXT_TITLE_4; listPaperText.PAPER_TEXT_TITLE_EN = paperText.PAPER_TEXT_TITLE_EN_4; listPaperText.PAPER_TEXT = paperText.PAPER_TEXT_4; listPaperText.PAPER_TEXT_EN = paperText.PAPER_TEXT_EN_4; listPaperText.CONFERENCE_SESSION_TOPIC_ID = myPaperAbstract.CONFERENCE_SESSION_TOPIC_ID; listPaperText.CONFERENCE_SESSION_TOPIC_NAME = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME; listPaperText.CONFERENCE_SESSION_TOPIC_NAME_EN = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME_EN; listPaperText.TYPE_OF_STUDY_ID = myPaperAbstract.TYPE_OF_STUDY_ID; listPaperText.TYPE_OF_STUDY_NAME = myPaperAbstract.TYPE_OF_STUDY_NAME; listPaperText.TYPE_OF_STUDY_NAME_EN = myPaperAbstract.TYPE_OF_STUDY_NAME_EN; listPaperText.CONFERENCE_PRESENTATION_TYPE_ID = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_ID; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME_EN = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME_EN; listPaperText.PAPER_TEXT_ATTACHED_FILENAME = paperText.PAPER_TEXT_ATTACHED_FILENAME_4; listPaperText.NUMBER_OF_PAGES_OF_PAPER_TEXT = paperText.NUMBER_OF_PAGES_OF_PAPER_TEXT_4; listPaperText.FIRST_SUBMITTED_DATE = paperText.FIRST_SUBMITTED_DATE_4; listPaperText.LAST_REVISED_DATE = paperText.LAST_REVISED_DATE_4; listObj.Add(listPaperText); } if (!String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_5) || !String.IsNullOrEmpty(paperText.PAPER_TEXT_TITLE_5)) { var listPaperText = new ListPaperTextSubmit(); listPaperText.PAPER_TEXT_TITLE = paperText.PAPER_TEXT_TITLE_5; listPaperText.PAPER_TEXT_TITLE_EN = paperText.PAPER_TEXT_TITLE_EN_5; listPaperText.PAPER_TEXT = paperText.PAPER_TEXT_5; listPaperText.PAPER_TEXT_EN = paperText.PAPER_TEXT_EN_5; listPaperText.CONFERENCE_SESSION_TOPIC_ID = myPaperAbstract.CONFERENCE_SESSION_TOPIC_ID; listPaperText.CONFERENCE_SESSION_TOPIC_NAME = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME; listPaperText.CONFERENCE_SESSION_TOPIC_NAME_EN = myPaperAbstract.CONFERENCE_SESSION_TOPIC_NAME_EN; listPaperText.TYPE_OF_STUDY_ID = myPaperAbstract.TYPE_OF_STUDY_ID; listPaperText.TYPE_OF_STUDY_NAME = myPaperAbstract.TYPE_OF_STUDY_NAME; listPaperText.TYPE_OF_STUDY_NAME_EN = myPaperAbstract.TYPE_OF_STUDY_NAME_EN; listPaperText.CONFERENCE_PRESENTATION_TYPE_ID = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_ID; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME; listPaperText.CONFERENCE_PRESENTATION_TYPE_NAME_EN = myPaperAbstract.CONFERENCE_PRESENTATION_TYPE_NAME_EN; listPaperText.PAPER_TEXT_ATTACHED_FILENAME = paperText.PAPER_TEXT_ATTACHED_FILENAME_5; listPaperText.NUMBER_OF_PAGES_OF_PAPER_TEXT = paperText.NUMBER_OF_PAGES_OF_PAPER_TEXT_5; listPaperText.FIRST_SUBMITTED_DATE = paperText.FIRST_SUBMITTED_DATE_5; listPaperText.LAST_REVISED_DATE = paperText.LAST_REVISED_DATE_5; listObj.Add(listPaperText); } return(ResponseSuccess(StringResource.Success, listObj)); } }