public async Task <IEnumerable <dynamic> > GetAsync(string tenant, PlAccountQueryModel query)
{
string sql = "SELECT * FROM finance.get_profit_and_loss_statement(@0::date,@1::date,@2::integer,@3::integer,@4::integer,@5::boolean)";
string json = await Factory.ScalarAsync <string>(tenant, sql, query.From, query.To, query.UserId, query.OfficeId, query.Factor, query.Compact).ConfigureAwait(false);
return(JsonConvert.DeserializeObject <IEnumerable <dynamic> >(json));
}
public async Task <ActionResult> GetPlAccountAsync(PlAccountQueryModel 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 ProfitLossStatement.GetAsync(this.Tenant, model).ConfigureAwait(true);
return(this.Ok(result));
}
catch (Exception ex)
{
return(this.Failed(ex.Message, HttpStatusCode.InternalServerError));
}
}
public async Task <IEnumerable <dynamic> > GetAsync(string tenant, PlAccountQueryModel query)
{
string sql = "EXECUTE finance.get_profit_and_loss_statement @0,@1,@2,@3,@4,@5;";
return(await Factory.GetAsync <dynamic>(tenant, sql, query.From, query.To, query.UserId, query.OfficeId, query.Factor, query.Compact).ConfigureAwait(false));
}
public static async Task <IEnumerable <dynamic> > GetAsync(string tenant, PlAccountQueryModel query)
{
var service = GetService(tenant);
return(await service.GetAsync(tenant, query).ConfigureAwait(false));
}