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