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