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