private void modificaToolStripMenuItem_Click(object sender, EventArgs e)
{
ModificaClient modificaClient;
foreach (ListViewItem clientItem in lvClienti.SelectedItems)
{
modificaClient = new ModificaClient();
modificaClient.Client = clientItem.Tag as Persoana;
if (modificaClient.ShowDialog(this) == DialogResult.OK)
{
var comanda = new SqlCommand();
var clientModificat = modificaClient.Client;
comanda.CommandText = "UPDATE CLIENTI SET NUME=@nume,PRENUME=@prenume,EMAIL=@email," +
"CETATENIE=@cetatenie," +
"DATA_NASTERE=@data_nastere,NUMAR_PASAPORT=@nr_pasaport,TELEFON=@telefon," +
"CNP=@cnp,SEX=@sex " +
"WHERE CNP=@cnp_cautat";
comanda.Parameters.Add("@nume", SqlDbType.VarChar).Value = clientModificat.Nume;
comanda.Parameters.Add("@prenume", SqlDbType.VarChar).Value = clientModificat.Prenume;
comanda.Parameters.Add("@email", SqlDbType.VarChar).Value = clientModificat.Email;
comanda.Parameters.Add("@cetatenie", SqlDbType.VarChar).Value = clientModificat.Cetatenie;
comanda.Parameters.Add("@data_nastere", SqlDbType.Date).Value = clientModificat.DataNastere.
ToString("yyyy-MM-dd");
comanda.Parameters.Add("@nr_pasaport", SqlDbType.VarChar).Value = clientModificat.NumarPasaport;
comanda.Parameters.Add("@telefon", SqlDbType.VarChar).Value = clientModificat.Telefon;
comanda.Parameters.Add("@cnp", SqlDbType.VarChar).Value = clientModificat.CNP;
comanda.Parameters.Add("@sex", SqlDbType.VarChar).Value = clientModificat.Sex;
comanda.Parameters.Add("@cnp_cautat", SqlDbType.VarChar).Value =
(clientItem.Tag as Persoana).CNP;
if (DBRepositoriesManager.AirCompanyDBExecuteNonQuerry(comanda) == -1)
{
MessageBox.Show("Eroare la actualizarea datelor pentru clientul " + clientModificat.CNP);
continue;
}
else
{
clientItem.Tag = clientModificat;
clientItem.SubItems.Clear();
clientItem.Text = clientModificat.Nume;
clientItem.SubItems.Add(clientModificat.Prenume);
clientItem.SubItems.Add(clientModificat.Cetatenie);
clientItem.SubItems.Add(clientModificat.NumarPasaport);
clientItem.SubItems.Add(clientModificat.DataNastere.ToShortDateString());
clientItem.SubItems.Add(clientModificat.CNP);
clientItem.SubItems.Add(clientModificat.Sex);
clientItem.SubItems.Add(clientModificat.Telefon);
clientItem.SubItems.Add(clientModificat.Email);
lvClienti.Refresh();
}
}
}
}
private void stergeToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (ListViewItem clientItem in lvClienti.SelectedItems)
{
var command = new SqlCommand();
command.CommandText = "DELETE FROM CLIENTI WHERE CNP=@cnp_de_sters";
command.Parameters.Add("@cnp_de_sters", SqlDbType.VarChar).Value = (clientItem.Tag as Persoana).CNP;
if (DBRepositoriesManager.AirCompanyDBExecuteNonQuerry(command) != -1)
{
lvClienti.Items.Remove(clientItem);
}
}
lvClienti.Refresh();
}
private void btnAdauga_Click(object sender, EventArgs e)
{
var client = clientUserControl1.Persoana;
if (client != null)
{
if (DBRepositoriesManager.AirCompanyDBExecuteNonQuerry("INSERT INTO CLIENTI" +
"(NUME,PRENUME,EMAIL,CETATENIE,DATA_NASTERE,NUMAR_PASAPORT,TELEFON,CNP,SEX) VALUES"
+ "('" + @client.Nume + "','" + @client.Prenume + "','" + @client.Email + "','" +
@client.Cetatenie + "','" +
@client.DataNastere.ToString("yyyy-MM-dd") + "','" + @client.NumarPasaport + "','" +
@client.Telefon + "','" +
@client.CNP + "','" + @client.Sex + "')") == -1)
{
MessageBox.Show("Eroare la adaugarea noului client in baza de date");
}
}
}