private void Update() { student1.SNAME = txtName.Text.Trim(); student1.SADDRESS = txtAddress.Text.Trim(); student1.SEMAIL = txtEmail.Text.Trim(); student1.SGDNAME = txtGDName.Text.Trim(); student1.SGDCONTACT = txtGDContact.Text.Trim(); student1.SDOB = dateTimePickerDOB.Value; student1.Grade = comboBoxGrade.Text.Trim(); student1.ClassName = comboBoxClass.Text.Trim(); using (SchoolManagementSystemDBEntities db = new SchoolManagementSystemDBEntities()) { if (student1.SID == 0) { db.Students.Add(student1); } else { db.Entry(student1).State = EntityState.Modified; } db.SaveChanges(); } MessageBox.Show("Student Details Updated Sucessfully"); this.Hide(); StudentList slist = new StudentList(); slist.ShowDialog(); }
private void delete() { if (MessageBox.Show("Are You Sure to Delete this Account?", "EF CRUD Operetion", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (SchoolManagementSystemDBEntities db = new SchoolManagementSystemDBEntities()) { var entry = db.Entry(student1); if (entry.State == EntityState.Detached) { db.Students.Attach(student1); } db.Students.Remove(student1); db.SaveChanges(); MessageBox.Show("Student Account Deleted Sucessfully"); this.Hide(); StudentList slist = new StudentList(); slist.ShowDialog(); } } }