public async Task <IEnumerable <MachineReporting> > spi_tbl_MachineReporting(MachineReporting machinerep)
{
using (IDbConnection sql = new SqlConnection(_constring))
{
string readSp = "spi_tbl_MachineReporting";
var queryParameters = new DynamicParameters();
queryParameters.Add("@ProcessName", machinerep.ProcessName);
queryParameters.Add("@ApplicationName", machinerep.ApplicationName);
queryParameters.Add("@TotalSecond", machinerep.TotalSeconds);
queryParameters.Add("@MachineHash", machinerep.MachineHash);
queryParameters.Add("@SessionID", machinerep.GUID);
return(await sql.QueryAsync <MachineReporting>(readSp, queryParameters, commandType : CommandType.StoredProcedure));
}
}
public async Task spi_tbl_MachineReporting([FromBody] MachineReporting machinerep)
{
await _repository.spi_tbl_MachineReporting(machinerep);
}