protected void Btn_stack_Click(object sender, System.EventArgs e)
{
ChuteDAO chmgr = new ChuteDAO();
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
Int32 stack_seq = 0;
string displayname = User.Identity.Name;
try
{
stack_seq = Int32.Parse(tb_stack.Text.ToString());
if (stack_seq != 0)
{
decimal upd_status = chmgr.Manage_stack(areaID, stack_seq, displayname);
if (upd_status == 0)
{
HandleError("Stacks and Trolleys Created successfully", 0);
}
else if (upd_status == -1)
{
HandleError("Trolley detach Failed", 1);
}
else
{
HandleError("Error Occurred", 1);
}
}
else
{
HandleError("Invalid Stack Sequence", 1);
}
Initialize_stack();
}
catch (Exception ex2)
{
HandleError(ex2.Message, 1);
Initialize_save();
}
BindData(areaID);
RadGrid1.Rebind();
}
public static string GetMessageAndLogException(Exception ex, UserActivity userActivity)
{
try
{
// Code for logging the Exception. In the Database.
ErrorDetails errorDetails = ErrorAndMessage(ex.Message);
ActivityLogDAO activityLog = new ActivityLogDAO();
userActivity = SetUserActivityObject(errorDetails, userActivity);
userActivity.TerminalId = Shared.UserHostName;
userActivity.UserId = Shared.CurrentUser;
activityLog.SaveUserActivity(userActivity);
}
catch (Exception e)
{
}
return(GetExceptionMessage(ex));
}
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;
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 btnSave_Click(object sender, System.EventArgs e)
{
ChuteDAO chmgr = new ChuteDAO();
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
string displayname = User.Identity.Name;
// Create new DataTable and DataSource objects.
DataTable dt_seq = new DataTable();
// Declare DataColumn and DataRow variables.
DataColumn dc_seq;
DataRow dr_seq;
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
dc_seq = new DataColumn();
dc_seq.DataType = System.Type.GetType("System.Int32");
dc_seq.ColumnName = "chute_id";
dt_seq.Columns.Add(dc_seq);
// Create second column.
dc_seq = new DataColumn();
dc_seq.DataType = System.Type.GetType("System.Int32");
dc_seq.ColumnName = "chute_seq";
dt_seq.Columns.Add(dc_seq);
try
{
foreach (GridItem item in RadGrid1.MasterTableView.Items)
{
if (item is GridEditableItem)
{
GridEditableItem editableItem = item as GridDataItem;
string chuteid_str = editableItem.OwnerTableView.DataKeyValues[item.ItemIndex]["chute_id"].ToString();
Int32 chuteid = Int32.Parse(chuteid_str);
Label ch_typ_lab = (Label)editableItem.FindControl("ch_type_lab");
Int32 ch_type_id = Int32.Parse(ch_typ_lab.Text);
if (ch_type_id == 2)
{
RadTextBox ch_seq_tb = (RadTextBox)editableItem.FindControl("ch_seq_TextBox");
Int32 ch_seq_id = Int32.Parse(ch_seq_tb.Text);
// Create new DataRow objects and add to DataTable.
dr_seq = dt_seq.NewRow();
dr_seq["chute_id"] = chuteid;
dr_seq["chute_seq"] = ch_seq_id;
dt_seq.Rows.Add(dr_seq);
}
}
}
dt_seq.DefaultView.Sort = "chute_seq";
dt_seq = dt_seq.DefaultView.ToTable();
Int32 realseq = 1;
foreach (DataRow row in dt_seq.Rows)
{
string id_str = row["chute_id"].ToString();
Int32 id = Int32.Parse(id_str);
decimal Chute_id = chmgr.Update_Chute_seq(id, realseq, displayname);
realseq++;
}
HandleError("Updated Chute Sequence Successfully", 0);
Initialize_save();
}
catch (Exception ex)
{
// activity logging
HandleError(ex.Message, 1);
}
BindData(areaID);
RadGrid1.Rebind();
}
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
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
LoadReleaseDAO loadmgr = new LoadReleaseDAO();
string displayname = User.Identity.Name;
Int32 area_id;
Int32 action_ind;
if (IsValidAreaSelected())
{
foreach (GridItem item in grdLoadRelease.MasterTableView.Items)
{
if (item is GridEditableItem)
{
GridEditableItem editableItem = item as GridDataItem;
CheckBox chlabel = (CheckBox)editableItem.FindControl("SelectRow");
UserActivity setclass = new UserActivity();
ActivityLogDAO actlog = new ActivityLogDAO();
if (chlabel.Checked)
{
string loadid = editableItem.OwnerTableView.DataKeyValues[item.ItemIndex]["pick_load_num"].ToString();
string singleOrder = editableItem.OwnerTableView.DataKeyValues[item.ItemIndex]["tot_single_orders"].ToString();
string multiOrders = editableItem.OwnerTableView.DataKeyValues[item.ItemIndex]["tot_multi_orders"].ToString();
RadComboBox areaid = (RadComboBox)editableItem.FindControl("releaseTo");
RadComboBox actionind = (RadComboBox)editableItem.FindControl("release_action");
area_id = Int32.Parse(areaid.SelectedValue);
action_ind = Int32.Parse(actionind.SelectedValue);
try
{
decimal resultCode = loadmgr.Update_Load(
loadid,
area_id,
action_ind,
int.Parse(string.IsNullOrEmpty(singleOrder) ? "0" : singleOrder),
int.Parse(string.IsNullOrEmpty(multiOrders) ? "0" : multiOrders),
displayname);
if (resultCode == -1)
{
HandleError("Load Release Failed for split load", 1);
}
else if (resultCode == -2)
{
HandleError("Area selected for Load Release/Unrelease is disabled", 1);
}
else if (resultCode == -3)
{
HandleError("Area does not accept store orders", 1);
}
else
{
HandleError("Load(s) Updated", 0);
}
}
catch (Exception ex)
{
// activity logging
setclass.AppSystem = (Int32)ActivityLogEnum.AppSystem.IHF;
setclass.ApplicationId = (Int32)ActivityLogEnum.ApplicationID.ManualSort;
setclass.ModuleId = (Int32)ActivityLogEnum.ModuleID.MSLoadRelease;
setclass.EventType = (Int32)EventType.ManualSortLoadRelease;
setclass.ResultCode = (Int32)ActivityLogEnum.ResultCd.MSLoadReleaseFailed;
setclass.EventDateTime = DateTime.Now;
setclass.SortLoadId = loadid;
setclass.Value1 = action_ind.ToString();
setclass.Value2 = area_id.ToString();
setclass.UserId = displayname;
actlog.SaveUserActivity(setclass);
HandleError(CleanErrorMessage(ex.Message), 1);
}
}
}
}
}
else
{
HandleError("Please select valid area to release the load.", 1);
}
//grdLoadRelease.Rebind();
string load_status_cd = loadStatus.SelectedItem.Value;
if (load_status_cd != string.Empty)
{
load_status = Int32.Parse(load_status_cd);
}
this.BindData(load_status);
grdLoadRelease.Rebind();
}
