public async Task <IActionResult> ListDataLampuForDDLInfo() { var response = new ResponseReportInfo(); try { await Db.Connection.OpenAsync(); var query = new ReportInfoQuery(Db); var result = await query.GetDataLampuForDDLInfo(); return(new OkObjectResult(result)); } catch (Exception exc) { response.message = "Error ! " + exc.ToString(); response.status = 1; return(new OkObjectResult(response)); } }
public async Task <IActionResult> InfoTotalWaktuLampuHidup([FromBody] InfoWaktuLampuHidupFilter body) { var response = new ResponseReportInfo(); try { if (body is null) { response.message = "Data tidak ditemukan ! "; response.status = 1; return(new OkObjectResult(response)); } await Db.Connection.OpenAsync(); var query = new ReportInfoQuery(Db); var DateFrom = body.Date_From; var DateTo = body.Date_To; var result = await query.InfoTotalWaktuLampuHidup(body.Date_From, body.Date_To, body.Lampu_ID); if (result is null) { response.message = "Data tidak ditemukan ! "; response.status = 1; return(new OkObjectResult(response)); } return(new OkObjectResult(result)); } catch (Exception exc) { response.message = "Error ! " + exc.ToString(); response.status = 1; return(new OkObjectResult(response)); } }