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