public AliancaConta()
{
//
// TODO: Add constructor logic here
//
Ativado = true;
funcionario = new Funcionario();
maquina = new Maquina();
alianca = new Alianca();
conta = new Conta();
}
public bool Insert(Funcionario funcionario)
{
System.Data.IDbConnection objConexao;
System.Data.IDbCommand objCommand;
string sql = "INSERT INTO TBL_FUNCIONARIO (FUN_ID, FUN_NOME, FUN_CPF, FUN_SENHA, FUN_ATIVADO) VALUES (?id, ?nome, ?cpf, ?senha, ?ativado)";
objConexao = Mapped.Connection();
objCommand = Mapped.Command(sql, objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?id", funcionario.ID));
objCommand.Parameters.Add(Mapped.Parameter("?nome", funcionario.Nome));
objCommand.Parameters.Add(Mapped.Parameter("?cpf", funcionario.CPF));
objCommand.Parameters.Add(Mapped.Parameter("?senha", funcionario.Senha));
objCommand.Parameters.Add(Mapped.Parameter("?ativado", funcionario.Ativado));
objCommand.ExecuteNonQuery();
objConexao.Close();
objCommand.Dispose();
objConexao.Dispose();
return true;
}
public Funcionario Select(int id)
{
Funcionario obj = null;
System.Data.IDbConnection objConexao;
System.Data.IDbCommand objCommand;
System.Data.IDataReader objDataReader;
objConexao = Mapped.Connection();
objCommand = Mapped.Command("SELECT * FROM TBL_FUNCIONARIO WHERE FUN_ID = ?codigo", objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?codigo", id));
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read())
{
obj = new Funcionario();
obj.ID = Convert.ToInt32(objDataReader["FUN_ID"]);
obj.Nome = Convert.ToString(objDataReader["FUN_NOME"]);
obj.CPF = Convert.ToInt32(objDataReader["FUN_CPF"]);
obj.Ativado = Convert.ToBoolean(objDataReader["FUN_ATIVADO"]);
}
objDataReader.Close();
objConexao.Close();
objCommand.Dispose();
objConexao.Dispose();
objDataReader.Dispose();
return obj;
}
/// <summary>
/// Metodo que busca no banco o funcionario desejado
/// </summary>
/// <param name="id">id do funcionario</param>
/// <returns>objeto Funcionario ou null caso nao encontre o id informado</returns>
public Funcionario Select(int id)
{
Funcionario funcionario = null;
System.Data.IDbConnection objConexao;
System.Data.IDbCommand objCommand;
System.Data.IDataReader objDataReader;
objConexao = Mapped.Connection();
objCommand = Mapped.Command("SELECT * FROM TBL_FUNCIONARIO AS FUN INNER JOIN TBL_CARGO AS CAR ON FUN.CAR_ID=CAR.CAR_ID WHERE FUN_ID = ?codigo ", objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?codigo", id));
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read())
{
funcionario = new Funcionario();
funcionario.ID = Convert.ToInt32(objDataReader["FUN_ID"]);
funcionario.Nome = Convert.ToString(objDataReader["FUN_NOME"]);
funcionario.CPF = Convert.ToInt32(objDataReader["FUN_CPF"]);
funcionario.Ativado = Convert.ToBoolean(objDataReader["FUN_ATIVADO"]);
//puxa os dados do relacionamento
funcionario.Cargo.ID = Convert.ToInt32(objDataReader["CAR_ID"]);
funcionario.Cargo.Nome = Convert.ToString(objDataReader["CAR_NOME"]);
}
objDataReader.Close();
objConexao.Close();
objCommand.Dispose();
objConexao.Dispose();
objDataReader.Dispose();
return funcionario;
}