public FindServerEventLogForReportsByUserDataSet FindServerEventLogForReportsByUser(string strLogonName, DateTime datStartDate, DateTime datEndDate) { try { aFindServerEventLogForReportsByUserDataSet = new FindServerEventLogForReportsByUserDataSet(); aFindServerEventLogForReportsByUserTableAdapter = new FindServerEventLogForReportsByUserDataSetTableAdapters.FindServerEventLogForReportsByUserTableAdapter(); aFindServerEventLogForReportsByUserTableAdapter.Fill(aFindServerEventLogForReportsByUserDataSet.FindServerEventLogForReportsByUser, strLogonName, datStartDate, datEndDate); } catch (Exception Ex) { InsertEventLogEntry(DateTime.Now, "Event Log Class // Find Server Event Log For Reports By User " + Ex.Message); } return(aFindServerEventLogForReportsByUserDataSet); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { string strKeyword = ""; string strValueForValidation; int intCounter; int intNumberOfRecords; DateTime datTransactionDate; string strLogonName; string strItemAccessed; string strEventNotes; bool blnFatalError = false; string strErrorMessage = ""; int intSecondCounter; bool blnThereIsAProblem; try { TheEventLogSecurityDataSet.eventlogsecurity.Rows.Clear(); //data validation if (cboReportType.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Report Type Was Not Chosen\n"; } if (gintSelectedIndex > 1) { strKeyword = txtEnterKeyWord.Text; if (strKeyword.Length < 3) { blnFatalError = true; strErrorMessage += "The Word Entered is not Long Enough\n"; } } strValueForValidation = txtStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { gdatStartDate = Convert.ToDateTime(strValueForValidation); } strValueForValidation = txtEndDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The End Date is not a Date\n"; } else { gdatEndDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } if (gintSelectedIndex == 1) { TheFindServerEventLogForReportsbyDateRangeDataSet = TheEventLogClass.FindServerEventLogForReportsByDateRange(gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { datTransactionDate = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].TransactionDate; strItemAccessed = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].ItemAccessed; strLogonName = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].LogonName; EventlLogSecurityDataSet.eventlogsecurityRow NewEventRow = TheEventLogSecurityDataSet.eventlogsecurity.NeweventlogsecurityRow(); NewEventRow.ItemAccessed = strItemAccessed; NewEventRow.LogonName = strLogonName; NewEventRow.TransactionDate = datTransactionDate; TheEventLogSecurityDataSet.eventlogsecurity.Rows.Add(NewEventRow); } } } else if (gintSelectedIndex == 2) { TheFindServerEventLogForReportsByUserDataSet = TheEventLogClass.FindServerEventLogForReportsByUser(strKeyword, gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindServerEventLogForReportsByUserDataSet.FindServerEventLogForReportsByUser.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { datTransactionDate = TheFindServerEventLogForReportsByUserDataSet.FindServerEventLogForReportsByUser[intCounter].TransactionDate; strItemAccessed = TheFindServerEventLogForReportsByUserDataSet.FindServerEventLogForReportsByUser[intCounter].ItemAccessed; strLogonName = TheFindServerEventLogForReportsByUserDataSet.FindServerEventLogForReportsByUser[intCounter].LogonName; EventlLogSecurityDataSet.eventlogsecurityRow NewEventRow = TheEventLogSecurityDataSet.eventlogsecurity.NeweventlogsecurityRow(); NewEventRow.ItemAccessed = strItemAccessed; NewEventRow.LogonName = strLogonName; NewEventRow.TransactionDate = datTransactionDate; TheEventLogSecurityDataSet.eventlogsecurity.Rows.Add(NewEventRow); } } } else if (gintSelectedIndex == 3) { TheFindServerEventLogForReportsByItemDataSet = TheEventLogClass.FindServerEventLogForReportsByItem(strKeyword, gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindServerEventLogForReportsByItemDataSet.FindServerEventLogForReportsByItem.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { datTransactionDate = TheFindServerEventLogForReportsByItemDataSet.FindServerEventLogForReportsByItem[intCounter].TransactionDate; strItemAccessed = TheFindServerEventLogForReportsByItemDataSet.FindServerEventLogForReportsByItem[intCounter].ItemAccessed; strLogonName = TheFindServerEventLogForReportsByItemDataSet.FindServerEventLogForReportsByItem[intCounter].LogonName; EventlLogSecurityDataSet.eventlogsecurityRow NewEventRow = TheEventLogSecurityDataSet.eventlogsecurity.NeweventlogsecurityRow(); NewEventRow.ItemAccessed = strItemAccessed; NewEventRow.LogonName = strLogonName; NewEventRow.TransactionDate = datTransactionDate; TheEventLogSecurityDataSet.eventlogsecurity.Rows.Add(NewEventRow); } } } dgrEventLog.ItemsSource = TheEventLogSecurityDataSet.eventlogsecurity; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Server Security Report // Search Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }