/// <summary>
/// Gets all the visits in the year provided
/// </summary>
/// <param name="p">The year to get the visits in</param>
/// <returns>A list of all the kids that visited this year</returns>
internal static List <Kid> GetVisitByYear(string p)
{
List <Visit> list = null;
List <Kid> kids;
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
var res = session.CreateQuery(" FROM Visit WHERE DATEPART(YEAR, VisitTime) like :year")
.SetParameter("year", p)
.List <Visit>();
list = (List <Visit>)res;
}
kids = KidProvider.GetKidsBasedOnIdInVisit(list);
}
return(kids);
}
internal static List <Kid> GetTodaysVisitKids()
{
List <Visit> list = null;
List <Kid> kids;
BindingList <StringValue> result = new BindingList <StringValue>();
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
var res = session.CreateQuery(" FROM Visit WHERE VisitTime >= DATEADD(DAY, DATEDIFF(DAY, '19000101', GETDATE()), '19000101')" +
"AND VisitTime < DATEADD(DAY, DATEDIFF(DAY, '18991231', GETDATE()), '19000101')")
.List <Visit>();
list = (List <Visit>)res;
}
kids = KidProvider.GetKidsBasedOnIdInVisit(list);
}
return(kids);
}
internal static System.ComponentModel.BindingList <StringValue> GetTodaysVisits()
{
List <Visit> list = null;
BindingList <StringValue> result = new BindingList <StringValue>();
using (ISession session = NHibernateHelper.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
var res = session.CreateQuery(" FROM Visit WHERE VisitTime >= DATEADD(DAY, DATEDIFF(DAY, '19000101', GETDATE()), '19000101')" +
"AND VisitTime < DATEADD(DAY, DATEDIFF(DAY, '18991231', GETDATE()), '19000101')")
.List <Visit>();
list = (List <Visit>)res;
}
var kids = KidProvider.GetKidsBasedOnIdInVisit(list);
foreach (var item in kids)
{
result.Add(new StringValue(item.FirstName));
}
}
return(result);
}
