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