public async Task <IEnumerable <MasterBlokDto> > GetAllAsync(MasterBlokDto param) { using var context = new AppDbContext(); IQueryable <MasterBlok> query = context.MasterBlok; if (!string.IsNullOrWhiteSpace(param.KodeBlok)) { query = query.Where(n => n.KodeBlok == param.KodeBlok); } if (!string.IsNullOrWhiteSpace(param.NamaBlok)) { query = query.Where(n => EF.Functions.Like(n.NamaBlok, $"%{param.NamaBlok}%")); } if (!string.IsNullOrWhiteSpace(param.KodeRayon)) { query = query.Where(n => n.KodeRayon == param.KodeRayon); } var data = await query.ToListAsync(); return(_mapper.Map <IEnumerable <MasterBlokDto> >(data)); }
public async Task <JsonResult> Get(string kodeBlok, string namaBlok, string koderayon) { var watch = Stopwatch.StartNew(); try { var param = new MasterBlokDto() { KodeBlok = kodeBlok, NamaBlok = namaBlok, KodeRayon = koderayon, }; AppResponse.ResponseGetData(await BlokService.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 <MasterBlokDto> > GetAll(MasterBlokDto param) { return(await Blok.GetAllAsync(param)); }