public Boolean Altera(FuncionarioDTO pFuncionarioDTO)
{
try
{
DataTable dt = new DataTable();
MySqlConnection Conexao = new MySqlConnection(StrCon);
StringBuilder vSQLCommand = new StringBuilder();
vSQLCommand.AppendLine("UPDATE funcionario SET");
vSQLCommand.AppendLine("NOME = @NOME ");
vSQLCommand.AppendLine(" WHERE 1 = 1 ");
if (pFuncionarioDTO.Identificador != default(int))
{
vSQLCommand.AppendLine("and idFuncionario = @idFuncionario ");
}
MySqlCommand com = new MySqlCommand(vSQLCommand.ToString(), Conexao);
com.Parameters.Add(new MySqlParameter("@idFuncionario", pFuncionarioDTO.Identificador));
com.Parameters.Add(new MySqlParameter("@Nome", pFuncionarioDTO.Nome));
Conexao.Open();
//dt.Load(com.ExecuteReader());
com.ExecuteReader();
Conexao.Close();
return true;
}
catch (Exception e)
{
throw e;
}
}
public Boolean Excluir(FuncionarioDTO pFuncionarioDTO)
{
try
{
DataTable dt = new DataTable();
MySqlConnection Conexao = new MySqlConnection(StrCon);
StringBuilder vSQLCommand = new StringBuilder();
vSQLCommand.AppendLine("DELETE FROM funcionario");
vSQLCommand.AppendLine(" WHERE 1 = 1 ");
if (pFuncionarioDTO.Identificador != default(int))
{
vSQLCommand.AppendLine("and idFuncionario = @idFuncionario ");
}
MySqlCommand com = new MySqlCommand(vSQLCommand.ToString(), Conexao);
if (pFuncionarioDTO.Identificador != default(int))
{
com.Parameters.Add(new MySqlParameter("@idFuncionario", pFuncionarioDTO.Identificador));
}
Conexao.Open();
//dt.Load(com.ExecuteReader());
com.ExecuteReader();
Conexao.Close();
return true;
}
catch (DataAccessException ex)
{
// Verifica se ocorreu erro de constraint
if (ex.InnerException is SqlException)
{
if (((SqlException)ex.InnerException).Number == 547)
throw new Exception();
else
throw;
}
else
throw;
}
catch (Exception e)
{
int pos = 0;
pos = e.Message.ToString().IndexOf("Cannot delete or update a parent row: a foreign key constraint fails (");
if (pos > 0)
{
throw new Exception();
}
else
throw new DataAccessException("Ocorreu um erro ao excluir o Cliente.", DataAccessExceptionLocation.DAO, e);
}
}
public DataTable SelecionarPesquisar(FuncionarioDTO pFuncionarioDTO)
{
try
{
DataTable dt = new DataTable();
MySqlConnection Conexao = new MySqlConnection(StrCon);
StringBuilder vSQLCommand = new StringBuilder();
vSQLCommand = new StringBuilder();
vSQLCommand.AppendLine(" SELECT ");
vSQLCommand.AppendLine(" IDFUNCIONARIO,");
vSQLCommand.AppendLine(" NOME");
vSQLCommand.AppendLine(" FROM FUNCIONARIO");
vSQLCommand.AppendFormat(" WHERE (1=1) idFuncionario ");
if (pFuncionarioDTO.Identificador!= default(int))
{
vSQLCommand.AppendLine("and idFuncionario = @idFuncionario ");
}
MySqlCommand com = new MySqlCommand(vSQLCommand.ToString(), Conexao);
if (pFuncionarioDTO.Identificador!= default(int))
{
com.Parameters.Add(new MySqlParameter("@idFuncionario", pFuncionarioDTO.Identificador));
}
Conexao.Open();
dt.Load(com.ExecuteReader());
com.ExecuteReader();
Conexao.Close();
return dt;
}
catch (Exception e)
{
throw e;
}
}
public Boolean Insere(FuncionarioDTO pFuncionarioDTO)
{
try
{
MySqlConnection Conexao = new MySqlConnection(StrCon);
StringBuilder vSQLCommand = new StringBuilder();
vSQLCommand.AppendLine("INSERT INTO funcionario(");
vSQLCommand.AppendLine("NOME) values (");
//com.Parameters.Add(new MySqlParameter("@idFuncionario", pDTO.Identificador));
vSQLCommand.AppendLine(" @Nome)");
MySqlCommand com = new MySqlCommand(vSQLCommand.ToString(), Conexao);
//com.Parameters.Add(new MySqlParameter("@idFuncionario", pDTO.Identificador));
com.Parameters.Add(new MySqlParameter("@Nome", pFuncionarioDTO.Nome));
Conexao.Open();
//dt.Load(com.ExecuteReader());
com.ExecuteReader();
Conexao.Close();
return true;
}
catch (Exception e)
{
throw e;
}
}