public IActionResult Update ([Bind("Id, Period")]ConfigurationUpload configuration)
{
if (ModelState.IsValid)
{
_repoConfiguration.Update(configuration);
return Ok();
}
return BadRequest();
}
public IActionResult Insert([FromBody] ConfigurationUpload configuration)
{
if (ModelState.IsValid)
{
var result = _repoConfiguration.Insert(configuration);
var lastResult = _repoConfiguration.GetLastInserted();
var uri = Url.Action("Get", new { Id = lastResult.Id, Version = "1.0" });
return(Created(uri, lastResult));
}
return(BadRequest());
}
public bool Insert(ConfigurationUpload item)
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;
if (db.State == ConnectionState.Closed)
{
db.Open();
}
string query = "INSERT INTO CONFIGURATION(ID_PERIOD) VALUES (@Period)";
var result = db.Execute(query, new { Period = item.IdPeriod });
db.Close();
return(result > 0);
}
}
public bool Update(ConfigurationUpload item)
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;
if (db.State == ConnectionState.Closed)
{
db.Open();
}
string query = "UPDATE CONFIGURATION SET ID_PERIOD = @Period WHERE ID = @Id";
var result = db.Execute(query, new { Period = item.IdPeriod, Id = item.Id });
db.Close();
return(result > 0);
}
}
