public async Task <IEnumerable <MasterWilayahDto> > GetAllAsync(MasterWilayahDto param) { using var context = new AppDbContext(); IQueryable <MasterWilayah> query = context.MasterWilayah; if (!string.IsNullOrWhiteSpace(param.KodeWil)) { query = query.Where(n => n.KodeWil == param.KodeWil); } if (!string.IsNullOrWhiteSpace(param.NamaWilayah)) { query = query.Where(n => EF.Functions.Like(n.NamaWilayah, $"%{param.NamaWilayah}%")); } var data = await query.ToListAsync(); return(_mapper.Map <IEnumerable <MasterWilayahDto> >(data)); }
public async Task <JsonResult> Get(string kodewil, string namawilayah) { var watch = Stopwatch.StartNew(); try { var param = new MasterWilayahDto() { KodeWil = kodewil, NamaWilayah = namawilayah }; AppResponse.ResponseGetData(await wilayahService.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 <MasterWilayahDto> > GetAll(MasterWilayahDto param) { return(await wilayah.GetAllAsync(param)); }