private void PopulateChoices() { // Initialization. string strConn = "Data Source=LAPTOP-6RBMDIS7\\SQLEXPRESS;Database=DBMS_Project;Integrated Security=SSPI;"; SqlConnection sqlConnection = new SqlConnection(strConn); SqlCommand sqlCommand = new SqlCommand("uspFetchCoursePreferenceDetails", sqlConnection); object rowCount; try { // Settings. sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Connection = sqlConnection; sqlCommand.CommandTimeout = 12 * 3600; //// Setting timeeout for longer queries to 12 hours. sqlCommand.Parameters.Add("@student_id", SqlDbType.Int).Value = _studentId; // Open. sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { SelectedCourse sc = new SelectedCourse(); sc.CollegeName = reader.GetString(0); sc.CourseName = reader.GetString(1); sc.Priority = reader.GetInt32(2); lvSelectedCourse.Items.Add(sc); } } else { Console.WriteLine("No rows found."); } sqlConnection.Close(); } catch (Exception ex) { // Close. sqlConnection.Close(); } }
private void btnAddCourse_Click(object sender, RoutedEventArgs e) { int priority = 0; if (string.IsNullOrWhiteSpace(cbCourseName.SelectedItem.ToString())) { MessageBox.Show("Please select course name", "Invalid course name", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (string.IsNullOrWhiteSpace(cbCollegeName.SelectedItem.ToString())) { MessageBox.Show("Please select college name", "Invalid college name", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (!int.TryParse(udPriority.Value.ToString(), out priority) || priority < 1) { MessageBox.Show("Please enter value more than or equal to 1", "Invalid priority", MessageBoxButton.OK, MessageBoxImage.Error); return; } var course = new SelectedCourse() { CollegeName = cbCollegeName.SelectedItem.ToString(), Priority = priority, CourseName = cbCourseName.SelectedItem.ToString() }; foreach (var courseItem in lvSelectedCourse.Items) { if (((SelectedCourse)courseItem).CollegeName == course.CollegeName && ((SelectedCourse)courseItem).CourseName == course.CourseName) { MessageBox.Show("Same combination exists, please enter different combination", "Combination exists", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (((SelectedCourse)courseItem).Priority == course.Priority) { MessageBox.Show("Same priority exists, please enter different priority", "Priority exists", MessageBoxButton.OK, MessageBoxImage.Error); return; } } lvSelectedCourse.Items.Add(course); }
private void OnPrevClicked(object sender, RoutedEventArgs e) { if (tabDocDetail.IsSelected) { if (!UpdateDocumentDetail()) { MessageBox.Show("Unexpected Error"); } else { MessageBox.Show("Document details saved successfully!!!", "Data saved", MessageBoxButton.OK); tabStudentDetail.IsSelected = true; btnPrev.Visibility = Visibility.Collapsed; FetchStudentDetails(); } } else if (tabMarkDetails.IsSelected) { if (!UpdateMarkDetails()) { MessageBox.Show("Unexpected Error"); } else { MessageBox.Show("Mark details saved successfully!!!", "Data saved", MessageBoxButton.OK); tabDocDetail.IsSelected = true; FetchDocumentDetails(); } } else if (tabChoice.IsSelected) { foreach (var course in lvSelectedCourse.Items) { SelectedCourse selectedCourse = course as SelectedCourse; bool resp = UpdateCourseDetails(selectedCourse.CollegeName, selectedCourse.CourseName, selectedCourse.Priority); if (!resp) { MessageBox.Show("Unexpected Error"); return; } } MessageBox.Show("Course choice details saved successfully!!!", "Data saved", MessageBoxButton.OK); FetchMarkDetails(); tabMarkDetails.IsSelected = true; btnNext.Visibility = Visibility.Visible; } else if (tabAllocation.IsSelected) { foreach (var course in lvSelectedCourse.Items) { SelectedCourse selectedCourse = course as SelectedCourse; bool resp = UpdateCourseDetails(selectedCourse.CollegeName, selectedCourse.CourseName, selectedCourse.Priority); if (!resp) { MessageBox.Show("Unexpected Error"); return; } } tabChoice.IsSelected = true; btnNext.Visibility = Visibility.Visible; } }