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