public IEnumerable<DotPay.ViewModel.VirtualCoinWithdrawListModel> GetVirtualCoinWithdrawBySearch(int? userID, CurrencyType currencyType, VirtualCoinTxState state, int page, int pageCount)
{
var paramters = new object[] { userID.HasValue ? userID.Value : 0, (int)state, (page - 1) * pageCount, pageCount };
var users = this.Context.Sql(getVirtualCoinWithdraw_Sql.FormatWith(currencyType.ToString()))
.Parameters(paramters)
.QueryMany<VirtualCoinWithdrawListModel>();
return users;
}
public ActionResult GetWithdrawCountBySearch(int? userID,CurrencyType currencyType, VirtualCoinTxState state)
{
var count = IoC.Resolve<IWithdrawQuery>().CountVirtualCoinWithdrawBySearch(userID,currencyType, state);
return Json(count);
}
public int CountVirtualCoinWithdrawBySearch(int?userID, CurrencyType currencyType, VirtualCoinTxState state)
{
var paramters = new object[] { userID.HasValue ? userID.Value : 0, (int)state };
return this.Context.Sql(getVirtualCoinWithdrawCount_Sql.FormatWith(currencyType.ToString()))
.Parameters(paramters)
.QuerySingle<int>();
}
public ActionResult GetWithdrawBySearch(int? userID,CurrencyType currencyType, VirtualCoinTxState state, int page)
{
var currencies = IoC.Resolve<IWithdrawQuery>().GetVirtualCoinWithdrawBySearch(userID,currencyType, state, page, Constants.DEFAULT_PAGE_COUNT);
return Json(currencies);
}
