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