internal bool Save(Interacao_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
bool retorno = false;
string sql = "INSERT INTO vcrm_interacao" +
" ( int_codigo " +
", int_data_hora " +
", can_codigo " +
", con_codigo " +
", atd_codigo " +
", int_conteudo) " +
"VALUES " +
"( @int_codigo " +
" , @int_data_hora " +
" , @can_codigo " +
" , @con_codigo " +
" , @atd_codigo " +
" , @int_conteudo ) ";
try
{
command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@int_codigo", pTO.int_codigo);
command.Parameters.AddWithValue("@int_data_hora", pTO.int_data_hora);
command.Parameters.AddWithValue("@can_codigo", pTO.CanalTO.can_codigo);
command.Parameters.AddWithValue("@con_codigo", pTO.ConsultorTO.con_codigo);
command.Parameters.AddWithValue("@atd_codigo", pTO.AtendimentoTO.atd_codigo);
command.Parameters.AddWithValue("@int_conteudo", pTO.int_conteudo);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}
internal List <Interacao_TO> SearchAll(string pCondicao)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
SqlDataReader reader = null;
string sql = " SELECT * FROM vcrm_interacao ";
List <Interacao_TO> collection = new List <Interacao_TO>();
try
{
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
Interacao_TO InteracaoTO = new Interacao_TO();
InteracaoTO.int_codigo = Convert.ToInt32(reader["int_codigo"]);
InteracaoTO.int_data_hora = Convert.ToDateTime(reader["int_data_hora"]);
InteracaoTO.CanalTO = new Canal_TO();
InteracaoTO.CanalTO.can_codigo = Convert.ToInt32(reader["can_codigo"]);
InteracaoTO.ConsultorTO = new Consultor_TO();
InteracaoTO.ConsultorTO.con_codigo = Convert.ToInt32(reader["con_codigo"]);
InteracaoTO.AtendimentoTO = new Atendimento_TO();
InteracaoTO.AtendimentoTO.atd_codigo = Convert.ToInt32(reader["atd_codigo"]);
InteracaoTO.int_conteudo = (reader["int_conteudo"]);
collection.Add(InteracaoTO);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(collection);
}
public Interacao_TO GetByCode(Interacao_TO pTO)
{
try
{
return(new Interacao_DAO().GetByCode(pTO));
}
catch (Exception)
{
throw;
}
}
internal Interacao_TO GetByCode(Interacao_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
SqlDataReader reader = null;
string sql = " SELECT * FROM vcrm_interacao ";
try
{
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
if (reader.Read())
{
pTO.int_codigo = Convert.ToInt32(reader["int_codigo"]);
pTO.int_data_hora = Convert.ToDateTime(reader["int_data_hora"]);
pTO.CanalTO = new Canal_TO();
pTO.CanalTO.can_codigo = Convert.ToInt32(reader["can_codigo"]);
pTO.ConsultorTO = new Consultor_TO();
pTO.ConsultorTO.con_codigo = Convert.ToInt32(reader["con_codigo"]);
pTO.AtendimentoTO = new Atendimento_TO();
pTO.AtendimentoTO.atd_codigo = Convert.ToInt32(reader["atd_codigo"]);
pTO.int_conteudo = (reader["int_conteudo"]);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(pTO);
}
public bool Delete(Interacao_TO pTO)
{
bool retorno = false;
try
{
retorno = new Interacao_DAO().Delete(pTO);
}
catch (Exception)
{
throw;
}
return(retorno);
}
public List <Interacao_TO> SearchAll(Interacao_TO pTO)
{
string condicao = "";
try
{
// implementa a condição de procura
condicao += "";
return(new Interacao_DAO().SearchAll(condicao));
}
catch (Exception)
{
throw;
}
}
public bool Save(bool pOpcao, Interacao_TO pTO)
{
bool retorno = false;
try
{
if (pOpcao)
{
retorno = new Interacao_DAO().Save(pTO);
}
else
{
retorno = new Interacao_DAO().Update(pTO);
}
}
catch (Exception)
{
throw;
}
return(retorno);
}
internal bool Delete(Interacao_TO pTO)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
connection.Open();
}
catch (Exception)
{
throw;
}
SqlCommand command = null;
bool retorno = false;
string sql = "DELETE FROM vcrm_interacao" +
"WHERE ... ";
try
{
command = new SqlCommand(sql, connection);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}