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