public FindOpenHelpDeskTicketsAssignedDataSet FindOpenHelpDeskTicketsAssigned(int intEmployeeID) { try { aFindOpenHelpDeskTicketsAssignedDataSet = new FindOpenHelpDeskTicketsAssignedDataSet(); aFindOpenHelpDeskTicketsAssignedTableAdapter = new FindOpenHelpDeskTicketsAssignedDataSetTableAdapters.FindOpenHelpDeskTicketsAssginedTableAdapter(); aFindOpenHelpDeskTicketsAssignedTableAdapter.Fill(aFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined, intEmployeeID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Help Desk Class // Find Open Help Desk Tickets Assigned " + Ex.Message); } return(aFindOpenHelpDeskTicketsAssignedDataSet); }
private void expMyTickets_Expanded(object sender, RoutedEventArgs e) { int intEmployeeID; int intCounter; int intNumberOfRecords; try { expMyTickets.IsExpanded = false; intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; TheFindOpenHelpDeskTicketsAssignedDataSet = TheHelpDeskClass.FindOpenHelpDeskTicketsAssigned(intEmployeeID); TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.Rows.Clear(); intNumberOfRecords = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { OpenHelpDeskTicketsDataSet.openhelpdeskticketsRow NewTicketRow = TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.NewopenhelpdeskticketsRow(); NewTicketRow.FirstName = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].FirstName; NewTicketRow.LastName = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].LastName; NewTicketRow.ReportedProblem = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].ReportedProblem; NewTicketRow.TicketDate = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].TicketDate; NewTicketRow.TicketID = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].TicketID; TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.Rows.Add(NewTicketRow); } } dgrOpenTickets.ItemsSource = TheOpenHelpDeskTicketsDataSet.openhelpdesktickets; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Help Desk Tickets // My Tickets Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }