public async Task <IEnumerable <MasterSumberAirDto> > GetAllAsync(MasterSumberAirDto param)
{
using var context = new AppDbContext();
IQueryable <MasterSumberAir> query = context.MasterSumberAir;
if (!string.IsNullOrWhiteSpace(param.KodeSumberAir))
{
query = query.Where(n => n.KodeSumberAir == param.KodeSumberAir);
}
if (!string.IsNullOrWhiteSpace(param.NamaSumberAir))
{
query = query.Where(n => EF.Functions.Like(n.NamaSumberAir, $"%{param.NamaSumberAir}%"));
}
var data = await query.ToListAsync();
return(_mapper.Map <IEnumerable <MasterSumberAirDto> >(data));
}
public async Task <JsonResult> Get(string kodeSumberAir, string namaSumberAir)
{
var watch = Stopwatch.StartNew();
try
{
var param = new MasterSumberAirDto()
{
KodeSumberAir = kodeSumberAir,
NamaSumberAir = namaSumberAir
};
AppResponse.ResponseGetData(await SumberAirService.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 <MasterSumberAirDto> > GetAll(MasterSumberAirDto param)
{
return(await sumberAir.GetAllAsync(param));
}
