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