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); } }