public async Task <IActionResult> GetAllData()
{
try
{
await Db.Connection.OpenAsync();
var query = new HistoryStateLampuQuery(Db);
var result = await query.AllDataSyn();
return(new OkObjectResult(result));
}
catch (Exception exc)
{
var response = new ResponseHistoryStateLampu();
response.message = "Error ! " + exc.ToString();
response.status = 1;
return(new OkObjectResult(response));
}
}
public async Task <IActionResult> GetDataWithFilter([FromBody] HistoryFilterBody body)
{
try
{
var response = new ResponseHistoryStateLampu();
if (body is null)
{
response.message = "Data tidak ditemukan ! ";
response.status = 1;
return(new OkObjectResult(response));
}
await Db.Connection.OpenAsync();
var query = new HistoryStateLampuQuery(Db);
var DateFrom = body.Date_From;
var DateTo = body.Date_To;
var result = await query.SelectWithFilterSync(body.Lampu_ID, body.Lampu_State, DateFrom, DateTo);
if (result is null)
{
response.message = "Data tidak ditemukan ! ";
response.status = 1;
return(new OkObjectResult(response));
}
return(new OkObjectResult(result));
}
catch (Exception exc)
{
var response = new ResponseHistoryStateLampu();
response.message = "Error ! " + exc.ToString();
response.status = 1;
return(new OkObjectResult(response));
}
}
