Exemple #1
0
        public static bool excluiConvenio(CL_Convenio objConvenio, string con)
        {
            DB_Funcoes.DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            string        sql    = "DELETE FROM convenio WHERE con_cod=" + objConvenio.con_cod;
            NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);

            Conn.Open();
            try
            {
                comand.ExecuteScalar();
                return(true);
            }
            catch (Exception ex)
            {
                ex.ToString();
                return(false);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
        }
Exemple #2
0
        public static bool alteraConvenio(CL_Convenio objConvenio, string con)
        {
            DB_Funcoes.DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            try
            {
                string sql = "UPDATE convenio SET con_agenc=@con_agenc, con_area=@con_area, con_banco=@con_banco, con_celul=@con_celul, " +
                             "con_cep=@con_cep, con_cgc=@con_cgc, con_cida=@con_cida, con_comis=@con_comis, con_cont=@con_cont, con_conta=@con_conta, " +
                             "con_email=@con_email, con_fone=@con_fone, con_est=@con_est, con_ende=@con_ende, con_iest=@con_iest, con_login=@con_login, " +
                             "con_nome=@con_nome, con_pedido=@con_pedido, con_revend=@con_revend, con_umov=@con_umov, con_situac=@con_situac, " +
                             "con_termi=@con_termi, con_tipo=@con_tipo, con_corretor=@con_corretor WHERE con_cod=@con_cod";

                NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
                comand.Parameters.AddWithValue("con_agenc", objConvenio.con_agencia);
                comand.Parameters.AddWithValue("con_area", objConvenio.con_area);
                comand.Parameters.AddWithValue("con_banco", objConvenio.con_banco);
                comand.Parameters.AddWithValue("con_celul", objConvenio.con_celul);
                comand.Parameters.AddWithValue("con_cep", objConvenio.con_cep);
                comand.Parameters.AddWithValue("con_cgc", objConvenio.con_cgc);
                comand.Parameters.AddWithValue("con_cida", objConvenio.con_cida);
                comand.Parameters.AddWithValue("con_comis", objConvenio.con_comis);
                comand.Parameters.AddWithValue("con_cont", objConvenio.con_cont);
                comand.Parameters.AddWithValue("con_conta", objConvenio.con_conta);
                comand.Parameters.AddWithValue("con_email", objConvenio.con_email);
                comand.Parameters.AddWithValue("con_fone", objConvenio.con_fone);
                comand.Parameters.AddWithValue("con_est", objConvenio.con_est);
                comand.Parameters.AddWithValue("con_ende", objConvenio.con_ende);
                comand.Parameters.AddWithValue("con_iest", objConvenio.con_iest);
                comand.Parameters.AddWithValue("con_login", objConvenio.con_login);
                comand.Parameters.AddWithValue("con_nome", objConvenio.con_nome);
                comand.Parameters.AddWithValue("con_pedido", objConvenio.con_pedido);
                comand.Parameters.AddWithValue("con_revend", objConvenio.con_revend);
                comand.Parameters.AddWithValue("con_umov", objConvenio.con_umov);
                comand.Parameters.AddWithValue("con_situac", objConvenio.con_situac);
                comand.Parameters.AddWithValue("con_termi", objConvenio.con_termi);
                comand.Parameters.AddWithValue("con_tipo", objConvenio.con_tipo);
                comand.Parameters.AddWithValue("con_cod", objConvenio.con_cod);
                comand.Parameters.AddWithValue("con_corretor", objConvenio.con_corretor);
                Conn.Open();
                comand.ExecuteScalar();
                return(true);
            }
            catch (Exception ex)
            {
                ex.ToString();
                return(false);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
        }
Exemple #3
0
 public static bool excluiConvenio(CL_Convenio objConvenio, string con)
 {
     if (objConvenio.con_cod > 0)
     {
         return(DB_Convenio.excluiConvenio(objConvenio, con));
     }
     else
     {
         return(false);
     }
 }
Exemple #4
0
        public static CL_Convenio buscaConSenha(CL_Convenio objConvenio, string con)
        {
            DB_Funcoes.DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            string sql = "SELECT con_cod, con_nome FROM convenio WHERE con_senha='" + objConvenio.con_senha + "'";

            NpgsqlCommand    comand = new NpgsqlCommand(sql, Conn);
            NpgsqlDataReader dr;

            try
            {
                Conn.Open();
                dr = comand.ExecuteReader();
                if (dr.HasRows)
                {
                    if (dr.Read())
                    {
                        objConvenio.con_cod  = Convert.ToInt32(dr["con_cod"]);
                        objConvenio.con_nome = dr["con_nome"].ToString().Trim();
                        return(objConvenio);
                    }
                    else
                    {
                        objConvenio = null;
                        return(objConvenio);
                    }
                }
                else
                {
                    objConvenio = null;
                    return(objConvenio);
                }
            }
            catch (Exception ex)
            {
                ex.ToString();
                objConvenio = null;
                return(objConvenio);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
        }
Exemple #5
0
        public static CL_Convenio buscaConvenio(string con_cod, string con)
        {
            DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            String sql = "SELECT * FROM convenio WHERE con_cod =" + con_cod;

            NpgsqlCommand    comand = new NpgsqlCommand(sql, Conn);
            NpgsqlDataReader dr;

            try
            {
                Conn.Open();
                dr = comand.ExecuteReader();
                if (dr.HasRows)
                {
                    if (dr.Read())
                    {
                        CL_Convenio objConvenio = new CL_Convenio();

                        objConvenio.con_cod  = Convert.ToInt32(dr["con_cod"]);
                        objConvenio.con_nome = dr["con_nome"].ToString().Trim();

                        return(objConvenio);
                    }
                    return(null);
                }
            }
            catch (Exception ex)
            {
                ex.ToString();
                return(null);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
            return(null);
        }
Exemple #6
0
        public static List <CL_Convenio> listarApp(string con)
        {
            DB_Funcoes.DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            string             sql         = "SELECT * FROM convenio WHERE con_umov='S' OR con_umov='A' ORDER BY con_cod";
            List <CL_Convenio> objListCon  = new List <CL_Convenio>();
            CL_Convenio        objConvenio = null;

            NpgsqlCommand    comand = new NpgsqlCommand(sql, Conn);
            NpgsqlDataReader dr;

            try
            {
                Conn.Open();
                dr = comand.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        objConvenio             = new CL_Convenio();
                        objConvenio.con_cod     = Convert.ToInt32(dr["con_cod"]);
                        objConvenio.con_nome    = dr["con_nome"].ToString().Trim();
                        objConvenio.con_comis   = Convert.ToDouble(dr["con_comis"]);
                        objConvenio.con_agencia = dr["con_agenc"].ToString().Trim();
                        objConvenio.con_area    = dr["con_area"].ToString().Trim();
                        objConvenio.con_banco   = dr["con_banco"].ToString().Trim();
                        objConvenio.con_celul   = dr["con_celul"].ToString().Trim();
                        objConvenio.con_cep     = dr["con_cep"].ToString().Trim();
                        objConvenio.con_cgc     = dr["con_cgc"].ToString().Trim();
                        objConvenio.con_cida    = dr["con_cida"].ToString().Trim();
                        objConvenio.con_cont    = dr["con_cont"].ToString().Trim();
                        objConvenio.con_conta   = dr["con_conta"].ToString().Trim();
                        objConvenio.con_email   = dr["con_email"].ToString().Trim();
                        objConvenio.con_ende    = dr["con_ende"].ToString().Trim();
                        objConvenio.con_est     = dr["con_est"].ToString().Trim();
                        objConvenio.con_fone    = dr["con_fone"].ToString().Trim();
                        objConvenio.con_iest    = dr["con_iest"].ToString().Trim();
                        objConvenio.con_login   = dr["con_login"].ToString().Trim();
                        objConvenio.con_pedido  = Convert.ToInt32(dr["con_pedido"]);
                        objConvenio.con_revend  = dr["con_revend"].ToString().Trim();
                        objConvenio.con_situac  = dr["con_situac"].ToString().Trim();
                        objConvenio.con_termi   = dr["con_termi"].ToString().Trim();
                        objConvenio.con_tipo    = dr["con_tipo"].ToString().Trim();
                        objConvenio.con_umov    = dr["con_umov"].ToString().Trim();
                        objListCon.Add(objConvenio);
                    }
                    dr.Close();
                    return(objListCon);
                }
                else
                {
                    objListCon = null;
                    return(objListCon);
                }
            }
            catch (Exception ex)
            {
                ex.ToString();
                objListCon = null;
                return(objListCon);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
        }
Exemple #7
0
        public static bool cadConvenio(CL_Convenio objConvenio, string con)
        {
            DB_Funcoes.DesmontaConexao(con);
            CONEXAO = montaDAO(CONEXAO);
            Conn    = new NpgsqlConnection(CONEXAO);

            try
            {
                objConvenio.con_cod = buscaCod(con);
                if (objConvenio.con_cod > 0)
                {
                    string sql = "INSERT INTO convenio (con_agenc, con_area, con_banco, con_celul, con_cep, con_cgc, con_cida, con_cod, con_comis, con_cont, con_conta, con_email, con_ende, con_est, con_fone, con_iest, con_login, con_nome, con_pedido, con_revend, con_senha, con_situac, con_termi, con_tipo, con_umov, con_corretor)" +
                                 "VALUES (@con_agenc, @con_area, @con_banco, @con_celul, @con_cep, @con_cgc, @con_cida, @con_cod, @con_comis, @con_cont, @con_conta, @con_email, @con_ende, @con_est, @con_fone, @con_iest, @con_login, @con_nome, @con_pedido, @con_revend, @con_senha, @con_situac, @con_termi, @con_tipo, @con_umov, @con_corretor)";

                    NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
                    comand.Parameters.AddWithValue("con_agenc", objConvenio.con_agencia);
                    comand.Parameters.AddWithValue("con_area", objConvenio.con_area);
                    comand.Parameters.AddWithValue("con_banco", objConvenio.con_banco);
                    comand.Parameters.AddWithValue("con_celul", objConvenio.con_celul);
                    comand.Parameters.AddWithValue("con_cep", objConvenio.con_cep);
                    comand.Parameters.AddWithValue("con_cgc", objConvenio.con_cgc);
                    comand.Parameters.AddWithValue("con_cida", objConvenio.con_cida);
                    comand.Parameters.AddWithValue("con_cod", objConvenio.con_cod);
                    comand.Parameters.AddWithValue("con_comis", objConvenio.con_comis);
                    comand.Parameters.AddWithValue("con_cont", objConvenio.con_cont);
                    comand.Parameters.AddWithValue("con_conta", objConvenio.con_conta);
                    comand.Parameters.AddWithValue("con_email", objConvenio.con_email);
                    comand.Parameters.AddWithValue("con_ende", objConvenio.con_ende);
                    comand.Parameters.AddWithValue("con_est", objConvenio.con_est);
                    comand.Parameters.AddWithValue("con_fone", objConvenio.con_fone);
                    comand.Parameters.AddWithValue("con_iest", objConvenio.con_iest);
                    comand.Parameters.AddWithValue("con_login", objConvenio.con_login);
                    comand.Parameters.AddWithValue("con_nome", objConvenio.con_nome);
                    comand.Parameters.AddWithValue("con_pedido", objConvenio.con_pedido);
                    comand.Parameters.AddWithValue("con_revend", objConvenio.con_revend);
                    comand.Parameters.AddWithValue("con_senha", objConvenio.con_senha);
                    comand.Parameters.AddWithValue("con_situac", objConvenio.con_situac);
                    comand.Parameters.AddWithValue("con_termi", objConvenio.con_termi);
                    comand.Parameters.AddWithValue("con_tipo", objConvenio.con_tipo);
                    comand.Parameters.AddWithValue("con_umov", objConvenio.con_umov);
                    comand.Parameters.AddWithValue("con_corretor", objConvenio.con_corretor);
                    Conn.Open();
                    comand.ExecuteScalar();
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                ex.ToString();
                return(false);
            }
            finally
            {
                if (Conn.State == ConnectionState.Open)
                {
                    Conn.Close();
                }
            }
        }
Exemple #8
0
 public static CL_Convenio buscaConSenha(CL_Convenio objConvenio, string con)
 {
     return(DB_Convenio.buscaConSenha(objConvenio, con));
 }