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();
}
