public async Task <ActionResult <List <JournalView> > > GetAsync([FromBody] JournalViewQuery query) { //var appUser = await AppUsers.GetCurrentAsync().ConfigureAwait(true); var appUser = new LoginView { UserId = 1, IsAdministrator = true, LoginId = 1, OfficeId = 1, RoleId = 1, CurrencyCode = "USD" }; query.OfficeId = appUser.OfficeId; query.UserId = appUser.UserId; query.From = query.From == DateTime.MinValue ? DateTime.Today : query.From; query.To = query.To == DateTime.MinValue ? DateTime.Today : query.To; try { var model = await _journalService.GetJournalViewAsync(null, query); return(model); } catch (Exception e) { return(null); } }
public async Task <ActionResult> GetAsync(JournalViewQuery query) { var appUser = await AppUsers.GetCurrentAsync().ConfigureAwait(true); query.OfficeId = appUser.OfficeId; query.UserId = appUser.UserId; var model = await Journals.GetJournalViewAsync(this.Tenant, query).ConfigureAwait(true); return(this.Ok(model)); }
public async Task <ActionResult> GetAsync(JournalViewQuery query) { var appUser = await AppUsers.GetCurrentAsync().ConfigureAwait(true); query.OfficeId = appUser.OfficeId; query.UserId = appUser.UserId; query.From = query.From == DateTime.MinValue ? DateTime.Today : query.From; query.To = query.To == DateTime.MinValue ? DateTime.Today : query.To; var model = await Journals.GetJournalViewAsync(this.Tenant, query).ConfigureAwait(true); return(this.Ok(model)); }
public static async Task <List <JournalView> > GetJournalViewAsync(string tenant, JournalViewQuery query) { string sql = "SELECT * FROM finance.get_journal_view(@0::integer,@1::integer,@2::date,@3::date,@4::bigint,@5::national character varying(50),@6::national character varying(50),@7::national character varying(50),@8::numeric(30, 6),@9::national character varying(50),@10::national character varying(50),@11::national character varying(50),@12::national character varying(12),@13::national character varying(50),@14::national character varying(128));"; if (DbProvider.GetDbType(DbProvider.GetProviderName(tenant)) == DatabaseType.SqlServer) { sql = "SELECT * FROM finance.get_journal_view(@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13);"; } var awaiter = await Factory.GetAsync <JournalView>(tenant, sql, query.UserId, query.OfficeId, query.From, query.To, query.TranId, query.TranCode.Or(""), query.ReferenceNumber.Or(""), query.Amount, query.StatementReference.Or(""), query.PostedBy.Or(""), query.Office.Or(""), query.Status.Or(""), query.VerifiedBy.Or(""), query.Reason.Or("")).ConfigureAwait(false); return(awaiter.OrderBy(x => x.TransactionMasterId).ToList()); }
public static async Task <List <JournalView> > GetJournalViewAsync(string tenant, JournalViewQuery query) { //Todo: The following query is incompatible with sql server const string sql = "SELECT * FROM finance.get_journal_view(@0::integer,@1::integer,@2::date,@3::date,@4::bigint,@5,@6,@7,@8,@9,@10,@11,@12,@13);"; var awaiter = await Factory.GetAsync <JournalView>(tenant, sql, query.UserId, query.OfficeId, query.From, query.To, query.TranId, query.TranCode.Or(""), query.Book.Or(""), query.ReferenceNumber.Or(""), query.StatementReference.Or(""), query.PostedBy.Or(""), query.Office.Or(""), query.Status.Or(""), query.VerifiedBy.Or(""), query.Reason.Or("")).ConfigureAwait(false); return(awaiter.OrderBy(x => x.TransactionMasterId).ToList()); }