protected void SearchbindData(string Unique_id)
        {
            lbSearchMsg.Text = "";

            string username, catid, operator_id;

            if (Session["username"] != null || Session["operator_id"] != null)
            {
                username    = Session["username"].ToString();
                catid       = Convert.ToString(Session["category"]);
                operator_id = Convert.ToString(Session["operator_id"]);
            }
            else
            {
                Session.Abandon();
                Response.Redirect("~/Login.aspx");
                return;
            }
            DataTable dt = new DataTable();


            Cls_Business_RptBulkActTransProces objTran = new Cls_Business_RptBulkActTransProces();

            dt = objTran.GetDetails(username, operator_id, catid, Unique_id);

            if (dt == null)
            {
                lblResponseMsg.Text = "No Data Found";
            }
            else if (dt.Rows.Count == 0)
            {
                lblResponseMsg.Text  = "No Data Found";
                DivShowValue.Visible = false;
            }


            else
            {
                DivShowValue.Visible = true;
                lblSumFile.Text      = dt.Rows[0]["uploadid"].ToString();
                lblSumTotal.Text     = dt.Rows[0]["total"].ToString();
                lblSumSuccess.Text   = dt.Rows[0]["success"].ToString();
                lblSumFailure.Text   = dt.Rows[0]["failed"].ToString();
                lblRemaing.Text      = dt.Rows[0]["remaing"].ToString();
            }
        }
        protected void binddata(string upload_id, int IntBulkStatus)
        {
            string username, catid, operator_id;

            if (Session["username"] != null || Session["operator_id"] != null)
            {
                username    = Session["username"].ToString();
                catid       = Convert.ToString(Session["category"]);
                operator_id = Convert.ToString(Session["operator_id"]);
            }
            else
            {
                Session.Abandon();
                Response.Redirect("~/Login.aspx");
                return;
            }
            DataTable dt = new DataTable();

            Cls_Business_RptBulkActTransProces objTran = new Cls_Business_RptBulkActTransProces();

            dt = objTran.GetBulkStatusDetails(username, upload_id, IntBulkStatus);

            if (dt == null)
            {
                Response.Redirect("~/ErrorPage.aspx");
                return;
            }



            if (dt.Rows.Count == 0)
            {
                grdBulkstatus.Visible = false;
                lbSearchMsg.Text      = "No data found";
            }
            else
            {
                //{
                //    btnGenerateExcel.Visible = true;
                DivGried.Visible = true;
            }
            grdBulkstatus.Visible = true;

            grdBulkstatus.DataSource = dt;
            grdBulkstatus.DataBind();
        }