public Owner GetOwner(Cat inCat) { Owner owner = new Owner { Name = DefaultOwnerName, }; if (Equals(null, _session) || Equals(null, inCat)) { return(owner); } try { List <Owner> owners = new List <DataDriver.Owner>( from cat in NHibernateTest.Load <Cat>( String.Format("FROM Cat WHERE CatKey={0}", inCat.Id), _session).Cast <Cat>() select cat.MyOwner) ; if (owners.Count > 0) { return(owners[0]); } } catch (Exception ex) { Debug.WriteLine(ex.Message); Debug.WriteLine(ex.StackTrace); } return(owner); }
public IEnumerable <T> GetAll <T>() where T : class { if (Equals(null, _session)) { return(new List <T>()); } return (from t in NHibernateTest.Load <T>(String.Empty, _session).Cast <T>() select t); }
public IEnumerable <Meal> GetMeals(Cat cat) { if (Equals(null, _session)) { return(new List <Meal>()); } return (from meal in NHibernateTest.Load <Meal>( String.Format("FROM Meal WHERE CatKey = {0}", cat.Id.ToString()), _session).Cast <Meal>() select meal); }
private Nom GetNom(string query, ISession session) { IEnumerable <Nom> noms = from test in NHibernateTest.Load <Nom>(query, _session).Cast <Nom>() select test; if (noms.Count <Nom>() > 0) { return(noms.ElementAt <Nom>(0)); } return(null); }
public void GetCurrentWeight(Cat cat) { if (Equals(null, _session)) { return; } var weights = from weight in NHibernateTest.Load <Weight>( String.Format("FROM Weight WHERE CatKey = {0} ORDER BY Date desc", cat.Id), _session).Cast <Weight>() select weight; if (weights.Count <Weight>() > 0) { cat.CurrentWeight = weights.ElementAt <Weight>(0); } }
public Owner GetOwner(string ownerName) { List <Owner> owners = new List <Owner>( from owner in NHibernateTest.Load <Owner>( String.Format("FROM Owner WHERE Name = {0}", ownerName), _session).Cast <Owner>() select owner); if (1 == owners.Count) { return(owners[0]); } if (0 == owners.Count) { Owner owner = new Owner(ownerName); SaveObject <Owner>(owner); return(owner); } return(null); }
public List <Cat> GetCats() { List <Cat> cats = new List <Cat>(); if (Equals(null, _session)) { return(cats); } try { cats.AddRange( from cat in NHibernateTest.Load <Cat>(String.Empty, _session).Cast <Cat>() where cat.Id >= 0 select cat) ; } catch (Exception ex) { cats = new List <Cat>(); Debug.WriteLine(ex.Message); Debug.WriteLine(ex.StackTrace); } return(cats); }
public List <Cat> GetOwnerCats(int ownerId) { List <Cat> cats = new List <Cat>(); if (Equals(null, _session)) { return(cats); } Owner owner = (from test in NHibernateTest.Load <Owner>( String.Format("FROM Owner WHERE OwnerKey={0}", ownerId), _session).Cast <Owner>() select test).First <Owner>(); if (Equals(null, owner)) { return(cats); } foreach (Cat aCat in owner.MyCats) { GetCurrentWeight(aCat); cats.Add(aCat); } return(cats); }