public async Task <JsonResult> Get(string kodegol, int?periodemulaiberlaku, string namagolongan, bool?status)
{
var watch = Stopwatch.StartNew();
try
{
var param = new MasterGolonganDto()
{
KodeGol = kodegol,
NamaGolongan = namagolongan,
PeriodeMulaiBerlaku = periodemulaiberlaku,
Status = status
};
AppResponse.ResponseGetData(await GolonganService.GetAll(param));
}
catch (Exception e)
{
AppResponse.ResponseErrorGetData(e.InnerException != null ? e.InnerException.Message : e.Message);
}
watch.Stop();
AppResponse._result.execution_time = watch.ElapsedMilliseconds;
return(new JsonResult(AppResponse._result));
}
public async Task <IEnumerable <MasterGolonganDto> > GetAllAsync(MasterGolonganDto param)
{
using var context = new AppDbContext();
IQueryable <MasterGolongan> query = context.MasterGolongan;
if (!string.IsNullOrWhiteSpace(param.KodeGol))
{
query = query.Where(n => n.KodeGol == param.KodeGol);
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(param.PeriodeMulaiBerlaku)))
{
query = query.Where(n => n.PeriodeMulaiBerlaku == param.PeriodeMulaiBerlaku);
}
if (!string.IsNullOrWhiteSpace(param.NamaGolongan))
{
query = query.Where(n => EF.Functions.Like(n.NamaGolongan, $"%{param.NamaGolongan}%"));
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(param.Status)))
{
query = query.Where(n => n.Status == param.Status);
}
var data = await query.ToListAsync();
return(_mapper.Map <IEnumerable <MasterGolonganDto> >(data));
}
public async Task <IEnumerable <MasterGolonganDto> > GetAll(MasterGolonganDto param)
{
return(await golongan.GetAllAsync(param));
}
