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