コード例 #1
0
        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));
        }
コード例 #2
0
        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));
        }
コード例 #3
0
 public async Task <IEnumerable <MasterBlokDto> > GetAll(MasterBlokDto param)
 {
     return(await Blok.GetAllAsync(param));
 }