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));
}
