private void button1_Click(object sender, EventArgs e)
{
Console.WriteLine(comboBox1.SelectedIndex);
if (comboBox1.SelectedIndex == 0)
{
SearchNaturalClient snc = new SearchNaturalClient();
this.Hide();
snc.ShowDialog();
this.Show();
NaturalClient nc = snc.ClientSelected;
if (nc != null)
{
textBox1.Text = nc.Dni;
textBox3.Text = nc.Name + " " + nc.Surname;
}
}
else
{
Console.WriteLine("Searching Legal Client");
SearchLegalClient slc = new SearchLegalClient();
this.Hide();
slc.ShowDialog();
this.Show();
LegalClient lc = slc.SelectedClient;
if (lc != null)
{
textBox1.Text = lc.RUC;
textBox3.Text = lc.CompanyName;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
String ruc = rucTextBox.Text;
String phone = phoneTextBox.Text;
String email = emailTextBox.Text;
String address = addressTextBox.Text;
String companyName = companyNameTextBox.Text;
bool flagOK = true;
if (!DataValidation.ValidField(Constants.RucRegex, ruc, ref flagOK))
{
label3.ForeColor = Color.Red;
}
if (!DataValidation.ValidField(Constants.CompanyNameRegex, companyName, ref flagOK))
{
label5.ForeColor = Color.Red;
}
if (!DataValidation.ValidField(Constants.PlaceRegex, address, ref flagOK))
{
label8.ForeColor = Color.Red;
}
if (!DataValidation.ValidField(Constants.PhoneRegex, phone, ref flagOK))
{
label4.ForeColor = Color.Red;
}
if (!DataValidation.ValidField(Constants.EmailRegex, email, ref flagOK))
{
label6.ForeColor = Color.Red;
}
if (flagOK)
{
LegalClient lc = new LegalClient();
lc.RUC = ruc; lc.PhoneNumber = phone; lc.Email = email; lc.Address = address; lc.CompanyName = companyName;
try {
legalClientBL.addLegalClient(lc);
dataGridView1.DataSource = legalClientBL.listLegalClients("", "");
MessageBox.Show("El cliente ha sido registrado", "Registro de cliente nuevo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex) {
MessageBox.Show("Ya existe este cliente con RUC " + ruc, "Error al añadir cliente jurídico", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Error en uno o más campos. Revise los campos en rojo.", "Campos incompletas", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public EditLegalClient(LegalClient lc)
{
InitializeComponent();
legalClientBL = new LegalClientBL();
selectedClient = lc;
textBox1.Text = Constants.CurrentUserText;
textBox2.Text = selectedClient.CompanyName;
textBox4.Text = selectedClient.Address;
textBox5.Text = selectedClient.PhoneNumber;
textBox6.Text = selectedClient.Email;
textBox2.Enabled = false;
textBox4.Enabled = false;
textBox5.Enabled = false;
textBox6.Enabled = false;
this.CenterToScreen();
}
public BindingList <LegalClient> listLegalClients(string ruc, string name)
{
BindingList <LegalClient> list = new BindingList <LegalClient>();
MySqlConnection con = new MySqlConnection(Constants.connectionString);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = "listLegalClients";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (ruc.Length == 0)
{
cmd.Parameters.Add("_ruc", MySqlDbType.String).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("_ruc", MySqlDbType.String).Value = ruc;
}
if (name.Length == 0)
{
cmd.Parameters.Add("_companyName", MySqlDbType.String).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("_companyName", MySqlDbType.String).Value = name;
}
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LegalClient lc = new LegalClient();
lc.Address = reader.GetString("Address");
lc.CompanyName = reader.GetString("CompanyName");
lc.Email = reader.GetString("Email");
lc.IdPerson = reader.GetInt32("IdPerson");
lc.PhoneNumber = reader.GetString("PhoneNumber");
lc.RUC = reader.GetString("Ruc");
lc.Points = reader.GetInt32("Points");
list.Add(lc);
}
con.Close();
return(list);
}
private void button1_Click_2(object sender, EventArgs e)
{
Console.WriteLine(comboBox1.SelectedIndex);
if (comboBox1.SelectedIndex == 0)
{
SearchNaturalClient snc = new SearchNaturalClient();
this.Hide();
snc.ShowDialog();
this.Show();
NaturalClient nc = snc.ClientSelected;
if (nc != null)
{
textBox1.Text = nc.Dni;
textBox3.Text = nc.Name + " " + nc.Surname;
pointsTextBox.Text = nc.Points.ToString();
nc.IdPerson = naturalClientBL.searchNaturalClient(nc.Dni);
idClient = nc.IdPerson;
Console.WriteLine("ID del cliente natural: " + nc.IdPerson);
}
}
else
{
Console.WriteLine("Searching Legal Client");
SearchLegalClient slc = new SearchLegalClient();
this.Hide();
slc.ShowDialog();
this.Show();
LegalClient lc = slc.SelectedClient;
if (lc != null)
{
textBox1.Text = lc.RUC;
textBox3.Text = lc.CompanyName;
pointsTextBox.Text = lc.Points.ToString();
lc.IdPerson = legalClientBL.searchLegalClient(lc.RUC);
idClient = lc.IdPerson;
Console.WriteLine("ID del cliente legal: " + lc.IdPerson);
}
}
}
public void addLegalClient(LegalClient lc)
{
MySqlConnection con = new MySqlConnection(Constants.connectionString);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = "addToBDLegalClient";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("_address", MySqlDbType.String).Value = lc.Address;
cmd.Parameters.Add("_phoneNumber", MySqlDbType.String).Value = lc.PhoneNumber;
cmd.Parameters.Add("_email", MySqlDbType.String).Value = lc.Email;
cmd.Parameters.Add("_companyName", MySqlDbType.String).Value = lc.CompanyName;
cmd.Parameters.Add("_ruc", MySqlDbType.String).Value = lc.RUC;
cmd.ExecuteNonQuery();
con.Close();
}
public void updateLegalClient(LegalClient lc)
{
dataAccess.updateLegalClient(lc);
}
public void addLegalClient(LegalClient lc)
{
dataAccess.addLegalClient(lc);
}
