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());
}
