public async Task <JsonResult> Get(string kodekelurahan, string namakelurahan, string kodekecamatan, string namakecamatan, string kodecabang, string namacabang) { var watch = Stopwatch.StartNew(); try { var param = new MasterKelurahanDto() { KodeKelurahan = kodekelurahan, NamaKelurahan = namakelurahan, KodeKecamatan = kodekecamatan, NamaKecamatan = namakecamatan, KodeCabang = kodecabang, NamaCabang = namacabang, }; AppResponse.ResponseGetData(await kelurahanService.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 <MasterKelurahanDto> > GetAllAsync(MasterKelurahanDto param) { using var context = new AppDbContext(); IQueryable <MasterKelurahan> query = context.MasterKelurahan; if (!string.IsNullOrWhiteSpace(param.KodeKelurahan)) { query = query.Where(n => n.KodeKelurahan == param.KodeKelurahan); } if (!string.IsNullOrWhiteSpace(param.NamaKelurahan)) { query = query.Where(n => EF.Functions.Like(n.NamaKelurahan, $"%{param.NamaKelurahan}%")); } if (!string.IsNullOrWhiteSpace(param.KodeKecamatan)) { query = query.Where(n => n.KodeKecamatan == param.KodeKecamatan); } if (!string.IsNullOrWhiteSpace(param.NamaKecamatan)) { query = query.Where(n => EF.Functions.Like(n.NamaKecamatan, $"%{param.NamaKecamatan}%")); } if (!string.IsNullOrWhiteSpace(param.KodeCabang)) { query = query.Where(n => n.KodeCabang == param.KodeCabang); } if (!string.IsNullOrWhiteSpace(param.NamaCabang)) { query = query.Where(n => EF.Functions.Like(n.NamaCabang, $"%{param.NamaCabang}%")); } var data = await query.ToListAsync(); return(_mapper.Map <IEnumerable <MasterKelurahanDto> >(data)); }
public async Task <IEnumerable <MasterKelurahanDto> > GetAll(MasterKelurahanDto param) { return(await kelurahan.GetAllAsync(param)); }