public FindServerEventLogByNoteKeywordDataSet FindServerEventLogByNoteKeyword(string strNoteKeyword, DateTime datStartDate, DateTime datEndDate) { try { aFindServerEventLogByNoteKeywordDataSet = new FindServerEventLogByNoteKeywordDataSet(); aFindServerEVentLogByNoteKeywordTableAdapter = new FindServerEventLogByNoteKeywordDataSetTableAdapters.FindServerLogByNoteKeywordTableAdapter(); aFindServerEVentLogByNoteKeywordTableAdapter.Fill(aFindServerEventLogByNoteKeywordDataSet.FindServerLogByNoteKeyword, strNoteKeyword, datStartDate, datEndDate); } catch (Exception Ex) { InsertEventLogEntry(DateTime.Now, "Event Log Class // Find Server Event Log By Note Keyword " + Ex.Message); } return(aFindServerEventLogByNoteKeywordDataSet); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { string strValueForValidation; bool blnFatalError = false; DateTime datStartDate = DateTime.Now; DateTime datTodaysDate = DateTime.Now; string strKeyword; int intRecordsReturned; try { TheFindServerLogAccessByEmployeeIDDataSet = TheEventLogClass.FindServerLogAccessByEmployeeID(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID); intRecordsReturned = TheFindServerLogAccessByEmployeeIDDataSet.FindServerLogAccessByEmmployeeID.Rows.Count; if (intRecordsReturned < 0) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Server Audit Log // THERE HAS BEEN AN ATTEMPT TO ACCESS THROUGH ERP"); TheMessagesClass.ErrorMessage("ACCESS DENIED, IT HAS BEEN NOTIFIED"); throw new Exception(); } blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Server Audit Log"); if (blnFatalError == true) { throw new Exception(); } //beginning data validation strValueForValidation = txtStartDate.Text; blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is not a Date"); return; } else { datStartDate = Convert.ToDateTime(strValueForValidation); blnFatalError = TheDataValidationClass.verifyDateRange(datStartDate, datTodaysDate); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is after Todays Date"); return; } } strKeyword = txtKeyword.Text; if (strKeyword.Length < 3) { TheMessagesClass.ErrorMessage("The Search Term is not Long Enough"); return; } PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); TheFindServerEventLogByNoteKeywordDataSet = TheEventLogClass.FindServerEventLogByNoteKeyword(strKeyword, datStartDate, datTodaysDate); string strTestVarialbe = TheFindServerEventLogByNoteKeywordDataSet.FindServerLogByNoteKeyword[0].EventNotes; dgrResults.ItemsSource = TheFindServerEventLogByNoteKeywordDataSet.FindServerLogByNoteKeyword; PleaseWait.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Server Audit Log // Search Button " + Ex.Message); TheSendEmailClass.SendEventLog("New Blue Jay ERP // Server Audit Log // Search Button " + Ex.ToString()); TheMessagesClass.ErrorMessage(Ex.ToString()); } }