private void btnInsert_Click(object sender, EventArgs e) { try { CONTACTS_LISTEntities context = new CONTACTS_LISTEntities(); CONTACTS_LIST directory = new CONTACTS_LIST(); directory.FIRSTNAME = txtFirst.Text; directory.LASTNAME = txtLast.Text; directory.EMAIL = txtEmail.Text; directory.PHONE = txtPhone.Text; directory.CATEGORY = comboCategory.SelectedItem.ToString(); directory.APPOINTMENT = txtAppointment.Text; context.CONTACTS_LIST.Add(directory); context.SaveChanges(); BindDataGridView(); ClearFields(); } catch (InvalidOperationException) { MessageBox.Show("Error entering data into the database."); } }
private void btnDelete_Click(object sender, EventArgs e) { CONTACTS_LISTEntities context = new CONTACTS_LISTEntities(); DataGridViewRow row = dataGridView1.SelectedRows[0]; string temp = row.Cells["First"].Value.ToString(); var val = context.CONTACTS_LIST.Where(t => t.FIRSTNAME.Equals(temp)).FirstOrDefault(); context.CONTACTS_LIST.Remove(val); context.SaveChanges(); BindDataGridView(); ClearFields(); }
private void btnUpdate_Click(object sender, EventArgs e) { CONTACTS_LISTEntities context = new CONTACTS_LISTEntities(); DataGridViewRow row = dataGridView1.SelectedRows[0]; string temp = row.Cells["First"].Value.ToString(); var val = context.CONTACTS_LIST.Where(t => t.FIRSTNAME.Equals(temp)).FirstOrDefault(); val.FIRSTNAME = txtFirst.Text; val.LASTNAME = txtLast.Text; val.EMAIL = txtEmail.Text; val.PHONE = txtPhone.Text; val.CATEGORY = comboCategory.SelectedItem.ToString(); val.APPOINTMENT = txtAppointment.Text; context.SaveChanges(); BindDataGridView(); ClearFields(); }