private void txtEnterLastName_TextChanged(object sender, TextChangedEventArgs e)
{
string strLastName;
int intLength;
int intCounter;
int intNumberOfRecords;
//getting the last name
strLastName = txtEnterLastName.Text;
intLength = strLastName.Length;
if (intLength > 2)
{
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
TheFindEmployeeByLastNameDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strLastName);
intNumberOfRecords = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
TheMessagesClass.ErrorMessage("Employee Not Found");
return;
}
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].FirstName + " " + TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].LastName);
}
cboSelectEmployee.SelectedIndex = 0;
}
}
public FindEmployeeByLastNameDataSet FindEmployeesByLastNameKeyWord(string strLastName)
{
try
{
strLastName = "%" + strLastName + "%";
aFindEmployeeByLastNameDataSet = new FindEmployeeByLastNameDataSet();
aFindEmployeeByLastNameTableAdapter = new FindEmployeeByLastNameDataSetTableAdapters.FindEmployeeByLastNameTableAdapter();
aFindEmployeeByLastNameTableAdapter.Fill(aFindEmployeeByLastNameDataSet.FindEmployeeByLastName, strLastName);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Employee DLL // Find Employees By Last Name Key Word // " + Ex.Message);
}
return(aFindEmployeeByLastNameDataSet);
}
public ComboEmployeeDataSet FillEmployeeComboBox(string strLastName)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
string strFullName;
string strFirstName;
int intEmployeeID;
aComboEmployeeDataSet.employees.Rows.Clear();
try
{
TheFindEmployeeByLastNameDataSet = FindEmployeesByLastNameKeyWord(strLastName);
intNumberOfRecords = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFirstName = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].FirstName;
intEmployeeID = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].EmployeeID;
strLastName = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].LastName;
strFullName = strFirstName + " " + strLastName;
ComboEmployeeDataSet.employeesRow NewEmployeeRow = aComboEmployeeDataSet.employees.NewemployeesRow();
NewEmployeeRow.EmployeeID = intEmployeeID;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.FullName = strFullName;
aComboEmployeeDataSet.employees.Rows.Add(NewEmployeeRow);
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Employee DLL // Fill Employee Combo Box " + Ex.Message);
}
return(aComboEmployeeDataSet);
}
private void txtEnterLastName_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strLastName;
int intLength;
int intCounter;
int intNumberOfRecords;
string strName;
if (gstrToolHistoryType == "Employee Search")
{
strLastName = txtEnterLastName.Text;
intLength = strLastName.Length;
if (intLength > 3)
{
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
TheFindEmployeeByLastNameDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strLastName);
intNumberOfRecords = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strName = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].FirstName + " ";
strName += TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].LastName;
cboSelectEmployee.Items.Add(strName);
}
cboSelectEmployee.SelectedIndex = 0;
}
else
{
TheMessagesClass.ErrorMessage("Employee Not Found");
}
}
}
}
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;
bool blnFatalError = false;
int intEmployeeID;
decimal decHours;
try
{
if (gblnProjectFound == false)
{
strProjectID = txtEnterProjectID.Text;
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProjectID);
intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Project Not Found, A Valid Project Must Be Entered");
return;
}
else
{
txtProjectName.Text = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectName;
MainWindow.gintProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID;
MainWindow.gstrAssignedProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].AssignedProjectID;
gblnProjectFound = true;
intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
decHours = Convert.ToDecimal(txtEnterHours.Text);
blnFatalError = TheProductivityDataEntryClass.InsertProductivityDataEntry(intEmployeeID, MainWindow.gintProjectID, datTransactionDate, decHours, 0, 0);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindProductivityDataEntryByDateDataSet = TheProductivityDataEntryClass.FindProductivityDataEntryByDate(datTransactionDate);
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");
TheFindEmployeeByLastNameDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strLastName);
intNumberOfRecords = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intNumberOfRecords == -1)
{
TheMessagesClass.InformationMessage("Employee Not Found");
return;
}
else
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].FirstName + " " + TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intCounter].LastName);
}
}
cboSelectEmployee.SelectedIndex = 0;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Enter Approved Transaction // Enter Last Name Text Change Event " + Ex.Message);
}
}
private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
int intCounter;
int intNumberOfRecords;
int intSecondNumberOfRecords;
int intSecondCounter;
int intBJCNumber;
int intToolCounter;
int intToolNumberOfRecords;
try
{
intSelectedIndex = cboSelectEmployee.SelectedIndex - 1;
if (intSelectedIndex > -1)
{
TheEmployeeToolsDataSet.employeetools.Rows.Clear();
TheVehicleToolsDataSet.vehicletools.Rows.Clear();
MainWindow.gintEmployeeID = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intSelectedIndex].EmployeeID;
MainWindow.gstrFirstName = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intSelectedIndex].FirstName;
MainWindow.gstrLastName = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intSelectedIndex].LastName;
TheFindToolsByEmployeeIDDataSet = TheToolsClass.FindToolsByEmployeeID(MainWindow.gintEmployeeID);
intNumberOfRecords = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
EmployeeToolsDataSet.employeetoolsRow NewToolRow = TheEmployeeToolsDataSet.employeetools.NewemployeetoolsRow();
NewToolRow.ToolCategory = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intCounter].ToolCategory;
NewToolRow.ToolDescription = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intCounter].ToolDescription;
NewToolRow.ToolNotes = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intCounter].ToolNotes;
NewToolRow.ToolID = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intCounter].ToolID;
NewToolRow.TransactionDate = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intCounter].TransactionDate;
TheEmployeeToolsDataSet.employeetools.Rows.Add(NewToolRow);
}
dgrTools.ItemsSource = TheEmployeeToolsDataSet.employeetools;
//checking for a vehicle
TheFindVehicleAssigedByEmployeeIDDataSet = TheVehicleMainClass.FindVehicleAssignedByEmployeeID(MainWindow.gintEmployeeID);
intNumberOfRecords = TheFindVehicleAssigedByEmployeeIDDataSet.FindVehicleAssignedByEmployeeID.Rows.Count - 1;
if (intNumberOfRecords == 0)
{
txtVehicleAssignment.Text = Convert.ToString(TheFindVehicleAssigedByEmployeeIDDataSet.FindVehicleAssignedByEmployeeID[0].BJCNumber);
}
else if (intNumberOfRecords > 0)
{
txtVehicleAssignment.Text = "Multiple";
}
else
{
txtVehicleAssignment.Text = "None";
}
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intBJCNumber = TheFindVehicleAssigedByEmployeeIDDataSet.FindVehicleAssignedByEmployeeID[intCounter].BJCNumber;
TheFindEmployeeByLastNameDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(Convert.ToString(intBJCNumber));
intSecondNumberOfRecords = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
gintVehicleEmployeeID = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intSecondCounter].EmployeeID;
TheFindToolsByEmployeeIDDataSet = TheToolsClass.FindToolsByEmployeeID(gintVehicleEmployeeID);
intToolNumberOfRecords = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID.Rows.Count - 1;
if (intToolNumberOfRecords > -1)
{
for (intToolCounter = 0; intToolCounter <= intToolNumberOfRecords; intToolCounter++)
{
VehicleToolsDataSet.vehicletoolsRow NewToolRow = TheVehicleToolsDataSet.vehicletools.NewvehicletoolsRow();
NewToolRow.BJCNumber = intBJCNumber;
NewToolRow.ToolCategory = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolCategory;
NewToolRow.ToolDescription = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolDescription;
NewToolRow.ToolID = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolID;
NewToolRow.ToolNotes = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolNotes;
TheVehicleToolsDataSet.vehicletools.Rows.Add(NewToolRow);
}
}
}
}
}
dgrVehicleTools.ItemsSource = TheVehicleToolsDataSet.vehicletools;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Terminate Employee // Combo box Change Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
string strIsInside;
string strDriver;
string strVehicleNumber;
string strEventDate;
double douEventDate;
DateTime datEventDate;
bool blnIsInSide = false;
int intVehicleCounter;
int intVehicleNumberOfRecords;
int intEmployeeCounter;
int intEmployeeNumberOfRecords;
string strAssignedOffice = "";
int intSubstringLength;
string strFullName;
int intVehicleID = 0;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
try
{
TheImportGEOFenceDataSet.importgeofence.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 5; intCounter <= intNumberOfRecords; intCounter++)
{
strEventDate = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strIsInside = Convert.ToString((range.Cells[intCounter, 9] as Excel.Range).Value2).ToUpper();
strDriver = Convert.ToString((range.Cells[intCounter, 10] as Excel.Range).Value2).ToUpper();
strVehicleNumber = Convert.ToString((range.Cells[intCounter, 11] as Excel.Range).Value2).ToUpper();
douEventDate = Convert.ToDouble(strEventDate);
datEventDate = DateTime.FromOADate(douEventDate);
if (strIsInside == "YES")
{
blnIsInSide = true;
}
else
{
blnIsInSide = false;
}
ImportGEOFencedDataSet.importgeofenceRow NewGEOFenceTransaction = TheImportGEOFenceDataSet.importgeofence.NewimportgeofenceRow();
NewGEOFenceTransaction.Driver = strDriver;
NewGEOFenceTransaction.EmployeeID = -1;
NewGEOFenceTransaction.EventTime = datEventDate;
NewGEOFenceTransaction.VehicleID = -1;
NewGEOFenceTransaction.VehicleNumber = strVehicleNumber;
NewGEOFenceTransaction.InSide = blnIsInSide;
TheImportGEOFenceDataSet.importgeofence.Rows.Add(NewGEOFenceTransaction);
}
dgrResults.ItemsSource = TheImportGEOFenceDataSet.importgeofence;
TheMessagesClass.InformationMessage("Click OK to Continue");
intNumberOfRecords = TheImportGEOFenceDataSet.importgeofence.Rows.Count - 1;
intVehicleNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
for (intVehicleCounter = 0; intVehicleCounter <= intVehicleNumberOfRecords; intVehicleCounter++)
{
strVehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleNumber;
if (TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleNumber.Contains(strVehicleNumber) == true)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID;
TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleNumber = strVehicleNumber;
strAssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].AssignedOffice;
intVehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID;
datStartDate = TheDateSearchClass.RemoveTime(TheImportGEOFenceDataSet.importgeofence[intCounter].EventTime);
datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1);
}
}
strDriver = TheImportGEOFenceDataSet.importgeofence[intCounter].Driver;
if (strDriver == "NO DRIVER CHECKED IN")
{
intEmployeeNumberOfRecords = TheFindWarehouseDataSet.FindWarehouses.Rows.Count - 1;
for (intEmployeeCounter = 0; intEmployeeCounter <= intEmployeeNumberOfRecords; intEmployeeCounter++)
{
if (strAssignedOffice == TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].FirstName)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].EmployeeID;
}
}
}
else
{
TheFindEmployeeByLastDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strDriver);
intEmployeeNumberOfRecords = TheFindEmployeeByLastDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intEmployeeNumberOfRecords == 0)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindEmployeeByLastDataSet.FindEmployeeByLastName[0].EmployeeID;
}
else
{
TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet = TheInspectionsClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate);
intEmployeeNumberOfRecords = TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count;
if (intEmployeeNumberOfRecords > 0)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[0].EmployeeID;
}
else
{
intEmployeeNumberOfRecords = TheFindWarehouseDataSet.FindWarehouses.Rows.Count - 1;
for (intEmployeeCounter = 0; intEmployeeCounter <= intEmployeeNumberOfRecords; intEmployeeCounter++)
{
if (strAssignedOffice == TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].FirstName)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].EmployeeID;
}
}
}
}
}
}
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import GEO Fence Report // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void BtnImportExcel_Click(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
string strFirstName;
string strLastName;
string strCellNumber;
int intRecordsReturned;
int intEmployeeCounter;
int intEmployeeID;
int intWarehouseID = 0;
string strPhoneNotes = "PHONE IMPORTED";
try
{
TheImportPhonesDataSet.cellphones.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 1; intCounter <= intNumberOfRecords; intCounter++)
{
strFirstName = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
strLastName = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
strCellNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
TheFindEmployeeByLastNameDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strLastName);
intRecordsReturned = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName.Rows.Count - 1;
intEmployeeID = -1;
if (intRecordsReturned > -1)
{
for (intEmployeeCounter = 0; intEmployeeCounter <= intRecordsReturned; intEmployeeCounter++)
{
if (strFirstName == TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intEmployeeCounter].FirstName)
{
intEmployeeID = TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intEmployeeCounter].EmployeeID;
intWarehouseID = FindWarehouseID(TheFindEmployeeByLastNameDataSet.FindEmployeeByLastName[intEmployeeCounter].HomeOffice);
}
}
}
ImportPhonesDataSet.cellphonesRow NewPhoneRow = TheImportPhonesDataSet.cellphones.NewcellphonesRow();
NewPhoneRow.EmployeeID = intEmployeeID;
NewPhoneRow.FirstName = strFirstName;
NewPhoneRow.LastName = strLastName;
NewPhoneRow.CellNumber = strCellNumber;
NewPhoneRow.WarehouseID = intWarehouseID;
NewPhoneRow.PhoneNotes = strPhoneNotes;
TheImportPhonesDataSet.cellphones.Rows.Add(NewPhoneRow);
}
PleaseWait.Close();
dgrResults.ItemsSource = TheImportPhonesDataSet.cellphones;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Import Cell Phones // Import Excel Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
