public List <View_Mag> SearchByDescription(string Desc) { List <View_Mag> a = new List <View_Mag>(); List <View_Mag> ret = new List <View_Mag>(); if (Desc != "") { var result = from i in db.articolis where i.DESCRIZIONE.Contains(Desc) select i; a = db.View_Mags.ToList(); foreach (articoli r in result) { View_Mag vm = new View_Mag(); vm = a.Where(x => x.ID == r.ID).FirstOrDefault(); if (vm != null) { ret.Add(vm); } } } if (ret != null) { return(ret); } else { return(null); } }
public View_Mag GetViwArticolo(int id) { View_Mag art = new View_Mag(); art = db.View_Mags.FirstOrDefault(x => x.ID == id); if (art != null) { return(art); } else { return(null); } }