Exemple #1
0
        public IEnumerable <StatementListRow> Get([FromQuery] StatementListArgs args)
        {
            var criteria = new List <string>();
            var id       = string.Empty;

            switch (args.type)
            {
            case StatementType.Bank:
                id = "bank_id";
                break;

            case StatementType.Corporate:
                id = "corporate_id";
                break;

            case StatementType.Merchant:
                id = "merchant_id";
                break;

            default:
                break;
            }
            var sql  = @"
                SELECT id, date, statement_end_date
                FROM public.pdf_statements where " + id + "=@0";
            var data = _db.Fetch <StatementListRow>(sql, args.key);

            return(data);
        }
Exemple #2
0
 public IEnumerable <FilterOption> Options([FromQuery] StatementListArgs args, [FromQuery] OptionArgs optionsArgs)
 {
     return(null);
 }