public void Post([FromBody] NovaSds sds)
{
var sdsNegocio = new SdsNegocio();
if (ModelState.IsValid)
{
sdsNegocio.Adiciona(sds);
}
}
public void Update(NovaSds sds)
{
//using (IDbConnection dbConnection = Connection)
using (var dbConnection = SimpleDbConnection()) //SQLite
{
string sQuery = @"UPDATE Sds_teste SET Name=@Name, Description=@Description WHERE id=@Id";
dbConnection.Open();
dbConnection.Query(sQuery, sds);
}
}
public void Put(int id, [FromBody] NovaSds sds)
{
sds.id = id;
var sdsNegocio = new SdsNegocio();
if (ModelState.IsValid)
{
sdsNegocio.Atualiza(sds);
}
}
public void Add(NovaSds sds)
{
//using (IDbConnection dbConnection = Connection)
using (var dbConnection = SimpleDbConnection()) //SQLite
{
string sQuery = @"INSERT INTO Sds_teste
(Name, Description) VALUES
(@Name, @Description)";
dbConnection.Open();
dbConnection.Execute(sQuery, sds);
}
}
public void Atualiza(NovaSds sds)
{
repositorioDapperSds.Update(sds);
}
public void Adiciona(NovaSds sds)
{
repositorioDapperSds.Add(sds);
}
