public FindServerEventLogForReportsByDateRangeDataSet FindServerEventLogForReportsByDateRange(DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindServerEventLogForReportsByDateRangeDataSet = new FindServerEventLogForReportsByDateRangeDataSet();
aFindServerEventLogForReportsByDateRangeTableAdapter = new FindServerEventLogForReportsByDateRangeDataSetTableAdapters.FindServerEventLogForReportsByDateRangeTableAdapter();
aFindServerEventLogForReportsByDateRangeTableAdapter.Fill(aFindServerEventLogForReportsByDateRangeDataSet.FindServerEventLogForReportsByDateRange, datStartDate, datEndDate);
}
catch (Exception Ex)
{
InsertEventLogEntry(DateTime.Now, "Event Log Class // Find Server Event Log For Reports By Date Range " + Ex.Message);
}
return(aFindServerEventLogForReportsByDateRangeDataSet);
}
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());
}
}
private void ResetControls()
{
//setting up the variables
int intCounter;
int intNumberOfRecords;
DateTime datTransactionDate;
string strLogonName;
string strItemAccessed;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
try
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
TheEventLogSecurityDataSet.eventlogsecurity.Rows.Clear();
txtEndDate.Text = "";
txtStartDate.Text = "";
txtEnterKeyWord.Text = "";
cboReportType.Items.Clear();
cboReportType.Items.Add("Select Report Type");
cboReportType.Items.Add("Date Search Report");
cboReportType.Items.Add("User Report");
cboReportType.Items.Add("Item Search");
cboReportType.SelectedIndex = 0;
datStartDate = DateTime.Now;
datStartDate = TheDateSearchClass.RemoveTime(datStartDate);
datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1);
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 1);
TheFindServerEventLogForReportsbyDateRangeDataSet = TheEventLogClass.FindServerEventLogForReportsByDateRange(datStartDate, datEndDate);
intNumberOfRecords = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
datTransactionDate = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].TransactionDate;
strLogonName = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].LogonName;
strItemAccessed = TheFindServerEventLogForReportsbyDateRangeDataSet.FindServerEventLogForReportsByDateRange[intCounter].ItemAccessed;
EventlLogSecurityDataSet.eventlogsecurityRow NewEventEntry = TheEventLogSecurityDataSet.eventlogsecurity.NeweventlogsecurityRow();
NewEventEntry.TransactionDate = datTransactionDate;
NewEventEntry.LogonName = strLogonName;
NewEventEntry.ItemAccessed = strItemAccessed;
TheEventLogSecurityDataSet.eventlogsecurity.Rows.Add(NewEventEntry);
}
}
dgrEventLog.ItemsSource = TheEventLogSecurityDataSet.eventlogsecurity;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Event Log Security // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
