public JsonResult getCargo(string id, string path) { doc = new XmlDocument(); doc.Load(path); List <Dominio.Cargo> lista = new List <Dominio.Cargo>(); XmlNodeList nodes = doc.SelectNodes(@"/dados/cargos/cargo"); foreach (XmlNode node in nodes) { if (node["id"].InnerText == id) { var cargo = new Dominio.Cargo() { CargoID = int.Parse(node["id"].InnerText), NomeCargos = node["nome"].InnerText, }; lista.Add(cargo); } } return(new JsonResult() { Data = lista }); }
public void NãoInsereCargoNoBancoComNomeJáExistente() { // arrange var cargo = new Cargo(2, "Deputado", 'A'); int quantidadeEsperada = 3; // act Services.CargoService.Inserir(cargo); int quantidadeObtida = Repositorio.CargoRepositorio.GetQuantidadeDeCargos(); //assert Assert.AreEqual(quantidadeEsperada, quantidadeObtida); }
public static void InativarCargo(int id, Cargo cargo) { if (!Eleicao.IniciarEleicao) { if (CargoRepositorio.PesquisarPorID(id) != null) { if (cargo.Situacao != 'I') { CargoRepositorio.InativarCargo(id, cargo); } } } }
public static void Editar(int id, Cargo cargo) { if (!Eleicao.IniciarEleicao) { if (CargoRepositorio.PesquisarPorID(id) != null) { if (cargo.Nome != null && CargoRepositorio.PesquisarPorNome(cargo.Nome) == null) { CargoRepositorio.Editar(id, cargo); } } } }
public static void Inserir(Cargo cargo) { if (!Eleicao.IniciarEleicao) { if (cargo.Nome != null && cargo.Situacao != '\0') { bool validaNome = CargoRepositorio.PesquisarPorNome(cargo.Nome) != null ? false : true; if (validaNome) { CargoRepositorio.Inserir(cargo); } } } }
public static void Editar(int id, Cargo cargo) { using (TransactionScope transacao = new TransactionScope()) using (IDbConnection connection = new SqlConnection(connectionString)) { IDbCommand comando = connection.CreateCommand(); comando.AddParameter("paramIDCargo", cargo.IDCargo); comando.AddParameter("paramNome", cargo.Nome); comando.CommandText = "UPDATE Cargo SET Nome = @paramCargoNome WHERE IDCargo = @paramIDCargo"; connection.Open(); comando.ExecuteNonQuery(); transacao.Complete(); connection.Close(); } }
public static void InativarCargo(int idCargo, Cargo cargo) { string connectionString = ConfigurationManager.ConnectionStrings["URNA"].ConnectionString; using (TransactionScope transacao = new TransactionScope()) using (IDbConnection connection = new SqlConnection(connectionString)) { IDbCommand comando = connection.CreateCommand(); comando.AddParameter("paramIDCargo", cargo.IDCargo); comando.CommandText = "UPDATE Cargo SET Situacao = 'I' WHERE IDCargo = @paramIDCargo"; connection.Open(); comando.ExecuteNonQuery(); transacao.Complete(); connection.Close(); } }
public static void Inserir(Cargo cargo) { string connectionString = ConfigurationManager.ConnectionStrings["URNA"].ConnectionString; using (TransactionScope transacao = new TransactionScope()) using (IDbConnection connection = new SqlConnection(connectionString)) { IDbCommand comando = connection.CreateCommand(); comando.AddParameter("paramNomeCargo", cargo.Nome); comando.AddParameter("paramSituacaoCargo", cargo.Situacao); comando.CommandText = "INSERT INTO Cargo (Nome, Situacao) VALUES (@paramNomeCargo, @paramSituacaoCargo)"; connection.Open(); comando.ExecuteNonQuery(); transacao.Complete(); connection.Close(); } }
public Mensual(int sueldo, string cedula, string nombre, Cargo cargo) : base(cedula, nombre, cargo) { this.sueldo = sueldo; }
public void AsignarCargo(Cargo cargo) { this.cargo = cargo; }
public Empleado(string cedula, string nombre, Cargo cargo) { this.cedula = cedula; this.nombre = nombre; this.cargo = cargo; }