public int GetCountTranslatedList(SuGlobalTranslate criteria, short languageId)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuGlobalTranslateQuery,
"FindGlobalTranslateSearchResult",
new object[] { criteria, languageId, string.Empty, true }));
}
public int GetCountUserLoginLoglist(DateTime?fromDate, DateTime?toDate, string UserName, string Status)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuUserLogQuery,
"FindSuUserLoginLogSearchResult",
new object[] { fromDate, toDate, UserName, Status, string.Empty, true }));
}
public int GetCountPostSAPLogList(string requestNo, string date, string status)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuPostSAPLogQuery,
"FindSuPostSAPLogSearchResult",
new object[] { requestNo, date, status, string.Empty, true }));
}
public int GetCountMenuList(short languageID)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuMenuQuery,
"FindSuMenuSearchResult",
new object[] { languageID, string.Empty, true }));
}
public IList <VORejectReasonLang> GetRejectReasonList(DbRejectReason dbRejectReason, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VORejectReasonLang>(
ScgDbQueryProvider.RejectReasonQuery, "FindReasonByDocumentTypeLanguageId",
new object[] { dbRejectReason, languageId, false, sortExpression }
, firstResult, maxResult, sortExpression));
}
public int GetRejectReasonCount(DbRejectReason dbRejectReason, short languageId)
{
return(NHibernateQueryHelper.CountByCriteria(
ScgDbQueryProvider.RejectReasonQuery,
"FindReasonByDocumentTypeLanguageId",
new object[] { dbRejectReason, languageId, true, string.Empty }));
}
public int GetCountList(short languageId)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuRTENodeQuery,
"FindSuRTENodeByLanguageId",
new object[] { languageId, string.Empty, true }));
}
public int GetCountFnEACAdvanceImportLoglist(FnEACAdvanceImportLog fnEACAdvanceImportLog)
{
return(NHibernateQueryHelper.CountByCriteria(
ScgeAccountingQueryProvider.FnEACAdvanceImportLogQuery,
"FindFnEACAdvanceImportLogSearchResult",
new object[] { fnEACAdvanceImportLog, string.Empty, true }));
}
public int GetCountDivisionList(short languageID, short organizationId)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuDivisionQuery,
"FindSuDivisionSearchResult",
new object[] { languageID, organizationId, string.Empty, true }));
}
public int GetExpenseGroupCount(VOExpenseGroup criteria, short languageId)
{
return(NHibernateQueryHelper.CountByCriteria(
ScgDbQueryProvider.DbExpenseGroupLangQuery,
"FindExpenseGroupByCriteria",
new object[] { criteria, languageId, true, string.Empty }));
}
public int GetCountSmsLogList(DateTime?fromDate, DateTime?toDate, string phoneNo)
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuSmsLogQuery,
"FindSuSmsLogSearchResult",
new object[] { fromDate, toDate, phoneNo, string.Empty, true }));
}
public int CountInvoiceItemList(long expenseId, short languageId)
{
return(NHibernateQueryHelper.CountByCriteria(
ScgeAccountingQueryProvider.FnExpenseInvoiceItemQuery,
"FindInvoiceItemByExpenseID",
new object[] { expenseId, languageId, true, string.Empty }
));
}
public IList <TranslateSearchResult> GetTranslatedList(SuGlobalTranslate criteria, short languageID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <TranslateSearchResult>(
QueryProvider.SuGlobalTranslateQuery,
"FindGlobalTranslateSearchResult",
new object[] { criteria, languageID, sortExpression, false },
firstResult, maxResult, sortExpression));
}
public IList <SuRTENode> GetSuRTENodeList(short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuRTENode>(
QueryProvider.SuRTENodeQuery,
"FindSuRTENodeByLanguageId",
new object[] { languageId, sortExpression, false },
firstResult, maxResult, sortExpression));
}
public IList <VOExpenseGroup> GetExpenseGroupList(VOExpenseGroup criteria, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOExpenseGroup>(
ScgDbQueryProvider.DbExpenseGroupLangQuery,
"FindExpenseGroupByCriteria",
new object[] { criteria, languageId, false, sortExpression },
firstResult, maxResult, sortExpression));
}
public int GetCount()
{
return(NHibernateQueryHelper.CountByCriteria(
QueryProvider.SuMenuQuery,
"FindSuMenuSearchResult",
new object[] { Convert.ToInt16("1"), string.Empty, true }));
//return base.FindAll().Count;
}
public IList <VOInvoiceItem> GetInvoiceItemListByExpenseID(long expenseId, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <VOInvoiceItem>(
ScgeAccountingQueryProvider.FnExpenseInvoiceItemQuery,
"FindInvoiceItemByExpenseID", new object[] { expenseId, languageId, false, sortExpression },
firstResult, maxResult, sortExpression
));
}
public IList <FnEACAdvanceImportLog> FindFnEACAdvanceImportLogListQuery(FnEACAdvanceImportLog fnEACAdvanceImportLog, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <FnEACAdvanceImportLog>(
ScgeAccountingQueryProvider.FnEACAdvanceImportLogQuery,
"FindFnEACAdvanceImportLogSearchResult",
new object[] { fnEACAdvanceImportLog, sortExpression, false },
firstResult,
maxResult,
sortExpression));
}
public bool ChekPermission(long UerID)
{
int result = NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbMileageRateRevisionQuery, "FindMieagePermission", new object[] { UerID });
if (result >= 1)
{
return(true);
}
return(false);
}
public IList <SuSmsLogSearchResult> GetSmsLogList(DateTime?fromDate, DateTime?toDate, string phoneNo, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuSmsLogSearchResult>(
QueryProvider.SuSmsLogQuery
, "FindSuSmsLogSearchResult"
, new object[] { fromDate, toDate, phoneNo, sortExpression, false }
, firstResult
, maxResult
, sortExpression));
}
public IList <SuUserLoginLog> FindSuUserLoginLogListQuery(DateTime?fromDate, DateTime?toDate, string UserName, string Status, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuUserLoginLog>(
QueryProvider.SuUserLogQuery,
"FindSuUserLoginLogSearchResult",
new object[] { fromDate, toDate, UserName, Status, sortExpression, false },
firstResult,
maxResult,
sortExpression));
}
public IList <SueHrExpenseLog> GeteHrExpenseLogList(SueHrExpenseLog query, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SueHrExpenseLog>(
QueryProvider.SuEHRExpenseLogQuery
, "FindEHRExpenseLogResult"
, new object[] { query, false, sortExpression }
, firstResult
, maxResult
, sortExpression));
}
public IList <SuPostSAPLogSearchResult> GetPostSAPLogList(string requestNo, string date, string status, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuPostSAPLogSearchResult>(
QueryProvider.SuPostSAPLogQuery
, "FindSuPostSAPLogSearchResult"
, new object[] { requestNo, date, status, sortExpression, false }
, firstResult
, maxResult
, sortExpression));
}
public Object GetList(int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuMenuSearchResult>(
QueryProvider.SuMenuQuery
, "FindSuMenuSearchResult"
, new object[] { Convert.ToInt16("1"), sortExpression, false }
, firstResult
, maxResult
, sortExpression));
//return base.FindAll();
}
public int CountByCountryCriteria(DbCountry country)
{
return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbCountryQuery, "FindByCountryCriteria", new object[] { country, true, Convert.ToInt16(0), string.Empty }));
}
public IList <CountryLang> GetCountryList(DbCountry country, short languageId, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <CountryLang>(ScgDbQueryProvider.DbCountryQuery, "FindByCountryCriteria", new object[] { country, false, languageId, sortExpression }, firstResult, maxResult, sortExpression));
}
public int GetCountSuUserRoleSearchResult(long userID, short languageID)
{
return(NHibernateQueryHelper.CountByCriteria(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { userID, languageID, string.Empty, true }));
}
//public IList<SuUserRoleSearchResult> GetTranslatedList(SuUserRoleSearchResult criteria, long userID, short languageID, int firstResult, int maxResult, string sortExpression)
//{
// return NHibernateQueryHelper.FindPagingByCriteria<SuUserRoleSearchResult>(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { criteria, userID, languageID }, firstResult, maxResult, sortExpression);
//}
//public ISQLQuery FindSuUserRoleSearchResult(SuUserRoleSearchResult userRoleSearchResult, long userID, short languageID)
//{
// StringBuilder sqlBuilder = new StringBuilder();
// sqlBuilder.AppendLine(" SELECT ur.ID as UserRoleId, ur.UserID as UserId, ur.RoleId as RoleId, rl.RoleName as RoleName, ur.Comment as Comment, ur.Active as Active ");
// sqlBuilder.AppendLine(" FROM SuUserRole ur INNER JOIN SuRole r on r.RoleID = ur.RoleID ");
// sqlBuilder.AppendLine(" INNER JOIN SuRoleLang rl on rl.RoleID = r.RoleID and rl.LanguageID = :languageID ");
// sqlBuilder.AppendLine(" WHERE ur.UserID = :userID ");
// QueryParameterBuilder parameterBuilder = new QueryParameterBuilder();
// parameterBuilder.AddParameterData("languageID", typeof(short), languageID);
// parameterBuilder.AddParameterData("userID", typeof(long), userID);
// ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
// parameterBuilder.FillParameters(query);
// query.AddScalar("UserRoleId", NHibernateUtil.Int64)
// .AddScalar("UserId", NHibernateUtil.Int64)
// .AddScalar("RoleId", NHibernateUtil.Int16)
// .AddScalar("RoleName", NHibernateUtil.String)
// .AddScalar("Comment", NHibernateUtil.String)
// .AddScalar("Active", NHibernateUtil.Boolean);
// query.SetResultTransformer(Transformers.AliasToBean(typeof(SuUserRoleSearchResult)));
// return query;
//}
//public int FindCountSuUserRoleSearchResult(SuUserRoleSearchResult userRoleSearchResult, long userID, short languageID)
//{
// StringBuilder sqlBuilder = new StringBuilder();
// sqlBuilder.AppendLine(" SELECT Count(*) as Count ");
// sqlBuilder.AppendLine(" FROM SuUserRole ur INNER JOIN SuRole r on r.RoleID = ur.RoleID ");
// sqlBuilder.AppendLine(" INNER JOIN SuRoleLang rl on rl.RoleID = r.RoleID and rl.LanguageID = :languageID ");
// sqlBuilder.AppendLine(" WHERE ur.UserID = :userID ");
// ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
// query.SetInt64("userID", userID);
// query.SetInt16("languageID", languageID);
// query.AddScalar("Count", NHibernateUtil.Int32);
// return Convert.ToInt32(query.UniqueResult());
//}
#endregion
#region ISuUserRoleQuery Members
public IList <SuUserRoleSearchResult> GetSuUserRoleSearchResultList(long userID, short languageID, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindPagingByCriteria <SuUserRoleSearchResult>(QueryProvider.SuUserRoleQuery, "FindSuUserRoleSearchResult", new object[] { userID, languageID, sortExpression, false }, firstResult, maxResult, sortExpression));
}
public IList <ServiceTeamLocationResult> GetServiceTeamLocationList(DbServiceTeam serviceTeam, int firstResult, int maxResult, string sortExpression)
{
return(NHibernateQueryHelper.FindByCriteria <ServiceTeamLocationResult>(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, false, sortExpression }));
}
public int CountServiceTeamLocationByServiceTeamID(DbServiceTeam serviceTeam)
{
return(NHibernateQueryHelper.CountByCriteria(ScgDbQueryProvider.DbServiceTeamLocationQuery, "FindServiceTeamLocationByServiceTeamID", new object[] { serviceTeam, true, string.Empty }));
}