private void exportToExcelItem_Click(object sender, RoutedEventArgs e) { DataTable dt = GlobalFunctions.ToDataTable <Candidate>((ObservableCollection <Candidate>)MainView.ItemsSource); GlobalFunctions.ExportToExcel(dt); }
private void searchButton_Click(object sender, RoutedEventArgs e) { string area = "|"; foreach (Area item in AreaCombo.Items) { if (item.IsChecked) { area += item.Id + "|"; } } if (area == "|") { area = null; } string status = "|"; foreach (Status item in StatusCombo.Items) { if (item.IsChecked) { status += item.ID + "|"; } } if (status == "|") { status = null; } string group = "|"; foreach (Group item in GroupList.Items) { if (item.IsChecked) { group += item.id + "|"; } } if (group == "|") { group = null; } string project = "|"; foreach (Project item in ProjectList.Items) { if (item.IsChecked) { project += item.ID + "|"; } } if (project == "|") { project = null; } string lastName = LastNametxt.Text; string firstName = FirstNametxt.Text; string position = Positiontxt.Text; bool?CvReceived = null; if (CVrEceivedYes.IsChecked == true) { CvReceived = true; } else if (CVrEceivedNo.IsChecked == true) { CvReceived = false; } bool?CvUploaded = null; if (CvUploadedYes.IsChecked == true) { CvUploaded = true; } else if (CvUploadedNo.IsChecked == true) { CvUploaded = false; } CandidatesDT = GlobalFunctions.GetTableFromServerArgs("SEARCH_CANDIDATE", "@FIRST_NAME" + "-" + firstName, "@LAST_NAME" + "-" + lastName, "@POSITION" + "-" + position, "@PROJECT" + "-" + project, "@AREA" + "-" + area, "@GROUP" + "-" + group, "@STATUS" + "-" + status , "@CVRECEIVED" + "-" + CvReceived, "@CV_UPLOADED" + "-" + CvUploaded); CandidatesCollection = Candidate.CreateCandidatesCollection(CandidatesDT); MainView.ItemsSource = CandidatesCollection; }