internal bool Save(Aluno_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
bool retorno = false;
string sql = "INSERT INTO aluno" +
"( alu_nome " +
", alu_telefone " +
", alu_email " +
", alu_data_nascimento " +
", alu_endereco " +
", alu_bairro " +
", alu_cpf) " +
"VALUES " +
"( @alu_nome " +
" , @alu_telefone " +
" , @alu_email " +
" , @alu_data_nascimento " +
" , @alu_endereco " +
" , @alu_bairro " +
" , @alu_cpf ) ";
try
{
command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@alu_nome", pTO.alu_nome);
command.Parameters.AddWithValue("@alu_telefone", pTO.alu_telefone);
command.Parameters.AddWithValue("@alu_email", pTO.alu_email);
command.Parameters.AddWithValue("@alu_data_nascimento", pTO.alu_data_nascimento);
command.Parameters.AddWithValue("@alu_endereco", pTO.alu_endereco);
command.Parameters.AddWithValue("@alu_bairro", pTO.alu_bairro);
command.Parameters.AddWithValue("@alu_cpf", pTO.alu_cpf);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}
public Aluno_TO GetByCode(Aluno_TO pTO)
{
try
{
return(new Aluno_DAO().GetByCode(pTO));
}
catch (Exception)
{
throw;
}
}
internal List <Aluno_TO> SearchAll(string pCondicao)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
SqlDataReader reader = null;
string sql = " SELECT * FROM aluno ";
List <Aluno_TO> collection = new List <Aluno_TO>();
try
{
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
Aluno_TO AlunoTO = new Aluno_TO();
AlunoTO.alu_codigo = Convert.ToInt32(reader["alu_codigo"]);
AlunoTO.alu_nome = Convert.ToString(reader["alu_nome"]);
AlunoTO.alu_telefone = Convert.ToInt32(reader["alu_telefone"]);
AlunoTO.alu_email = Convert.ToString(reader["alu_email"]);
AlunoTO.alu_data_nascimento = Convert.ToDateTime(reader["alu_data_nascimento"]);
AlunoTO.alu_endereco = Convert.ToString(reader["alu_endereco"]);
AlunoTO.alu_bairro = Convert.ToString(reader["alu_bairro"]);
AlunoTO.alu_cpf = Convert.ToString(reader["alu_cpf"]);
collection.Add(AlunoTO);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(collection);
}
internal Aluno_TO GetByCode(Aluno_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
SqlDataReader reader = null;
string sql = " SELECT * FROM aluno " +
"WHERE alu_codigo = @alu_codigo ";
try
{
command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@alu_codigo", pTO.alu_codigo);
reader = command.ExecuteReader();
if (reader.Read())
{
pTO.alu_codigo = Convert.ToInt32(reader["alu_codigo"]);
pTO.alu_nome = Convert.ToString(reader["alu_nome"]);
pTO.alu_telefone = Convert.ToInt32(reader["alu_telefone"]);
pTO.alu_email = Convert.ToString(reader["alu_email"]);
pTO.alu_data_nascimento = Convert.ToDateTime(reader["alu_data_nascimento"]);
pTO.alu_endereco = Convert.ToString(reader["alu_endereco"]);
pTO.alu_bairro = Convert.ToString(reader["alu_bairro"]);
pTO.alu_cpf = Convert.ToString(reader["alu_cpf"]);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(pTO);
}
public bool Delete(Aluno_TO pTO)
{
bool retorno = false;
try
{
retorno = new Aluno_DAO().Delete(pTO);
}
catch (Exception)
{
throw;
}
return(retorno);
}
public List <Aluno_TO> SearchAll(Aluno_TO pTO)
{
string condicao = "";
List <Aluno_TO> collection = new List <Aluno_TO>();
try
{
// implementa a condição de procura
condicao = "";
//return new Aluno_DAO().SearchAll(condicao);
collection = new Aluno_DAO().SearchAll(condicao);
}
catch (Exception)
{
throw;
}
return(collection);
}
public bool Save(Aluno_TO pTO, bool save)
{
bool retorno = false;
try
{
if (save)
{
retorno = new Aluno_DAO().Save(pTO);
}
else
{
retorno = new Aluno_DAO().Update(pTO);
}
}
catch (Exception)
{
throw;
}
return(retorno);
}
internal bool Delete(Aluno_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
bool retorno = false;
string sql = "DELETE FROM aluno WHERE alu_codigo = @alu_codigo ";
try
{
command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@alu_codigo", pTO.alu_codigo);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}
