private void btnOgrKaydet_Click(object sender, EventArgs e) { if (txtNameStudent.Text != "" && txtSurnameS.Text != "") { using (BookCenterDBEntities1 dbEntities1 = new BookCenterDBEntities1()) { TBLReaderStudent studentData = new TBLReaderStudent(); studentData.NationalNo = mtxtNational.Text; studentData.Name = txtNameStudent.Text; studentData.Surname = txtSurnameS.Text; studentData.ClassNo = txtClass.Text; studentData.DateBirth = Convert.ToDateTime(mskDateBirth.Text); studentData.Telephone = txtNumber.Text; studentData.Email = txtEmail.Text; studentData.MembershipDate = DateTime.Today; studentData.Address = txtAdress.Text; studentData.Gender = cmbGender.Text; studentData.Images = "Student.png"; dbEntities1.TBLReaderStudent.Add(studentData); dbEntities1.SaveChanges(); MessageBox.Show("İşlem Başarılı."); StudentCellsClear(); UpdateHomaPage(); } } else { MessageBox.Show("Boş kayıt giremezsiniz."); } StudentDataFill(); }
private void btnOgrGuncelle_Click(object sender, EventArgs e) { using (BookCenterDBEntities1 db = new BookCenterDBEntities1()) { if (studentID != 0) { TBLReaderStudent updateStudent = db.TBLReaderStudent.Find(studentID); updateStudent.NationalNo = mtxtNational.Text; updateStudent.Name = txtNameStudent.Text; updateStudent.Surname = txtSurnameS.Text; updateStudent.ClassNo = txtClass.Text; updateStudent.DateBirth = Convert.ToDateTime(mskDateBirth.Text); updateStudent.Telephone = txtNumber.Text; updateStudent.Email = txtEmail.Text; updateStudent.MembershipDate = DateTime.Today; updateStudent.Address = txtAdress.Text; updateStudent.Gender = cmbGender.Text; db.SaveChanges(); MessageBox.Show("İşlem Başarılı"); StudentCellsClear(); UpdateHomaPage(); } else { MessageBox.Show("Veri Seçmelisiniz."); } } StudentDataFill(); }
private void btnOgrSil_Click(object sender, EventArgs e) { using (BookCenterDBEntities1 db = new BookCenterDBEntities1()) { if (studentID != 0) { TBLReaderStudent deleteStudent = db.TBLReaderStudent.Find(studentID); db.TBLReaderStudent.Remove(deleteStudent); db.SaveChanges(); studentID = 0; MessageBox.Show("İşlem Başarılı"); UpdateHomaPage(); } else { MessageBox.Show("Veri Seçmelisiniz."); } } StudentDataFill(); }