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