protected void bindAllGrids(string service_str)
        {
            //separating and manupulating plan poids
            ViewState["ServicePoid"] = service_str.Split('!')[0];
            lblStbNo.Text            = service_str.Split('!')[1];

            //showing service status
            Cls_Business_TxnAssignPlan obj = new Cls_Business_TxnAssignPlan();
            string ServiceStatus           = obj.getServiceStatus(service_str.Split('!')[4]);

            if (ServiceStatus == "A")
            {
                lbactive.Visible = false; lbdeactive.Visible = true;
            }
            else if (ServiceStatus == "IA")
            {
                lbactive.Visible = true; lbdeactive.Visible = false;
            }
            else if (ServiceStatus == "CL")
            {
                lbactive.Visible = false; lbdeactive.Visible = false;
            }
            else if (ServiceStatus == "EX")
            {
                lbactive.Visible = false; lbdeactive.Visible = false;
            }


            string all_plan_string = service_str.Split('!')[3]; //--this is plan string under service
            string service_data    = obj.getServiceDataBL(Session["username"].ToString(), city, all_plan_string, ViewState["customer_no"].ToString());

            string[] service_data_arr = service_data.Split('#');
            if (service_data_arr[0] != "9999")
            {
                msgboxstr("Something went wrong from procedure");
                return;
            }

            //generating basic table
            string basic_data_str = service_data_arr[1];

            if (basic_data_str != null && basic_data_str != "")
            {
                string[] basic_plan_arr = basic_data_str.Split('~');
                string   basic_poids    = dataTableBuilder(dtBasicPlans, basic_plan_arr);
            }


            //generating addon table
            string addon_data_str = service_data_arr[2];

            if (addon_data_str != null && addon_data_str != "")
            {
                string[] addon_plan_arr = addon_data_str.Split('~');
                addon_poids = dataTableBuilder(dtAddonPlans, addon_plan_arr);
                addon_poids = addon_poids.TrimEnd(',');
            }
            else
            {
                addon_poids = "'0'";
            }


            //generating alacarte table
            string alacarte_data_str = service_data_arr[3];

            if (alacarte_data_str != null && alacarte_data_str != "")
            {
                string[] alacarte_plan_arr = alacarte_data_str.Split('~');
                ala_poids = dataTableBuilder(dtAlacartePlans, alacarte_plan_arr);
                ala_poids = ala_poids.TrimEnd(',');
            }
            else
            {
                ala_poids = "'0'";
            }

            grdCarte.DataSource = dtAlacartePlans;
            grdCarte.DataBind();
            if (dtAlacartePlans.Rows.Count == 0)
            {
                lblAlacartePlan.Visible = false;
                //AlacarteAccordion.Visible = false;
            }
            else
            {
                lblAlacartePlan.Visible = true;
                //AlacarteAccordion.Visible = true;
                //AlacarteAccordion.SelectedIndex = -1;
            }


            grdBasicPlanDetails.DataSource = dtBasicPlans;
            grdBasicPlanDetails.DataBind();
            if (dtBasicPlans.Rows.Count == 0)
            {
                lblBasicPlan.Visible = false;
            }
            else
            {
                lblBasicPlan.Visible = true;
            }


            grdAddOnPlan.DataSource = dtAddonPlans;
            grdAddOnPlan.DataBind();
            if (dtAddonPlans.Rows.Count == 0)
            {
                lblAddonPlan.Visible = false;
                //AddonAccordion.Visible = false;
            }
            else
            {
                lblAddonPlan.Visible = true;
                //AddonAccordion.Visible = true;
                //AddonAccordion.SelectedIndex = -1;
            }
        }
        protected void bindAllGrids(string service_str)
        {
            try
            {
                //separating and manupulating plan poids
                ViewState["ServicePoid"] = service_str.Split('!')[0];
                lblStbNo.Text            = service_str.Split('!')[1];

                //showing service status
                Cls_Business_TxnAssignPlan obj = new Cls_Business_TxnAssignPlan();
                string ServiceStatus           = obj.getServiceStatus(service_str.Split('!')[4]);
                if (ServiceStatus == "A")
                {
                    lbactive.Visible = false; lbdeactive.Visible = true;
                }
                else if (ServiceStatus == "IA")
                {
                    lbactive.Visible = true; lbdeactive.Visible = false;
                }
                else if (ServiceStatus == "CL")
                {
                    lbactive.Visible = false; lbdeactive.Visible = false;
                }
                else if (ServiceStatus == "EX")
                {
                    lbactive.Visible = false; lbdeactive.Visible = false;
                }


                string all_plan_string = service_str.Split('!')[3]; //--this is plan string under service

                string city = "";
                if (ViewState["cityid"] != null && ViewState["cityid"].ToString() != "")
                {
                    city = ViewState["cityid"].ToString();
                }
                string   service_data     = obj.getServiceDataBL(Session["username"].ToString(), city, all_plan_string, ViewState["customer_no"].ToString());
                string[] service_data_arr = service_data.Split('#');
                if (service_data_arr[0] != "9999")
                {
                    //show only customer information but hide plan details
                    setSearchBox();
                    pnlCustDetails.Visible = true;
                    pnlGridHolder.Visible  = false;
                    btnReset.Visible       = true;
                    lblSearchResponse.Text = "";
                    msgboxstr("Something went wrong while fetching plan details...");
                    return;
                }
                else
                {
                    //show only customer information as well as plan details
                    setSearchBox();
                    pnlCustDetails.Visible = true;
                    pnlGridHolder.Visible  = true;
                    btnReset.Visible       = true;
                    lblSearchResponse.Text = "";
                }

                //generating basic table
                string basic_data_str = service_data_arr[1];
                if (basic_data_str != null && basic_data_str != "")
                {
                    //DataTable dtBasicPlans = (DataTable)ViewState["customer_basic_plans"];
                    string[] basic_plan_arr = basic_data_str.Split('~');
                    string   basic_poids    = dataTableBuilder(dtBasicPlans, basic_plan_arr);
                }


                //generating addon table
                string addon_data_str = service_data_arr[2];
                if (addon_data_str != null && addon_data_str != "")
                {
                    //DataTable dtAddonPlans = (DataTable)ViewState["customer_addon_plans"];
                    string[] addon_plan_arr = addon_data_str.Split('~');
                    addon_poids = dataTableBuilder(dtAddonPlans, addon_plan_arr);
                    addon_poids = addon_poids.TrimEnd(',');
                    //poidlist = addon_poids;
                }
                else
                {
                    addon_poids = "'0'";
                }


                //generating alacarte table
                string alacarte_data_str = service_data_arr[3];
                if (alacarte_data_str != null && alacarte_data_str != "")
                {
                    // DataTable dtAlacartePlans = (DataTable)ViewState["customer_alacarte_plans"];
                    string[] alacarte_plan_arr = alacarte_data_str.Split('~');
                    ala_poids = dataTableBuilder(dtAlacartePlans, alacarte_plan_arr);
                    ala_poids = ala_poids.TrimEnd(',');
                }
                else
                {
                    ala_poids = "'0'";
                }

                grdCarte.DataSource = dtAlacartePlans;
                grdCarte.DataBind();
                if (dtAlacartePlans.Rows.Count == 0)
                {
                    lblAlacartePlan.Visible   = false;
                    AlacarteAccordion.Visible = false;
                }
                else
                {
                    lblAlacartePlan.Visible         = true;
                    AlacarteAccordion.Visible       = true;
                    AlacarteAccordion.SelectedIndex = -1;
                }


                grdBasicPlanDetails.DataSource = dtBasicPlans;
                grdBasicPlanDetails.DataBind();
                if (dtBasicPlans.Rows.Count == 0)
                {
                    lblBasicPlan.Visible = false;
                }
                else
                {
                    lblBasicPlan.Visible = true;
                }


                grdAddOnPlan.DataSource = dtAddonPlans;
                grdAddOnPlan.DataBind();
                if (dtAddonPlans.Rows.Count == 0)
                {
                    lblAddonPlan.Visible   = false;
                    AddonAccordion.Visible = false;
                }
                else
                {
                    lblAddonPlan.Visible         = true;
                    AddonAccordion.Visible       = true;
                    AddonAccordion.SelectedIndex = -1;
                }
            }
            catch (Exception ex)
            {
                FileLogText("BindAllGrid", "", Session["username"].ToString(), ex.Message.ToString());
            }
        }