private void ResetControls()
{
//setting back to default
TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName("");
TheImportITAssetsDataSet.importitassets.Rows.Clear();
dgrAssets.ItemsSource = TheImportITAssetsDataSet.importitassets;
}
public FindWarehouseByWarehouseNameDataSet FindWarehouseByWarehouseName(string strWarehouseName)
{
try
{
aFindWarehouseByWarehouseNameDataSet = new FindWarehouseByWarehouseNameDataSet();
aFindWarehouseByWarehouseNameTableAdapter = new FindWarehouseByWarehouseNameDataSetTableAdapters.FindWarehouseByWarehouseNameTableAdapter();
aFindWarehouseByWarehouseNameTableAdapter.Fill(aFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName, strWarehouseName);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Warehouse By Warehouse Name " + Ex.Message);
}
return(aFindWarehouseByWarehouseNameDataSet);
}
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;
int intAssetID;
string strAssetID;
string strAssetDescription;
string strAssetType;
string strSite;
string strLocation;
string strSerialNumber;
string strManufacturer;
string strModel;
int intRecordsReturned;
bool blnItemFound;
int intWarehouseID;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
expImportExcel.IsExpanded = false;
TheImportWASPITAssetsDataSet.importassets.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;
}
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 = 2; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strAssetID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
intAssetID = Convert.ToInt32(strAssetID);
strAssetDescription = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
strAssetType = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
strSite = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
strLocation = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
strSerialNumber = Convert.ToString((range.Cells[intCounter, 13] as Excel.Range).Value2).ToUpper();
strManufacturer = Convert.ToString((range.Cells[intCounter, 15] as Excel.Range).Value2).ToUpper();
strModel = Convert.ToString((range.Cells[intCounter, 16] as Excel.Range).Value2).ToUpper();
if (strSite == "GROVEPORT")
{
strSite = "CBUS-GROVEPORT";
}
TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strSite);
intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID;
TheFindWASPAssetByAssetIDDataSet = TheAssetClass.FindWaspAssetByAssetID(intAssetID);
intRecordsReturned = TheFindWASPAssetByAssetIDDataSet.FindWaspAssetByAssetID.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
else if (intRecordsReturned < 1)
{
TheFindWaspAssetsBySerialNumberDataSet = TheAssetClass.FindWaspAssetsBySerialNumber(strSerialNumber);
intRecordsReturned = TheFindWaspAssetsBySerialNumberDataSet.FindWaspAssetsBySerialNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
}
if (blnItemFound == false)
{
ImportWASPITAssetsDataSet.importassetsRow NewAssetRow = TheImportWASPITAssetsDataSet.importassets.NewimportassetsRow();
NewAssetRow.AssetDescription = strAssetDescription;
NewAssetRow.AssetID = intAssetID;
NewAssetRow.AssetType = strAssetType;
NewAssetRow.Location = strLocation;
NewAssetRow.Manufacturer = strManufacturer;
NewAssetRow.Model = strModel;
NewAssetRow.SerialNumber = strSerialNumber;
NewAssetRow.Site = strSite;
NewAssetRow.WarehouseID = intWarehouseID;
TheImportWASPITAssetsDataSet.importassets.Rows.Add(NewAssetRow);
}
}
dgrITAssets.ItemsSource = TheImportWASPITAssetsDataSet.importassets;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Wasp IT Assets // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
private void ChangeVehicleInYardToWarehouse()
{
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
int intCounter;
int intNumberOfRecords;
int intVehicleID;
int intWarehouseID;
int intTransactionID;
string strWarehouse;
bool blnFatalError = false;
try
{
datStartDate = TheDateSearchClass.RemoveTime(datStartDate);
datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1);
TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardShowingVehicleIDDateRange(datStartDate, datEndDate);
intNumberOfRecords = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange.Rows.Count - 1;
if(intNumberOfRecords > -1)
{
for(intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intVehicleID = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange[intCounter].VehicleID;
strWarehouse = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange[intCounter].AssignedOffice;
TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strWarehouse);
intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID;
TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID);
intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID;
blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false);
if (blnFatalError == true)
throw new Exception();
blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(intVehicleID, intWarehouseID);
if (blnFatalError == true)
throw new Exception();
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(intVehicleID, intWarehouseID);
if (blnFatalError == true)
throw new Exception();
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Main Window // Change Vehicle In Yard To Warehouse " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting up local variables
DateTime datTransactionDate = DateTime.Now;
int intNumberOfRecords;
int intCounter;
int intTransactionID;
int intAssetID;
bool blnFatalError = false;
string strSite;
try
{
TheWaspAssetIDDataSet = TheAssetClass.GetWaspAssetIDInfo();
chkIsTool.IsChecked = false;
intAssetID = TheWaspAssetIDDataSet.waspassetid[0].CreatedAssetID;
intTransactionID = TheWaspAssetIDDataSet.waspassetid[0].TransactionID;
MainWindow.gintAssetID = intAssetID;
intAssetID++;
txtAssetID.Text = Convert.ToString(MainWindow.gintAssetID);
txtDate.Text = Convert.ToString(datTransactionDate);
blnFatalError = TheAssetClass.UpdateWaspAssetID(intTransactionID, intAssetID);
txtLocation.Text = MainWindow.gstrAssetLocation;
TheFindWaspAssetLocationByLoctionDataSet = TheAssetClass.FindWaspAssetLocationByLocation(MainWindow.gstrAssetLocation);
strSite = TheFindWaspAssetLocationByLoctionDataSet.FindWaspAssetLocationByLocation[0].AssetSite;
txtSite.Text = strSite;
if (strSite == "GROVEPORT")
{
strSite = "CBUS-GROVEPORT";
}
TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strSite);
MainWindow.gintWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID;
txtWarehouseID.Text = Convert.ToString(MainWindow.gintWarehouseID);
TheFindSortedToolCategoryDataSet = TheToolCategoryClass.FindSortedToolCategory();
cboAssetCategory.Items.Add("Select Category");
intNumberOfRecords = TheFindSortedToolCategoryDataSet.FindSortedToolCategory.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboAssetCategory.Items.Add(TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intCounter].ToolCategory);
}
cboAssetCategory.SelectedIndex = 0;
txtSerialNo.Text = "UNKNOWN";
txtModel.Text = "UNKNOWN";
txtManufacturer.Text = "UNKNOWN";
}
catch (Exception Ex)
{
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Wasp Asset // Window Loaded Method " + Ex.Message);
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Wasp Asset // Window Loaded Method " + 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;
int intVehicleID = 0;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
string strItemID;
int intItemID = 0;
string strItem;
string strManufacturer;
string strModel;
string strSerialNumber;
string strQuantity;
int intQuantity = 0;
string strWarehouse;
string strAssetNotes;
bool blnFatalError = false;
int intWarehouseID;
try
{
TheImportITAssetsDataSet.importitassets.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++)
{
strItemID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
blnFatalError = TheDataValidationClass.VerifyIntegerData(strItemID);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Item ID is not Numeric at Count " + Convert.ToString(intCounter));
return;
}
else
{
intItemID = Convert.ToInt32(strItemID);
}
strItem = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
strManufacturer = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
strModel = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
strSerialNumber = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
strQuantity = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
blnFatalError = TheDataValidationClass.VerifyIntegerData(strQuantity);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Quantity is not Numeric");
return;
}
else
{
intQuantity = Convert.ToInt32(strQuantity);
}
strWarehouse = Convert.ToString((range.Cells[intCounter, 7] as Excel.Range).Value2).ToUpper();
TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strWarehouse);
intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID;
strAssetNotes = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper();
ImportITAssetsDataSet.importitassetsRow NewItAsset = TheImportITAssetsDataSet.importitassets.NewimportitassetsRow();
NewItAsset.Item = strItem;
NewItAsset.ItemID = intItemID;
NewItAsset.Location = strWarehouse;
NewItAsset.Manufacturer = strManufacturer;
NewItAsset.Model = strModel;
NewItAsset.Notes = strAssetNotes;
NewItAsset.Quantity = intQuantity;
NewItAsset.SerialNumber = strSerialNumber;
NewItAsset.WarehouseID = intWarehouseID;
TheImportITAssetsDataSet.importitassets.Rows.Add(NewItAsset);
}
dgrAssets.ItemsSource = TheImportITAssetsDataSet.importitassets;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import IT Assets // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
