public void guardarDatos(String Nombre, String Apellido, String Cedula, String Cargo, String Telefono, String Contrasena)
{
Colaborador conexion = new Colaborador();
int ingresado = 0;
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spAñadirColaborador", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", Nombre);
cmd.Parameters.AddWithValue("@Apellido", Apellido);
cmd.Parameters.AddWithValue("@NCedula", Cedula);
cmd.Parameters.AddWithValue("@Cargo", Cargo);
cmd.Parameters.AddWithValue("@Telefono", Telefono);
cmd.Parameters.AddWithValue("@Contraseña", Contrasena);
con.Open();
ingresado=cmd.ExecuteNonQuery();
con.Close();
}
}
if (ingresado > 0)
{
MessageBox.Show("Colaborador Ingresado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void actualizarDatos()
{
Colaborador conexion = new Colaborador();
int ingresado = 0;
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spActualizarColaborador", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", tNombre.Text);
cmd.Parameters.AddWithValue("@Apellido", tApellido.Text);
cmd.Parameters.AddWithValue("@Ncedula", tCedula.Text);
cmd.Parameters.AddWithValue("@Cargo", tCargo.Text);
cmd.Parameters.AddWithValue("@Telefono", tTelefono.Text);
con.Open();
ingresado= cmd.ExecuteNonQuery();
con.Close();
}
}
if (ingresado > 0)
{
MessageBox.Show("Colaborador Actualizado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void guardarDatos(DateTime Fecha, float Valor, String NumFactura, String CedulaColab, String Descripcion)
{
Colaborador conexion = new Colaborador();
int ingresado = 0;
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spAgregarEgreso", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Fecha", Fecha);
cmd.Parameters.AddWithValue("@Valor", Valor);
cmd.Parameters.AddWithValue("@NumFactura", NumFactura);
cmd.Parameters.AddWithValue("@CedulaColab", CedulaColab);
cmd.Parameters.AddWithValue("@Id_proveedor", Convert.ToString(comboBox1.SelectedValue));
cmd.Parameters.AddWithValue("@Descripcion", Descripcion);
con.Open();
ingresado=cmd.ExecuteNonQuery();
con.Close();
}
}
if (ingresado > 0)
{
MessageBox.Show("Egreso Registrado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void ActualizarDatos(String Nombre, String Apellido, String Cedula, String Direccion)
{
Colaborador conexion = new Colaborador();
int ingresado = 0;
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spActualizarClienteNatural", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Direccion", Direccion);
cmd.Parameters.AddWithValue("@NCedula", Cedula);
cmd.Parameters.AddWithValue("@Nombre", Nombre);
cmd.Parameters.AddWithValue("@Apellido", Apellido);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
using (SqlConnection con2 = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
SqlConnection sqlConnection1 = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd3 = new SqlCommand();
SqlDataReader reader;
cmd3.CommandText = "SELECT Id_Cliente FROM Persona_Natural where Ncedula='" + Cedula + "'";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = sqlConnection1;
sqlConnection1.Open();
reader = cmd3.ExecuteReader();
reader.Read();
int id = reader.GetInt32(0);
using (SqlCommand cmdx = new SqlCommand("spEliminarTelefonos", con2))
{
cmdx.CommandType = CommandType.StoredProcedure;
cmdx.Parameters.AddWithValue("@Id_Cliente", id);
con2.Open();
cmdx.ExecuteNonQuery();
con2.Close();
}
for (int i = 0; i < lista.Count(); i++)
{
using (SqlCommand cmd2 = new SqlCommand("spAgregarTelefono", con2))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Id_Cliente", id);
cmd2.Parameters.AddWithValue("@Telefono", lista.ElementAt(i).Text);
con2.Open();
ingresado=cmd2.ExecuteNonQuery();
con2.Close();
}
}
sqlConnection1.Close();
}
if (ingresado > 0)
{
MessageBox.Show("Cliente Actualizado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void actualizarDatos()
{
Colaborador conexion = new Colaborador();
int ingresado = 0;
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spActualizarProveedor", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", textBox1.Text);
cmd.Parameters.AddWithValue("@Apellido", textBox2.Text);
cmd.Parameters.AddWithValue("@RUC", textBox3.Text);
cmd.Parameters.AddWithValue("@Nombre_empresa", textBox4.Text);
cmd.Parameters.AddWithValue("@Direccion", tdireccion.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
using (SqlCommand cmd = new SqlCommand("spBorrarTelProveedor", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RUC", textBox3.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
for (int i = 0; i < lista.Count(); i++)
{
using (SqlCommand cmd = new SqlCommand("spAgregarTelefonoProveedor", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RUC", textBox3.Text);
cmd.Parameters.AddWithValue("@Telefono", lista[i].Text);
con.Open();
ingresado=cmd.ExecuteNonQuery();
con.Close();
}
}
}
if (ingresado > 0)
{
MessageBox.Show("Proveedor Actualizado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void guardarDatos(String Nombre, String Cantidad, String Descripcion)
{
Colaborador conexion = new 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"))
{
using (SqlCommand cmd = new SqlCommand("spAgregarProducto", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", Nombre);
cmd.Parameters.AddWithValue("@Cantidad", Cantidad);
cmd.Parameters.AddWithValue("@Descricion", Descripcion);
cmd.Parameters.AddWithValue("@RUC", Convert.ToString(cbProveedores.SelectedValue));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
private void bActualizar_Click(object sender, EventArgs e)
{
Colaborador conexion = new Colaborador();
using (SqlConnection con = new SqlConnection("Data Source=25.22.77.136,49170;Database=imp_isabelita;Integrated Security=False;User ID=sa;Password=imprentaisabelita;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
using (SqlCommand cmd = new SqlCommand("spActualizarProducto", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cod", Tid.Text);
if (rAgregar.Checked)
cmd.Parameters.AddWithValue("@cant", Convert.ToInt32(Ingresar.Text));
else if (rQuitar.Checked)
cmd.Parameters.AddWithValue("@cant", (-1) * Convert.ToInt32(Ingresar.Text));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
this.Close();
}
public void guardarDatosProveedor(String Nombre, String Apellido, String Ruc, String Nombre_empresa, String Direccion)
{
Colaborador conexion = new Colaborador();
int ingresado = 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"))
{
using (SqlCommand cmd = new SqlCommand("spAgregarProveedor", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", Nombre);
cmd.Parameters.AddWithValue("@Apellido", Apellido);
cmd.Parameters.AddWithValue("@RUC", Ruc);
cmd.Parameters.AddWithValue("@Direccion", Direccion);
cmd.Parameters.AddWithValue("@Nombre_empresa", Nombre_empresa);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
using (SqlConnection con2 = 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"))
{
SqlConnection sqlConnection1 = 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 cmd3 = new SqlCommand();
//SqlDataReader reader;
/*cmd3.CommandText = "SELECT RUC FROM Proveedor where RUC='" + Ruc + "';
cmd3.CommandType = CommandType.Text;
cmd3.Connection = sqlConnection1;
reader = cmd3.ExecuteReader();
reader.Read();
int id = reader.GetInt32(0);*/
sqlConnection1.Open();
for (int i = 0; i < lista.Count(); i++)
{
using (SqlCommand cmd2 = new SqlCommand("spAgregarTelefonoProveedor", con2))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@RUC", Ruc);
cmd2.Parameters.AddWithValue("@Telefono", lista.ElementAt(i).Text);
con2.Open();
ingresado=cmd2.ExecuteNonQuery();
con2.Close();
}
}
sqlConnection1.Close();
}
if (ingresado > 0)
{
MessageBox.Show("Proveedor Guardado Satisfactoriamente", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
