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 frmStudent_Load(object sender, EventArgs e)
{
cmbSession.DataSource = SessionsHelper.GetSessionsNameList();
cmbDepartment.DataSource = DepartmentsHelper.GetDepartmentsNameList();
cmbProgram.DataSource = ProgramsHelper.GetProgramsNameList();
cmbGender.DataSource = Enum.GetValues(typeof(Gender));
FillGrid();
}
private void FillGridStudent(Students s)
{
dgvStudentDetail.Rows.Clear();
dgvStudentDetail.Rows.Add($"Adı : {s.Name}");
dgvStudentDetail.Rows.Add($"TC No : {s.TCNO}");
dgvStudentDetail.Rows.Add($"Dönem : {SessionsHelper.GetByNameFromID(s.SessionID)}");
dgvStudentDetail.Rows.Add($"Bölüm : {DepartmentsHelper.GetByNameFromID(s.DepartmentID)}");
dgvStudentDetail.Rows.Add($"Dönem : {ProgramsHelper.GetByNameFromID(s.ProgramID)}");
}
private void FillGrid()
{
dgvProgramList.Rows.Clear();
foreach (var program in ProgramsHelper.GetProgramsModelList())
{
int row = dgvProgramList.Rows.Add();
dgvProgramList.Rows[row].Cells[0].Value = program.ProgramID;
dgvProgramList.Rows[row].Cells[1].Value = program.Name;
row++;
}
}
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 btnEdit_Click(object sender, EventArgs e)
{
if (dgvProgramList.Rows.Count > 0)
{
if (dgvProgramList.SelectedRows.Count == 1)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var programID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
var p = ProgramsHelper.GetById(Convert.ToInt32(programID));
txtProgramName.Text = Convert.ToString(p.Name);
EnableComponent();
}
}
else
{
MessageBox.Show("Program listesi boş!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtProgramName.Text.Trim().Length == 0)
{
MessageBox.Show("Lütfen Program ismini giriniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!ProgramsHelper.HaveProgramName(txtProgramName.Text))
{
Programs p = new Programs();
p.Name = txtProgramName.Text;
ProgramsHelper.Add(p);
MessageBox.Show("Program ekleme başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillGrid();
}
else
{
MessageBox.Show("Aynı isimde bir Program zaten ekli!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
epProgram.Clear();
bool check = SessionsHelper.ControlValidate(txtProgramName, "Lütfen Program İsmini Giriniz.", epProgram);
if (check)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var programID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
var p = ProgramsHelper.GetById(Convert.ToInt32(programID));
p.Name = txtProgramName.Text.Trim();
ProgramsHelper.Update(p);
MessageBox.Show("Program güncelleme başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
FillGrid();
DisableComponent();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dgvProgramList.Rows.Count > 0)
{
if (dgvProgramList.SelectedRows.Count == 1)
{
DialogResult dialogResult = MessageBox.Show("Program'ı silmek istediğinize emin misiniz?", "Library Management System", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int selectIndex = dgvProgramList.CurrentRow.Index;
var programID = dgvProgramList.Rows[selectIndex].Cells[0].Value;
ProgramsHelper.Delete(Convert.ToInt32(programID));
MessageBox.Show("Program Silme İşlemi Başarılı", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillGrid();
}
}
else
{
MessageBox.Show("Lütfen silmek istediğiniz programı seçiniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Program listesi boş!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show("Lütfen silmek istediğiniz programı seçiniz!", "Library Management System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
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);
}
}