public static bool ValidaCaracter(Cargos cargo)
{
for (int i = 0; i < cargo.getNome().Length; i++)
if (cargo.getNome()[i].Equals('0') || cargo.getNome()[i].Equals('1') || cargo.getNome()[i].Equals('2') || cargo.getNome()[i].Equals('3') || cargo.getNome()[i].Equals('4') || cargo.getNome()[i].Equals('5') || cargo.getNome()[i].Equals('6') || cargo.getNome()[i].Equals('7') || cargo.getNome()[i].Equals('8') || cargo.getNome()[i].Equals('9'))
throw new CaracterInvalidoException("O nome não pode conter caracter numérico!");
for (int i = 0; i < cargo.getNome().Length; i++)
if (cargo.getNome()[i].Equals('*') || cargo.getNome()[i].Equals('&') || cargo.getNome()[i].Equals('(') || cargo.getNome()[i].Equals(')') || cargo.getNome()[i].Equals('!') || cargo.getNome()[i].Equals('@') || cargo.getNome()[i].Equals('#') || cargo.getNome()[i].Equals('$') || cargo.getNome()[i].Equals('%') || cargo.getNome()[i].Equals('¨') || cargo.getNome()[i].Equals('-') || cargo.getNome()[i].Equals('_') || cargo.getNome()[i].Equals('+') || cargo.getNome()[i].Equals('=') || cargo.getNome()[i].Equals('§') || cargo.getNome()[i].Equals(',') || cargo.getNome()[i].Equals('.') || cargo.getNome()[i].Equals('/') || cargo.getNome()[i].Equals('?') || cargo.getNome()[i].Equals(':') || cargo.getNome()[i].Equals(';') || cargo.getNome()[i].Equals('|') || cargo.getNome()[i].Equals(']') || cargo.getNome()[i].Equals('}') || cargo.getNome()[i].Equals('{') || cargo.getNome()[i].Equals('['))
throw new CaracterInvalidoException("O nome não pode conter caracter especial!");
if (cargo.getSalario() < 1)
throw new CaracterInvalidoException("Salário inválido!");
return true;
}
public static bool Alterar(Cargos cargo)
{
try
{
using (OracleCommand c = ConexaoOracle.ObterConexao().CreateCommand())
{
c.CommandType = System.Data.CommandType.Text;
c.CommandText = "UPDATE cargos SET nome=:nome, salario=:salario, descricao=:descricao WHERE cargoid = :codigo";
c.Parameters.Add("nome", OracleType.VarChar).Value = cargo.getNome();
c.Parameters.Add("salario", OracleType.Float).Value = cargo.getSalario();
c.Parameters.Add("descricao", OracleType.VarChar).Value = cargo.getDescricao();
c.Parameters.Add("codigo", OracleType.Int32).Value = cargo.getCargoId();
c.ExecuteNonQuery();
return true;
}
}
catch (OracleException e)
{
throw e;
}
}
public static bool Inserir(Cargos cargo)
{
try
{
using (OracleCommand c = ConexaoOracle.ObterConexao().CreateCommand())
{
c.CommandType = System.Data.CommandType.Text;
c.CommandText = "INSERT INTO cargos values(CARGOS_SEQ.NEXTVAL, :nome, :salario, :descricao)";
c.Parameters.Add("nome", OracleType.VarChar).Value = cargo.getNome();
c.Parameters.Add("salario", OracleType.Float).Value = cargo.getSalario();
c.Parameters.Add("descricao", OracleType.VarChar).Value = cargo.getDescricao();
c.ExecuteNonQuery();
return true;
}
}
catch (OracleException e)
{
throw e;
}
}
