public List <VetVisitModel> GetAllVetVisitForDog(DogId dogId) { List <VetVisitModel> models; using (ISession session = NHibernateSession.OpenSession()) // Open a session to conect to the database { var model = session.Query <VetVisit>().Where(c => !c.Deleted.HasValue && c.Dog.DogId == dogId.Value); models = model.Select(x => x.ToVetVisitModel()).ToList(); // Querying to get all the users } return(models); }
public List <FoodModel> GetAllFoodForDog(DogId dogId) { List <FoodModel> foodModels; using (ISession session = NHibernateSession.OpenSession()) // Open a session to conect to the database { var food = session.Query <Food>().Where(c => !c.Deleted.HasValue && c.Dog.DogId == dogId.Value); foodModels = food.Select(x => x.ToFoodModel()).ToList(); // Querying to get all the users } return(foodModels); }
public List <HealthModel> GetAllHealthForDog(DogId dogId) { List <HealthModel> healthModels; using (ISession session = NHibernateSession.OpenSession()) // Open a session to conect to the database { var health = session.Query <Health>().Where(c => !c.Deleted.HasValue && c.Dog.DogId == dogId.Value); healthModels = health.Select(x => x.ToHealthModel()).ToList(); // Querying to get all the users } return(healthModels); }
public List <IncidentModel> GetAllIncidentForDog(DogId dogId) { List <IncidentModel> incidentModels; using (ISession session = NHibernateSession.OpenSession()) // Open a session to conect to the database { var incident = session.Query <Incident>().Where(c => !c.Deleted.HasValue && c.Dog.DogId == dogId.Value); incidentModels = incident.Select(x => x.ToIncidentModel()).ToList(); // Querying to get all the users } return(incidentModels); }
public DogModel GetDogById(DogId dogId) { DogModel dogModel = new DogModel(); using (ISession session = NHibernateSession.OpenSession()) // Open a session to conect to the database { var dog = session.Query <Dog>().FirstOrDefault(c => c.DogId == dogId.Value); if (dog != null) { dogModel = dog.ToDogModel(); } } return(dogModel); }
public DogModel GetDogById(DogId dogId) { return(_dogRepository.GetDogById(dogId)); }