public static DBConexion Instance()
{
if (frmInstance == null)
{
frmInstance = new DBConexion();
}
return frmInstance;
}
public DBConexion(string driver, string server, string port, string db, string user, string password)
{
this.server = server;
this.puerto = port;
this.database = db;
this.usuarioDB = user;
this.password = password;
this.conn = new MySqlConnection("server=" + server + ";port=" + puerto + ";database=" + database + ";userid=" + usuarioDB + ";password="******";");
frmInstance = this;
}
private void btnProbarConexion_Click(object sender, EventArgs e)
{
DDB.DBConexion conn = new DDB.DBConexion(Properties.Settings.Default.DRIVER, txtSERVER.Text, txtPUERTO.Text , txtDB.Text, txtUSER.Text, txtPASSWORD.Text);
if (conn.conection.State == ConnectionState.Open)
{
MessageBox.Show("Conexion Exitosa", "CONEXION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Conexion Fallo", "ERROR DE CONEXION", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void verificarConexionBD()
{
progressText.Text = "Verificando conexion con Base de Datos ...";
try
{
//seteando parametros de conexion
DDB.DBConexion conn = new DDB.DBConexion(Properties.Settings.Default.DRIVER,Properties.Settings.Default.SERVER, Properties.Settings.Default.PUERTO, Properties.Settings.Default.DATABASE, Properties.Settings.Default.USERDB, Properties.Settings.Default.PASSWORD);
progressText.Text = "Conexion con Base de Datos :" + conn.conection.State;
if (conn.conection.State != ConnectionState.Open)
{
OK = false;
}
Thread.Sleep(1000);
}
catch (Exception ex)
{
progressText.Text = "Fallo conexion con Base de Datos";
OK = false;
Thread.Sleep(1000);
}
}
public DBSIC()
{
conn = DBConexion.Instance();
}
public DBInvInicial()
{
conn = DBConexion.Instance();
}
public DBPartida()
{
conn = DBConexion.Instance();
}
public DBPac()
{
conn = DBConexion.Instance();
}
public DBCuenta()
{
conn = DBConexion.Instance();
}
public DBImages()
{
conn = DBConexion.Instance();
}
public DBMovCash()
{
conn = DBConexion.Instance();
}
public DBVencidos()
{
conn = DBConexion.Instance();
}
public DBReporte()
{
conn = DBConexion.Instance();
}
public DBTarjeta()
{
conn = DBConexion.Instance();
}
public DBGasto()
{
conn = DBConexion.Instance();
}
public DBUsuario()
{
conn = DBConexion.Instance();
}
public DBPRENDASAL()
{
conn = DBConexion.Instance();
}
public DBPrestamo()
{
conn = DBConexion.Instance();
}
public DBCatalogo()
{
conn = DBConexion.Instance();
}
