private void buttonUpdate_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); if (textBoxId.Text != "") { using (PersonCrudEntities db = new PersonCrudEntities()) { int id = Convert.ToInt32(textBoxId.Text); person isExests = db.people.FirstOrDefault(r => r.email == textBoxEmail.Text); person aPerson = db.people.FirstOrDefault(r => r.ID == id); if (isExests == null) { aPerson.name = textBoxName.Text; aPerson.email = textBoxEmail.Text; //is email exists or not //db.people.Add(aPerson); db.SaveChanges(); MessageBox.Show("Updated Successfully !"); } else { MessageBox.Show("email already exists."); } } } else { MessageBox.Show("Please Select a member for update."); } showAllData(); }
private void button1_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); using (PersonCrudEntities db = new PersonCrudEntities()) { person isExests = db.people.FirstOrDefault(r => r.email == textBoxEmail.Text); if (isExests == null) { person aPerson = new person { name = textBoxName.Text, email = textBoxEmail.Text }; //is email exists or not db.people.Add(aPerson); db.SaveChanges(); MessageBox.Show("data saved !"); } else { MessageBox.Show("email already exists."); } showAllData(); } }
public void showAllData() { using (PersonCrudEntities db = new PersonCrudEntities()) { List <person> v = db.people.ToList(); foreach (person item in v) { int n = dataGridView1.Rows.Add(); dataGridView1.Rows[n].Cells[0].Value = item.ID; dataGridView1.Rows[n].Cells[1].Value = item.name; dataGridView1.Rows[n].Cells[2].Value = item.email; } } }
private void buttonDelete_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); if (textBoxId.Text != "") { using (PersonCrudEntities db = new PersonCrudEntities()) { int id = Convert.ToInt32(textBoxId.Text); person aPerson = db.people.FirstOrDefault(r => r.ID == id); db.people.Remove(aPerson); db.SaveChanges(); MessageBox.Show("Deleted successfully !"); } } else { MessageBox.Show("Please select a Member for delete."); } showAllData(); }