private void ChooseAddress_Load(object sender, EventArgs e)
{
uxCBAisle.SelectedIndex = 0;
uxCBShelf.SelectedIndex = 0;
uxCBSubshelf.SelectedIndex = 0;
try
{
dsPhysicalInventory = new DataSetPhysicalInventory();
cache.AddObject(CacheAddress.PhysicalInventoryData, dsPhysicalInventory);
taWarehouseInventory = new WarehouseInventoryTableAdapter();
taWarehouseLocations = new WarehouseLocationsTableAdapter();
taPhysicalProgress = new PhysicalProgressTableAdapter();
taPhysicalProgressSummary = new PhysicalProgressSummaryTableAdapter();
taEmployee = new EmployeeTableAdapter();
cache.AddObject(CacheAddress.WarehouseInventoryTableAdapter, taWarehouseInventory);
cache.AddObject(CacheAddress.WarehouseLocationsTableAdapter, taWarehouseLocations);
cache.AddObject(CacheAddress.PhysicalProgressTableAdapter, taPhysicalProgress);
cache.AddObject(CacheAddress.PhysicalProgressSummaryTableAdapter, taPhysicalProgressSummary);
cache.AddObject(CacheAddress.EmployeeTableAdapter, taEmployee);
cache.AddObject(CacheAddress.BeginPhysicalAisle, BeginPhysicalAisle);
cache.AddObject(CacheAddress.BeginPhysicalShelf, BeginPhysicalShelf);
cache.AddObject(CacheAddress.BeginPhysicalSubshelf, BeginPhysicalSubshelf);
taWarehouseLocations.Fill(dsPhysicalInventory.WarehouseLocations);
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
}
private void uxButtonContinuePhysical_Click(object sender, EventArgs e)
{
try
{
DataSetPhysicalInventory dsPhysicalInventory = (DataSetPhysicalInventory)cache.RetrieveObject(CacheAddress.PhysicalInventoryData);
EmployeeTableAdapter taEmployee = (EmployeeTableAdapter)cache.RetrieveObject(CacheAddress.EmployeeTableAdapter);
taEmployee.Fill(dsPhysicalInventory.Employee, uxTextBoxPassword.Text);
string OperatorCode;
Exception ex = null;
switch (dsPhysicalInventory.Employee.Rows.Count)
{
case 1:
OperatorCode = dsPhysicalInventory.Employee[0].OperatorCode;
break;
case 0:
ex = new Exception("Invalid password.");
uxTextBoxPassword.Focus();
throw ex;
default:
ex = new Exception("Unknown error validating password.");
uxTextBoxPassword.Focus();
throw ex;
}
PhysicalProgressTableAdapter taPhysicalProgressTableAdapter = (PhysicalProgressTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressTableAdapter);
BeginPhysicalAisle = uxCBAisle.Text;
BeginPhysicalShelf = Int32.Parse(uxCBShelf.Text);
BeginPhysicalSubshelf = Int32.Parse(uxCBSubshelf.Text);
cache.RemoveObject(CacheAddress.BeginPhysicalAisle);
cache.RemoveObject(CacheAddress.BeginPhysicalShelf);
cache.RemoveObject(CacheAddress.BeginPhysicalSubshelf);
cache.AddObject(CacheAddress.BeginPhysicalAisle, BeginPhysicalAisle);
cache.AddObject(CacheAddress.BeginPhysicalShelf, BeginPhysicalShelf);
cache.AddObject(CacheAddress.BeginPhysicalSubshelf, BeginPhysicalSubshelf);
// Continue cycle count for specified address.
taPhysicalProgressTableAdapter.Fill(dsPhysicalInventory.PhysicalProgress, BeginPhysicalAisle, BeginPhysicalShelf, BeginPhysicalSubshelf);
cache.AddObject(CacheAddress.PhysicalInventoryData, dsPhysicalInventory);
Application.Run(new frmScanToLocation());
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
catch (Exception ex)
{
// Getting exception when loading frmScanToLocation.
//MessageBox.Show (ex.Message);
}
}
private void frmScanToLocation_Load(object sender, EventArgs e)
{
try
{
MyRFGun = new SymbolRFGun.SymbolRFGun();
MyRFGun.RFScan += new RFScanEventHandler(MyRFGun_RFScan);
}
catch (SymbolRFGunException ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
try
{
//Select Device from device list
Symbol.Audio.Device MyDevice = (Symbol.Audio.Device)Symbol.StandardForms.SelectDevice.Select(
Symbol.Audio.Controller.Title,
Symbol.Audio.Device.AvailableDevices);
if (MyDevice == null)
{
MessageBox.Show("No Device Selected", "SelectDevice");
//close the form
this.Close();
return;
}
//check the device type
switch (MyDevice.AudioType)
{
//if standard device
case Symbol.Audio.AudioType.StandardAudio:
MyAudioController = new Symbol.Audio.StandardAudio(MyDevice);
break;
//if simulated device
case Symbol.Audio.AudioType.SimulatedAudio:
MyAudioController = new Symbol.Audio.SimulatedAudio(MyDevice);
break;
default:
throw new Symbol.Exceptions.InvalidDataTypeException("Unknown Device Type");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Exception ex = null;
dsPhysicalInventory = (DataSetPhysicalInventory)cache.RetrieveObject(CacheAddress.PhysicalInventoryData);
taEmployee = (EmployeeTableAdapter)cache.RetrieveObject(CacheAddress.EmployeeTableAdapter);
taPhysicalProgress = (PhysicalProgressTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressTableAdapter);
taPhysicalProgressSummary = (PhysicalProgressSummaryTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressSummaryTableAdapter);
taWarehouseInventory = (WarehouseInventoryTableAdapter)cache.RetrieveObject(CacheAddress.WarehouseInventoryTableAdapter);
switch (dsPhysicalInventory.Employee.Rows.Count)
{
case 1:
OperatorCode = dsPhysicalInventory.Employee[0].OperatorCode;
uxLabelOperatorCode.Text = OperatorCode;
break;
case 0:
ex = new Exception("Invalid password.");
throw ex;
default:
ex = new Exception("Unknown error validating password.");
throw ex;
}
PutAwayAisle = (string)cache.RetrieveObject(CacheAddress.BeginPhysicalAisle);
BeginPhysicalShelf = (Int32)cache.RetrieveObject(CacheAddress.BeginPhysicalShelf);
BeginPhysicalSubshelf = (Int32)cache.RetrieveObject(CacheAddress.BeginPhysicalSubshelf);
uxCBAisle.Items.Add(PutAwayAisle);
uxCBAisle.SelectedIndex = 0;
if (BeginPhysicalShelf == 0)
{
uxCBShelf.Items.Add("1");
uxCBShelf.Items.Add("2");
uxCBShelf.Items.Add("3");
uxCBShelf.Items.Add("4");
PutAwayShelf = 1;
}
else
{
uxCBShelf.Items.Add(BeginPhysicalShelf.ToString());
PutAwayShelf = BeginPhysicalShelf;
}
uxCBShelf.SelectedIndex = 0;
if (BeginPhysicalSubshelf == 0)
{
uxCBSubshelf.Items.Add("1");
uxCBSubshelf.Items.Add("2");
uxCBSubshelf.Items.Add("3");
uxCBSubshelf.Items.Add("4");
uxCBSubshelf.Items.Add("5");
uxCBSubshelf.Items.Add("6");
uxCBSubshelf.Items.Add("7");
uxCBSubshelf.Items.Add("8");
uxCBSubshelf.Items.Add("9");
uxCBSubshelf.Items.Add("10");
uxCBSubshelf.Items.Add("11");
uxCBSubshelf.Items.Add("12");
PutAwaySubshelf = 1;
}
else
{
uxCBSubshelf.Items.Add(BeginPhysicalSubshelf.ToString());
PutAwaySubshelf = BeginPhysicalSubshelf;
}
uxCBSubshelf.SelectedIndex = 0;
RefreshProgress();
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void uxButtonBeginPhysical_Click(object sender, EventArgs e)
{
try
{
DataSetPhysicalInventory dsPhysicalInventory = (DataSetPhysicalInventory)cache.RetrieveObject(CacheAddress.PhysicalInventoryData);
EmployeeTableAdapter taEmployee = (EmployeeTableAdapter)cache.RetrieveObject(CacheAddress.EmployeeTableAdapter);
taEmployee.Fill(dsPhysicalInventory.Employee, uxTextBoxPassword.Text);
string OperatorCode;
Exception ex = null;
switch (dsPhysicalInventory.Employee.Rows.Count)
{
case 1:
OperatorCode = dsPhysicalInventory.Employee [0].OperatorCode;
break;
case 0:
ex = new Exception("Invalid password.");
uxTextBoxPassword.Focus();
throw ex;
default:
ex = new Exception("Unknown error validating password.");
uxTextBoxPassword.Focus();
throw ex;
}
PhysicalProgressTableAdapter taPhysicalProgressTableAdapter = (PhysicalProgressTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressTableAdapter);
BeginPhysicalAisle = uxCBAisle.Text;
BeginPhysicalShelf = Int32.Parse(uxCBShelf.Text);
BeginPhysicalSubshelf = Int32.Parse(uxCBSubshelf.Text);
// Validate before continuing.
string ValidationMessage = OperatorCode + " will initiate a cycle count on aisle " + BeginPhysicalAisle;
if (BeginPhysicalShelf == 0)
{
ValidationMessage += " all shelves and";
}
else
{
ValidationMessage += " shelf " + BeginPhysicalShelf.ToString() + " and";
}
if (BeginPhysicalSubshelf == 0)
{
ValidationMessage += " all positions.";
}
else
{
ValidationMessage += " position " + BeginPhysicalSubshelf.ToString() + ".";
}
if (MessageBox.Show(ValidationMessage, "Confirmation",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel)
{
ex = new Exception("Operation cancelled.");
uxCBAisle.Focus();
throw ex;
}
cache.RemoveObject(CacheAddress.BeginPhysicalAisle);
cache.RemoveObject(CacheAddress.BeginPhysicalShelf);
cache.RemoveObject(CacheAddress.BeginPhysicalSubshelf);
cache.AddObject(CacheAddress.BeginPhysicalAisle, BeginPhysicalAisle);
cache.AddObject(CacheAddress.BeginPhysicalShelf, BeginPhysicalShelf);
cache.AddObject(CacheAddress.BeginPhysicalSubshelf, BeginPhysicalSubshelf);
// Begin cycle count for specified address.
Int32 Result;
taPhysicalProgressTableAdapter.BeginPhysical_ByAddress(OperatorCode, BeginPhysicalAisle, BeginPhysicalShelf, BeginPhysicalSubshelf, out Result);
taPhysicalProgressTableAdapter.Fill(dsPhysicalInventory.PhysicalProgress, BeginPhysicalAisle, BeginPhysicalShelf, BeginPhysicalSubshelf);
cache.AddObject(CacheAddress.PhysicalInventoryData, dsPhysicalInventory);
Application.Run(new frmScanToLocation());
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
catch (Exception ex)
{
// Getting exception when loading frmScanToLocation.
//MessageBox.Show (ex.Message);
}
}
