public static async Task <dynamic> GetAsync(string tenant, TrialBalanceQuery query, LoginView meta) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT account_id,account_number,account AS title,previous_debit,previous_credit,debit,credit,closing_debit,closing_credit,parent_account_id FROM finance.get_trial_balance_tree(CAST(@0 AS date), CAST(@1 AS date), @2, @3, @4, @5)", query.From, query.To, meta.UserId, meta.OfficeId, query.Factor, query.ChangeSide); return(await db.SelectAsync <dynamic>(sql).ConfigureAwait(false)); } }
public async Task <ActionResult> TrialBalanceAsync(TrialBalanceQuery query) { if (!this.ModelState.IsValid) { return(this.InvalidModelState(this.ModelState)); } var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(false); try { var data = await DAL.TrialBalanceTree.GetAsync(this.Tenant, query, meta).ConfigureAwait(true); return(this.Ok(data)); } catch (Exception ex) { return(this.Failed(ex.Message, HttpStatusCode.InternalServerError)); } }