private void personaNaturalToolStripMenuItem_Click(object sender, EventArgs e)
{
IngresarPersonaNatural ingPe = new IngresarPersonaNatural();
ingPe.MdiParent = this; //PAra que se ejecute ingresarTrabajo dentro de la pantalla de principal
ingPe.Show();
}
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
}
}