public ActionResult Establishment(EstablishmentSearch search)
{
using (var session = NHibernateHelper.CreateSessionFactory())
{
using (var transaction = session.BeginTransaction())
{
var registrations = new List <Registration>(session.CreateCriteria(typeof(Registration)).List <Registration>());
if (!String.IsNullOrEmpty(search.EstablishmentName))
{
registrations = registrations.Where(s => s.EstablishmentName.ToLower().Contains(search.EstablishmentName.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.PhermcRegistrationNumber))
{
registrations = registrations.Where(s => s.PhermcRegistrationNumber.ToLower().Contains(search.PhermcRegistrationNumber.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.CacNumber))
{
registrations = registrations.Where(s => s.CacNumber.ToLower().Contains(search.CacNumber.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.Location))
{
registrations = registrations.Where(s => s.CacNumber.ToLower().Contains(search.Location.ToLower())).ToList();
}
registrations = registrations.Where(s => s.RegistrationDate >= search.RegistrationDateFrom.DayMin()).ToList();
if (search.RegistrationDateTo.Equals(DateTime.MinValue))
{
registrations = registrations.Where(s => s.RegistrationDate <= DateTime.MaxValue).ToList();
}
else
{
registrations = registrations.Where(s => s.RegistrationDate <= search.RegistrationDateTo.DayMax()).ToList();
}
/*
* registrations = registrations.Where(s => s.LastRenewalDate >= search.LastRenewalDateFrom.DayMin()).ToList();
*
* if (search.LastRenewalDateTo.Equals(DateTime.MinValue))
* {
* registrations = registrations.Where(s => s.LastRenewalDate <= DateTime.MaxValue).ToList();
* }
* else
* {
* registrations = registrations.Where(s => s.LastRenewalDate <= search.LastRenewalDateTo.DayMax()).ToList();
* }*/
registrations.ForEach(x =>
{
//if (x.State != null) x.State.Locations = null;
});
return(Content(WebApiHelper.ObjectToJsonString(registrations), "application/json"));
}
}
}
public ActionResult Establishment(EstablishmentSearch search)
{
using (var session = NHibernateHelper.CreateSessionFactory())
{
using (var transaction = session.BeginTransaction())
{
var registrations = new List<Registration>(session.CreateCriteria(typeof(Registration)).List<Registration>());
if (!String.IsNullOrEmpty(search.EstablishmentName))
{
registrations = registrations.Where(s => s.EstablishmentName.ToLower().Contains(search.EstablishmentName.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.PhermcRegistrationNumber))
{
registrations = registrations.Where(s => s.PhermcRegistrationNumber.ToLower().Contains(search.PhermcRegistrationNumber.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.CacNumber))
{
registrations = registrations.Where(s => s.CacNumber.ToLower().Contains(search.CacNumber.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(search.Location))
{
registrations = registrations.Where(s => s.CacNumber.ToLower().Contains(search.Location.ToLower())).ToList();
}
registrations = registrations.Where(s => s.RegistrationDate >= search.RegistrationDateFrom.DayMin()).ToList();
if (search.RegistrationDateTo.Equals(DateTime.MinValue))
{
registrations = registrations.Where(s => s.RegistrationDate <= DateTime.MaxValue).ToList();
}
else
{
registrations = registrations.Where(s => s.RegistrationDate <= search.RegistrationDateTo.DayMax()).ToList();
}
/*
registrations = registrations.Where(s => s.LastRenewalDate >= search.LastRenewalDateFrom.DayMin()).ToList();
if (search.LastRenewalDateTo.Equals(DateTime.MinValue))
{
registrations = registrations.Where(s => s.LastRenewalDate <= DateTime.MaxValue).ToList();
}
else
{
registrations = registrations.Where(s => s.LastRenewalDate <= search.LastRenewalDateTo.DayMax()).ToList();
}*/
registrations.ForEach(x =>
{
//if (x.State != null) x.State.Locations = null;
});
return Content(WebApiHelper.ObjectToJsonString(registrations), "application/json");
}
}
}