private void ResetControls()
{
txtEnterItem.Text = "";
TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber("f**k you asshole");
dgrResults.ItemsSource = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber;
}
private void BtnFind_Click(object sender, RoutedEventArgs e)
{
int intRecordsReturned;
string strItem;
try
{
strItem = txtEnterItem.Text;
if (strItem == "")
{
TheMessagesClass.ErrorMessage("The Item Or Serial Number Were\nNot Entered");
return;
}
TheFindITAssetBySerialNumber = TheITAssetClass.FindITAssetBySerialNumber(strItem);
intRecordsReturned = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber.Rows.Count;
if (intRecordsReturned == 1)
{
txtHomeOffice.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].HomeOffice;
txtItem.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Item;
txtManufacturer.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Manufacturer;
txtModel.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Model;
txtSerialNumber.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].SerialNumber;
gintItemID = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].ItemID;
}
else
{
TheFindITAssetsByItemDataSet = TheITAssetClass.FindITAssetsByItem(strItem);
intRecordsReturned = TheFindITAssetsByItemDataSet.FindITAssetByItem.Rows.Count;
if (intRecordsReturned == 1)
{
txtHomeOffice.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].HomeOffice;
txtItem.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Item;
txtManufacturer.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Manufacturer;
txtModel.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Model;
txtSerialNumber.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].SerialNumber;
gintItemID = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].ItemID;
}
else
{
TheMessagesClass.ErrorMessage("Asset not Found or Be More specific");
return;
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Sign Out IT Asset // Find Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindITAssetBySerialNumberDataSet FindITAssetBySerialNumber(string strSerialNumber)
{
try
{
aFindITAssetBySerialNumberDataSet = new FindITAssetBySerialNumberDataSet();
aFindITAssetBySerialNumberTableAdapter = new FindITAssetBySerialNumberDataSetTableAdapters.FindITAssetBySerialNumberTableAdapter();
aFindITAssetBySerialNumberTableAdapter.Fill(aFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber, strSerialNumber);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "IT Asset Class // Find IT Asset By Serial Number " + Ex.Message);
}
return(aFindITAssetBySerialNumberDataSet);
}
private void BtnFind_Click(object sender, RoutedEventArgs e)
{
string strSerialNumber;
int intRecordsReturned;
try
{
strSerialNumber = txtEnterSerialNumber.Text;
if (strSerialNumber == "")
{
TheMessagesClass.ErrorMessage("Serial Number Was Not Entered");
return;
}
TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber);
intRecordsReturned = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("The Serial Number was not Found");
return;
}
//loading controls
gintItemID = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].ItemID;
txtItemID.Text = Convert.ToString(gintItemID);
txtItem.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Item;
txtManufacturer.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Manufacturer;
txtModel.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Model;
txtHomeOffice.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].HomeOffice;
mitProcess.IsEnabled = true;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Retire IT Assets // Find Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void TxtEnterItem_TextChanged(object sender, TextChangedEventArgs e)
{
string strSerialNumber;
int intLength;
int intRecordsReturned;
strSerialNumber = txtEnterItem.Text;
intLength = strSerialNumber.Length;
if (intLength > 4)
{
TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber);
intRecordsReturned = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheFindITAssetsByItemDataSet = TheITAssetsClass.FindITAssetsByItem(strSerialNumber);
intRecordsReturned = TheFindITAssetsByItemDataSet.FindITAssetByItem.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("No Records Found");
return;
}
dgrResults.ItemsSource = TheFindITAssetsByItemDataSet.FindITAssetByItem;
}
else
{
dgrResults.ItemsSource = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber;
}
}
}
private void expProcessImport_Expanded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
int intItemID;
string strItem;
string strManufacturer;
string strModel;
string strSerialNumber;
int intQuantity;
decimal decValue = 0;
string strUpgrades = "NONE";
int intWarehouseID;
int intRecordsReturned;
try
{
intNumberOfRecords = TheImportITAssetsDataSet.importitassets.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
intItemID = TheImportITAssetsDataSet.importitassets[intCounter].ItemID;
strItem = TheImportITAssetsDataSet.importitassets[intCounter].Item;
strManufacturer = TheImportITAssetsDataSet.importitassets[intCounter].Manufacturer;
strModel = TheImportITAssetsDataSet.importitassets[intCounter].Model;
strSerialNumber = TheImportITAssetsDataSet.importitassets[intCounter].SerialNumber;
intQuantity = TheImportITAssetsDataSet.importitassets[intCounter].Quantity;
intWarehouseID = TheImportITAssetsDataSet.importitassets[intCounter].WarehouseID;
if (intItemID > 1000)
{
blnFatalError = TheITAssetsClass.UpdateITAssetLocation(intItemID, intWarehouseID);
if (blnFatalError == true)
{
throw new Exception();
}
}
else
{
TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber);
intRecordsReturned = TheFindITAssetByItemIDDataSet.FindITAssetByItemID.Rows.Count;
if (intRecordsReturned > 0)
{
blnFatalError = TheITAssetsClass.UpdateITAssetLocation(intItemID, intWarehouseID);
if (blnFatalError == true)
{
throw new Exception();
}
}
else if (intRecordsReturned < 1)
{
blnFatalError = TheITAssetsClass.InsertITAsset(strItem, strManufacturer, strModel, strSerialNumber, intQuantity, decValue, strUpgrades, intWarehouseID);
if (blnFatalError == true)
{
throw new Exception();
}
}
}
}
TheMessagesClass.InformationMessage("The Records have been Updated");
ResetControls();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import IT Assets // Process Import Expander " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
