public int RequestCount() { VOUCurrencySetup criteria = GetSuUserCriteria(); int count = SsDbQueryProvider.DbCurrencyQuery.CountCurrencyByCriteria(criteria); return(count); }
public Object RequestData(int startRow, int pageSize, string sortExpression) { VOUCurrencySetup criteria = GetSuUserCriteria(); return(SsDbQueryProvider.DbCurrencyQuery.GetCurrencyListByCriteria(criteria, startRow, pageSize, sortExpression)); //return SsDbQueryProvider.DbCurrencyQuery.GetCurrencyList(new DbCurrency(), startRow, pageSize, sortExpression); }
public VOUCurrencySetup GetSuUserCriteria() { VOUCurrencySetup currency = new VOUCurrencySetup(); currency.Symbol = ctlSymbol.Text; currency.Description = ctrDescription.Text; return(currency); }
public void BindCurrency(short currencyId) { VOUCurrencySetup currency = SsDbQueryProvider.DbCurrencyQuery.GetCurrencyLangByCurrencyID(currencyId, UserAccount.CurrentLanguageID); if (currency != null) { SelectedValue = currency.CurrencyID.ToString(); ctlCurrency.Text = currency.Symbol; } ctlCurrencyAutoCompleteUpdatePanel.Update(); }
protected void ctlPBLocalCurrencyGridview_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType.Equals(DataControlRowType.DataRow)) { short currencyId = UIHelper.ParseShort(ctlPBLocalCurrencyGridview.DataKeys[e.Row.RowIndex]["CurrencyID"].ToString()); // get currency id from gridview VOUCurrencySetup Currency = SsDbQueryProvider.DbCurrencyQuery.GetCurrencyLangByCurrencyID(currencyId, UserAccount.CurrentLanguageID); Literal symbol = e.Row.FindControl("ctlLocalCurrency") as Literal; if (symbol != null) { symbol.Text = Currency.Symbol; } Literal description = e.Row.FindControl("ctrLocalDescription") as Literal; if (description != null) { description.Text = Currency.Description; } } }
public int CountCurrencyByCriteria(VOUCurrencySetup criteria) { return(NHibernateQueryHelper.CountByCriteria(SsDbQueryProvider.DbCurrencyQuery, "FindCurrencyByCriteria", new object[] { criteria, true, string.Empty })); }
public ISQLQuery FindCurrencyByCriteria(VOUCurrencySetup criteria, bool isCount, string sortExpression) { StringBuilder sqlBuilder = new StringBuilder(); QueryParameterBuilder queryParameterBuilder = new QueryParameterBuilder(); if (!isCount) { sqlBuilder.Append(" select DbCurrency.CurrencyID as CurrencyID, DbCurrency.Symbol as Symbol, "); sqlBuilder.Append(" DbCurrency.Active as Active, DbCurrencyLang.CurrencyLangID as CurrencyLangID , "); sqlBuilder.Append(" DbCurrencyLang.LanguageID as LanguageID ,DbCurrencyLang.Description as Description "); } else { sqlBuilder.Append(" select count(DbCurrency.Symbol) as Count "); } sqlBuilder.Append(" from DbCurrency Left Outer Join DbCurrencyLang "); sqlBuilder.Append(" on DbCurrency.CurrencyID=DbCurrencyLang.CurrencyID and DbCurrencyLang.LanguageID= :langId "); queryParameterBuilder.AddParameterData("langId", typeof(short), UserAccount.CurrentLanguageID); #region WhereClause StringBuilder whereClauseBuilder = new StringBuilder(); if (!string.IsNullOrEmpty(criteria.Symbol)) { whereClauseBuilder.Append(" and DbCurrency.Symbol like :Symbol "); queryParameterBuilder.AddParameterData("Symbol", typeof(string), String.Format("%{0}%", criteria.Symbol)); } if (!string.IsNullOrEmpty(criteria.Description)) { whereClauseBuilder.Append(" and DbCurrencyLang.Description Like :Description "); queryParameterBuilder.AddParameterData("Description", typeof(string), String.Format("%{0}%", criteria.Description)); } if (!string.IsNullOrEmpty(whereClauseBuilder.ToString())) { sqlBuilder.Append(String.Format(" where 1=1 {0} ", whereClauseBuilder.ToString())); } #endregion #region Order By if (!isCount) { if (!string.IsNullOrEmpty(sortExpression)) { sqlBuilder.Append(String.Format(" order by {0} ", sortExpression)); } else { sqlBuilder.Append(" order by DbCurrency.Symbol , DbCurrencyLang.Description ,DbCurrency.Active "); } } #endregion ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString()); queryParameterBuilder.FillParameters(query); if (isCount) { query.AddScalar("Count", NHibernateUtil.Int32); } else { query.AddScalar("CurrencyID", NHibernateUtil.Int16) .AddScalar("Symbol", NHibernateUtil.String) .AddScalar("CurrencyLangID", NHibernateUtil.Int64) .AddScalar("LanguageID", NHibernateUtil.Int16) .AddScalar("Description", NHibernateUtil.String) .AddScalar("Active", NHibernateUtil.Boolean); query.SetResultTransformer(Transformers.AliasToBean(typeof(VOUCurrencySetup))); } return(query); }
public IList <VOUCurrencySetup> GetCurrencyListByCriteria(VOUCurrencySetup criteria, int firstResult, int maxResult, string sortExpression) { return(NHibernateQueryHelper.FindPagingByCriteria <VOUCurrencySetup>(SsDbQueryProvider.DbCurrencyQuery, "FindCurrencyByCriteria", new object[] { criteria, false, sortExpression }, firstResult, maxResult, sortExpression)); }