private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehouseDataSet.FindPartsWarehouses.Rows.Count;
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
TheWarehouseCountDataSet.warehousecount.Rows.Clear();
dgrResult.ItemsSource = TheWarehouseCountDataSet.warehousecount;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehouseDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Warehouse Inventory Report // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void LoadComboBox()
{
int intCounter;
int intNumberOfRecords;
try
{
cboSelectWarehouse.Items.Clear();
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
cboSelectWarehouse.Items.Add("Select Warehouse");
intNumberOfRecords = TheFindPartsWarehouseDataSet.FindPartsWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehouseDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
TheFinalCalculatedInventoryStatsDataSet.inventorystats.Rows.Clear();
dgrResults.ItemsSource = TheFinalCalculatedInventoryStatsDataSet.inventorystats;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Warehouse Inventory Stats // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
string strFullName;
try
{
//clearing text boxes
txtAssignedReelID.Text = "";
txtPartDescription.Text = "";
txtPartNumber.Text = "";
txtPONumber.Text = "";
txtProjectID.Text = "";
txtReelFootage.Text = "";
lblWarehouseSelected.Content = "Select Warehouse";
gblnReelIDChecked = false;
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Warehouse Employee");
TheFindEmployeeByDepartmentDataSet = TheEmployeeClass.FindEmployeeByDepartment("WAREHOUSE");
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFullName = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].FirstName + " ";
strFullName += TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].LastName;
cboSelectEmployee.Items.Add(strFullName);
}
cboSelectEmployee.SelectedIndex = 0;
TheFindPartsWarehousesDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehousesDataSet.FindPartsWarehouses.Rows.Count - 1;
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehousesDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Cable Reel // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindPartsWarehousesDataSet FindPartsWarehouses()
{
try
{
aFindPartsWarehouseDataSet = new FindPartsWarehousesDataSet();
aFindPartsWarehouseTableAdapter = new FindPartsWarehousesDataSetTableAdapters.FindPartsWarehousesTableAdapter();
aFindPartsWarehouseTableAdapter.Fill(aFindPartsWarehouseDataSet.FindPartsWarehouses);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Employee DLL // Find Parts Warehouses // " + Ex.Message);
}
return(aFindPartsWarehouseDataSet);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
//setting form conditions
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
pbxEmployeeID.Focus();
gintNumberOfMisses = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Enter Inventory // Main Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
MainWindow.gintEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(MainWindow.gintEmployeeID, "New Blue Jay ERP // Add Inventory Location");
if (blnFatalError == true)
{
throw new Exception();
}
gblnItemFound = false;
txtEnterLocation.Text = "";
txtPartDescription.Text = "";
txtPartNumber.Text = "";
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehouseDataSet.FindPartsWarehouses.Rows.Count;
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehouseDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Inventory Location // Reset Controls " + Ex.Message);
TheSendEmailClass.SendEventLog(Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
TheFindPartsWarehousesDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehousesDataSet.FindPartsWarehouses.Rows.Count - 1;
cboSelectWarehouse.Items.Add("Select Warehouse");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehousesDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
btnImportExcel.IsEnabled = false;
btnProcess.IsEnabled = false;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
cboSelectWarehouse.Items.Add("Select Warehouse");
MainWindow.gintEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.gintEmployeeID, "New Blue Jay ERP // Import Inventory Locations");
if (blnFatalError == true)
{
throw new Exception();
}
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehouseDataSet.FindPartsWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehouseDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
TheImportInventoryLocationdDataSet.importinventorylocations.Rows.Clear();
dgrImportedInformation.ItemsSource = TheImportInventoryLocationdDataSet.importinventorylocations;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Inventory Locations // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecord;
bool blnFatalError = false;
try
{
TheImportInventoryDataSet.importinventory.Rows.Clear();
dgrInventory.ItemsSource = TheImportInventoryDataSet.importinventory;
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Import INventory ");
if (blnFatalError == true)
{
throw new Exception();
}
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecord = TheFindPartsWarehouseDataSet.FindPartsWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecord; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehouseDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Inventory // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnSignIn_Click(object sender, RoutedEventArgs e)
{
//setting local variables
string strLastName;
bool blnThereIsAproblem = false;
bool blnFatalError = false;
string strValueForValidation;
string strErrorMessage = "";
int intRecordsReturned;
bool blnOpenSession = false;
TheFindPartsWarehouseDataSet = TheEmployeeClass.FindPartsWarehouses();
try
{
//data validation
strValueForValidation = pbxEmployeeID.Password;
blnThereIsAproblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAproblem == true)
{
blnFatalError = true;
strErrorMessage = strErrorMessage + "The Employee ID is not an Integer\n";
}
else
{
gintEmployeeID = Convert.ToInt32(strValueForValidation);
}
strLastName = txtLastName.Text;
if (strLastName == "")
{
blnFatalError = true;
strErrorMessage = strErrorMessage + "The Last Name Was Not Entered\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
TheVerifyLogonDataSet = TheEmployeeClass.VerifyLogon(gintEmployeeID, strLastName);
intRecordsReturned = TheVerifyLogonDataSet.VerifyLogon.Rows.Count;
if (intRecordsReturned == 0)
{
LogonFailed();
}
else
{
if (TheVerifyLogonDataSet.VerifyLogon[0].EmployeeGroup == "USERS")
{
LogonFailed();
}
else
{
blnOpenSession = CheckForOpenSession();
blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(gintEmployeeID, "ENTER INVENTORY // USER LOGIN");
if (blnFatalError == true)
{
throw new Exception();
}
if (blnOpenSession == false)
{
MainMenu MainMenu = new EnterInventory.MainMenu();
MainMenu.Show();
this.Hide();
}
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Enter Inventory // Main Window // Sign In Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
