public static string vallidatePalletID(string palletID, string position, string returnOrder)
        {
            InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
            Ent_tticol125         obj  = new Ent_tticol125();
            string strError            = string.Empty;
            string retorno             = string.Empty;

            //TextBox quantity = (TextBox)e.Row.Cells[10].FindControl("palletId");



            obj.paid = palletID.Trim().ToUpperInvariant();

            DataTable resultado = idal.vallidatePalletData(ref obj, ref strError);
            //decimal palletQuantity = 0;
            //decimal status;
            //string tableName = string.Empty;
            //decimal givenQuantity = Convert.ToDecimal(quantity);

            /* select  col131.t$paid "palletid", col131.t$loaa "current_location",
             * col131.t$qtya "current_qty", col131.t$item "item", ibd001.t$dsca "description"*/
            string  item, description, palletid, current_location, unit, war, stat;
            decimal current_qty;

            if (resultado.Rows.Count < 1)
            {
                return(null);
            }
            else
            {
                foreach (DataRow dr in resultado.Rows)
                {
                    palletid         = dr.ItemArray[0].ToString();
                    current_location = dr.ItemArray[1].ToString();
                    current_qty      = Convert.ToDecimal(dr.ItemArray[2].ToString());
                    item             = dr.ItemArray[3].ToString();
                    description      = dr.ItemArray[4].ToString();
                    unit             = dr.ItemArray[5].ToString();
                    war  = dr.ItemArray[6].ToString();
                    stat = dr.ItemArray[7].ToString();

                    // lblItemValue.Text = item;
                    //lblItemDescValue.Text = description;
                    //lblUnitValue.Text = unit;
                    //lbllotValue.Text = lot;


                    string  warehouse, itemcode;
                    decimal qty;
                    InterfazDAL_twhcol130 idal2      = new InterfazDAL_twhcol130();
                    DataTable             resultado1 = idal2.vallidatePurchaseOrderWithPosition(ref returnOrder, ref position, ref strError);
                    if (resultado1.Rows.Count < 1)
                    {
                        return(null);
                    }
                    else
                    {
                        foreach (DataRow dr1 in resultado1.Rows)
                        {
                            itemcode  = dr1.ItemArray[0].ToString();
                            warehouse = dr1.ItemArray[1].ToString();
                            qty       = Convert.ToDecimal(dr1.ItemArray[2].ToString());
                            if (warehouse.Trim() != war.Trim())
                            {
                                return(PalletWarehousedoesnotmatch);
                            }
                            if (itemcode.Trim() != item.Trim())
                            {
                                return(PalletItemcodedoesnotmatch);
                            }
                            if (current_qty < qty)
                            {
                                return(ActualquantitypalletIDequalorlessthanorderedquantity
                                       );
                            }
                        }
                    }
                }

                return(JsonConvert.SerializeObject(resultado));
            }
        }