private void DecreaseBalance() { foreach (DataGridViewRow row in dataGridView1.Rows) { string idCliente = textBoxIDcliente.Text; Connection.OpenConnection(); MySqlDataReader reader = Class_.Cliente.BuscarCliente(Connection.myConnection, idCliente); if (reader.Read()) { Class_.Cliente cliente = new Class_.Cliente(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9), reader.GetString(10), reader.GetString(11), reader.GetString(12), reader.GetString(13), reader.GetFloat(14), reader.GetBoolean(15)); cliente.Saldo = cliente.Saldo - float.Parse(textBoxTotal.Text); if (cliente.Saldo < 0) { cliente.Saldo = 0; } CurrentBalance = cliente.Saldo.ToString(); //MessageBox.Show(cliente.Saldo.ToString()); Connection.CloseConnection(); Connection.OpenConnection(); Class_.Cliente.ModifyBenefic(Connection.myConnection, cliente); Connection.CloseConnection(); break; } Connection.CloseConnection(); } }
private void buttonConsultaC_Click(object sender, EventArgs e) { CConnection.OpenConnection(); MySqlDataReader Reader = Class_.Cliente.BuscarCliente(CConnection.myConnection, dataGridView1.CurrentRow.Cells[0].Value.ToString()); if (Reader.Read()) { if (Reader.GetBoolean(15)) { Class_.Cliente nCliente = new Class_.Cliente(Reader.GetInt32(0), Reader.GetString(1), Reader.GetString(2), Reader.GetString(3), Reader.GetString(4), Reader.GetString(5), Reader.GetString(6), Reader.GetString(7), Reader.GetString(8), Reader.GetString(9), Reader.GetString(10), Reader.GetString(11), Reader.GetString(12), Reader.GetString(13), Reader.GetFloat(14), Reader.GetBoolean(15)); Console.Write(Reader.GetString(1)); Consulta_Cliente consulta_cliente = new Consulta_Cliente(nCliente, CConnection); CConnection.CloseConnection(); consulta_cliente.ShowDialog(); LoadData(); } else { MessageBox.Show("No existe ID de cliente"); } } else { MessageBox.Show("no existe ID"); } CConnection.CloseConnection(); }
private void buttonAgregarC_Click(object sender, EventArgs e) { if (textBoxNombreC.Text == "" || textBoxApellidosC.Text == "" || textBoxDireccionC.Text == "" || textBoxEmailC.Text == "" || textBoxTel.Text == "") { MessageBox.Show("Favor de llenar\nlos campos requeridos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (!email_bien_escrito(textBoxEmailC.Text) && textBoxRFC.Text.Length < 10) { MessageBox.Show("Verifique que los campos esten escritos\ncorrectamente!"); } else { CConnection.OpenConnection(); Class_.Cliente nCliente = new Class_.Cliente(1, textBoxNombreC.Text, textBoxApellidosC.Text, textBoxDireccionC.Text, dateTimePickerFechaNac.Text, textBoxEmailC.Text, textBoxTel.Text , textBoxRFC.Text, textBoxDomFisc.Text, textBoxRazSoc.Text, textBoxCP.Text, textBoxPais.Text, textBoxEstado.Text, textBoxMunicipio.Text, 0, true); Class_.Cliente.AgregarCliente(CConnection.myConnection, nCliente); CConnection.CloseConnection(); MessageBox.Show("Captura Exitosa"); this.Close(); } } }
private void LoadCustomer(string idCustomer) { Connection.OpenConnection(); MySqlDataReader reader = Class_.Cliente.BuscarCliente(Connection.myConnection, idCustomer); if (reader.Read()) { Class_.Cliente customer = new Class_.Cliente(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9), reader.GetString(10), reader.GetString(11), reader.GetString(12), reader.GetString(13), reader.GetFloat(14), reader.GetBoolean(15)); Connection.CloseConnection(); labelNombreD.Text = customer.Nombre; labelApellidoD.Text = customer.Apellido; labelDireccionD.Text = customer.Direccion; string[] fecha = customer.FechaNac.Split(' '); labelFechaNacD.Text = fecha[0]; labelEmailD.Text = customer.E_mail; labelTelD.Text = customer.Tel; labelRFCD.Text = customer.RFC; labelRazonSocD.Text = customer.RazonSocial; labelDomicilioFiscD.Text = customer.DomFiscal; labelCPD.Text = customer.CP; labelPaisD.Text = customer.Pais; labelEstadoD.Text = customer.Estado; labelMunicipioD.Text = customer.Municipio; } }
public Consulta_Cliente(Class_.Cliente Cliente, Class_.Connection Connection) { InitializeComponent(); this.Cliente = Cliente; this.Connection = Connection; LoadC(); if (!Cliente.Disponible) { buttonBaja.Enabled = false; } }
private void buttonListo_Click(object sender, EventArgs e) { if (email_bien_escrito(textBoxEmail.Text) && textBoxRFC.Text.Length > 9) { Connection.OpenConnection(); Class_.Cliente nCliente = new Class_.Cliente(Cliente.ID, textBoxNombre.Text, textBoxApellidos.Text, textBoxDireccion.Text, dateTimePicker1.Text, textBoxEmail.Text, textBoxTel.Text, textBoxRFC.Text, textBoxDomFiscal.Text, textBoxRazonSocial.Text, textBoxCP.Text, textBoxPais.Text, textBoxEstado.Text, textBoxMunicipio.Text, float.Parse(textBoxSaldo.Text), true); Class_.Cliente.ModificarCliente(Connection.myConnection, nCliente); Connection.CloseConnection(); MessageBox.Show("Datos Modificados"); this.Close(); } else { MessageBox.Show("Verifique que los datos esten bien escritos"); } }