protected void LinkButton2_Click(object sender, EventArgs e)
{
Valid = new Validation();
if (BoxID != "")
{
if (Valid.IsValidOrder(BoxID) == true)
{
BoxScanGroup.Attributes["class"] = "form-group has-success";
CartonUpdatePanel.Visible = true;
ProductPanel.Visible = true;
LocationPanel.Visible = true;
QuantityPanel.Visible = true;
CartonPanel.Visible = true;
// string shipmentID = Valid.GetShipmentID(BoxID);
// string orderNumber = Valid.GetOrderNumber(BoxID);
LocationTextBox.Focus();
if (Panel2.Visible == true && Valid.IsValidOrder(BoxID) == true && CheckBox1.Checked == false)
{
PickTicketDataSource.SelectCommand = "SELECT PRODUCT_MASTER.DESCRIPTION, PRODUCT_MASTER.SHORT_DESCRIPTION, PRODUCT_MASTER.PIECE_PICK_LOCATION as from_location, OUTBOUND_SHIPMENT_DETAILS.ORDER_LINE, OUTBOUND_SHIPMENT_DETAILS.Ordered_units as quantity FROM OUTBOUND_SHIPMENT_DETAILS INNER JOIN PRODUCT_MASTER ON OUTBOUND_SHIPMENT_DETAILS.PRODUCT_ID = PRODUCT_MASTER.PRODUCT_ID where OUTBOUND_SHIPMENT_DETAILS.shipment_id='" + Valid.GetShipmentID(BoxID) + "' and OUTBOUND_SHIPMENT_DETAILS.order_Number='" + Valid.GetOrderNumber(BoxID) + "'and OUTBOUND_SHIPMENT_DETAILS.UOM='EA' order by Product_master.Piece_pick_location";
}
if (Panel2.Visible == true && Valid.IsValidOrder(BoxID) == true && CheckBox1.Checked == true)
{
PickTicketDataSource.SelectCommand = "select MQ.order_line, MQ.FROM_LOCATION,PM.DESCRIPTION,PM.short_description, Sum(MQ.QUANTITY_REQUIRED) as quantity From Move_queue MQ (NOLOCK), inventory INV (NOLOCK), Locations L (NOLOCK), Product_Master PM (NOLOCK) Where (INV._RID_ = MQ.INV_RID) And (PM.PRODUCT_ID = INV.PRODUCT_ID) And (MQ.FROM_LOCATION = L.LOCATION_ID) And (MQ.TYPE = 'PICK') And (MQ.LABELLEVEL = 'EA') And L.PICKING_ZONE = '" + CurrentZone + "' And (MQ.SHIPMENT_ID = '" + Valid.GetShipmentID(BoxID) + "') And (MQ.ORDER_NUMBER = '" + Valid.GetOrderNumber(BoxID) + "') Group By MQ.SHIPMENT_ID, MQ.ORDER_NUMBER, MQ.ORDER_LINE, MQ.LABELLEVEL, ISNULL(INV.CASELABEL, ''), INV.PRODUCT_ID,PM.description, PM.SHORT_DESCRIPTION, L.PICKING_ZONE, L.LOCATION_GROUP, MQ.FROM_LOCATION, PICK_SEQUENCE, TO_LOCATION Order By L.LOCATION_GROUP, FROM_LOCATION";
}
CartonUpdatePanel.Update();
// PickUpdatePannel.Update();
}
else
{
BoxScannTextBox.Text = "";
BoxScannTextBox.Attributes["placeholder"] = "Shipment ID is not valid";
BoxScannTextBox.Text = "";
BoxScanGroup.Attributes["class"] = "form-group has-error";
}
}
else
{
BoxScannTextBox.Text = "";
BoxScannTextBox.Attributes["placeholder"] = "Please Scan an order";
BoxScanGroup.Attributes["class"] = "form-group has-error";
}
}
protected void CartonTimer_Tick(object sender, EventArgs e)
{
CartonUpdatePanel.Update();
GridView1.DataBind();
}