public static bool Annotate(MyLibraryModel Model, int pmid, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { UserComment UpdateComment = (from u in entity.UserComments where u.userid == UserId && u.pmid == pmid select u).FirstOrDefault(); if (UpdateComment == null) { UserComment NewUserComment = new UserComment(); NewUserComment.pmid = pmid; NewUserComment.userid = UserId; NewUserComment.nickname = Model.UserComment.nickname; NewUserComment.comment = Model.UserComment.comment; NewUserComment.updatedate = DateTime.Now; NewUserComment.createdate = DateTime.Now; entity.UserComments.Add(NewUserComment); } else { UpdateComment.userid = UserId; UpdateComment.nickname = Model.UserComment.nickname; UpdateComment.comment = Model.UserComment.comment; UpdateComment.updatedate = DateTime.Now; entity.Entry(UpdateComment).State = EntityState.Modified; } entity.SaveChanges(); return(true); } }
// Get Topics public static ACRDocumentRelationshipModel GetTopics(int doc_id) { using (EditorsEntities entity = new EditorsEntities()) { ACRDocumentRelationshipModel acrdr = new ACRDocumentRelationshipModel(); acrdr.TopicList = (from c in entity.CommentAuthors.AsEnumerable() join e in entity.EditorTopics on c.id equals e.EditorID join t in entity.Topics on e.TopicID equals t.TopicID join s in entity.Specialties on t.SpecialtyID equals s.SpecialtyID where t.SpecialtyID == 1 && c.affiliations != "" orderby t.TopicName select new { t.TopicID, t.TopicName }).Distinct().Select(x => new SelectListItem { Value = x.TopicID.ToString(), Text = x.TopicName }).ToList(); acrdr.DocId = doc_id; return(acrdr); } }
//lib_GetGeneCitationsDirectlyByGeneID public static List <PersonalizedMedicine_User> GetGeneCitations(int userid, int?geneid) { var gene_citlist = new List <PersonalizedMedicine_User>(); using (EditorsEntities entity = new EditorsEntities()) { var gene_citations = (from cg in entity.CitationsGenes.AsEnumerable() where cg.GeneID == Convert.ToInt64(geneid) select cg.PMID).ToList(); if (gene_citations != null) { foreach (var data in gene_citations) { if (data != 0) { PersonalizedMedicine_User gene = DisplayPmids(Convert.ToInt32(userid), data.ToString(), 2, 1); gene.Displaydate = !string.IsNullOrEmpty(gene.Displaydate) ? gene.Displaydate.Substring(0, 4) : null; gene.Pmid = Convert.ToInt32(data); gene_citlist.Add(gene); gene.Gene_citationslist = gene_citlist; } } return(gene_citlist); } return(gene_citlist); } }
// For Deleting User SubTopic Calling from above static void DeleteUserSubTopic(EditorsEntities entity, int SubTopicId, int UserId) { // First, delete UserCitations for this SubTopic var UserCitationsToBeDeleted = entity.UserCitations.Where(u => u.SubTopicID == SubTopicId && u.UserID == UserId).ToList(); foreach (UserCitation UC in UserCitationsToBeDeleted) { entity.UserCitations.Remove(UC); } // Deleted UserCitations by above statement // Second, delete searches for this SubTopic entity.lib_DeleteSearchesFromSubTopic(SubTopicId, UserId); // Executing lib_DeleteSearchesFromSubTopic Stored Procedure. // Delete searches for this SubTopic by above stored procedure // Third, delete this SubTopic from subtopics and userhas sponsersubtopic var UserSubTopicToBeDeleted = entity.SubTopics.Where(s => s.SubTopicID == SubTopicId && s.UserID == UserId && s.Type == 2).FirstOrDefault(); if (UserSubTopicToBeDeleted != null) { entity.SubTopics.Remove(UserSubTopicToBeDeleted); } var UserSponsorFolderToBeDeleted = entity.UserHasSponsorFolders.Where(s => s.UserFolderId == SubTopicId && s.UserId == UserId).FirstOrDefault(); if (UserSponsorFolderToBeDeleted != null) { entity.UserHasSponsorFolders.Remove(UserSponsorFolderToBeDeleted); } entity.SaveChanges(); }
public static List <PersonalizedMedicine_User> GetTestCitations(int userid, int?testid) { var test_citlist = new List <PersonalizedMedicine_User>(); using (EditorsEntities entity = new EditorsEntities()) { var test_citations = (from ct in entity.CitationsTests.AsEnumerable() where ct.TestID == Convert.ToInt64(testid) select ct.PMID).ToList(); if (test_citations != null) { foreach (var data in test_citations) { if (data != 0) { PersonalizedMedicine_User test = DisplayPmids(Convert.ToInt32(userid), data.ToString(), 2, 1); test.Displaydate = !string.IsNullOrEmpty(test.Displaydate) ? test.Displaydate.Substring(0, 4) : null; test.Pmid = Convert.ToInt32(data); test_citlist.Add(test); test.Gene_citationslist = test_citlist; } } return(test_citlist); } return(test_citlist); } }
// For Deleting Specialty public static bool DeleteSpecialty(int specid, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { var Topics = (from s in entity.Topics where s.UserID == UserId && s.Type == 2 && s.SpecialtyID == specid select s.TopicID).ToList(); foreach (var TopicId in Topics) { DeleteUserTopic(entity, TopicId, UserId); } //Nuke all auto-queries associated with this specialty entity.lib_DeleteUserAutoQueries(specid, UserId); // Executing lib_DeleteUserAutoQueries stored procedure // Finally, delete the enclosing specialty itself var UserSpecialtyToBeDelete = entity.UserSpecialties.Where(s => s.SpecialtyID == specid && s.UserID == UserId).FirstOrDefault(); if (UserSpecialtyToBeDelete != null) { entity.UserSpecialties.Remove(UserSpecialtyToBeDelete); } entity.SaveChanges(); return(true); } }
/// <summary> /// TO GET Clinical science links with Geneid /// </summary> /// <param name="geneid"></param> /// <returns></returns> public static List <clinicalsciencelinks> Getclinicallinks(int?geneid) { var linkdata = new List <clinicalsciencelinks>(); using (EditorsEntities entity = new EditorsEntities()) { var clinicallinks = (from csl in entity.GenesArticles where csl.GeneID == geneid select new clinicalsciencelinks { ArticleId = csl.ArticleID, ArticleTitle = csl.ArticleTitle, Year = csl.Year, AuthorList = ((from t1 in entity.ArticlesAuthors where t1.ArticleID == csl.ArticleID select t1.AuthorName).Take(1).FirstOrDefault()) }).ToList(); foreach (var item in clinicallinks) { clinicalsciencelinks linkinfo = new clinicalsciencelinks(); linkinfo.ArticleId = item.ArticleId; linkinfo.ArticleTitle = item.ArticleTitle; linkinfo.Year = item.Year; linkinfo.AuthorList = item.AuthorList; linkinfo.gene = Convert.ToInt32(geneid); linkdata.Add(linkinfo); } return(linkdata); } }
// For Getting All HiddenSubTopics of User public static List <int> GetHiddenSubTopicIds(int UserId) { using (EditorsEntities entity = new EditorsEntities()) { var HiddenSubTopics = entity.HiddenSubTopics.Where(h => h.UserID == UserId).Select(s => s.SubTopicID).ToList(); return(HiddenSubTopics); } }
// For Deleting User Sponsor Topic public static bool DeleteSponsorTopic(int TopicId, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { DeleteUserSposorTopic(entity, TopicId, UserId); return(true); } }
public static List <SelectListItem> GetparticularGeneNames(int?id) { using (EditorsEntities entity = new EditorsEntities()) { var getgenes = (from g in entity.Genes.AsEnumerable().Where(i => i.GeneID == id).OrderBy(k => k.Name) select new SelectListItem { Value = g.GeneID.ToString(), Text = g.Name, Selected = (g.GeneID == id) }).ToList(); return(getgenes); } }
public static List <SelectListItem> GetTestNames(int?id) { using (EditorsEntities entity = new EditorsEntities()) { var test = (from t in entity.Tests.AsEnumerable().OrderBy(k => k.Name) select new SelectListItem { Value = t.TestID.ToString(), Text = t.Name, Selected = (t.TestID == id) }).ToList(); return(test); } }
public static List <SelectListItem> GetGenesForTestByTestID(int?id) { using (EditorsEntities entity = new EditorsEntities()) { var test = (from t in entity.lib_GetGenesForTestByTestID(id).OrderBy(k => k.Name) select new SelectListItem { Value = t.GeneID.ToString(), Text = t.Name }).ToList(); return(test); } }
// To Get PMIDS for Spponsor Citation public static List <PmidClass> GetSponsorPMids(int SubTopicId) { using (EditorsEntities entity = new EditorsEntities()) { string query = "[lib_GetSponsorCitations] @SubTopicID"; SqlParameter p_SubTopicId = new SqlParameter("@SubTopicID", SubTopicId); var PMIDs = entity.Database.SqlQuery <PmidClass>(query, p_SubTopicId).ToList(); return(PMIDs); } }
// To Get Abstract Comments EC public static List <AbstractCommentsECModel> GetAbstractCommentsEC(int MID) { using (EditorsEntities entity = new EditorsEntities()) { string query = "[lib_GetAbstractCommentsEC20] @PMID"; SqlParameter PMID = new SqlParameter("@PMID", MID); var Result = entity.Database.SqlQuery <AbstractCommentsECModel>(query, PMID).ToList(); return(Result); } }
public static List <SelectListItem> GetAliasNameByGeneIDAliasID(int?geneid, int?aliasid) { using (EditorsEntities entity = new EditorsEntities()) { var genes = (from t in entity.GeneAliases.AsEnumerable() where t.GeneID == geneid && t.AliasID == aliasid select t.GeneID).FirstOrDefault(); var getgenes = (from g in entity.Genes.AsEnumerable().Where(i => i.GeneID == genes).OrderBy(k => k.Name) select new SelectListItem { Value = g.GeneID.ToString(), Text = g.Name }).ToList(); return(getgenes); } }
public static List <FolderEditorialComments> GetFolderECComments(int specId) { using (EditorsEntities entity = new EditorsEntities()) { List <FolderEditorialComments> folderECList = null; string query = "lib_GetFoldersEC20Citations @SpecialtyID"; SqlParameter SpecialtyID = new SqlParameter("@SpecialtyID", specId); folderECList = entity.Database.SqlQuery <FolderEditorialComments>(query, SpecialtyID).ToList(); return(folderECList); } }
public static int[] Getpmids(int?Commentid) { using (EditorsEntities entity = new EditorsEntities()) { var getpmids = (from t1 in entity.EditorialComments.AsEnumerable() join t2 in entity.ArticleSelections on t1.ThreadID equals t2.ThreadID where t1.CommentID == Commentid select t2.PMID).ToArray(); return(getpmids); } }
// To Hide UserTopic public static bool HideTopics(List <int> TopicIds, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { foreach (var TopicId in TopicIds) { HideTopic(entity, TopicId, UserId); } entity.SaveChanges(); return(true); } }
public static List <UserFolderListEdit> GetUserFolderListEdit(int SpecId, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { List <UserFolderListEdit> folderList = null; string query = "[lib_GetFolderListSFE] @UserID,@SpecialtyID"; SqlParameter UserID = new SqlParameter("@UserID", UserId); SqlParameter SpecialtyID = new SqlParameter("@SpecialtyID", SpecId); folderList = entity.Database.SqlQuery <UserFolderListEdit>(query, UserID, SpecialtyID).ToList(); return(folderList); } }
// To Add User Specialty public static bool AddUserSpecialty(GetUserSpecialtyModel Model, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { UserSpecialty UsNew = new UserSpecialty(); UsNew.SpecialtyID = (Int32)Model.SelectedSpecialtyId; UsNew.UserID = UserId; UsNew.DateAdded = DateTime.Now; entity.UserSpecialties.Add(UsNew); entity.SaveChanges(); return(true); } }
// For Delete ACR Document Relation public static bool DeleteACRDocumentRelation(int RelId) { using (EditorsEntities entity = new EditorsEntities()) { doc_in_subtopic docRelation = entity.doc_in_subtopic.Find(RelId); if (docRelation != null) { entity.doc_in_subtopic.Remove(docRelation); entity.SaveChanges(); } return(true); } }
public static List <SelectListItem> GetUserSubTopics(int TopicId, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { var Result = entity.lib_GetUserSubTopics(UserId, TopicId).ToList(); var Result1 = Result.Select(s => new SelectListItem { Text = s.SubTopicName, Value = s.SubTopicID.ToString() }).ToList(); return(Result1); } }
// For delete ACR Document public static bool DeleteACRDocument(int docId) { using (EditorsEntities entity = new EditorsEntities()) { doc DeleteDoc = entity.docs.Find(docId); if (DeleteDoc != null) { entity.docs.Remove(DeleteDoc); entity.SaveChanges(); } return(true); } }
static void DeleteUserSposorTopic(EditorsEntities entity, int TopicId, int UserId) { // First need to Get and delete SubTopics in the Topic which is going to Delete var Subtopics = (from s in entity.SubTopics where s.TopicID == TopicId && (((s.Type == 2) && s.UserID == UserId) || s.Type == 3) select s.SubTopicID).ToList(); foreach (var SubTopicId in Subtopics) { DeleteUserSubTopic(entity, SubTopicId, UserId); } entity.lib_RemoveSponsorTopic(UserId, TopicId); entity.SaveChanges(); }
// To Delete UserCitation public static bool DeleteCitation(int fid, int mid, int userid) { using (EditorsEntities entity = new EditorsEntities()) { UserCitation UC = entity.UserCitations.Where(c => c.UserID == userid && c.PMID == mid && c.SubTopicID == fid).FirstOrDefault(); if (UC != null) { UC.Deleted = true; entity.Entry(UC).State = EntityState.Modified; entity.SaveChanges(); } return(true); } }
public static PersonalizedMedicine_User GetTestDetails(int?testid) { using (EditorsEntities entity = new EditorsEntities()) { var gettests = (from tests in entity.Tests.AsEnumerable() where tests.TestID == Convert.ToInt64(testid) select new PersonalizedMedicine_User { Name = tests.Name, Summary = tests.Summary }).FirstOrDefault(); return(gettests); } }
public static UserCommentAbstract GetUserComment(int Mid, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { var Result = (from uc in entity.UserComments where uc.pmid == Mid && uc.userid == UserId select new UserCommentAbstract { nickname = uc.nickname, comment = uc.comment, updatedate = uc.updatedate }).FirstOrDefault(); return(Result); } }
// To Add User Topic public static bool AddTopic(int SpecId, string TopicName, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { Topic NewUserTopic = new Topic(); NewUserTopic.TopicName = TopicName; NewUserTopic.SpecialtyID = SpecId; NewUserTopic.Type = 2; // 2 Represents User Topic NewUserTopic.UserID = UserId; NewUserTopic.createtime = DateTime.Now; entity.Topics.Add(NewUserTopic); entity.SaveChanges(); return(true); } }
public static bool checkGeneexists(int?geneid) { using (EditorsEntities entity = new EditorsEntities()) { var check = entity.Genes.Any(i => i.GeneID == geneid); if (check == true) { return(true); } else { return(false); } } }
public static bool checkTestexists(int?testid) { using (EditorsEntities entity = new EditorsEntities()) { var check = entity.Tests.Any(i => i.TestID == testid); if (check == true) { return(true); } else { return(false); } } }