public async Task <IEnumerable <MasterMerekMeterDto> > GetAllAsync(MasterMerekMeterDto param)
        {
            using var context = new AppDbContext();

            IQueryable <MasterMerekMeter> query = context.MasterMerekMeter;

            if (!string.IsNullOrWhiteSpace(param.KodeMerekMeter))
            {
                query = query.Where(n => n.KodeMerekMeter == param.KodeMerekMeter);
            }

            if (!string.IsNullOrWhiteSpace(param.NamaMerekMeter))
            {
                query = query.Where(n => EF.Functions.Like(n.NamaMerekMeter, $"%{param.NamaMerekMeter}%"));
            }

            var data = await query.ToListAsync();

            return(_mapper.Map <IEnumerable <MasterMerekMeterDto> >(data));
        }
Example #2
0
        public async Task <JsonResult> Get(string kodeMerekMeter, string namaMerekMeter)
        {
            var watch = Stopwatch.StartNew();

            try
            {
                var param = new MasterMerekMeterDto()
                {
                    KodeMerekMeter = kodeMerekMeter,
                    NamaMerekMeter = namaMerekMeter
                };

                AppResponse.ResponseGetData(await MerekMeterService.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));
        }
Example #3
0
 public async Task <IEnumerable <MasterMerekMeterDto> > GetAll(MasterMerekMeterDto param)
 {
     return(await MerekMeter.GetAllAsync(param));
 }