Example #1
0
        protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                GridDataItem dataItem = (GridDataItem)e.Item;

                String scageid = dataItem.GetDataKeyValue("cage_id").ToString();
                Int32  icageid = Int32.Parse(scageid);


                CageReportsDAO cagedao = new CageReportsDAO();

                decimal cg_status = cagedao.GetCageStatus(icageid);

                // for the image

                TableCell cell     = dataItem["ReadyForDespatch"];
                Button    ReadyBtn = (Button)cell.FindControl("btn_ready");

                if (cg_status == 40)//detached
                {
                    ReadyBtn.Visible = true;
                }
                else
                {
                    ReadyBtn.Visible = false;
                }
            }
        }
Example #2
0
        public void BindData_troverview(string I_carrier)
        {
            CageReportsDAO crdao   = new CageReportsDAO();
            DataSet        ds_crov = new DataSet();

            ds_crov             = crdao.GetParcelstobecaged(I_carrier);
            RadGrid2.DataSource = ds_crov.Tables[0];
        }
Example #3
0
        protected void Button3_Click(object sender, EventArgs e)
        {
            string carr_id = DD_carrier.SelectedItem.Value;

            try
            {
                // get carrier barcode


                CageReportsDAO crdao       = new CageReportsDAO();
                string         carrbarcode = crdao.GetCarrierBarcode(carr_id);

                // get cage barcode
                Button       btn      = (Button)sender;
                GridDataItem dataitem = (GridDataItem)btn.NamingContainer;

                String scageid = dataitem.GetDataKeyValue("cage_id").ToString();
                Int32  icageid = Int32.Parse(scageid);

                string cagebarcode = crdao.GetCageBarcode(icageid);

                // call ready to despatch


                DespatchDAO desdao = new DespatchDAO();


                string cagename = desdao.ProcessBarcode(carrbarcode, cagebarcode, username);

                Label1.Text      = "Cage " + scageid + " Is Ready For despatch";
                Label1.ForeColor = Color.Blue;

                Label1.Visible = true;
            }
            catch (Exception ex)
            {
                Label1.Text      = "Error:" + ex.Message.Substring(ex.Message.IndexOf(" ", 0), (ex.Message.IndexOf("ORA", 1) - ex.Message.IndexOf(" ", 0)));
                Label1.Visible   = true;
                Label1.ForeColor = Color.Red;
            }


            //RadGrid2.Rebind();

            this.BindData_troverview(carr_id);

            RadGrid2.Rebind();

            GetCageIds();
            HiddenField1.Value = cages;
        }
Example #4
0
        public void GetCageIds()
        {
            CageReportsDAO cg_firstload = new CageReportsDAO();
            string         carrierid    = DD_carrier.SelectedItem.Value;
            string         cagesids     = cg_firstload.Getcageidstring(carrierid);

            if (cagesids == string.Empty || cagesids == "null" || cagesids == "0")
            {
                cages = "No cages for Despatch";
            }
            else
            {
                cages = "Click OK to Despatch " + cagesids + " Cages for " + carrierid;
            }
        }
Example #5
0
        private void Getdropdown()
        {
            CageReportsDAO crdao = new CageReportsDAO();
            DataSet        ds_cd = new DataSet();
            DataTable      dt_cd = new DataTable();


            ds_cd = crdao.GetCarriersWithSelect();
            dt_cd = ds_cd.Tables[0];

            foreach (DataRow row in dt_cd.Rows)
            {
                string item_code_str = row["Carrier_id"].ToString();
                string item_desc     = row["Carrier"].ToString();
                DD_carrier.Items.Insert(0, new ListItem(item_desc, item_code_str));
            }
        }
Example #6
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            string         carrid = DD_carrier.SelectedItem.Value;
            DespatchDAO    desdao = new DespatchDAO();
            CageReportsDAO crdao  = new CageReportsDAO();

            try
            {
                string carrbarcode = crdao.GetCarrierBarcode(carrid);

                decimal cagecount = desdao.ValidateCagesForDespatch(carrbarcode);
                if (cagecount > 0)
                {
                    string queueoutput = desdao.QueueForDespatch(carrbarcode, username);
                }

                this.BindData_troverview(carrid);

                RadGrid2.Rebind();

                CageReportsDAO cg_firstload = new CageReportsDAO();
                string         carrierid    = DD_carrier.SelectedItem.Value;
                string         cagesids     = cg_firstload.Getcageidstring(carrierid);
                if (cagesids == string.Empty || cagesids == "null" || cagesids == "0")
                {
                    Label1.Text = string.Empty;
                }
                else
                {
                    Label1.Text      = "Cages Despatched for " + carrid;
                    Label1.ForeColor = Color.Blue;
                }
            }
            catch (Exception Ex2)
            {
                Label1.Text      = "Error:" + Ex2.Message.Substring(Ex2.Message.IndexOf(" ", 0), (Ex2.Message.IndexOf("ORA", 1) - Ex2.Message.IndexOf(" ", 0)));
                Label1.Visible   = true;
                Label1.ForeColor = Color.Red;
            }

            Label1.Visible = true;
        }