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);
}
}
}
