private string connectionStringMysql()
        {
            string      cadena = string.Empty;
            ConexionDAO objDa  = new ConexionDAO();

            cadena = objDa.CnxMySQL();
            return(cadena);
        }
        public string Usuarios_Insertar(EnUsuario objEn)
        {
            string      msg       = string.Empty;
            ConexionDAO cadenaDao = new ConexionDAO();

            using (MySqlConnection cn = new MySqlConnection(cadenaDao.CnxMySQL()))
            {
                cn.Open();
                using (MySqlTransaction tran = cn.BeginTransaction())
                {
                    try
                    {
                        DaUsuario OjbDAO = new DaUsuario();
                        OjbDAO.Usuarios_Insertar(objEn, tran);
                        tran.Commit();
                        msg = "EXITO";
                    }
                    catch (MySqlException ex)
                    {
                        tran.Rollback();
                        throw ex;
                    }
                    catch (Exception ex)
                    {
                        tran.Rollback();
                        throw ex;
                    }
                    finally
                    {
                        tran.Dispose();
                        cn.Close();
                    }
                    return(msg);
                }
            }
        }
Example #3
0
        public string Devices_configuracion(int ID, string cadena)
        {
            string      msg       = string.Empty;
            ConexionDAO cadenaDao = new ConexionDAO();

            using (MySqlConnection cn = new MySqlConnection(cadenaDao.CnxMySQL()))
            {
                cn.Open();
                using (MySqlTransaction tran = cn.BeginTransaction())
                {
                    try
                    {
                        DaDevices OjbDAO = new DaDevices();
                        OjbDAO.Devices_configuracion(ID, cadena, tran);
                        tran.Commit();
                        msg = "EXITO";
                    }
                    catch (MySqlException ex)
                    {
                        tran.Rollback();
                        throw ex;
                    }
                    catch (Exception ex)
                    {
                        tran.Rollback();
                        throw ex;
                    }
                    finally
                    {
                        tran.Dispose();
                        cn.Close();
                    }
                    return(msg);
                }
            }
        }