public int EditaSetor(Setor s) { string sql = "UPDATE setor SET nome = @nome WHERE codSetor = @codigo;"; int result = 0; SqlConnection conn = new SqlConnection(strConnection); SqlCommand sqlcmd = new SqlCommand(sql, conn); sqlcmd.Parameters.AddWithValue("@codigo", s.GetCodSetor()); sqlcmd.Parameters.AddWithValue("@nome", s.GetNome()); try { conn.Open(); result = sqlcmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(result); }
public int ExcluiSetor(Setor s) { string sql = "DELETE FROM setor WHERE codSetor = @codigo"; int result = 0; SqlConnection conn = new SqlConnection(strConnection); SqlCommand sqlcmd = new SqlCommand(sql, conn); sqlcmd.Parameters.AddWithValue("@codigo", s.GetCodSetor()); try { conn.Open(); result = sqlcmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(result); }