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