示例#1
0
 private void ingresarColaboradoresToolStripMenuItem_Click(object sender, EventArgs e)
 {
     IngresarColaborador inColaborador = new IngresarColaborador();
     inColaborador.MdiParent = this; //PAra que se ejecute ingresarTrabajo dentro de la pantalla de principal
     inColaborador.Show();
 }
示例#2
0
        private void Buscar_Click(object sender, EventArgs e)
        {
            int ContTemp;
            bool error = false;
            if (Principal.State == (int)Principal.Estado.Cliente)
            {
                #region
                //Abrir lo de editar cliente
                //Buscar si existe el Id de lo que esté buscando.
                //En caso de existir y tener una longitud de 10, abrir el "IngresarPersonaNatural"
                //Caso contrario, y de existir, abrir "IngresarEmpresa"
                //Nótese que en estos caso la celda de RUC/Cédula debe estar bloqueada.
                using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Initial Catalog=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
                {
                    if (textBox1.Text.Length == 10)
                    {
                        #region
                        SqlCommand cmd = new SqlCommand();
                        SqlDataReader reader;
                        cmd.CommandText = "buscarInfoPesonaNatural";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Connection = con;
                        cmd.Parameters.AddWithValue("@Ncedula", textBox1.Text);
                        con.Open();
                        reader = cmd.ExecuteReader();
                        reader.Read();
                        //NCedula   [0]
                        //Nombre    [1]
                        //Apellido  [2]
                        //Direccion [3]
                        //Telefono  [4]...[9]
                        try
                        {
                            informacion[0] = reader.GetString(0);
                            informacion[1] = reader.GetString(1);
                            informacion[2] = reader.GetString(2);
                            informacion[3] = reader.GetString(3);
                            informacion[4] = reader.GetString(4);

                            ContTemp = 5;
                            while (reader.Read())
                            {
                                informacion[ContTemp] = reader.GetString(4);
                                ContTemp++;
                            }
                        }
                        catch
                        {
                            error = true;
                        }
                        con.Close();
                        #endregion
                    }
                    else if (textBox1.Text.Length == 13)
                    {
                        #region
                        // RUC para pruebas 1400016877001
                        SqlCommand cmd = new SqlCommand();
                        SqlDataReader reader;
                        cmd.CommandText = "buscarInfoEmpresas";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Connection = con;
                        cmd.Parameters.AddWithValue("@RUC", textBox1.Text);
                        con.Open();
                        reader = cmd.ExecuteReader();
                        reader.Read();
                        //RUC   [0]
                        //RazonSocial    [1]
                        //Direccion  [2]
                        //Telefonos [3] .. [9]
                        try
                        {
                            informacion[0] = reader.GetString(0);
                            informacion[1] = reader.GetString(1);
                            informacion[2] = reader.GetString(2);
                            informacion[3] = reader.GetString(3);

                            ContTemp = 4;
                            while (reader.Read())
                            {
                                informacion[ContTemp] = reader.GetString(3);
                                ContTemp++;
                            }
                        }
                        catch
                        {
                            error = true;
                        }
                        con.Close();
                        #endregion
                    }
                    else
                    {
                        error = true;
                    }
                    /*
                    cmd.CommandText = "buscarInfoPesonaNatural";
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@Cedula", textBox1.Text);
                    sqlConnection1.Open();

                    reader = cmd.ExecuteReader();
                    */
                }
                if (!error)
                {
                    Buscador.Actualizar = true;
                    if (textBox1.Text.Length == 10)
                    {
                        IngresarPersonaNatural ing = new IngresarPersonaNatural();
                        ing.MdiParent = this.MdiParent;
                        ing.Show();
                    }
                    else
                    {
                        IngresarEmpresa ing2 = new IngresarEmpresa();
                        ing2.MdiParent = this.MdiParent;
                        ing2.Show();
                    }
                    this.Dispose();
                }
                else
                {
                    MessageBox.Show("No se encontraron datos del cliente", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                #endregion
            }
            else if (Principal.State == (int)Principal.Estado.Colaborador)
            {
                #region
                //Abrir editar colaborador
                using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Initial Catalog=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
                {
                    if (textBox1.Text.Length == 10)
                    {
                        SqlCommand cmd = new SqlCommand();
                        SqlDataReader reader;
                        cmd.CommandText = "spConsultarColaborador";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Connection = con;
                        cmd.Parameters.AddWithValue("@ced", textBox1.Text);
                        con.Open();
                        reader = cmd.ExecuteReader();
                        reader.Read();

                        //Nombre [0]
                        //Apellido [1]
                        //Ncedula [2]
                        //Cargo [3]
                        //Telefono [4]
                        //Contraseña [5]
                        try
                        {
                            informacion[0] = reader.GetString(0);
                            informacion[1] = reader.GetString(1);
                            informacion[2] = reader.GetString(2);
                            informacion[3] = reader.GetString(3);
                            informacion[4] = reader.GetString(4);
                            informacion[5] = "******";

                            Actualizar = true;
                            IngresarColaborador ing = new IngresarColaborador();
                            ing.Show();
                            this.Dispose();
                        }
                        catch
                        {
                            MessageBox.Show("No se encontraron datos del colaborador", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        finally
                        {
                            con.Close();
                        }

                    }
                }
                #endregion
            }
            else if (Principal.State == (int)Principal.Estado.Inventario)
            {
                #region
                //Abrir editar Inventario
                #endregion
            }
            else if ((Principal.State == (int)Principal.Estado.Trabajo))
            {
                int x=0;
                using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Initial Catalog=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
                {
                    SqlCommand cmd = new SqlCommand();

                    cmd.CommandText = "spEntregarTrabajo";
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@Id", textBox1.Text);
                    con.Open();
                    x = cmd.ExecuteNonQuery();
                    con.Close();
                }
                if ( x > 0)
                {
                    MessageBox.Show("Trabajo Entregado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
                else
                {
                    MessageBox.Show("Trabajo No Encontrado", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            else
            {
                #region
                //Abrir proveedor
                using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Initial Catalog=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
                {
                    SqlCommand cmd = new SqlCommand();
                    SqlDataReader reader;
                    cmd.CommandText = "spConsultarProveedor";
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@RUC", textBox1.Text);
                    con.Open();
                    reader = cmd.ExecuteReader();
                    reader.Read();

                    try
                    {
                        //Nombre            [0]
                        //Apellid           [1]
                        //RUC               [2]
                        //DIRECCION         [3]
                        //NOMBRE_EMPRESA    [4]
                        //TELEFONO          [5]...[9]
                        int ContTmp = 6;
                        informacion[0] = reader.GetString(0);
                        informacion[1] = reader.GetString(1);
                        informacion[2] = reader.GetString(2);
                        informacion[3] = reader.GetString(3);
                        informacion[4] = reader.GetString(4);
                        informacion[5] = reader.GetString(5);

                        while (reader.Read())
                        {
                            informacion[ContTmp] = reader.GetString(5);
                            ContTmp++;
                        }
                        Actualizar = true;
                        IngresarProveedor ing4 = new IngresarProveedor();
                        ing4.Show();
                        this.Dispose();
                    }
                    catch
                    {
                        MessageBox.Show("No se encontraron datos del proveedor", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                #endregion
            }
        }