public object Clone() { Candidat clona = (Candidat)this.MemberwiseClone(); clona.cnp = this.cnp; clona.cetatenie = this.cetatenie; clona.nume = this.nume; clona.initialaTatalui = this.initialaTatalui; clona.prenume = this.prenume; clona.sex = this.sex; clona.adresa = this.adresa; clona.nrTelefon = this.nrTelefon; clona.email = this.email; return(clona); }
private void candidat_bt_Click(object sender, EventArgs e) { string cnp; string cetatenie; string nume; string initialaTatalui; string prenume; string sex; string adresa; string nrTelefon; string email; cnp = cnp_tb.Text; cetatenie = cetatenie_tb.Text; nume = nume_tb.Text; initialaTatalui = initialaTatalui_tb.Text; prenume = prenume_tb.Text; sex = sex_cb.Text; adresa = adresa_tb.Text; nrTelefon = nrTelefon_tb.Text; email = email_tb.Text; if (cnp.ToString().Length == 13 && adresa.Length > 5 && nrTelefon.Length == 10 && email.Length > 5) { Candidat c = new Candidat(cnp, cetatenie, nume, initialaTatalui, prenume, sex, adresa, nrTelefon, email); string connString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = candidati.accdb"; OleDbConnection conexiune = new OleDbConnection(connString); OleDbCommand candidat = new OleDbCommand(); candidat.Connection = conexiune; try { conexiune.Open(); candidat.CommandText = "INSERT INTO candidati VALUES(?,?,?,?,?,?,?,?,?)"; candidat.Parameters.Add("cnp", OleDbType.Char, 14).Value = cnp; candidat.Parameters.Add("cetatenie", OleDbType.Char, 30).Value = cetatenie; candidat.Parameters.Add("nume", OleDbType.Char, 30).Value = nume; candidat.Parameters.Add("initiala_tatalui", OleDbType.Char, 3).Value = initialaTatalui; candidat.Parameters.Add("prenume", OleDbType.Char, 30).Value = prenume; candidat.Parameters.Add("sex", OleDbType.Char, 10).Value = sex; candidat.Parameters.Add("adresa", OleDbType.Char, 60).Value = adresa; candidat.Parameters.Add("numar_telefon", OleDbType.Integer).Value = nrTelefon; candidat.Parameters.Add("email", OleDbType.Char, 40).Value = email; candidat.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MessageBox.Show(c.ToString()); listaCandidat.Add(c); conexiune.Close(); cnp_tb.Clear(); cetatenie_tb.Clear(); nume_tb.Clear(); initialaTatalui_tb.Clear(); prenume_tb.Clear(); adresa_tb.Clear(); nrTelefon_tb.Clear(); email_tb.Clear(); } } else { MessageBox.Show("A fost detectata cel putin o eroare"); } }