private void btnProtegeCNX_Click(object sender, EventArgs e)
{
if (txtCadenaConexion.TextLength > 0)
{
CLS.Utilities objCnx = new CLS.Utilities();
objCnx.ProtectConnectionString();
}
/*
* try
* {
* //Se abre el app.config para recuperar la seccion ConnectionStrings
* Configuration MiAppConfig = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);
* //Se recupera la seccion ConnectionStrings
* ConnectionStringsSection MiSeccion = (ConnectionStringsSection)(MiAppConfig.GetSection("connectionStrings"));
* //Se protege la seccion, caso contrario se desprotege
* if (MiSeccion.SectionInformation.IsProtected)
* MiSeccion.SectionInformation.UnprotectSection();
* else
* MiSeccion.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
* //Se guarda los cambios
* MiAppConfig.Save();
* if (MiSeccion.SectionInformation.IsProtected)
* MessageBox.Show("Cadena de Conexion Protegida");
* else
* MessageBox.Show("No esta protegida");
*
* }catch (Exception ex){
* MessageBox.Show(ex.Message);
* }
*/
}
private void btnRestaurar_Click(object sender, EventArgs e)
{
CLS.Utilities objConx = new CLS.Utilities();
string ConnectionString = objConx.GetConnectionString();
ConnectionString += ";convertzerodatetime=true;";
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "SQL Script|*.sql";
openFileDialog1.Title = "Open Script File";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
dumpFile = openFileDialog1.FileName;
// Reset variables
curBytes = 0;
totalBytes = 0;
cancel = false;
// Initialize MySqlConnection and MySqlCommand components
conn = new MySqlConnection(ConnectionString);
cmd = new MySqlCommand();
cmd.Connection = conn;
conn.Open();
// Start the Timer here
timer1.Start();
mb.ImportInfo.IntervalForProgressReport = (int)nmImInterval.Value;
mb.Command = cmd;
bwImport.RunWorkerAsync();
}
}
private void btnBackup_Click(object sender, EventArgs e)
{
//Sin Usarse porque estan por separados los módulos de respaldo y restauración.
DateTime Hoy = DateTime.Now; //antes DateTime Hoy = DateTime.today;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "SQL Script|*.sql";
saveFileDialog1.Title = "Save as Script File";
DBM.CLS.Utilities config = new CLS.Utilities();
saveFileDialog1.FileName = config.GetMySQL_DatabaseName() + " Date " + Hoy.ToString("dd-MM-yyyy HH.mm") + ".sql";
CLS.Utilities objConx = new CLS.Utilities();
string ConnectionString = objConx.GetConnectionString();
ConnectionString += ";charset=utf8;convertzerodatetime=true;";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
dumpFile = saveFileDialog1.FileName;
// Reset variables
curTable = 0;
totalTables = 0;
cancel = false;
// Initialize MySqlConnection and MySqlCommand components
conn = new MySqlConnection(ConnectionString);
cmd = new MySqlCommand();
cmd.Connection = conn;
conn.Open();
// Start the Timer here
timer2.Start();
mb.ExportInfo.IntervalForProgressReport = (int)nmImInterval.Value;
mb.Command = cmd;
bwExport.RunWorkerAsync();
}
}
private void btnDesProtegeCNX_Click(object sender, EventArgs e)
{
if (txtCadenaConexion.TextLength > 0)
{
CLS.Utilities objCnx = new CLS.Utilities();
objCnx.UnprotectConnectionString();
}
}
private void btnCambiaCNX_Click(object sender, EventArgs e)
{
if (txtCadenaConexion.TextLength > 0)
{
CLS.Utilities objCnx = new CLS.Utilities();
objCnx.SaveConnectionString(txtCadenaConexion.Text);
}
}
private void ConnectionSettings_Load(object sender, EventArgs e)
{
CLS.Utilities objCnx = new CLS.Utilities();
txtServer.Text = objCnx.GetMySQL_ServerName();
txtPort.Text = objCnx.GetMySQL_Port().ToString();
txtBD.Text = objCnx.GetMySQL_DatabaseName();
txtUser.Text = objCnx.GetMySQL_UserName();
txtPass.Text = objCnx.GetMySQL_Password();
}
private void btnSave_Click(object sender, EventArgs e)
{
CLS.Connection cnxValidate = new CLS.Connection();
CLS.Utilities objConx = new CLS.Utilities();
string newString = null;
newString = objConx.SetConnectionStringComplete(txtServer.Text, uint.Parse(txtPort.Text), txtBD.Text, txtUser.Text, txtPass.Text);
if (chkVerify.Checked)
{
if (cnxValidate.ValidarConexion(newString))
{
MessageBox.Show("Conexión exitosa", "ConnectionSettings", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (newString != null)
{
objConx.SaveConnectionString(newString);
objConx.ProtectConnectionString();
DBM.CLS.QUERY Query_ = new DBM.CLS.QUERY();
Query_.GetColumnWidth("pedido", "listo");
if (Query_.GetColumnWidth("pedido", "listo")["COLUMN_TYPE"].ToString().Trim() == "tinyint(1)")
{
DBM.CLS.Transaccion Trans = new DBM.CLS.Transaccion();
string query = "";
query = "ALTER TABLE `pedido` CHANGE `listo` `listo` TINYINT(2) NULL DEFAULT NULL;";
if (Trans.CreateTransaction(query))
{
MessageBox.Show("El campo LISTO ahora tiene un ancho de 2 ", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
else
{
MessageBox.Show("No se pudo establecer la conexión con el servidor." + saltoLinea + "Para guardar los datos sin comprobar la conexión desactive la casilla de verificación", "ConnectionSettings", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (newString != null)
{
objConx.SaveConnectionString(newString);
objConx.ProtectConnectionString();
}
}
}
private void btnObtieneCNX_Click(object sender, EventArgs e)
{
CLS.Utilities objCnx = new CLS.Utilities();
txtCadenaConexion.Text = objCnx.GetConnectionString();
}
