public void Cadastrar(Cargo cargo) { if (BuscarPorNome(cargo.Nome) == false) { using (IDbConnection connection = new SqlConnection(connectionString)) { IDbCommand comando = connection.CreateCommand(); comando.CommandText = "INSERT INTO Cargo VALUES (@nome, @situacao)"; IDbDataParameter nome = comando.CreateParameter(); nome.ParameterName = "nome"; nome.Value = cargo.Nome; IDbDataParameter param = comando.CreateParameter(); param.ParameterName = "situacao"; param.Value = cargo.Situacao.ToString().ToUpper(); connection.Open(); comando.ExecuteNonQuery(); connection.Close(); } } else { Console.WriteLine("Nome inserido já existe"); } }
public void Editar(Cargo cargo) { using (TransactionScope transacao = new TransactionScope()) using (IDbConnection conection = new SqlConnection(connectionString)) { IDbCommand comando = conection.CreateCommand(); comando.CommandText = "UPDATE Cargo SET Nome = @nome , Situacao = @situacao WHERE IDCargo = @idcargo"; comando.AddParameter("nome", cargo.Nome); comando.AddParameter("situacao", cargo.Situacao.ToString().ToUpper()); conection.Open(); comando.ExecuteNonQuery(); transacao.Complete(); conection.Close(); } }