private void button1_Click(object sender, EventArgs e) { if (Equals(txtCNP.Text, "") || !OnlyNumbers() || txtCNP.Text.Length != 13) { MessageBox.Show("Introduceti un CNP valid"); } else { using (UserEntities context = new UserEntities()) { try { tblUser2 obj = context.tblUser2.FirstOrDefault(r => r.CNP == txtCNP.Text); if (obj != null) { context.tblUser2.Remove(obj); context.SaveChanges(); MessageBox.Show("Stergere realizata cu succes"); Clear(); } else { MessageBox.Show("Nu exista persoana cauta"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void Cautare_Click(object sender, EventArgs e) { if (Equals(txtCNP.Text, "") || !OnlyNumbers() || txtCNP.Text.Length != 13) { MessageBox.Show("Introduceti un CNP valid"); } else { using (UserEntities context = new UserEntities()) { try { tblUser2 obj = context.tblUser2.FirstOrDefault(r => r.CNP == txtCNP.Text); if (obj != null) { txtNume.Text = obj.Nume; txtPrenume.Text = obj.Prenume; txtAdresa.Text = obj.Adresa; } else { MessageBox.Show("Persoana cautata nu exista"); } }catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void button1_Click(object sender, EventArgs e) { using (UserEntities context = new UserEntities()) { try { dataGridView1.DataSource = context.tblUser2.ToList(); }catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private Boolean Exists()//Verifica daca CNP-ul introdus exista deja { using (UserEntities context = new UserEntities()) { tblUser2 obj = context.tblUser2.FirstOrDefault(r => r.CNP == txtCNP.Text); if (obj != null) { return(true); } else { return(false); } } }
private void Button1_Click(object sender, EventArgs e) { if (Equals(txtCNP.Text, "") || !OnlyNumbers() || txtCNP.Text.Length != 13) { MessageBox.Show("Introduceti un CNP valid"); } else if (Equals(txtNume.Text.Trim(), "") && Equals(txtPrenume.Text.Trim(), "") && Equals(txtAdresa.Text.Trim(), "")) { MessageBox.Show("Trebuie modificat cel putin un camp"); } else { using (UserEntities context = new UserEntities()) { try { tblUser2 obj = context.tblUser2.FirstOrDefault(r => r.CNP == txtCNP.Text); if (obj != null) { if (!Equals(txtNume.Text.Trim(), "")) { obj.Nume = txtNume.Text.Trim(); } if (!Equals(txtPrenume.Text.Trim(), "")) { obj.Prenume = txtPrenume.Text.Trim(); } if (!Equals(txtAdresa.Text.Trim(), "")) { obj.Adresa = txtAdresa.Text.Trim(); } context.SaveChanges(); MessageBox.Show("Editare realizata cu succes"); Clear(); } else { MessageBox.Show("Persoana cautata nu exista"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void btnAdauga_Click(object sender, EventArgs e) { if (Equals(txtNume.Text.Trim(), "") || Equals(txtPrenume.Text.Trim(), "") || Equals(txtAdresa.Text.Trim(), "") || Equals(txtCNP.Text, "")) { MessageBox.Show("Te rog completeaza campurile obligatorii"); } else if (txtCNP.Text.Length != 13) { MessageBox.Show("CNP-ul trebuie sa contina 13 cifre"); } else if (!OnlyNumbers()) { MessageBox.Show("CNP-ul contine doar cifre"); } else if (Exists()) { MessageBox.Show("CNP-ul introdus exista deja"); } else { using (UserEntities context = new UserEntities())//UserEntities e clasa care reprezinta baza de data(kind of) { try { tblUser2 obj = new tblUser2 { Nume = txtNume.Text.Trim(), Prenume = txtPrenume.Text.Trim(), CNP = txtCNP.Text, Adresa = txtAdresa.Text.Trim() }; context.tblUser2.Add(obj); context.SaveChanges(); MessageBox.Show("Adaugare realizata cu succes"); Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }