public Canal_TO GetByCode(Canal_TO pTO) { try { return(new Canal_DAO().GetByCode(pTO)); } catch (Exception) { throw; } }
internal bool Save(Canal_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_canal" + " ( can_codigo " + ", can_nome " + ", can_virtual " + ", can_facebook " + ", can_gmail) " + "VALUES " + "( @can_codigo " + " , @can_nome " + " , @can_virtual " + " , @can_facebook " + " , @can_gmail ) "; try { command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@can_codigo", pTO.can_codigo); command.Parameters.AddWithValue("@can_nome", pTO.can_nome); command.Parameters.AddWithValue("@can_virtual", pTO.can_virtual); command.Parameters.AddWithValue("@can_facebook", pTO.can_facebook); command.Parameters.AddWithValue("@can_gmail", pTO.can_gmail); command.ExecuteNonQuery(); retorno = true; } catch (Exception) { throw; } finally { command.Dispose(); connection.Close(); connection.Dispose(); } return(retorno); }
public bool Delete(Canal_TO pTO) { bool retorno = false; try { retorno = new Canal_DAO().Delete(pTO); } catch (Exception) { throw; } return(retorno); }
internal List <Canal_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_canal "; List <Canal_TO> collection = new List <Canal_TO>(); try { command = new SqlCommand(sql, connection); reader = command.ExecuteReader(); while (reader.Read()) { Canal_TO CanalTO = new Canal_TO(); CanalTO.can_codigo = Convert.ToInt32(reader["can_codigo"]); CanalTO.can_nome = Convert.ToString(reader["can_nome"]); CanalTO.can_virtual = Convert.ToInt32(reader["can_virtual"]); CanalTO.can_facebook = Convert.ToInt32(reader["can_facebook"]); CanalTO.can_gmail = Convert.ToInt32(reader["can_gmail"]); collection.Add(CanalTO); } } catch (Exception) { throw; } finally { reader.Close(); command.Dispose(); connection.Close(); connection.Dispose(); } return(collection); }
public List <Canal_TO> SearchAll(Canal_TO pTO) { string condicao = ""; try { // implementa a condição de procura condicao += ""; return(new Canal_DAO().SearchAll(condicao)); } catch (Exception) { throw; } }
internal Canal_TO GetByCode(Canal_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_canal "; try { command = new SqlCommand(sql, connection); reader = command.ExecuteReader(); if (reader.Read()) { pTO.can_codigo = Convert.ToInt32(reader["can_codigo"]); pTO.can_nome = Convert.ToString(reader["can_nome"]); pTO.can_virtual = Convert.ToInt32(reader["can_virtual"]); pTO.can_facebook = Convert.ToInt32(reader["can_facebook"]); pTO.can_gmail = Convert.ToInt32(reader["can_gmail"]); } } catch (Exception) { throw; } finally { reader.Close(); command.Dispose(); connection.Close(); connection.Dispose(); } return(pTO); }
public bool Save(bool pOpcao, Canal_TO pTO) { bool retorno = false; try { if (pOpcao) { retorno = new Canal_DAO().Save(pTO); } else { retorno = new Canal_DAO().Update(pTO); } } catch (Exception) { throw; } return(retorno); }
internal bool Delete(Canal_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_canal" + "WHERE ... "; try { command = new SqlCommand(sql, connection); command.ExecuteNonQuery(); retorno = true; } catch (Exception) { throw; } finally { command.Dispose(); connection.Close(); connection.Dispose(); } return(retorno); }