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); } }