public static Species GetSpecies(int id) { using (var db = new FloraModel()) { return(db.Specieses.Single(p => p.SpeciesId == id)); } }
public static Species GetSpecies(string name) { using (var db = new FloraModel()) { return(db.Specieses.Single(p => p.BinomialName == name)); } }
public static Genus GetGenus(string name) { using (var db = new FloraModel()) { return(db.Genera.Single(p => p.Name == name)); } }
public static bool IsExist(int id) { using (var db = new FloraModel()) { return(db.Phylums.Single(p => p.PhylumId == id) != null); } }
public static Classe GetClasse(int id) { using (var db = new FloraModel()) { return(db.Classes.Single(p => p.ClasseId == id)); } }
public SpeciesSelected GetSpecies(string query) { SpeciesSelected ss; using (var db = new FloraModel()) { try { var species = (from s in db.Specieses where s.CommonName == query || s.BinomialName == query select s).First(); ss = new SpeciesSelected { Species = species, Photo = db.Photos.Single(p => p.SpeciesForeignKey == species.SpeciesId), Genus = db.Genera.Single(g => g.GenusId == species.GenusForeignKey) }; ss.Family = db.Families.Single(f => f.FamilyId == ss.Genus.FamilyForeignKey); ss.Order = db.Orders.Single(o => o.OrderId == ss.Family.OrderForeignKey); ss.Classe = db.Classes.Single(c => c.ClasseId == ss.Order.ClasseForeignKey); ss.Phylum = db.Phylums.Single(p => p.PhylumId == ss.Classe.PhylumForeignKey); ss.Kingdom = db.Kingdoms.Single(k => k.KingdomId == ss.Phylum.KingdomForeignKey); return(ss); } catch (Exception) { return(null); } } }
public void GetData(Action <List <TileSpecies>, Exception> callback) { // Use this to connect to the actual data service using (var db = new FloraModel()) { var speciesList = (from s in db.Specieses select s).ToList(); var tileSpeciesList = new List <TileSpecies>(); foreach (var species in speciesList) { var t = new TileSpecies(); t.SpeciesId = species.SpeciesId; t.Binomial = species.BinomialName; t.CommonName = species.CommonName; try { var p = species.Photos.First(); t.PhotoId = p.PhotoId; t.PhotoUrl = p.Url; } catch (Exception ex) { } tileSpeciesList.Add(t); } callback(tileSpeciesList, null); } }
public static Kingdom GetKingdom(string name) { using (var db = new FloraModel()) { return(db.Kingdoms.Single(k => k.Name == name)); } }
public static Order GetOrder(string name) { using (var db = new FloraModel()) { return(db.Orders.Single(p => p.Name == name)); } }
public static bool IsExist(int id) { using (var db = new FloraModel()) { return(db.Kingdoms.Single(k => k.KingdomId == id) != null); } }
public static Order GetOrder(int id) { using (var db = new FloraModel()) { return(db.Orders.Single(p => p.OrderId == id)); } }
public static Phylum GetPhylum(int id) { using (var db = new FloraModel()) { return(db.Phylums.Single(p => p.PhylumId == id)); } }
public static bool IsExist(int id) { using (var db = new FloraModel()) { return(db.Families.Single(p => p.FamilyId == id) != null); } }
public static Genus GetGenus(int id) { using (var db = new FloraModel()) { return(db.Genera.Single(p => p.GenusId == id)); } }
public static Classe GetClasse(string name) { using (var db = new FloraModel()) { return(db.Classes.Single(p => p.Name == name)); } }
public static bool IsExist(int id) { using (var db = new FloraModel()) { return(db.Genera.Single(p => p.GenusId == id) != null); } }
public static Phylum GetPhylum(string name) { using (var db = new FloraModel()) { return(db.Phylums.Single(p => p.Name == name)); } }
public static Family GetFamily(int id) { using (var db = new FloraModel()) { return(db.Families.Single(p => p.FamilyId == id)); } }
public static Family GetFamily(string name) { using (var db = new FloraModel()) { return(db.Families.Single(p => p.Name == name)); } }
public static Kingdom GetKingdom(int id) { using (var db = new FloraModel()) { return(db.Kingdoms.Single(k => k.KingdomId == id)); } }
public static Photo GetPhoto(int id) { using (var db = new FloraModel()) { return(db.Photos.Single(p => p.PhotoId == id)); } }
public static void Save(Order order) { using (var db = new FloraModel()) { db.Orders.AddOrUpdate(order); db.SaveChanges(); } }
public static void Save(Family family) { using (var db = new FloraModel()) { db.Families.AddOrUpdate(family); db.SaveChanges(); } }
public static void SaveKingdom(Kingdom kingdom) { using (var db = new FloraModel()) { db.Kingdoms.AddOrUpdate(kingdom); db.SaveChanges(); } }
public static void Save(Photo photo) { using (var db = new FloraModel()) { db.Photos.AddOrUpdate(photo); db.SaveChanges(); } }
public static void Save(Species species) { using (var db = new FloraModel()) { db.Specieses.AddOrUpdate(species); db.SaveChanges(); } }
public static void Save(Classe classe) { using (var db = new FloraModel()) { db.Classes.AddOrUpdate(classe); db.SaveChanges(); } }
public static void Save(Phylum phylum) { using (var db = new FloraModel()) { db.Phylums.AddOrUpdate(phylum); db.SaveChanges(); } }
public static void Save(Genus genus) { using (var db = new FloraModel()) { db.Genera.AddOrUpdate(genus); db.SaveChanges(); } }
public static bool IsExist(string name) { using (var db = new FloraModel()) { try { db.Phylums.Single(p => p.Name == name); return(true); } catch (InvalidOperationException) { return(false); } } }