protected void Page_Load(object sender, EventArgs e) { 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_item = decimal.Parse(Request.QueryString["itemid"].ToString()); string I_sku_barcode = Request.QueryString["skubarcode"].ToString(); string I_label = Request.QueryString["locationname"].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; //this.Master.MessageBoard = "location is " + I_label; // on page load display this message // split the label string UserActivity setclass = new UserActivity(); ActivityLogDAO actlog = new ActivityLogDAO(); string barcodetype_sku = "SKU"; try { string[] labels = I_label.Split('.'); List <string> labelname = new List <string>(); foreach (string label in labels) { labelname.Add(label); } StringBuilder sb = new StringBuilder(); if (!String.IsNullOrEmpty(labelname[0])) { if (!String.IsNullOrEmpty(labelname[1])) { sb.Append("<div>"); sb.Append("<table width='100%' cellspacing='0px' cellpadding='0px' style='border-width:1px;border-collapse:collapse; border-style:solid;border-color:White;'>"); sb.Append("<tr>"); sb.Append("<td style='font-size:20px;padding-left:2px;border-width:2px;border-style:solid;border-color:White;'>" + labelname[0] + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td style='padding-left:2px;border-width:2px;border-style:solid;border-color:White;'>" + labelname[1] + "</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</div>"); } else { sb.Append("<div>"); sb.Append("<table width='100%' cellspacing='0px' cellpadding='0px' style='border-width:1px;border-collapse:collapse; border-style:solid;border-color:White;'>"); sb.Append("<tr>"); sb.Append("<td style='font-size:24px;padding-left:2px;border-width:2px;border-style:solid;border-color:White;'>" + labelname[0] + "</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</div>"); } } this.Master.MessageBoard = sb.ToString(); } 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.ScanItemForLocate; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.ItemvalidationFailed; setclass.ExpectedBarcodeType = barcodetype_sku; setclass.Barcode = I_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(I_item); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = "Error: Retrieving location name failed"; this.Master.DisplayMessage = true; // redirect to scan sku ??????????? Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&chutearea=" + I_chute_area); } if (IsPostBack) { string loc_barcode = this.Master.BarcodeValue; if (loc_barcode == string.Empty) { this.Master.ErrorMessage = "Invalid Scan. Please scan again"; this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } else { if (loc_barcode.Length > 50) { loc_barcode = loc_barcode.Substring(0, 50); } LocateDAO locdao = new LocateDAO(); // user scans trolley location or overflow tote // validate if it is a trolley location or overflow tote // prevalidate the location barcode string loc_chk = loc_barcode.Substring(0, 2).ToString(); string barcode_loc = "Location"; decimal loc_id = 0; try { loc_id = locdao.PreValidateLocation(loc_barcode); } catch (Exception ex3) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.ScanLocation; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.LocationValidationFailed; setclass.ExpectedBarcodeType = barcode_loc; setclass.Barcode = loc_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = ex3.Message.Substring(ex3.Message.IndexOf(" ", 0), (ex3.Message.IndexOf("ORA", 1) - ex3.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } if (loc_chk.ToUpper() == "LC") { try { // if it is trolley location then validate using p_valid_location decimal tr_loc = locdao.Validate_Location(loc_barcode, I_item, I_user, I_terminal); if (tr_loc == 0) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.ScanLocation; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.LocationValidationFailed; setclass.ExpectedBarcodeType = barcode_loc; setclass.Barcode = loc_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); // if location is invalid then error this.Master.ErrorMessage = "Error: Location Validation Failed"; this.Master.DisplayMessage = true; } else { // else locate item using p_locate_item string detached_ind = locdao.Locate_item(I_item, tr_loc, I_user, I_terminal); if (!String.IsNullOrEmpty(detached_ind)) { if (detached_ind == "F") { // redirect to scan sku for scanning another sku or chute Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&chutearea=" + I_chute_area); } else if (detached_ind == "T") { // log off user //locdao.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 = "Chute"; setclass.Barcode = I_chute_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); setclass.SessionEndDateTime = DateTime.Now; actlog.SaveUserActivity(setclass); // locate main screen Response.Redirect("Locate.aspx?message=" + "T"); //this.Master.BarcodeValue = string.Empty; //this.Master.SuccessMessage = "Trolley is successfully located and detached"; //this.Master.DisplayMessage = true; } } } } catch (Exception ex2) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.LocateItem; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.FailedToLocate; setclass.ExpectedBarcodeType = barcode_loc; setclass.Barcode = loc_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = ex2.Message.Substring(ex2.Message.IndexOf(" ", 0), (ex2.Message.IndexOf("ORA", 1) - ex2.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } } else if (loc_chk.ToUpper() == "OT") { string barcode_ot = "Overflow Tote"; try { // if it is OT location then validate using p_valid_location decimal ot_loc = locdao.Validate_Tote(loc_barcode, I_item, I_user, I_terminal); if (ot_loc == 0) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.ScanOFTForAttach; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.OFTValidationFailed; setclass.ExpectedBarcodeType = barcode_ot; setclass.Barcode = loc_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); // if location is invalid then error this.Master.ErrorMessage = "Error: While validating Overflow Tote Location Location"; this.Master.DisplayMessage = true; } else { // else locate item using p_locate_item // debug........... //this.Master.MessageBoard = "item is:" + I_item + "ot loc is:" + ot_loc + "user is:" + I_user + "trolley id is" + I_trolley_id; string detached_ind = locdao.Locate_tote_item(I_item, ot_loc, I_user, I_trolley_id, I_terminal); if (!String.IsNullOrEmpty(detached_ind)) { if (detached_ind == "F") { // redirect to scan sku for scanning another sku or chute Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&chutearea=" + I_chute_area); } else if (detached_ind == "T") { // log off user //locdao.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 = "Chute"; setclass.Barcode = I_chute_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); setclass.SessionEndDateTime = DateTime.Now; actlog.SaveUserActivity(setclass); // end of log off // locate main screen Response.Redirect("Locate.aspx?message=" + "T"); //this.Master.BarcodeValue = string.Empty; //this.Master.SuccessMessage = "Trolley is successfully located and detached"; //this.Master.DisplayMessage = true; } } } } 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.LocateItem; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.FailedToLocateInOT; setclass.ExpectedBarcodeType = barcode_ot; setclass.Barcode = loc_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.TrolleyLocationId = decimal.ToInt32(loc_id); setclass.ItemNumber = decimal.ToInt32(I_item); 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; } } } }//end of postback }
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; if (!IsPostBack) { { // on page load display this message ShowMessage("Scan Chute", MessageType.NormalMessage); this.step.Value = RemoveForPackStep.Initial.ToString(); } } else { _barcode = (this.Master.BarcodeValue.Length > 50) ? this.Master.BarcodeValue.Substring(0, 50) : this.Master.BarcodeValue; if (_barcode != string.Empty) { _barcode = _barcode.ToUpper(); switch (this.step.Value) { // Initial - scan chute to attach to chute case "Initial": { /* Scan Chute and attach to chute for session */ try { validatechute(_barcode); string itemsInChute = "F"; _removepackdao.itemsinchute(decimal.Parse(this.chuteid.Value), ref itemsInChute); if (itemsInChute == "F") { ShowMessage("No orders for this chute, please scan another chute", MessageType.NormalMessage); this.step.Value = RemoveForPackStep.Initial.ToString(); } else { this.Master.MessageBoard = "Scan SKU barcode"; this.step.Value = RemoveForPackStep.ScanSku.ToString(); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } break; } case "ScanSku": { // If a chute bacode has been scanned if (_barcode.Substring(0, 2) == "CH") { this.step.Value = RemoveForPackStep.Initial.ToString(); validatechute(_barcode); string itemsInChute = "F"; _removepackdao.itemsinchute(decimal.Parse(this.chuteid.Value), ref itemsInChute); if (itemsInChute == "F") { ShowMessage("No orders for this chute, please scan another chute", MessageType.NormalMessage); this.step.Value = RemoveForPackStep.Initial.ToString(); } else { this.Master.MessageBoard = "Scan SKU barcode"; this.step.Value = RemoveForPackStep.ScanSku.ToString(); } } else { try { itemid.Value = _locatedao.Find_item(decimal.Parse(this.chuteid.Value), _barcode, User.Identity.Name, string.Empty, decimal.Parse(this.areaid.Value)).ToString(); if (decimal.Parse(itemid.Value) > 0) { this.singleschutelabel.Value = string.Empty; this.singleschuteid.Value = string.Empty; string IsManualSingle = "F"; IsManualSingle = _locatedao.OrderForManualArea(decimal.Parse(this.areaid.Value), decimal.Parse(this.chuteid.Value), decimal.Parse(itemid.Value)); if (IsManualSingle.ToUpper() != "F") { string[] singleschuteval; singleschuteval = IsManualSingle.Split('-'); this.singleschuteid.Value = singleschuteval[0]; this.singleschutelabel.Value = singleschuteval[1]; this.step.Value = RemoveForPackStep.ScanSinglesChute.ToString(); string msg = "Scan " + singleschuteval[1]; ShowMessage(msg, MessageType.NormalMessage); } else { try { string location_name = _locatedao.Find_location_name(decimal.Parse(itemid.Value)); if (location_name == null) { ShowMessage("Location not found for Item", MessageType.ErrorConfirm); this.Master.MessageBoard = "Scan SKU Barcode"; } try { // if last item then pre-warn user to remove the order decimal itemCount = 0; _removepackdao.itemsnotlocated(decimal.Parse(itemid.Value), ref itemCount); string removeOrderStr = ""; if (itemCount < 2) { removeOrderStr = ", then remove order"; } string locstr = LocationMessage(location_name, removeOrderStr); // if (itemCount < 2) locstr += ", then remove order"; this.step.Value = RemoveForPackStep.ScanLocation.ToString(); ShowMessage(locstr, MessageType.NormalMessage); } catch { ShowMessage("Error getting location details", MessageType.ErrorConfirm); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } } else { if (itemid.Value == "0") { // if item not found ShowMessage("Item not for this chute", MessageType.ErrorConfirm); this.Master.BarcodeValue = string.Empty; } } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } break; } case "ScanLocation": { //This could be a overflow tote or a trolley location if (_barcode.Substring(0, 2) == "LC") { try { _locationid = _locatedao.Validate_Location(_barcode, decimal.Parse(itemid.Value), User.Identity.Name, null); if (_locationid == 0) { ShowMessage("Location Validation Failed", MessageType.ErrorConfirm); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } else if (_barcode.Substring(0, 2) == "OT") { try { _overflowtoteid = _locatedao.Validate_Tote(_barcode, decimal.Parse(itemid.Value), User.Identity.Name, null); if (_overflowtoteid == 0) { ShowMessage("Overflow Tote Validation Failed", MessageType.ErrorConfirm); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } else { ShowMessage("Invalid location or overflow tote barcode", MessageType.ErrorConfirm); this.Master.BarcodeValue = string.Empty; } if (_locationid > 0 || _overflowtoteid > 0) { string fullyLocatedInd = "F"; decimal ordernumber = 0; decimal ordervolume = 0; string toteService = string.Empty; string toteBarcodePrefix = string.Empty; string toteTypeName = string.Empty; decimal currLocId = 0; string currLocBarcode = string.Empty; string currLocLabel = string.Empty; decimal numItems = 0; try { _removepackdao.locateitem(decimal.Parse(itemid.Value), _locationid, _overflowtoteid, decimal.Parse(this.trolleyid.Value), User.Identity.Name, null, ref ordernumber, ref fullyLocatedInd, ref ordervolume, ref toteService, ref toteBarcodePrefix, ref toteTypeName, ref currLocId, ref currLocBarcode, ref currLocLabel, ref numItems); if (fullyLocatedInd == "T") { this.Master.MessageBoard = "<embed id='snd' src='" + ConfigurationManager.AppSettings["SuccessSound"] + "' autostart='true' hidden='true'></embed>" + "Remove " + numItems.ToString() + " item(s) from " + currLocLabel + " to a " + toteTypeName + "<br />Scan location barcode"; this.step.Value = RemoveForPackStep.ReScanLocation.ToString(); this.locationbarcode.Value = currLocBarcode; this.totetype.Value = toteTypeName; this.toteservice.Value = toteService; } else { this.step.Value = RemoveForPackStep.ScanSku.ToString(); ShowMessage("Scan SKU barcode", MessageType.NormalMessage); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } break; } case "ReScanLocation": { if (_barcode == this.locationbarcode.Value) { // log the activity - success _useract.AppSystem = (int)ActivityLogEnum.AppSystem.IHF; _useract.ApplicationId = (int)ActivityLogEnum.ApplicationID.RemoveForPack; _useract.ModuleId = (int)ActivityLogEnum.ModuleID.RemoveForPack; _useract.EventType = (int)EventType.RescanLocation; _useract.UserId = Shared.CurrentUser; _useract.Barcode = _barcode; _useract.Value1 = this.locationbarcode.Value; _useract.ResultCode = (Int32)ActivityLogEnum.ResultCd.Success; _uadao.SaveUserActivity(_useract); // set step and show message this.step.Value = RemoveForPackStep.ScanTote.ToString(); String msgStr = "Scan " + this.toteservice.Value + " to "; if (this.totelabel.Value == string.Empty) { msgStr += "a " + this.totetype.Value + "."; } else { msgStr += "tote " + this.totelabel.Value + "."; } ShowMessage(msgStr, MessageType.NormalMessage); } else { // log the activity - failure _useract.AppSystem = (int)ActivityLogEnum.AppSystem.IHF; _useract.ApplicationId = (int)ActivityLogEnum.ApplicationID.RemoveForPack; _useract.ModuleId = (int)ActivityLogEnum.ModuleID.RemoveForPack; _useract.EventType = (int)EventType.RescanLocation; _useract.UserId = Shared.CurrentUser; _useract.Barcode = _barcode; _useract.Value1 = this.locationbarcode.Value; _useract.ResultCode = (Int32)ActivityLogEnum.ResultCd.LocationValidationFailed; _uadao.SaveUserActivity(_useract); // show the error message ShowMessage("Incorrect Location", MessageType.ErrorConfirm); } break; } case "ScanTote": { if (this.totebarcode.Value != string.Empty && this.totebarcode.Value != _barcode) { ShowMessage("Scan to tote: " + this.totelabel.Value, MessageType.ErrorConfirm); } else { decimal nextlocid = 0; string nextlocbarcode = string.Empty; string nextloclabel = string.Empty; decimal itemcount = 0; string totelabel = string.Empty; try { _removepackdao.movetotote(locationbarcode.Value, _barcode, User.Identity.Name, null, ref nextlocid, ref nextlocbarcode, ref nextloclabel, ref totelabel, ref itemcount); if (nextlocid == 0) { // no more items for this order // need to see if there are any more orders left in this chute string msg = this.toteservice.Value + " in tote"; string itemsInChute = "F"; _removepackdao.itemsinchute(decimal.Parse(this.chuteid.Value), ref itemsInChute); if (itemsInChute == "F") { msg += ". No more orders in this chute, please scan another chute"; this.step.Value = RemoveForPackStep.Initial.ToString(); } else { msg += ", scan next item for locate"; this.step.Value = RemoveForPackStep.ScanSku.ToString(); } ShowMessage(msg, MessageType.NormalMessage); // ShowMessage(this.toteservice.Value + " in tote, scan next item for locate", MessageType.NormalMessage); this.totebarcode.Value = string.Empty; this.totelabel.Value = string.Empty; // this.step.Value = RemoveForPackStep.ScanSku.ToString(); } else { ShowMessage("Remove " + itemcount.ToString() + " item(s) from " + nextloclabel + " to " + totelabel + "<br />Scan location barcode", MessageType.NormalMessage); this.totebarcode.Value = _barcode; this.totelabel.Value = totelabel; this.locationbarcode.Value = nextlocbarcode; this.step.Value = RemoveForPackStep.ReScanLocation.ToString(); } } catch (Exception ex) { string exceptionMessage = ex.Message; if (isErrorMessage(ref exceptionMessage)) { ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } else { // There aren't really messages passed back for non error conditions in this back end proc ShowMessage(exceptionMessage, MessageType.ErrorConfirm); } } } break; } case "ScanSinglesChute": { string singleschutelabel = this.singleschutelabel.Value; decimal singleschuteid = decimal.Parse(this.singleschuteid.Value); if (_barcode == string.Empty) { ShowMessage("Invalid scan. Please scan again.", MessageType.ErrorConfirm); this.Master.MessageBoard = "Scan " + singleschutelabel; } else { LocateDAO locadao = new LocateDAO(); // check if scanned chute is the same as the one passed in decimal scannedchuteid = 0; try { scannedchuteid = locadao.PreValidateChute(_barcode); } catch (Exception ex) { // activity logging _useract.AppSystem = (int)ActivityLogEnum.AppSystem.IHF; _useract.ApplicationId = (int)ActivityLogEnum.ApplicationID.RemoveForPack; _useract.ModuleId = (int)ActivityLogEnum.ModuleID.RemoveForPack; _useract.EventType = (int)EventType.ScanLocation; _useract.ResultCode = (Int32)ActivityLogEnum.ResultCd.LocationValidationFailed; _useract.ExpectedBarcodeType = "Chute barcode"; _useract.Barcode = _barcode; _useract.UserId = Shared.CurrentUser; _useract.ChuteId = (int)singleschuteid; _useract.ItemNumber = Int32.Parse(this.itemid.Value); _uadao.SaveUserActivity(_useract); // display error string msg = ex.Message.Substring(ex.Message.IndexOf(" ", 0), ex.Message.IndexOf("ORA", 1) - ex.Message.IndexOf(" ", 0)); ShowMessage(msg, MessageType.ErrorConfirm); this.Master.BarcodeValue = string.Empty; } if (scannedchuteid != 0) { if (scannedchuteid == singleschuteid) { // chute id is correct - move on to next SKU this.step.Value = RemoveForPackStep.ScanSku.ToString(); ShowMessage("Scan SKU barcode", MessageType.NormalMessage); this.singleschutelabel.Value = string.Empty; this.singleschuteid.Value = string.Empty; } else { ShowMessage("Invalid scan. Please scan again.", MessageType.ErrorConfirm); // activity logging _useract.AppSystem = (int)ActivityLogEnum.AppSystem.IHF; _useract.ApplicationId = (int)ActivityLogEnum.ApplicationID.RemoveForPack; _useract.ModuleId = (int)ActivityLogEnum.ModuleID.RemoveForPack; _useract.EventType = (int)EventType.LogOffChuteForLocate; _useract.ResultCode = (Int32)ActivityLogEnum.ResultCd.InvalidChuteType; _useract.ExpectedBarcodeType = "Chute"; _useract.Barcode = _barcode; _useract.UserId = Shared.CurrentUser; _useract.ChuteId = (int)singleschuteid; _useract.ItemNumber = Int32.Parse(this.itemid.Value); _useract.SessionEndDateTime = DateTime.Now; _uadao.SaveUserActivity(_useract); } } else { ShowMessage("Invalid scan. Please scan again.", MessageType.ErrorConfirm); // activity logging _useract.AppSystem = (int)ActivityLogEnum.AppSystem.IHF; _useract.ApplicationId = (int)ActivityLogEnum.ApplicationID.RemoveForPack; _useract.ModuleId = (int)ActivityLogEnum.ModuleID.RemoveForPack; _useract.EventType = (int)EventType.LogOffChuteForLocate; _useract.ResultCode = (Int32)ActivityLogEnum.ResultCd.InvalidChuteType; _useract.ExpectedBarcodeType = "Chute"; _useract.Barcode = _barcode; _useract.UserId = Shared.CurrentUser; _useract.ChuteId = (int)singleschuteid; _useract.ItemNumber = Int32.Parse(this.itemid.Value); _useract.SessionEndDateTime = DateTime.Now; _uadao.SaveUserActivity(_useract); } } break; } } } } this.Master.BarcodeValue = string.Empty; }
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; } } }
protected void Page_Load(object sender, EventArgs e) { 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_item = decimal.Parse(Request.QueryString["itemid"].ToString()); string I_sku_barcode = Request.QueryString["skubarcode"].ToString(); string I_chute_area = Request.QueryString["chutearea"].ToString(); string I_T_chute_label = Request.QueryString["tchutelabel"].ToString(); decimal I_T_chute_id = decimal.Parse(Request.QueryString["tchuteid"].ToString()); UserActivity setclass = new UserActivity(); ActivityLogDAO actlog = new ActivityLogDAO(); string barcodetype_sku = "Chute"; try { StringBuilder sb = new StringBuilder(); if (!String.IsNullOrEmpty(I_T_chute_label)) { sb.Append("<div>"); sb.Append("<table width='100%' cellspacing='0px' cellpadding='0px' style='border-width:1px;border-collapse:collapse; border-style:solid;border-color:White;'>"); sb.Append("<tr>"); sb.Append("<td style='font-size:24px;padding-left:2px;border-width:2px;border-style:solid;border-color:White;'>" + I_T_chute_label + "</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</div>"); } this.Master.MessageBoard = sb.ToString(); } 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.ScanItemForLocate; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.ItemvalidationFailed; setclass.ExpectedBarcodeType = barcodetype_sku; setclass.Barcode = I_sku_barcode; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = "Error: Retrieving Chute label"; this.Master.DisplayMessage = true; Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&chutearea=" + I_chute_area); } if (IsPostBack) { string loc_barcode = this.Master.BarcodeValue; if (loc_barcode == string.Empty) { this.Master.ErrorMessage = "Invalid Scan. Please scan again"; this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } else { if (loc_barcode.Length > 50) { loc_barcode = loc_barcode.Substring(0, 50); } LocateDAO locdao = new LocateDAO(); // Check if the scan chute id similar to target chute id. decimal chute_id = 0; try { chute_id = locdao.PreValidateChute(loc_barcode); } catch (Exception ex3) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.ScanLocation; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.LocationValidationFailed; setclass.ExpectedBarcodeType = "Chute barcode"; setclass.Barcode = loc_barcode; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.ItemNumber = decimal.ToInt32(I_item); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = ex3.Message.Substring(ex3.Message.IndexOf(" ", 0), (ex3.Message.IndexOf("ORA", 1) - ex3.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } if (chute_id != 0) { if (chute_id == I_T_chute_id) { // redirect to scan sku for scanning another sku or chute Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + I_trolley_id + "&chutetype=" + I_chute_type + "&chutearea=" + I_chute_area); } else { this.Master.ErrorMessage = "Invalid Chute. Please scan again"; this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; // 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.InvalidChuteType; setclass.ExpectedBarcodeType = "Chute"; setclass.Barcode = I_chute_barcode; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.ItemNumber = decimal.ToInt32(I_item); setclass.SessionEndDateTime = DateTime.Now; actlog.SaveUserActivity(setclass); } } else { this.Master.ErrorMessage = "Invalid Chute. Please scan again"; this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; // 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.InvalidChuteType; setclass.ExpectedBarcodeType = "Chute"; setclass.Barcode = I_chute_barcode; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(I_trolley_id); setclass.ItemNumber = decimal.ToInt32(I_item); setclass.SessionEndDateTime = DateTime.Now; actlog.SaveUserActivity(setclass); } } } }
protected void Page_Load(object sender, EventArgs e) { 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_chute_type = decimal.Parse(Request.QueryString["chutetype"].ToString()); //Default area to sorter when not passed. decimal I_chute_area = decimal.Parse(Request.QueryString["chutearea"] == null? "1" : Request.QueryString["chutearea"].ToString()); //string I_terminal = this.Master.HostName; string I_terminal = null; string barcodetype = "Trolley"; UserActivity setclass = new UserActivity(); ActivityLogDAO actlog = new ActivityLogDAO(); if (!IsPostBack) { // on page load display this message this.Master.MessageBoard = "Scan Trolley Barcode for Attach"; } else { string trolley_barcode = this.Master.BarcodeValue; if (trolley_barcode != string.Empty) { if (trolley_barcode.Length > 50) { trolley_barcode = trolley_barcode.Substring(0, 50); } } LocateDAO locdao = new LocateDAO(); //decimal trolley_id = 0; // check if the chute is singles or multi if (I_chute_type == 1) // singles { decimal trolley_id_singles = 0; // validate the trolley barcode using oms_attach_trolley.p_validate_trolley try { trolley_id_singles = locdao.Validate_Trolley(I_chute_id, trolley_barcode, I_user, I_terminal); } 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.ScanTrolleyForAttach; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.TrolleyScanFailed; setclass.ExpectedBarcodeType = barcodetype; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(trolley_id_singles); 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; } // attach the trolley try { // if no errors then attach trolley to chute using oms_attach_trolley.p_attach_trolley_to_chute locdao.Attach_Trolley(I_chute_id, trolley_id_singles, I_user, I_terminal); // Log user to chute using p_log_on_to_chute /************ commented out for time being ************/ //locdao.Log_on_to_Chute(I_chute_barcode, I_user); /************ commented out for time being ************/ // trolley attach success for singles // log off user from locating session /************ commented out for time being ************/ //locdao.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; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(trolley_id_singles); actlog.SaveUserActivity(setclass); /************ commented out for time being ************/ // redirect to main page of locate to scan another chute Response.Redirect("Locate.aspx"); } 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.TrolleyAttachLocate; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.FailedToAttach; setclass.ExpectedBarcodeType = barcodetype; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(trolley_id_singles); 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; } }// chute type is 1 else if (I_chute_type == 2) // multi { // check if chute is attached to a trolley decimal chutes_trolley_id = 0; try { chutes_trolley_id = locdao.Chute_Trolley(I_chute_barcode, I_user, I_terminal); } catch (Exception xx1) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.TrolleyAttachLocate; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.FailedToAttach; setclass.ExpectedBarcodeType = barcodetype; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(chutes_trolley_id); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = xx1.Message.Substring(xx1.Message.IndexOf(" ", 0), (xx1.Message.IndexOf("ORA", 1) - xx1.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } // if no trolley is attached if (chutes_trolley_id == 0) { // validate the trolley barcode using oms_attach_trolley.p_validate_trolley decimal trolley_id_new = 0; try { trolley_id_new = locdao.Validate_Trolley(I_chute_id, trolley_barcode, I_user, I_terminal); } catch (Exception xx2) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.ScanTrolleyForAttach; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.TrolleyScanFailed; setclass.ExpectedBarcodeType = barcodetype; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(trolley_id_new); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = xx2.Message.Substring(xx2.Message.IndexOf(" ", 0), (xx2.Message.IndexOf("ORA", 1) - xx2.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } // attach trolley try { // if no errors then attach trolley to chute using oms_attach_trolley.p_attach_trolley_to_chute locdao.Attach_Trolley(I_chute_id, trolley_id_new, I_user, I_terminal); // Log user to chute using p_log_on_to_chute /************ commented out for time being ************/ //locdao.Log_on_to_Chute(I_chute_barcode, I_user); /************ commented out for time being ************/ // redirect to scan sku Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + trolley_id_new + "&chutetype=" + I_chute_type + "&chutearea =" + I_chute_area); } catch (Exception xx3) { // activity logging setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF; setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.AttachAndLocate; setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.AttachAndlocate; setclass.EventType = (Int32)EventType.TrolleyAttachLocate; setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.FailedToAttach; setclass.ExpectedBarcodeType = barcodetype; setclass.Barcode = trolley_barcode; setclass.TerminalId = I_terminal; setclass.UserId = I_user; setclass.ChuteId = decimal.ToInt32(I_chute_id); setclass.TrolleyId = decimal.ToInt32(trolley_id_new); actlog.SaveUserActivity(setclass); this.Master.ErrorMessage = xx3.Message.Substring(xx3.Message.IndexOf(" ", 0), (xx3.Message.IndexOf("ORA", 1) - xx3.Message.IndexOf(" ", 0))); this.Master.DisplayMessage = true; this.Master.BarcodeValue = string.Empty; } } else // another trolley is attached { // redirect to scan sku Response.Redirect("LocateScanSku.aspx?chuteID=" + I_chute_id + "&chutebarcode=" + I_chute_barcode + "&userlogon=" + I_user + "&trolleyid=" + chutes_trolley_id + "&chutetype=" + I_chute_type + "&chutearea =" + I_chute_area); } } // chute type is 2 } // end of post back }