Beispiel #1
0
 /// <summary>
 /// Captura um registro pelo código
 /// </summary>
 /// <param name="pTO">Objeto Curso_TO</param>
 /// <returns>Objeto Curso_TO</returns>
 public Curso_TO GetByCode(Curso_TO pTO)
 {
     try
     {
         return(new Curso_DAO().GetByCode(pTO));
     }
     catch (Exception)
     {
         throw;
     }
 }
Beispiel #2
0
        public bool Delete(Curso_TO pTO)
        {
            bool retorno = false;

            try
            {
                retorno = new Curso_DAO().Delete(pTO);
            }
            catch (Exception)
            {
                throw;
            }
            return(retorno);
        }
Beispiel #3
0
        internal List <Curso_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 curso ";

            List <Curso_TO> collection = new List <Curso_TO>();

            try
            {
                command = new SqlCommand(sql, connection);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    Curso_TO CursoTO = new Curso_TO();
                    CursoTO.cur_codigo    = Convert.ToInt32(reader["cur_codigo"]);
                    CursoTO.cur_nome      = Convert.ToString(reader["cur_nome"]);
                    CursoTO.cur_descricao = Convert.ToString(reader["cur_descricao"]);
                    CursoTO.cur_duracao   = Convert.ToInt32(reader["cur_duracao"]);
                    collection.Add(CursoTO);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                reader.Close();
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }
            return(collection);
        }
Beispiel #4
0
        /// <summary>
        /// Captura uma lista de objetos Curso_TO
        /// </summary>
        /// <param name="pTO">Objeto Curso_TO</param>
        /// <returns>lista de objetos Curso_TO</returns>
        public List <Curso_TO> SearchAll(Curso_TO pTO)
        {
            string condicao = "";

            try
            {
                // implementa a condição de procura
                condicao += "";
                return(new Curso_DAO().SearchAll(condicao));
            }
            catch (Exception)
            {
                throw;
            }
        }
Beispiel #5
0
        internal Curso_TO GetByCode(Curso_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 curso " +
                         "WHERE  cur_codigo = @cur_codigo ";

            try
            {
                command = new SqlCommand(sql, connection);

                command.Parameters.AddWithValue("@cur_codigo", pTO.cur_codigo);
                reader = command.ExecuteReader();

                if (reader.Read())
                {
                    pTO.cur_codigo    = Convert.ToInt32(reader["cur_codigo"]);
                    pTO.cur_nome      = Convert.ToString(reader["cur_nome"]);
                    pTO.cur_descricao = Convert.ToString(reader["cur_descricao"]);
                    pTO.cur_duracao   = Convert.ToInt32(reader["cur_duracao"]);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                reader.Close();
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }

            return(pTO);
        }
Beispiel #6
0
        internal bool Save(Curso_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 curso" +
                         "( cur_nome " +
                         ", cur_descricao " +
                         ", cur_duracao) " +
                         "VALUES " +
                         "(  @cur_nome " +
                         " , @cur_descricao " +
                         " , @cur_duracao ) ";

            try
            {
                command = new SqlCommand(sql, connection);
                command.Parameters.AddWithValue("@cur_nome", pTO.cur_nome);
                command.Parameters.AddWithValue("@cur_descricao", pTO.cur_descricao);
                command.Parameters.AddWithValue("@cur_duracao", pTO.cur_duracao);
                command.ExecuteNonQuery();
                retorno = true;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }

            return(retorno);
        }
Beispiel #7
0
        internal bool Update(Curso_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 = "UPDATE curso" +
                         " SET cur_nome = @cur_nome " +
                         " , cur_descricao = @cur_descricao " +
                         " , cur_duracao = @cur_duracao " +
                         "WHERE  cur_codigo = @cur_codigo ";

            try
            {
                command = new SqlCommand(sql, connection);
                command.Parameters.AddWithValue("@cur_codigo", pTO.cur_codigo);
                command.Parameters.AddWithValue("@cur_nome", pTO.cur_nome);
                command.Parameters.AddWithValue("@cur_descricao", pTO.cur_descricao);
                command.Parameters.AddWithValue("@cur_duracao", pTO.cur_duracao);
                command.ExecuteNonQuery();
                retorno = true;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }

            return(retorno);
        }
Beispiel #8
0
        public bool Save(Curso_TO pTO, bool novo)
        {
            bool retorno = false;

            try
            {
                if (novo)
                {
                    retorno = new Curso_DAO().Save(pTO);
                }
                else
                {
                    retorno = new Curso_DAO().Update(pTO);
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(retorno);
        }
Beispiel #9
0
        internal bool Delete(Curso_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 curso WHERE  cur_codigo = @cur_codigo ";

            try
            {
                command = new SqlCommand(sql, connection);
                command.Parameters.AddWithValue("@cur_codigo", pTO.cur_codigo);
                command.ExecuteNonQuery();
                retorno = true;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }

            return(retorno);
        }