public IResponseTransaction <T> GetTransaction <T>() where T : class, IResponse, new()
 {
     lock ( _pendingTransactionSyncLock )
     {
         if (_pendingTransaction != null)
         {
             throw new InvalidOperationException();
         }
         var rv = new ResponseTransaction <T>(this);
         _pendingTransaction = rv;
         return(rv);
     }
 }
        public async Task <ResponseTransaction> Paging(string keyword, int pageSize, int pageNumber)
        {
            using SqlConnection connection = new SqlConnection(_connectionStrings.Value);
            var procName = "SP_FilterDataTransaction";

            parameters.Add("@paramKeyword", keyword);
            parameters.Add("@paramPageSize", pageSize);
            parameters.Add("@paramPageNumber", pageNumber);
            parameters.Add("@length", dbType: DbType.Int32, direction: ParameterDirection.Output);
            parameters.Add("@filterlength", dbType: DbType.Int32, direction: ParameterDirection.Output);

            var result = new ResponseTransaction
            {
                Data = await connection.QueryAsync <TransactionViewModel>(procName, parameters, commandType : CommandType.StoredProcedure)
            };

            int filterlength = parameters.Get <int>("@filterlength");

            result.Filterlength = filterlength;
            int length = parameters.Get <int>("@length");

            result.Length = length;
            return(result);
        }
Пример #3
0
 public IEnumerable <PerformadTransaction> GetSales(TransactionFilter filter)
 {
     return(ResponseTransaction.FindByFilter(filter));
 }