public ActionResult personalized_medicine(int?geneid, string aliasid, int?testid)
{
var pmusermodel = new PersonalizedMedicine_User();
pmusermodel.checkgene = PersonalizedMedicine.checkGeneexists(geneid);
pmusermodel.checktest = PersonalizedMedicine.checkTestexists(testid);
pmusermodel.GetGenealiases = PersonalizedMedicine.GetGenealiases(geneid);
pmusermodel.GeneTestlist = PersonalizedMedicine.GetTestNames(testid);
pmusermodel.Geneslist = PersonalizedMedicine.GetGeneNames(geneid);
if (geneid != null && pmusermodel.checkgene)
{
pmusermodel = PersonalizedMedicine.GetGeneDetails(geneid);
pmusermodel.GetGeneComments = PersonalizedMedicine.getCommentsSection(geneid);
pmusermodel.GetRelatededitorscomments = PersonalizedMedicine.getRelatedEditorsChoiceSection(geneid, CurrentUser.UserId);
pmusermodel.Getclinicalinks = PersonalizedMedicine.Getclinicallinks(geneid);
pmusermodel.Gene_citationslist = PersonalizedMedicine.GetGeneCitations(CurrentUser.UserId, geneid);
pmusermodel.GetGeneslinks = PersonalizedMedicine.Getlinkinfo(geneid);
pmusermodel.GetGenealiases = PersonalizedMedicine.GetGenealiases(geneid);
pmusermodel.GeneTestlist = PersonalizedMedicine.GetTestsforGenebygeneid(geneid);
pmusermodel.Geneslist = PersonalizedMedicine.GetGeneNames(geneid);
if (!string.IsNullOrEmpty(aliasid))
{
pmusermodel.Geneslist = PersonalizedMedicine.GetparticularGeneNames(geneid);
}
}
if (testid != null && pmusermodel.checktest)
{
pmusermodel = PersonalizedMedicine.GetTestDetails(testid);
pmusermodel.GetTestComments = PersonalizedMedicine.getTestCommentsSection(testid);
pmusermodel.GetRelatededitorsTestcomments = PersonalizedMedicine.getRelatedEditorsTestChoiceSection(testid, CurrentUser.UserId);
pmusermodel.Test_citationslist = PersonalizedMedicine.GetTestCitations(CurrentUser.UserId, testid);
pmusermodel.GetTestslinks = PersonalizedMedicine.GetTestlinkinfo(testid);
pmusermodel.GetGenesrelatedtoTest = PersonalizedMedicine.GetGenesForTestByTestID(testid);
pmusermodel.GetGenealiases = PersonalizedMedicine.GetGenealiases(geneid);
pmusermodel.GeneTestlist = PersonalizedMedicine.GetTestNames(testid);
pmusermodel.Geneslist = PersonalizedMedicine.GetparticularGeneNames(geneid);
}
if (geneid != null)
{
pmusermodel.GeneId = Convert.ToInt32(geneid);
}
if (testid != null)
{
pmusermodel.TestId = Convert.ToInt32(testid);
}
pmusermodel.checkgene = PersonalizedMedicine.checkGeneexists(geneid);
pmusermodel.checktest = PersonalizedMedicine.checkTestexists(testid);
if ((geneid != null && pmusermodel.checkgene == false) || (testid != null && pmusermodel.checktest == false))
{
pmusermodel.Geneslist = PersonalizedMedicine.GetGeneNames(geneid);
}
return(View(pmusermodel));
}
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);
}
}
public PartialViewResult Editclinicallinks(PersonalizedMedicine_User gene)
{
var pmusermodel = new PersonalizedMedicine_User();
pmusermodel.Getclinicalinks = PersonalizedMedicine.Getclinicallinks(gene.GeneId);
return(PartialView("_Clinicalsciencelinks", pmusermodel));
}
//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);
}
}
public ActionResult GetGenealiasbyGeneId(PersonalizedMedicine_User gene)
{
var pmmodel = new PersonalizedMedicine_User(); var pmusermodel = new List <PersonalizedMedicine_User>();
// List<SelectListItem> genealis = PersonalizedMedicine.GeneGenesalias(gene.GeneId);
List <SelectListItem> genetests = PersonalizedMedicine.GetTestsforGenebygeneid(gene.GeneId);
pmusermodel = PersonalizedMedicine.GetaliasesforGene(gene.GeneId);
pmmodel.GetGenealiases = PersonalizedMedicine.GetGenealiases(gene.GeneId);
pmmodel.GeneTestlist = PersonalizedMedicine.GetTestNames(gene.TestId);
return(Json(new { pmusermodel, genetests, pmmodel.GetGenealiases, pmmodel.GeneTestlist }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetGeneandTestsbyaliasID(PersonalizedMedicine_User gene)
{
var pmusermodel = new PersonalizedMedicine_User();
List <SelectListItem> getgenesbyaliasid = PersonalizedMedicine.GetAliasNameByGeneIDAliasID(gene.GeneId, Convert.ToInt32(gene.aliasid));
List <SelectListItem> genestest = PersonalizedMedicine.GetGenesForTestByTestID(gene.GeneId);
// pmusermodel.GetAttachedGenealias = PersonalizedMedicine.GetAttachedGenealiastoTest(gene.TestId);
pmusermodel.Geneslist = PersonalizedMedicine.GetGeneNames(gene.GeneId);
pmusermodel.GeneTestlist = PersonalizedMedicine.GetTestNames(gene.TestId);
return(Json(new { getgenesbyaliasid, genestest, pmusermodel.Geneslist, pmusermodel.GeneTestlist }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetGenealiasbyTestid(PersonalizedMedicine_User gene)
{
var pmusermodel = new PersonalizedMedicine_User();
pmusermodel.GetAttachedGenealias = PersonalizedMedicine.GetAttachedGenealiastoTest(gene.TestId);
List <SelectListItem> genestest = PersonalizedMedicine.GetGenesForTestByTestID(gene.TestId);
pmusermodel.Geneslist = PersonalizedMedicine.GetGeneNames(gene.GeneId);
//pmusermodel.GeneTestlist = PersonalizedMedicine.GetTestNames(gene.TestId);
pmusermodel.GetGenealiases = PersonalizedMedicine.GetGenealiases(gene.GeneId);
return(Json(new { pmusermodel.GetAttachedGenealias, genestest, pmusermodel.Geneslist, pmusermodel.GetGenealiases }, JsonRequestBehavior.AllowGet));
}
//lib_GetEditorsChoiceCommentsCitationsForCommentByCommentID
public static PersonalizedMedicine_User DisplayPmids(int?UserID, string PMIDList, int?DisplayMode, byte?SearchSort)
{
using (Cogent3Entities entity = new Cogent3Entities())
{
PersonalizedMedicine_User result = null;
string query = "[ap_DisplayPMID] @UserID,@PMIDList,@DisplayMode,@SearchSort";
SqlParameter UserIDs = new SqlParameter("@UserID", UserID);
SqlParameter PMIDSlst = new SqlParameter("@PMIDList", PMIDList);
SqlParameter DisplayModes = new SqlParameter("@DisplayMode", DisplayMode);
SqlParameter SearchSorts = new SqlParameter("@SearchSort", SearchSort);
result = entity.Database.SqlQuery <PersonalizedMedicine_User>(query, UserIDs, PMIDSlst, DisplayModes, SearchSorts).FirstOrDefault();
return(result);
}
}
//lib_GetTestCommentsByTestID
//lib_GetTestCommentSTSByTestID
/// <summary>
/// To get Test Comments with Testid
/// </summary>
/// <param name="testid"></param>
/// <returns></returns>
public static List <PersonalizedMedicine_User> getTestCommentsSection(int?testid)
{
var Getcommentslist = new List <PersonalizedMedicine_User>();
using (EditorsEntities entity = new EditorsEntities())
{
var commentslist = new List <PersonalizedMedicine_User>();
var getcomments = (from tc in entity.TestComments
join ca in entity.CommentAuthors on tc.id equals ca.id
where tc.TestID == testid
select new PersonalizedMedicine_User
{
CommentID = tc.CommentID,
Commnet = tc.Comment,
CommnetDate = tc.CommentDate,
Author = ca.name
}).ToList();
if (getcomments != null && getcomments.Count != 0)
{
foreach (var data in getcomments)
{
var comments = new PersonalizedMedicine_User();
comments.CommentID = data.CommentID;
comments.Commnet = data.Commnet;
comments.CommnetDate = data.CommnetDate;
comments.Author = data.Author;
comments.GetTestspecialties = (from tcc in entity.TestCommentCombos
join sc in entity.Specialties on tcc.SpecialtyID equals sc.SpecialtyID
join tp in entity.Topics on tcc.TopicID equals tp.TopicID
join sbp in entity.SubTopics on tcc.SubTopicID equals sbp.SubTopicID
where tcc.TestID == testid && tcc.CommentID == data.CommentID
select new PersonalizedMedicinespecialties
{
SpecialtyName = sc.SpecialtyName,
Topicname = tp.TopicName,
Subtopicname = sbp.SubTopicName
}).ToList();
commentslist.Add(comments);
Getcommentslist = commentslist;
}
return(Getcommentslist);
}
return(Getcommentslist);
}
}
public static List <PersonalizedMedicine_User> getRelatedEditorsChoiceSection(int?Geneid, int?Userid)
{
var editorcommentslist = new List <PersonalizedMedicine_User>();
int[] newpmid;
using (EditorsEntities entity = new EditorsEntities())
{
var getrelatededitorscomments = (entity.lib_GetEditorsChoiceCommentsForGeneByGeneID(Geneid)).ToList();
var commentslist = new List <PersonalizedMedicine_User>();
foreach (var item in getrelatededitorscomments)
{
var editorcmnts = new PersonalizedMedicine_User();
newpmid = Getpmids(item.CommentID);
foreach (var data in newpmid)
{
editorcmnts = DisplayPmids(Userid, data.ToString(), 2, 1);
editorcmnts.EditorCommentID = item.CommentID;
editorcmnts.EditorCommnet = item.Comment;
editorcmnts.EditorCommentDate = Convert.ToInt32(item.CommentDate);
editorcmnts.EditorCommentMonth = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToInt32(item.CommentMonth));
editorcmnts.EditorCommentAuthor = item.Author;
editorcmnts.Getspecialties = (from ecc in entity.EditorialComments
join stref in entity.SubTopicReferences on ecc.ThreadID equals stref.ThreadID
join sbtpc in entity.SubTopics on stref.SubTopicID equals sbtpc.SubTopicID
join tpc in entity.Topics on sbtpc.TopicID equals tpc.TopicID
join sp in entity.Specialties on tpc.SpecialtyID equals sp.SpecialtyID
where ecc.CommentID == item.CommentID
select new PersonalizedMedicinespecialties
{
SpecialtyName = sp.SpecialtyName,
Topicname = tpc.TopicName,
Subtopicname = sbtpc.SubTopicName
}).ToList();
commentslist.Add(editorcmnts);
editorcommentslist = commentslist;
}
}
return(editorcommentslist);
}
}
public static List <PersonalizedMedicine_User> GetaliasesforGene(int?geneid)
{
var attchgenes = new List <PersonalizedMedicine_User>();
using (EditorsEntities entity = new EditorsEntities())
{
var getlist = new List <PersonalizedMedicine_User>();
var getgeneid = entity.GeneAliases.AsEnumerable().Where(i => i.GeneID == geneid).ToList();
foreach (var data in getgeneid)
{
var attchedtestgenes = new PersonalizedMedicine_User();
attchedtestgenes.Attachedgene = data.AliasName;
attchedtestgenes.aliasid = data.AliasID + "_" + data.GeneID;
getlist.Add(attchedtestgenes);
attchgenes = getlist;
}
return(attchgenes);
}
}
public static List <PersonalizedMedicine_User> GetAttachedGenealiastoTest(int?testid)
{
var attchgenes = new List <PersonalizedMedicine_User>();
using (EditorsEntities entity = new EditorsEntities())
{
var getlist = new List <PersonalizedMedicine_User>();
var getgeneid = entity.lib_GetGenesForTestByTestID(testid).ToList();
foreach (var data in getgeneid)
{
var getgalias = entity.GeneAliases.AsEnumerable().Where(i => i.GeneID == data.GeneID).ToList();
foreach (var item in getgalias)
{
var attchedtestgenes = new PersonalizedMedicine_User();
attchedtestgenes.Attachedgene = item.AliasName;
attchedtestgenes.aliasid = item.AliasID + "_" + item.GeneID;
getlist.Add(attchedtestgenes);
attchgenes = getlist;
}
}
return(attchgenes);
}
}
public static List <PersonalizedMedicine_User> GetGenealiases(int?geneid)
{
bool check = checkGeneexists(geneid);
if (geneid != null && geneid != 0 && check)
{
var genealiasdata = new List <PersonalizedMedicine_User>();
using (EditorsEntities entity = new EditorsEntities())
{
var genes = (from gl in entity.GeneAliases.Where(i => i.GeneID == geneid).OrderBy(k => k.AliasName) select gl).ToList();
foreach (var item in genes)
{
var getgenealias = new PersonalizedMedicine_User();
getgenealias.aliasid = item.AliasID + "_" + item.GeneID;
getgenealias.GeneAlias = item.AliasName;
genealiasdata.Add(getgenealias);
}
return(genealiasdata);
}
}
else
{
var genealiasdata = new List <PersonalizedMedicine_User>();
using (EditorsEntities entity = new EditorsEntities())
{
var genes = (from gl in entity.GeneAliases.OrderBy(k => k.AliasName) select gl).ToList();
foreach (var item in genes)
{
var getgenealias = new PersonalizedMedicine_User();
getgenealias.aliasid = item.AliasID + "_" + item.GeneID;
getgenealias.GeneAlias = item.AliasName;
genealiasdata.Add(getgenealias);
}
return(genealiasdata);
}
}
}
