private void ejecucion()
{
string miCarpeta = "Copias_de_Seguridad_de_" + txtsoftware;
if (System.IO.Directory.Exists(txtRuta.Text + miCarpeta))
{
}
else
{
System.IO.Directory.CreateDirectory(txtRuta.Text + miCarpeta);
}
string ruta_completa = txtRuta.Text + miCarpeta;
string SubCarpeta = ruta_completa + @"\Respaldo_al_" + DateTime.Now.Day + "_" + (DateTime.Now.Month) + "_" + DateTime.Now.Year + "_" + DateTime.Now.Hour + "_" + DateTime.Now.Minute;
try
{
System.IO.Directory.CreateDirectory(System.IO.Path.Combine(ruta_completa, SubCarpeta));
}
catch (Exception)
{
}
try
{
string v_nombre_respaldo = Base_De_datos + ".bak";
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("BACKUP DATABASE " + Base_De_datos + " TO DISK = '" + SubCarpeta + @"\" + v_nombre_respaldo + "'", CONEXIONMAESTRA.conectar);
cmd.ExecuteNonQuery();
acaba = true;
}
catch (Exception ex)
{
acaba = false;
MessageBox.Show(ex.Message);
}
}
private void dibujarMESAS()
{
try
{
PanelMesas.Controls.Clear();
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("mostrar_mesas_por_salon", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_salon", id_salon);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Button b = new Button();
Panel panel = new Panel();
int alto = Convert.ToInt32(rdr["y"].ToString());
int ancho = Convert.ToInt32(rdr["x"].ToString());
int tamanio_letra = Convert.ToInt32(rdr["Tamanio_letra"].ToString());
Point tamanio = new Point(ancho, alto);
panel.BackgroundImage = Properties.Resources.mesa_vacia;
panel.BackgroundImageLayout = ImageLayout.Zoom;
panel.Cursor = Cursors.Hand;
panel.Tag = rdr["Id_mesa"].ToString();
panel.Size = new System.Drawing.Size(tamanio);
b.Text = rdr["Mesa"].ToString();
b.Name = rdr["Id_mesa"].ToString();
if (b.Text != "NULO")
{
b.Size = new System.Drawing.Size(tamanio);
b.BackColor = Color.FromArgb(5, 179, 90);
b.Font = new System.Drawing.Font("Microsoft Sans Serif", tamanio_letra);
b.FlatStyle = FlatStyle.Flat;
b.FlatAppearance.BorderSize = 0;
b.ForeColor = Color.White;
PanelMesas.Controls.Add(b);
}
else
{
PanelMesas.Controls.Add(panel);
}
b.Click += new EventHandler(miEvento);
panel.Click += new EventHandler(miEventopanel_click);
}
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
CONEXIONMAESTRA.Cerrar();
MessageBox.Show(ex.StackTrace);
}
}
internal void disminuir_tamanio_letra()
{
try
{
SqlCommand cmd = new SqlCommand();
CONEXIONMAESTRA.abrir();
cmd = new SqlCommand("disminuir_tamanio_letra", CONEXIONMAESTRA.conectar);
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
dibujarMESAS();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
internal void aumentar_tamaño_mesa()
{
try
{
SqlCommand cmd = new SqlCommand();
CONEXIONMAESTRA.abrir();
cmd = new SqlCommand("aumentar_tamanio_mesa", CONEXIONMAESTRA.conectar);
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
dibujarMESAS();
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}
private void mostrar_id_salon_recien_ingresado()
{
SqlCommand com = new SqlCommand("mostrar_id_salon_recien_ingresado", CONEXIONMAESTRA.conectar);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Salon", txtSalonedicion.Text);
try
{
CONEXIONMAESTRA.abrir();
idsalon = Convert.ToInt32(com.ExecuteScalar());
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
CONEXIONMAESTRA.Cerrar();
MessageBox.Show(ex.StackTrace);
}
}
private void editar_mesa()
{
try
{
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("editar_mesa", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mesa", txtmesaedicion.Text);
cmd.Parameters.AddWithValue("@id_mesa", Configurar_mesas_ok.idmesa);
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
Close();
}
catch (Exception ex)
{
CONEXIONMAESTRA.Cerrar();
MessageBox.Show(ex.Message);
}
}
private void insertar_salon()
{
try
{
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("insertar_Salon", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Salon", txtSalonedicion.Text);
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
mostrar_id_salon_recien_ingresado();
insertar_mesas_vacias();
Close();
}
catch (Exception ex)
{
CONEXIONMAESTRA.conectar.Close();
MessageBox.Show(ex.Message);
}
}
private void insertar_mesas_vacias()
{
for (int i = 1; i <= 80; i++)
{
try
{
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("insertar_mesa", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mesa", "NULO");
cmd.Parameters.AddWithValue("@idsalon", idsalon);
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
CONEXIONMAESTRA.Cerrar();
MessageBox.Show(ex.StackTrace);
}
}
}
private void Ejecucion()
{
string myFolder = "Copia_de_Seguridad_de_" + txtSoftware;
if (!Directory.Exists(txtRuta.Text + myFolder))
{
Directory.CreateDirectory(txtRuta.Text + myFolder);
}
string path = txtRuta.Text + myFolder;
string subFolder = path + @"\Respaldo_al_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second;
try
{
Directory.CreateDirectory(Path.Combine(path, subFolder));
}
catch (Exception)
{
throw;
}
try
{
string vNombreRespaldo = baseDeDatos + ".bak";
CONEXIONMAESTRA.open();
string comando = $"BACKUP DATABASE {baseDeDatos} TO DISK = '{subFolder}\\{vNombreRespaldo}'";
SqlCommand cmd = new SqlCommand(comando, CONEXIONMAESTRA.connection);
cmd.ExecuteNonQuery();
end = true;
}
catch (Exception ex)
{
end = false;
MessageBox.Show(ex.Message);
}
}
private void Insertar_Producto1()
{
try
{
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("insertar_Producto", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Descripcion", txtdescripcion.Text);
cmd.Parameters.AddWithValue("@Id_grupo", Productos_rest.id_grupo);
cmd.Parameters.AddWithValue("@Precio_de_venta", txtprecioventa.Text);
cmd.Parameters.AddWithValue("@Estado_imagen", ESTADO_IMAGEN);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
ImagenProducto.Image.Save(ms, ImagenProducto.Image.RawFormat);
cmd.Parameters.AddWithValue("@Imagen", ms.GetBuffer());
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Insertar_Grupo_de_Productos()
{
try
{
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("Insertar_Grupo_de_Productos", CONEXIONMAESTRA.conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Grupo", txtgrupo.Text);
cmd.Parameters.AddWithValue("@Por_defecto", "NO");
cmd.Parameters.AddWithValue("@Estado", "ACTIVO");
cmd.Parameters.AddWithValue("@Estado_de_icono", ESTADO_IMAGEN);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
ImagenGrupo.Image.Save(ms, ImagenGrupo.Image.RawFormat);
cmd.Parameters.AddWithValue("@Icono", ms.GetBuffer());
cmd.ExecuteNonQuery();
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dibujarGrupos()
{
try
{
Panel_grupos.Controls.Clear();
CONEXIONMAESTRA.abrir();
SqlCommand cmd = new SqlCommand("select * from Grupo_de_Productos", CONEXIONMAESTRA.conectar);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Label b = new Label();
Panel p1 = new Panel();
Panel p2 = new Panel();
PictureBox I1 = new PictureBox();
b.Text = rdr["Grupo"].ToString();
b.Name = rdr["Idline"].ToString();
b.Size = new System.Drawing.Size(119, 25);
b.Font = new System.Drawing.Font("Microsoft Sans Serif", 13);
b.BackColor = Color.Transparent;
b.ForeColor = Color.White;
b.Dock = DockStyle.Fill;
b.TextAlign = ContentAlignment.MiddleCenter;
b.Cursor = Cursors.Hand;
p1.Size = new System.Drawing.Size(140, 133);
p1.BorderStyle = BorderStyle.FixedSingle;
p1.Dock = DockStyle.Bottom;
p1.BackColor = Color.FromArgb(43, 43, 43);
p1.Name = rdr["Idline"].ToString();
p2.Size = new System.Drawing.Size(140, 25);
p2.Dock = DockStyle.Top;
p2.BackColor = Color.Transparent;
p2.BorderStyle = BorderStyle.None;
I1.Size = new System.Drawing.Size(140, 76);
I1.Dock = DockStyle.Top;
I1.BackgroundImage = null;
byte[] bi = (Byte[])rdr["Icono"];
MemoryStream ms = new MemoryStream(bi);
I1.Image = Image.FromStream(ms);
I1.SizeMode = PictureBoxSizeMode.Zoom;
I1.Cursor = Cursors.Hand;
I1.Tag = rdr["Idline"].ToString();
MenuStrip Menustrip = new MenuStrip();
Menustrip.BackColor = Color.Transparent;
Menustrip.AutoSize = false;
Menustrip.Size = new System.Drawing.Size(28, 24);
Menustrip.Dock = DockStyle.Right;
Menustrip.Name = rdr["Idline"].ToString();
ToolStripMenuItem ToolStripPRINCIPAL = new ToolStripMenuItem();
ToolStripMenuItem ToolStripEDITAR = new ToolStripMenuItem();
ToolStripMenuItem ToolStripELIMINAR = new ToolStripMenuItem();
ToolStripMenuItem ToolStripRESTAURAR = new ToolStripMenuItem();
ToolStripPRINCIPAL.Image = Properties.Resources.menuCajas_claro;
ToolStripPRINCIPAL.BackColor = Color.Transparent;
ToolStripEDITAR.Text = "Editar";
ToolStripEDITAR.Name = rdr["Grupo"].ToString();
ToolStripEDITAR.Tag = rdr["Idline"].ToString();
ToolStripELIMINAR.Text = "Eliminar";
ToolStripELIMINAR.Tag = rdr["Idline"].ToString();
ToolStripRESTAURAR.Text = "Restaurar";
ToolStripRESTAURAR.Tag = rdr["Idline"].ToString();
Menustrip.Items.Add(ToolStripPRINCIPAL);
ToolStripPRINCIPAL.DropDownItems.Add(ToolStripEDITAR);
ToolStripPRINCIPAL.DropDownItems.Add(ToolStripELIMINAR);
ToolStripPRINCIPAL.DropDownItems.Add(ToolStripRESTAURAR);
p2.Controls.Add(Menustrip);
p1.Controls.Add(b);
if (rdr["Estado_de_icono"].ToString() != "VACIO")
{
p1.Controls.Add(I1);
}
p1.Controls.Add(p2);
b.BringToFront();
p2.SendToBack();
Panel_grupos.Controls.Add(p1);
b.Click += new EventHandler(miEventoLabel);
I1.Click += new EventHandler(miEventoImagen);
}
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
CONEXIONMAESTRA.Cerrar();
MessageBox.Show(ex.StackTrace);
}
}
private void dibujarSalones()
{
flowLayoutPanel1.Controls.Clear();
try
{
CONEXIONMAESTRA.abrir();
string query = "mostrar_SALON";
SqlCommand cmd = new SqlCommand(query, CONEXIONMAESTRA.conectar);
cmd.CommandType = (System.Data.CommandType) 4;
cmd.Parameters.AddWithValue("@buscar", txtsalon.Text);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Button b = new Button();
Panel panelC1 = new Panel();
Panel panelLATERAL = new Panel();
b.Text = rdr["Salon"].ToString();
b.Name = rdr["Id_salon"].ToString();
b.Tag = rdr["Estado"].ToString();
b.Dock = DockStyle.Fill;
b.BackColor = Color.Transparent;
b.Font = new System.Drawing.Font("Microsoft Sans Serif", 12);
b.FlatStyle = FlatStyle.Flat;
b.FlatAppearance.BorderSize = 0;
b.FlatAppearance.MouseDownBackColor = Color.FromArgb(64, 64, 64);
b.FlatAppearance.MouseOverBackColor = Color.FromArgb(43, 43, 43);
b.TextAlign = ContentAlignment.MiddleLeft;
b.Tag = rdr["Estado"].ToString();
panelC1.Size = new System.Drawing.Size(244, 58);
panelC1.Name = rdr["Id_salon"].ToString();
panelLATERAL.Size = new System.Drawing.Size(3, 58);
panelLATERAL.Dock = DockStyle.Left;
panelLATERAL.BackColor = Color.Transparent;
panelLATERAL.Name = rdr["Id_salon"].ToString();
string estado = rdr["Estado"].ToString();
if (estado == "ELIMINADO")
{
b.Text = rdr["Salon"].ToString() + " - Eliminado";
b.ForeColor = Color.FromArgb(231, 63, 67);
}
else
{
b.ForeColor = Color.White;
}
panelC1.Controls.Add(b);
panelC1.Controls.Add(panelLATERAL);
flowLayoutPanel1.Controls.Add(panelC1);
b.BringToFront();
panelLATERAL.SendToBack();
b.Click += new EventHandler(miEvento_salon_button);
}
CONEXIONMAESTRA.Cerrar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
