internal bool Update(Cliente_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 = "UPDATE vcrm_cliente" +
" SET cli_codigo = @cli_codigo " +
" , cli_nome = @cli_nome " +
" , cli_email = @cli_email " +
" , cli_celular = @cli_celular " +
" , cli_lead = @cli_lead " +
" , cli_logradouro = @cli_logradouro " +
" , cli_numero = @cli_numero " +
" , cid_codigo = @cid_codigo " +
" , cli_codstur = @cli_codstur " +
" , cli_telefone = @cli_telefone " +
"WHERE ... ";
try
{
command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@cli_codigo", pTO.cli_codigo);
command.Parameters.AddWithValue("@cli_nome", pTO.cli_nome);
command.Parameters.AddWithValue("@cli_email", pTO.cli_email);
command.Parameters.AddWithValue("@cli_celular", pTO.cli_celular);
command.Parameters.AddWithValue("@cli_lead", pTO.cli_lead);
command.Parameters.AddWithValue("@cli_logradouro", pTO.cli_logradouro);
command.Parameters.AddWithValue("@cli_numero", pTO.cli_numero);
command.Parameters.AddWithValue("@cid_codigo", pTO.CidadeTO.cid_codigo);
command.Parameters.AddWithValue("@cli_codstur", pTO.cli_codstur);
command.Parameters.AddWithValue("@cli_telefone", pTO.cli_telefone);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}
internal List <Cliente_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_cliente ";
List <Cliente_TO> collection = new List <Cliente_TO>();
try
{
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
Cliente_TO ClienteTO = new Cliente_TO();
ClienteTO.cli_codigo = Convert.ToInt32(reader["cli_codigo"]);
ClienteTO.cli_nome = Convert.ToString(reader["cli_nome"]);
ClienteTO.cli_email = Convert.ToString(reader["cli_email"]);
ClienteTO.cli_celular = Convert.ToString(reader["cli_celular"]);
ClienteTO.cli_lead = Convert.ToInt32(reader["cli_lead"]);
ClienteTO.cli_logradouro = Convert.ToString(reader["cli_logradouro"]);
ClienteTO.cli_numero = Convert.ToInt32(reader["cli_numero"]);
ClienteTO.CidadeTO = new Cidade_TO();
ClienteTO.CidadeTO.cid_codigo = Convert.ToInt32(reader["cid_codigo"]);
ClienteTO.cli_codstur = Convert.ToInt32(reader["cli_codstur"]);
ClienteTO.cli_telefone = Convert.ToString(reader["cli_telefone"]);
collection.Add(ClienteTO);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(collection);
}
public Cliente_TO GetByCode(Cliente_TO pTO)
{
try
{
return(new Cliente_DAO().GetByCode(pTO));
}
catch (Exception)
{
throw;
}
}
internal Cliente_TO GetByCode(Cliente_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_cliente ";
try
{
command = new SqlCommand(sql, connection);
reader = command.ExecuteReader();
if (reader.Read())
{
pTO.cli_codigo = Convert.ToInt32(reader["cli_codigo"]);
pTO.cli_nome = Convert.ToString(reader["cli_nome"]);
pTO.cli_email = Convert.ToString(reader["cli_email"]);
pTO.cli_celular = Convert.ToString(reader["cli_celular"]);
pTO.cli_lead = Convert.ToInt32(reader["cli_lead"]);
pTO.cli_logradouro = Convert.ToString(reader["cli_logradouro"]);
pTO.cli_numero = Convert.ToInt32(reader["cli_numero"]);
pTO.CidadeTO = new Cidade_TO();
pTO.CidadeTO.cid_codigo = Convert.ToInt32(reader["cid_codigo"]);
pTO.cli_codstur = Convert.ToInt32(reader["cli_codstur"]);
pTO.cli_telefone = Convert.ToString(reader["cli_telefone"]);
}
}
catch (Exception)
{
throw;
}
finally
{
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
return(pTO);
}
public bool Delete(Cliente_TO pTO)
{
bool retorno = false;
try
{
retorno = new Cliente_DAO().Delete(pTO);
}
catch (Exception)
{
throw;
}
return(retorno);
}
public List <Cliente_TO> SearchAll(Cliente_TO pTO)
{
string condicao = "";
try
{
// implementa a condição de procura
condicao += "";
return(new Cliente_DAO().SearchAll(condicao));
}
catch (Exception)
{
throw;
}
}
public bool Save(bool pOpcao, Cliente_TO pTO)
{
bool retorno = false;
try
{
if (pOpcao)
{
retorno = new Cliente_DAO().Save(pTO);
}
else
{
retorno = new Cliente_DAO().Update(pTO);
}
}
catch (Exception)
{
throw;
}
return(retorno);
}
internal bool Delete(Cliente_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_cliente" +
"WHERE ... ";
try
{
command = new SqlCommand(sql, connection);
command.ExecuteNonQuery();
retorno = true;
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
connection.Dispose();
}
return(retorno);
}