public IList GetBookings(DataRange period)
{
if (period == null)
{
throw new Exception("Periodo non valido!");
}
if (period.IsEmpty())
{
throw new Exception("Periodo non valido!");
}
Query q = _ps.CreateNewQuery("MapperBooking");
AbstractBoolCriteria c = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
c.AddCriteria(Criteria.DateTimeContained("Date", period.Start.Date, period.Finish.Date.AddDays(1).AddSeconds(-1), _ps.DBType));
q.AddWhereClause(c);
string sss = q.CreateQuery(_ps);
return(q.Execute(_ps));
}
public PeriodAppointmentDTO(PeriodAppointmentDTOEnum state, DataRange range, bool findAlsoOverlappedAppointments, bool noPeriod)
{
_findAlsoOverlappedAppointments = findAlsoOverlappedAppointments;
_state = state;
_range = range;
_noPeriod = noPeriod;
if (_range == null)
{
_range = AppointmentUtils.CreateRangeForQuery(new DataRange(DateTime.Now, DateTime.Now));
}
if (_range.IsEmpty())
{
_range = AppointmentUtils.CreateRangeForQuery(new DataRange(DateTime.Now, DateTime.Now));
}
}
public WIN.TECHNICAL.PERSISTENCE.AbstractBoolCriteria GenerateSql()
{
bool modified = false;
CompositeCriteria c = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
if (!string.IsNullOrEmpty(_subject))
{
c.AddCriteria(Criteria.Matches("Subject", _subject, DataAccessServices.Instance().PersistenceFacade.DBType));
modified = true;
}
if (!string.IsNullOrEmpty(_priority))
{
PriorityType t = (PriorityType)Enum.Parse(typeof(PriorityType), _priority);
c.AddCriteria(Criteria.Equal("Priority", Convert.ToInt32(t).ToString()));
modified = true;
}
if (!_range.IsEmpty())
{
DataRange r = AppointmentUtils.CreateRangeForQuery(_range);
c.AddCriteria(Criteria.DateTimeContained("OutcomeDate", r.Start, r.Finish, DataAccessServices.Instance().PersistenceFacade.DBType));
modified = true;
}
CompositeCriteria c1 = CreateStapeCriteria();
if (c1 != null)
{
c.AddCriteria(c1);
modified = true;
}
if (modified)
{
return(c);
}
return(null);
}
