private void validatechute(string barcode)
{
decimal chutetype;
// validate chute using oms_attach_trolley.p_validate_chute
this.chuteid.Value = _locatedao.Validate_Chute(barcode, User.Identity.Name, null).ToString();
// find the chute type if it is singles = 1 or multi = 2
chutetype = _locatedao.Get_chute_type(decimal.Parse(this.chuteid.Value));
// If a multi chute
if (chutetype == 2)
{
// *** SG *** this.areaid.Value = _locatedao.Get_Chute_Area(decimal.Parse(this.chuteid.Value)).ToString();
_trolleyid = _locatedao.Chute_Trolley(barcode, User.Identity.Name, null);
this.trolleyid.Value = _trolleyid.ToString();
if (_trolleyid > 0)
{
if (this.ordernumber.Value == string.Empty)
{
//string service = _locatedao.ServiceForLocation(decimal.Parse(this.ordernumber.Value));
}
else
{
ShowMessage("Scan SKU barcode", MessageType.NormalMessage);
}
this.step.Value = RemoveForPackClearupStep.ScanLocation.ToString();
}
else
{
ShowMessage("No Trolley Attached to Chute", MessageType.ErrorConfirm);
}
}
else
{
ShowMessage("Not Multi Item Order Chute", MessageType.ErrorConfirm);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string IsManualSingle = "F";
string chute_label = string.Empty;
this.Master.Reset();
this.Master.RegisterStandardScript = true;
decimal I_chute_id = decimal.Parse(Request.QueryString["chuteID"].ToString());
string I_chute_barcode = Request.QueryString["chutebarcode"].ToString();
string I_user = Request.QueryString["userlogon"].ToString();
decimal I_trolley_id = decimal.Parse(Request.QueryString["trolleyid"].ToString());
decimal I_chute_type = decimal.Parse(Request.QueryString["chutetype"].ToString());
decimal I_chute_area = decimal.Parse(Request.QueryString["chutearea"] == null?"0":Request.QueryString["chutearea"].ToString());
//string I_terminal = this.Master.HostName;
string I_terminal = null;
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
if (!IsPostBack)
{
// on page load display this message
this.Master.MessageBoard = "Scan SKU Barcode";
}
else
{
string sku_barcode = this.Master.BarcodeValue;
if (sku_barcode == string.Empty)
{
this.Master.ErrorMessage = "Invalid Scan. Please scan again";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
else
{
if (sku_barcode.Length > 50)
{
sku_barcode = sku_barcode.Substring(0, 50);
}
LocateDAO locdao = new LocateDAO();
decimal item_id = 0;
string location_name = null;
// the user can either scan a sku or another chute
// check if it is a chute or sku barcode
if (sku_barcode.Length < 2)
{
this.Master.ErrorMessage = "Invalid Barcode";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
else
{
string chk_barcode = sku_barcode.Substring(0, 2).ToUpper();
if (chk_barcode.ToUpper() == "CH")
{
// user has scanned the chute
decimal chute_id = 0;
decimal chute_type = 0;
LocateDAO locdaoch = new LocateDAO();
string chute_barcode = sku_barcode;
string barcodetype_ch = "Chute";
try
{
// logoff user from previous session
/************ commented out for time being ************/
//locdaoch.Log_off_Chute(I_chute_id, I_user);
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.LogOffChuteForLocate;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.Success;
setclass.ExpectedBarcodeType = barcodetype_ch;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = I_user;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
/************ commented out for time being ************/
// validate chute using oms_attach_trolley.p_validate_chute
chute_id = locdaoch.Validate_Chute(chute_barcode, I_user, I_terminal);
// Log user to chute using p_log_on_to_chute
/************ commented out for time being ************/
//locdaoch.Log_on_to_Chute(chute_barcode, I_user);
/************ commented out for time being ************/
// find the chute type if it is singles = 1 or multi = 2
chute_type = locdaoch.Get_chute_type(chute_id);
if (chute_type == 2)
{
I_chute_area = locdao.Get_Chute_Area(chute_id);
}
// find the trolley attached p_chute_trolley
decimal trolley_id_ch = locdaoch.Chute_Trolley(chute_barcode, I_user, I_terminal);
if (trolley_id_ch == 0)
{
// if the trolley id is null then ask user to scan trolley
// redirect to attach trolley
// no trolley attached to chute
if (chute_type == 1) // singles
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + I_user + "&chutetype=" + chute_type + "&chutearea =" + I_chute_area);
}
else if (chute_type == 2) // multi
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + I_user + "&chutetype=" + chute_type + "&chutearea =" + I_chute_area);
}
}
else
{
// trolley is already attached
if (chute_type == 1) // singles
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + I_user + "&chutetype=" + chute_type + "&chutearea =" + I_chute_area);
}
else if (chute_type == 2) // multi
{
// redirect to scan sku
Response.Redirect("LocateScanSku.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + trolley_id_ch + "&chutetype=" + chute_type + "&chutearea =" + I_chute_area);
}
else
{
this.Master.ErrorMessage = "Wrong Chute Type";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
}
}
catch (Exception ex)
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.ScanChuteForAttach;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.ChuteScanFailed;
setclass.ExpectedBarcodeType = barcodetype_ch;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = I_user;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
this.Master.ErrorMessage = ex.Message.Substring(ex.Message.IndexOf(" ", 0), (ex.Message.IndexOf("ORA", 1) - ex.Message.IndexOf(" ", 0)));
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
}
else
{
// user has scanned a SKU
// Validate SKU
// find item using p_find_chute_item
string barcodetype = "SKU";
try
{
item_id = locdao.Find_item(I_chute_id, sku_barcode, I_user, I_terminal, I_chute_area);
if (item_id > 0)
{
IsManualSingle = locdao.OrderForManualArea(I_chute_area, I_chute_id, item_id);
if (IsManualSingle.ToUpper() != "F")
{
string[] T_chute_Val;
T_chute_Val = IsManualSingle.Split('-');
Response.Redirect("LocateManualAreaChute.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&itemid=" + item_id + "&skubarcode=" + sku_barcode + "&chutearea=" + I_chute_area + "&tchutelabel=" + T_chute_Val[1] + "&tchuteid=" + T_chute_Val[0]);
}
}
if (item_id == 0)
{
// if item not found
this.Master.ErrorMessage = "Item not for this chute";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
this.Master.MessageBoard = "Please Scan the SKU Barcode";
}
else
{
// else display trolley location using p_location_name_for_item
location_name = locdao.Find_location_name(item_id);
if (location_name == null)
{
this.Master.ErrorMessage = "Location not found for Item";
this.Master.DisplayMessage = true;
this.Master.MessageBoard = "Scan SKU Barcode";
}
else
{
// display location label
// redirect to scan trolley location
//this.Master.MessageBoard = "location is " + location_name;
Response.Redirect("LocateScanLocation.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&itemid=" + item_id + "&skubarcode=" + sku_barcode + "&locationname=" + location_name + "&chutearea=" + I_chute_area);
}
}
}
catch (Exception ex1)
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.ScanItemForLocate;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.ItemvalidationFailed;
setclass.ExpectedBarcodeType = barcodetype;
setclass.Barcode = sku_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = I_user;
setclass.ChuteId = decimal.ToInt32(I_chute_id);
setclass.TrolleyId = decimal.ToInt32(I_trolley_id);
setclass.ItemNumber = decimal.ToInt32(item_id);
actlog.SaveUserActivity(setclass);
this.Master.ErrorMessage = ex1.Message.Substring(ex1.Message.IndexOf(" ", 0), (ex1.Message.IndexOf("ORA", 1) - ex1.Message.IndexOf(" ", 0)));
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
} // sku
} // barcode length greater than 2
} // barcode not empty
} //end of else
}
protected void Page_Load(object sender, EventArgs e)
{
this.Master.Reset();
this.Master.RegisterStandardScript = true;
string I_message = null;
if (Request.QueryString["message"] != null)
{
I_message = Request.QueryString["message"].ToString();
}
string user_logon = User.Identity.Name;
//string I_terminal = this.Master.HostName; //Shared.UserHostName;
string I_terminal = null;
string barcodetype = "Chute";
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
if (!IsPostBack)
{
if (I_message == "T") // message exists
{
this.Master.MessageBoard = "Trolley is successfully located and detached. Scan next Chute for Locate";
}
else
{
// on page load display this message
this.Master.MessageBoard = "Scan Chute for Locate";
}
}
else
{
string chute_barcode = this.Master.BarcodeValue;
if (chute_barcode != string.Empty)
{
if (chute_barcode.Length > 50)
{
chute_barcode = chute_barcode.Substring(0, 50);
}
}
decimal chute_id = 0;
decimal chute_type = 0;
decimal chute_area = 0;
LocateDAO locdao = new LocateDAO();
try
{
// validate chute using oms_attach_trolley.p_validate_chute
chute_id = locdao.Validate_Chute(chute_barcode, user_logon, I_terminal);
// find the chute type if it is singles = 1 or multi = 2
chute_type = locdao.Get_chute_type(chute_id);
if (chute_type == 2)
{
chute_area = locdao.Get_Chute_Area(chute_id);
}
}
catch (Exception ex)
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.ScanChuteForAttach;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.ChuteScanFailed;
setclass.ExpectedBarcodeType = barcodetype;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = user_logon;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
//this.Master.MessageBoard = chute_id.ToString();
this.Master.ErrorMessage = ex.Message.Substring(ex.Message.IndexOf(" ", 0), (ex.Message.IndexOf("ORA", 1) - ex.Message.IndexOf(" ", 0)));
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
try
{
// find the trolley attached p_chute_trolley
decimal trolley_id = locdao.Chute_Trolley(chute_barcode, user_logon, I_terminal);
if (trolley_id == 0)
{
// if the trolley id is null then ask user to scan trolley
// redirect to attach trolley
// no trolley attached to chute
if (chute_type == 1) // singles
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + user_logon + "&chutetype=" + chute_type + "&chutearea=" + chute_area);
}
else if (chute_type == 2) // multi
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + user_logon + "&chutetype=" + chute_type + "&chutearea=" + chute_area);
}
else
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.LogOnChuteForLocate;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.InvalidChuteType;
setclass.ExpectedBarcodeType = barcodetype;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = user_logon;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
// end of activity logging
this.Master.ErrorMessage = "Please enter either Chute Type: Single or Chute Type: Multi";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
}
else
{
// trolley is already attached
if (chute_type == 1) // singles
{
// redirect to scan trolley page
Response.Redirect("LocateTrolleyAttach.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + user_logon + "&chutetype=" + chute_type + "&chutearea=" + chute_area);
}
else if (chute_type == 2) // multi
{
// redirect to scan sku
// Log user to chute using p_log_on_to_chute
// ************ commented out for time being ************ /
//locdao.Log_on_to_Chute(chute_barcode, user_logon);
// ************ commented out for time being ************ /
Response.Redirect("LocateScanSku.aspx?chuteID=" + chute_id + "&chutebarcode=" + chute_barcode + "&userlogon=" + user_logon + "&trolleyid=" + trolley_id + "&chutetype=" + chute_type + "&chutearea=" + chute_area);
}
else
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.LogOnChuteForLocate;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.InvalidChuteType;
setclass.ExpectedBarcodeType = barcodetype;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = user_logon;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
// end of activity logging
this.Master.ErrorMessage = "Please enter either Chute Type: Single or Chute Type: Multi";
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
}
}
catch (Exception ex1)
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate;
setclass.EventType = (Int32)EventType.LogOnChuteForLocate;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.LogonFailed;
setclass.ExpectedBarcodeType = barcodetype;
setclass.Barcode = chute_barcode;
setclass.TerminalId = I_terminal;
setclass.UserId = user_logon;
setclass.ChuteId = decimal.ToInt32(chute_id);
actlog.SaveUserActivity(setclass);
// end of activity logging
this.Master.ErrorMessage = ex1.Message.Substring(ex1.Message.IndexOf(" ", 0), (ex1.Message.IndexOf("ORA", 1) - ex1.Message.IndexOf(" ", 0)));
this.Master.DisplayMessage = true;
this.Master.BarcodeValue = string.Empty;
}
}
}