private void btnUpdate_Click(object sender, EventArgs e) { if (listViewCourse.SelectedItems.Count > 0) { try { if (IsValid()) { int courseID = int.Parse(listViewCourse.SelectedItems[0].SubItems[0].Text); BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); BusinessEntity.CourseEntity oldCourse = courseManager.GetSingle(courseID); BusinessEntity.CourseEntity newCourse = new BusinessEntity.CourseEntity(); newCourse.ID = courseID; newCourse.Title = txtTitle.Text; newCourse.Description = txtDescription.Text; courseManager.Update(newCourse); MessageBox.Show("Course Information Updated Successfully."); LoadCourses(); } } catch (Exception ex) { //save to log table MessageBox.Show("Update Failed, Please try again."); } } else { MessageBox.Show("Please select course from the list first."); } }
private void btnDelete_Click(object sender, EventArgs e) { if (listViewCourse.SelectedItems.Count > 0) { try { DialogResult result = MessageBox.Show("Are you sure you want to delete the selected record?", "Training Information Management System", MessageBoxButtons.YesNo); if (result == DialogResult.OK) { int courseID = int.Parse(listViewCourse.SelectedItems[0].SubItems[0].Text); BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); BusinessEntity.CourseEntity oldCourse = courseManager.GetSingle(courseID); courseManager.Delete(oldCourse); MessageBox.Show("Course Information Deleted Successfully."); LoadCourses(); } } catch (Exception ex) { //save to log table MessageBox.Show("Delete Failed, Please try again."); } } else { MessageBox.Show("Please select trainee from the list first."); } }
private void listViewCourse_SelectedIndexChanged(object sender, EventArgs e) { if (listViewCourse.SelectedItems.Count > 0) { int courseID = int.Parse(listViewCourse.SelectedItems[0].SubItems[0].Text); BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); BusinessEntity.CourseEntity course = courseManager.GetSingle(courseID); txtTitle.Text = course.Title; txtDescription.Text = course.Description; } }
private void frmTraineeCourse_Load(object sender, EventArgs e) { this.Tag = "Bereket"; LoadTraineeCourses(); BusinessLogic.TraineeManager traineeManager = new BusinessLogic.TraineeManager(); List <BusinessEntity.TraineeEntity> trainees = traineeManager.GetAll(); cboTrainee.DataSource = trainees; cboTrainee.ValueMember = "ID"; cboTrainee.DisplayMember = "Fullname"; BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); List <BusinessEntity.CourseEntity> courses = courseManager.GetAll(); cboCourse.DataSource = courses; cboCourse.ValueMember = "ID"; cboCourse.DisplayMember = "Title"; }
private void LoadCourses() { BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); List <BusinessEntity.CourseEntity> courseEntities = courseManager.GetAll(); listViewCourse.Items.Clear(); if (courseEntities == null) { MessageBox.Show("Sorry database error occured, please try again."); } else { foreach (BusinessEntity.CourseEntity courseEntity in courseEntities) { ListViewItem item = new ListViewItem(courseEntity.ID.ToString()); item.SubItems.Add(courseEntity.Title); listViewCourse.Items.Add(item); } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (IsValid()) { BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); BusinessEntity.CourseEntity course = new BusinessEntity.CourseEntity(); course.Title = txtTitle.Text; course.Description = txtDescription.Text; courseManager.Save(course); MessageBox.Show("Course Information Saved Successfully."); LoadCourses(); } } catch (Exception ex) { //save to log table MessageBox.Show("Save Failed, Please try again."); } }
private void PopulateCombobox() { //populate gender BusinessLogic.GenderManager genderManager = new BusinessLogic.GenderManager(); List <BusinessEntity.GenderEntity> genders = genderManager.GetAll(); genders.Add(new BusinessEntity.GenderEntity() { ID = 0, Title = "All" }); cboGender.DataSource = genders.OrderBy(x => x.ID).ToList(); cboGender.ValueMember = "ID"; cboGender.DisplayMember = "Title"; //populate academic level BusinessLogic.AcademicLevelManager academicLevelManager = new BusinessLogic.AcademicLevelManager(); List <BusinessEntity.AcademicLevelEntity> academicLevels = academicLevelManager.GetAll(); academicLevels.Add(new BusinessEntity.AcademicLevelEntity() { ID = 0, Title = "All" }); cboAcademicLevel.DataSource = academicLevels.OrderBy(x => x.ID).ToList(); cboAcademicLevel.ValueMember = "ID"; cboAcademicLevel.DisplayMember = "Title"; //populate trainee BusinessLogic.TraineeManager traineeManager = new BusinessLogic.TraineeManager(); List <BusinessEntity.TraineeEntity> trainees = traineeManager.GetAll(); trainees.Add(new BusinessEntity.TraineeEntity() { ID = 0, Fullname = "All" }); cboTrainee.DataSource = trainees.OrderBy(x => x.ID).ToList(); cboTrainee.ValueMember = "ID"; cboTrainee.DisplayMember = "Fullname"; cboTraineePayment.DataSource = trainees.OrderBy(x => x.ID).ToList(); cboTraineePayment.ValueMember = "ID"; cboTraineePayment.DisplayMember = "Fullname"; //populate course BusinessLogic.CourseManager courseManager = new BusinessLogic.CourseManager(); List <BusinessEntity.CourseEntity> courses = courseManager.GetAll(); courses.Add(new BusinessEntity.CourseEntity() { ID = 0, Title = "All" }); cboCourse.DataSource = courses.OrderBy(x => x.ID).ToList(); cboCourse.ValueMember = "ID"; cboCourse.DisplayMember = "Title"; cboCoursePayment.DataSource = courses.OrderBy(x => x.ID).ToList(); cboCoursePayment.ValueMember = "ID"; cboCoursePayment.DisplayMember = "Title"; }