private void BtnEdit_Click(object sender, EventArgs e) { if (dgvStudentList.Rows.Count > 0) { if (dgvStudentList.SelectedRows.Count == 1) { int selectIndex = dgvStudentList.CurrentRow.Index; var studentID = dgvStudentList.Rows[selectIndex].Cells[0].Value; var student = StudentsHelper.GetById(Convert.ToInt32(studentID)); cmbSession.SelectedItem = SessionsHelper.GetByNameFromID(student.SessionID); cmbDepartment.SelectedItem = DepartmentsHelper.GetByNameFromID(student.DepartmentID); cmbProgram.SelectedItem = ProgramsHelper.GetByNameFromID(student.ProgramID); txtStudentName.Text = student.Name; txtTCNO.Text = student.TCNO; cmbGender.SelectedIndex = student.Gender; txtEnrollNo.Text = student.EnrollNo; txtAddress.Text = student.Address; txtContactNo.Text = student.ContactNo; EnableComponent(); } } }
private void BtnDelete_Click(object sender, EventArgs e) { try { if (dgvStudentList.Rows.Count > 0) { int selectIndex = dgvStudentList.CurrentRow.Index; var studentID = dgvStudentList.Rows[selectIndex].Cells[0].Value; DialogResult dialogResult = MessageBox.Show("Öğrenciyi silmek istediğinize emin misiniz?", "Library Management System", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { var s = StudentsHelper.GetById(Convert.ToInt32(studentID)); s.Status = 0; StudentsHelper.Update(s); MessageBox.Show("Öğrenci Silme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information); FillGrid(); ClearForm(); } } } catch (Exception ex) { MessageBox.Show("Herhangi bir eleman seçmediniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BtnSearchStudent_Click(object sender, EventArgs e) { ep.Clear(); if (txtStudentID.Text.Trim().Length == 0) { ep.SetError(txtStudentID, "Öğrenci ID giriniz!"); txtStudentID.Focus(); return; } try { var s = StudentsHelper.GetStudentByID(Convert.ToInt32(txtStudentID.Text)); FillGridStudent(s); btnSearchStudent.Enabled = false; txtStudentID.Enabled = false; } catch (Exception ex) { MessageBox.Show("Bu ID'ye ait öğrenci bulunamadı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (btnSearchBook.Enabled == false || btnSearchStudent.Enabled == false) { btnCancel.Enabled = true; } if (btnSearchBook.Enabled == false && btnSearchStudent.Enabled == false) { btnAdd.Enabled = true; } }
private void btnSearchStudent_Click(object sender, EventArgs e) { ep.Clear(); if (txtStudentID.Text.Trim().Length == 0) { ep.SetError(txtStudentID, "Öğrenci ID giriniz!"); txtStudentID.Focus(); return; } try { var s = StudentsHelper.GetStudentByID(Convert.ToInt32(txtStudentID.Text)); FillGridStudent(s); FillGridBook(Convert.ToInt32(txtStudentID.Text)); if (dgvIssueBookList.Rows.Count > 0) { btnSearchStudent.Enabled = false; btnSelectIssueBook.Enabled = true; txtStudentID.Enabled = false; dgvIssueBookList.Enabled = true; } else { MessageBox.Show("Bu ID'ye ait öğrencide kitap yoktur.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("Bu ID'ye ait öğrenci bulunamadı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSelectFine_Click(object sender, EventArgs e) { if (dgvFineList.Rows.Count > 0) { if (dgvFineList.SelectedRows.Count == 1) { int selectIndex = dgvFineList.CurrentRow.Index; var studentID = dgvFineList.Rows[selectIndex].Cells[1].Value; dgvFineList.Enabled = false; gbStudent.Enabled = true; btnCancel.Enabled = true; btnSelectFine.Enabled = false; var s = StudentsHelper.GetStudentByID(Convert.ToInt32(studentID)); FillGridStudent(s); } } }
private void FillGrid() { dgvStudentList.Rows.Clear(); foreach (var student in StudentsHelper.GetActiveStudentsList()) { int row = dgvStudentList.Rows.Add(); dgvStudentList.Rows[row].Cells[0].Value = student.StudentID; dgvStudentList.Rows[row].Cells[1].Value = student.Name; dgvStudentList.Rows[row].Cells[2].Value = student.TCNO; dgvStudentList.Rows[row].Cells[3].Value = student.EnrollNo; dgvStudentList.Rows[row].Cells[4].Value = SessionsHelper.GetByNameFromID(student.SessionID); dgvStudentList.Rows[row].Cells[5].Value = DepartmentsHelper.GetByNameFromID(student.DepartmentID); dgvStudentList.Rows[row].Cells[6].Value = ProgramsHelper.GetByNameFromID(student.ProgramID); dgvStudentList.Rows[row].Cells[7].Value = student.RegisterDate.ToString("dd MMMM yyyy"); dgvStudentList.Rows[row].Cells[8].Value = student.Address; dgvStudentList.Rows[row].Cells[9].Value = student.ContactNo; dgvStudentList.Rows[row].Cells[10].Value = StaffsHelper.GetByNameFromID(student.StaffID); row++; } }
private void btnAdd_Click(object sender, EventArgs e) { ep.Clear(); if (txtStudentName.Text.Trim().Length == 0) { ep.SetError(txtStudentName, "Öğrenci adı boş bırakılamaz!"); txtStudentName.Focus(); return; } if (txtTCNO.Text.Trim().Length == 0) { ep.SetError(txtTCNO, "TC NO boş bırakılamaz!"); txtTCNO.Focus(); return; } if (txtEnrollNo.Text.Trim().Length == 0) { ep.SetError(txtEnrollNo, "Enroll No boş bırakılamaz!"); txtEnrollNo.Focus(); return; } if (txtAddress.Text.Trim().Length == 0) { ep.SetError(txtAddress, "Adres boş bırakılamaz!"); txtAddress.Focus(); return; } if (txtContactNo.Text.Trim().Length == 0) { ep.SetError(txtContactNo, "Telefon No boş bırakılamaz!"); txtContactNo.Focus(); return; } if (txtTCNO.Text.Trim().Length != 11) { MessageBox.Show("TC No 11 hanali olmalıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtContactNo.Text.Trim().Length < 9 || txtContactNo.Text.Trim().Length > 14) { MessageBox.Show("Lütfen geçerli bir telefon numarası giriniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!StudentsHelper.HaveTCNO(txtTCNO.Text) && !StudentsHelper.HaveEnrollNo(txtEnrollNo.Text) && !StudentsHelper.HaveContactNo(txtEnrollNo.Text)) { Students s = new Students(); s.SessionID = SessionsHelper.GetByName(cmbSession.SelectedItem.ToString()); s.DepartmentID = DepartmentsHelper.GetByName(cmbDepartment.SelectedItem.ToString()); s.ProgramID = ProgramsHelper.GetByName(cmbProgram.SelectedItem.ToString()); s.StaffID = _staffID; s.Name = txtStudentName.Text; s.TCNO = txtTCNO.Text; s.Status = 1; s.Gender = cmbGender.SelectedIndex; s.EnrollNo = txtEnrollNo.Text; s.Address = txtAddress.Text; s.ContactNo = txtContactNo.Text; s.RegisterDate = DateTime.Now; StudentsHelper.Add(s); MessageBox.Show("Öğrenci Ekleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbSession.SelectedIndex = 0; cmbDepartment.SelectedIndex = 0; cmbProgram.SelectedIndex = 0; txtStudentName.Text = string.Empty; txtTCNO.Text = string.Empty; cmbGender.SelectedIndex = 0; txtEnrollNo.Text = string.Empty; txtAddress.Text = string.Empty; txtContactNo.Text = string.Empty; FillGrid(); } else { MessageBox.Show("Girdiğiniz TC, Enroll veya Telefon numarası sistemde kayıtlıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BtnUpdate_Click(object sender, EventArgs e) { ep.Clear(); if (txtStudentName.Text.Trim().Length == 0) { ep.SetError(txtStudentName, "Öğrenci adı boş bırakılamaz!"); txtStudentName.Focus(); return; } if (txtTCNO.Text.Trim().Length == 0) { ep.SetError(txtTCNO, "TC NO boş bırakılamaz!"); txtTCNO.Focus(); return; } if (txtEnrollNo.Text.Trim().Length == 0) { ep.SetError(txtEnrollNo, "Enroll No boş bırakılamaz!"); txtEnrollNo.Focus(); return; } if (txtAddress.Text.Trim().Length == 0) { ep.SetError(txtAddress, "Adres boş bırakılamaz!"); txtAddress.Focus(); return; } if (txtContactNo.Text.Trim().Length == 0) { ep.SetError(txtContactNo, "Telefon No boş bırakılamaz!"); txtContactNo.Focus(); return; } if (txtTCNO.Text.Trim().Length != 11) { MessageBox.Show("TC No 11 hanali olmalıdır.", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtContactNo.Text.Trim().Length < 9 || txtContactNo.Text.Trim().Length > 14) { MessageBox.Show("Lütfen geçerli bir telefon numarası giriniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int selectIndex = dgvStudentList.CurrentRow.Index; var studentID = dgvStudentList.Rows[selectIndex].Cells[0].Value; if (!StudentsHelper.HaveContactNo(txtContactNo.Text, Convert.ToInt32(studentID)) && !StudentsHelper.HaveEnrollNo(txtEnrollNo.Text, Convert.ToInt32(studentID)) && !StudentsHelper.HaveTCNO(txtTCNO.Text, Convert.ToInt32(studentID))) { var s = StudentsHelper.GetById(Convert.ToInt32(studentID)); s.SessionID = SessionsHelper.GetByName(cmbSession.SelectedItem.ToString()); s.DepartmentID = DepartmentsHelper.GetByName(cmbDepartment.SelectedItem.ToString()); s.ProgramID = ProgramsHelper.GetByName(cmbProgram.SelectedItem.ToString()); s.Name = txtStudentName.Text; s.Gender = cmbGender.SelectedIndex; s.Address = txtAddress.Text; s.EnrollNo = txtEnrollNo.Text; s.TCNO = txtTCNO.Text; s.ContactNo = txtContactNo.Text; StudentsHelper.Update(s); MessageBox.Show("Öğrenci Güncelleme Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbSession.SelectedIndex = 0; cmbDepartment.SelectedIndex = 0; cmbProgram.SelectedIndex = 0; txtStudentName.Text = string.Empty; txtTCNO.Text = string.Empty; cmbGender.SelectedIndex = 0; txtEnrollNo.Text = string.Empty; txtAddress.Text = string.Empty; txtContactNo.Text = string.Empty; ClearForm(); FillGrid(); DisableComponent(); } else { MessageBox.Show("Girdiğiniz TC, Enroll veya Telefon numarası sistemde kayıtlıdır!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }