public FindEmployeeByLastNameEndDateDataSet FindEmployeeByLastNameEndDate(string strLastName, DateTime datEndDate)
{
try
{
aFindEmployeeByLastNameEndDateDataSet = new FindEmployeeByLastNameEndDateDataSet();
aFindEmployeeByLastNameEndDateTableAdapter = new FindEmployeeByLastNameEndDateDataSetTableAdapters.FindEmployeesByLastNameEndDateTableAdapter();
aFindEmployeeByLastNameEndDateTableAdapter.Fill(aFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate, strLastName, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "The Employee Class // Find Employee By Last Name End Date " + Ex.Message);
}
return(aFindEmployeeByLastNameEndDateDataSet);
}
private void txtEnterLastName_TextChanged(object sender, TextChangedEventArgs e)
{
string strValueForValidation;
bool blnFatalError = false;
string strLastName;
int intLength;
int intCounter;
int intNumberOfRecords;
DateTime datEndDate;
try
{
CheckProject();
strValueForValidation = txtDriveTime.Text;
blnFatalError = TheDataValidationClass.VerifyDoubleData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Drive Time is not Entered");
return;
}
else
{
gdecDriveTime = Convert.ToDecimal(strValueForValidation);
if (gdecDriveTime == 0)
{
TheMessagesClass.ErrorMessage("The Drive Time Cannot be 0");
return;
}
else if (gdecDriveTime > 16)
{
TheMessagesClass.ErrorMessage("Drive Time Cannot Be Greater Than 16");
return;
}
TheFindWorkTaskByKeywordDataSet = TheWorkTaskClass.FindWorkTaskByTaskKeyword("DRIVE TIME");
gintDriveTimeTaskID = TheFindWorkTaskByKeywordDataSet.FindWorkTaskByTaskKeyword[0].WorkTaskID;
}
strValueForValidation = txtNonProductive.Text;
blnFatalError = TheDataValidationClass.VerifyDoubleData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Non-Productivity Time is not Numeric\n");
return;
}
else
{
gdecNonProductiveTime = Convert.ToDecimal(strValueForValidation);
}
datEndDate = TheDateSearchClass.SubtractingDays(DateTime.Now, 21);
strLastName = txtEnterLastName.Text;
intLength = strLastName.Length;
if (intLength > 2)
{
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
TheFindEmployeeByLastNameEndDateDataSet = TheEmployeeClass.FindEmployeeByLastNameEndDate(strLastName, datEndDate);
intNumberOfRecords = TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate.Rows.Count - 1;
if (intNumberOfRecords == -1)
{
TheMessagesClass.InformationMessage("Employee Not Found");
return;
}
else
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intCounter].FirstName + " " + TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intCounter].LastName);
}
}
cboSelectEmployee.SelectedIndex = 0;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Project Labor // Enter Last Name Text Box " + Ex.Message);
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Project Labor // Enter Last Name Text Box " + Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtEnterLastLame_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strProjectID;
int intRecordsReturned;
string strLastName;
int intLength;
int intCounter;
int intNumberOfRecords;
DateTime datTransactionDate = DateTime.Now;
DateTime datTodaysDate = DateTime.Now;
bool blnFatalError = false;
int intEmployeeID;
decimal decHours;
DateTime datEndDate;
try
{
datEndDate = TheDateSearchClass.SubtractingDays(datTodaysDate, 21);
blnFatalError = TheDataValidationClass.VerifyDateData(txtTransactionDate.Text);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date Entered is not a Date");
return;
}
else
{
datTransactionDate = Convert.ToDateTime(txtTransactionDate.Text);
}
if (datTransactionDate > datTodaysDate)
{
TheMessagesClass.ErrorMessage("The Date Entered is in the Future");
return;
}
if (gblnProjectFound == false)
{
strProjectID = txtEnterProjectID.Text;
TheFindProjectMatrixByCustomerProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerProjectID(strProjectID);
intRecordsReturned = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID.Rows.Count;
if (intRecordsReturned == 0)
{
TheFindProjectMatrixByAssignedProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByAssignedProjectID(strProjectID);
intRecordsReturned = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Project Not Found, A Valid Project Must Be Entered");
return;
}
else
{
MainWindow.gintProjectID = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID[0].ProjectID;
}
}
else
{
MainWindow.gintProjectID = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID[0].ProjectID;
}
TheFindProjectByProjectIDDataSet = TheProjectClass.FindProjectByProjectID(MainWindow.gintProjectID);
MainWindow.gstrAssignedProjectID = strProjectID;
txtProjectName.Text = TheFindProjectByProjectIDDataSet.FindProjectByProjectID[0].ProjectName;
gblnProjectFound = true;
intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
decHours = Convert.ToDecimal(txtEnterHours.Text);
blnFatalError = TheProductivityDataEntryClass.InsertProductivityDataEntry(intEmployeeID, MainWindow.gintProjectID, datTodaysDate, decHours, 0, 0);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindProductivityDataEntryByDateDataSet = TheProductivityDataEntryClass.FindProductivityDataEntryByDate(datTodaysDate);
gintDataEntryTransactionID = TheFindProductivityDataEntryByDateDataSet.FindProductivtyDataEntryByDate[0].TransactionID;
gintEmployeeCounter = 0;
gintTaskCounter = 0;
}
strLastName = txtEnterLastLame.Text;
intLength = strLastName.Length;
if (intLength > 2)
{
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
TheFindEmployeeByLastNameEndDateDataSet = TheEmployeeClass.FindEmployeeByLastNameEndDate(strLastName, datEndDate);
intNumberOfRecords = TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate.Rows.Count - 1;
if (intNumberOfRecords == -1)
{
TheMessagesClass.InformationMessage("Employee Not Found");
return;
}
else
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intCounter].FirstName + " " + TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intCounter].LastName);
}
}
cboSelectEmployee.SelectedIndex = 0;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Project Labor // Enter Last Name Text Change Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
