public ActionResult <IEnumerable <PersonalMeasurement> > GetAll()
{
string sql = "Select * from dbo.PersonalMeasurements";
var result = new List <PersonalMeasurement>();
using (var databaseConnection = new SqlConnection(conn))
{
databaseConnection.Open();
using (var selectCommand = new SqlCommand(sql, databaseConnection))
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
PersonalMeasurement personalMeasurement = new PersonalMeasurement();
{
personalMeasurement.Id = reader.GetInt32(0);
personalMeasurement.UId = reader.GetInt32(1);
personalMeasurement.Pressure = reader.GetInt32(2);
personalMeasurement.Humidity = reader.GetInt32(3);
personalMeasurement.Temp = reader.GetInt32(4);
personalMeasurement.TimeStamp = reader.GetSqlDateTime(5).Value;
}
result.Add(personalMeasurement);
}
}
}
return(this.Ok(result));
}
}
public void Add_ValidObjectPassed_ReturnsCreatedResponse()
{
// Arrange
PersonalMeasurement testItem = new PersonalMeasurement(123, 1000, 50, 20);
// Act
var createdResponse = _controller.Add(testItem);
// Assert
Assert.IsType <OkObjectResult>(createdResponse);
}
public void Add_InvalidObjectPassed_ReturnsBadRequest()
{
// Arrange
var PressureMissingItem = new PersonalMeasurement();
_controller.ModelState.AddModelError("Pressure", "Required");
// Act
var badResponse = _controller.Add(PressureMissingItem);
// Assert
Assert.IsType <BadRequestObjectResult>(badResponse);
}
public void Add_ValidObjectPassed_ReturnedResponseHasCreatedItem()
{
// Arrange
var testItem = new PersonalMeasurement(123, 1000, 50, 20);
// Act
var createdResponse = _controller.Add(testItem) as OkObjectResult;
var item = createdResponse.Value as PersonalMeasurement;
// Assert
Assert.IsType <PersonalMeasurement>(item);
Assert.Equal(testItem.Pressure, item.Pressure);
}
public ActionResult <IEnumerable <PersonalMeasurement> > GetById(string id)
{
//int uid;
//try
//{
// uid = Int32.Parse(id);
//}
//catch (Exception e)
//{
// return BadRequest();
//}
string sql = $"Select * from dbo.PersonalMeasurements Where UID={id}";
var result = new List <PersonalMeasurement>();
using (var databaseConnection = new SqlConnection(conn))
{
databaseConnection.Open();
using (var selectCommand = new SqlCommand(sql, databaseConnection))
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
PersonalMeasurement personalMeasurement = new PersonalMeasurement();
{
personalMeasurement.Id = reader.GetInt32(0);
personalMeasurement.UId = reader.GetInt32(1);
personalMeasurement.Pressure = reader.GetInt32(2);
personalMeasurement.Humidity = reader.GetInt32(3);
personalMeasurement.Temp = reader.GetInt32(4);
personalMeasurement.TimeStamp = reader.GetSqlDateTime(5).Value;
}
result.Add(personalMeasurement);
}
}
}
if (result.Count < 1)
{
return(this.NotFound());
}
return(this.Ok(result));
}
}
public ActionResult Add([FromBody] PersonalMeasurement value)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string timeStamp = value.TimeStamp.ToString("yyyy-MM-dd hh:mm:ss").Replace(".", ":");
string sql = $"Insert INTO dbo.PersonalMeasurements (UID, Pressure, Humidity, Temp, TimeStamp) values ({value.UId}, {value.Pressure}, {value.Humidity}, {value.Temp}, '{timeStamp}')";
using (var databaseConnection = new SqlConnection(conn))
{
databaseConnection.Open();
using (var insertCommand = new SqlCommand(sql, databaseConnection))
{
insertCommand.ExecuteNonQuery();
}
}
return(this.Ok(value));
}
