public async Task <IEnumerable <dynamic> > GetAsync(string tenant, CashFlowStatementQueryModel query) { string sql = "SELECT * FROM finance.get_cash_flow_statement(@0::date,@1::date,@2::integer,@3::integer,@4::integer)"; string json = await Factory.ScalarAsync <string>(tenant, sql, query.From, query.To, query.UserId, query.OfficeId, query.Factor).ConfigureAwait(false); return(JsonConvert.DeserializeObject <IEnumerable <dynamic> >(json)); }
public async Task <ActionResult> GetCashFlowAsync(CashFlowStatementQueryModel model) { if (!this.ModelState.IsValid) { return(this.InvalidModelState(this.ModelState)); } var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true); model.OfficeId = meta.OfficeId; model.UserId = meta.UserId; try { var result = await CashFlowStatement.GetAsync(this.Tenant, model).ConfigureAwait(true); return(this.Ok(result)); } catch (Exception ex) { return(this.Failed(ex.Message, HttpStatusCode.InternalServerError)); } }
public static async Task <IEnumerable <dynamic> > GetAsync(string tenant, CashFlowStatementQueryModel query) { var service = GetService(tenant); return(await service.GetAsync(tenant, query).ConfigureAwait(false)); }
public async Task <IEnumerable <dynamic> > GetAsync(string tenant, CashFlowStatementQueryModel query) { string sql = "EXECUTE finance.get_cash_flow_statement @0,@1,@2,@3,@4;"; return(await Factory.GetAsync <dynamic>(tenant, sql, query.From, query.To, query.UserId, query.OfficeId, query.Factor).ConfigureAwait(false)); }