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();
 }
예제 #3
0
 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);
            }
        }