public System.Collections.IList GetComuneByFiscalCode(string code)
{
Query query = _ps.CreateNewQuery("MapperComune");
query.SetTable("TB_COMUNI");
AbstractBoolCriteria crit = Criteria.Equal("CODICE_FISCALE", "'" + code.Replace("'", "''") + "'");
query.AddWhereClause(crit);
IList l = query.Execute(_ps);
return(l);
}
public IList GetCheckins(DateTime date)
{
IList result = null;
IPersistenceFacade _ps = DataAccessServices.Instance().PersistenceFacade;
Query q = _ps.CreateNewQuery("MapperCheckin");
AbstractBoolCriteria c = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
c.AddCriteria(Criteria.DateTimeContained("Checkin", date.Date, date.AddDays(1).Date.AddSeconds(-1), _ps.DBType));
q.AddWhereClause(c);
string p = q.CreateQuery(_ps);
result = q.Execute(_ps);
IList result1 = new ArrayList();
foreach (Checkin item in result)
{
result1.Add(new ArrivedPerson(item));
}
return(result1);
}
public IList GetPaymentStatistics(int year)
{
IPersistenceFacade _ps = DataAccessServices.Instance().PersistenceFacade;
Query q = _ps.CreateNewQuery("MapperPaymentStatistics");
q.SetTable(string.Format("dbo.GetCollectsByYear({0})", year.ToString()));
return(q.Execute(_ps));
}
public IInstallInfo GetInstallInfo()
{
IPersistenceFacade svc = DataAccessServices.Instance().PersistenceFacade;
Query q = svc.CreateNewQuery("MapperLicInfo");
q.AddWhereClause(Criteria.MatchesEqual("HardwareId", _hardwareId, svc.DBType));
IList i = q.Execute(svc);
if (i.Count == 0)
{
return(null);
}
return((IInstallInfo)((LicInfo)i[0]).InstallationInfo);
}
public IUser GetUser(string username, string password)
{
Query query = ps.CreateNewQuery("MapperUser");
CompositeCriteria mainCriteria = new CompositeCriteria(AbstractBoolCriteria.Operatore.AndOp);
mainCriteria.AddCriteria(Criteria.Equal("Username", "'" + username + "'"));
#if (FENEAL)
mainCriteria.AddCriteria(Criteria.Equal("Password", "'" + password + "'"));
#else
mainCriteria.AddCriteria(Criteria.Equal("Passwordd", "'" + password + "'"));
#endif
query.AddWhereClause(mainCriteria);
IList list = query.Execute(ps);
if (list.Count == 0)
{
return(null);
}
return(list[0] as IUser);
}
