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