protected void prepData()
        {
            SC_GetSubCategories sc = new SC_GetSubCategories();

            {
                sc.Subcategory = "MVP";
                sc.GetData();
                if (sc.Tables.Count >= 1 && sc.Tables[0].Rows.Count > 0)
                {
                    Subcategories = sc.Tables[0];
                }
            }
            medicalSubcategories.DataSource = Subcategories;
            medicalSubcategories.DataBind();

            SC_GetRecentProviders grp = new SC_GetRecentProviders();

            {
                grp.CCHID      = this.PrimaryCCHID;
                grp.Category   = Category;
                grp.EmployerID = this.EmployerID;
                grp.GetData();

                if (grp.Tables.Count >= 1 && grp.Tables[0].Rows.Count > 0)
                {
                    UsedProviders = grp.Tables[0];
                }
            }
            recentProviders.DataSource = UsedProviders;
            recentProviders.DataBind();
            medicalRecentSubcategory.DataSource = UsedProviders;
            medicalRecentSubcategory.DataBind();

            SC_GetFairPriceAlternatives fpa = new SC_GetFairPriceAlternatives();

            {
                fpa.CCHID    = this.PrimaryCCHID;
                fpa.Category = Category;
                if (UsedProviders != null && UsedProviders.Rows.Count > 0)
                {
                    fpa.SpecialtyID = Convert.ToInt16(UsedProviders.Rows[0]["specialtyID"]);
                    lblFairPriceAlternativeCategory.Text = getSpecialtyNameByID(Convert.ToInt32(UsedProviders.Rows[0]["specialtyID"]));
                }
                fpa.Lat    = double.Parse(ThisSession.PatientLatitude);
                fpa.Lon    = double.Parse(ThisSession.PatientLongitude);
                fpa.RowMax = 5;
                fpa.GetData();

                if (fpa.Tables.Count >= 1 && fpa.Tables[0].Rows.Count > 0)
                {
                    Providers = fpa.Tables[0];
                }
            }
            fairPriceProviders.DataSource = Providers;
            fairPriceProviders.DataBind();
        }
 private void loadSubcategories()
 {
     Repeater            subCategoriesList = (Repeater)FindControl("medicalSubcategories");
     SC_GetSubCategories gsc = new SC_GetSubCategories(); {
         gsc.Subcategory = category;
         gsc.GetData();
         if (gsc.Tables.Count >= 1 && gsc.Tables[0].Rows.Count > 0)
         {
             subCategoriesList.DataSource = gsc.Tables[0];
             subCategoriesList.DataBind();
         }
     }
 }
 private void loadSubcategories()
 {
     Repeater subCategoriesList = (Repeater)FindControl("medicalSubcategories");
     SC_GetSubCategories gsc = new SC_GetSubCategories(); {
         gsc.Subcategory = category;
         gsc.GetData();
         if (gsc.Tables.Count >= 1 && gsc.Tables[0].Rows.Count > 0) {
             subCategoriesList.DataSource = gsc.Tables[0];
             subCategoriesList.DataBind();
         }
     }
 }
        protected void prepData()
        {
            SC_GetSubCategories sc = new SC_GetSubCategories();
            {
                sc.Subcategory = "MVP";
                sc.GetData();
                if (sc.Tables.Count >= 1 && sc.Tables[0].Rows.Count > 0)
                {
                    Subcategories = sc.Tables[0];
                }
            }
            medicalSubcategories.DataSource = Subcategories;
            medicalSubcategories.DataBind();

            SC_GetRecentProviders grp = new SC_GetRecentProviders();
            {
                grp.CCHID = this.PrimaryCCHID;
                grp.Category = Category;
                grp.EmployerID = this.EmployerID;
                grp.GetData();

                if (grp.Tables.Count >= 1 && grp.Tables[0].Rows.Count > 0)
                {
                    UsedProviders = grp.Tables[0];
                }

            }
            recentProviders.DataSource = UsedProviders;
            recentProviders.DataBind();
            medicalRecentSubcategory.DataSource = UsedProviders;
            medicalRecentSubcategory.DataBind();

            SC_GetFairPriceAlternatives fpa = new SC_GetFairPriceAlternatives();
            {
                fpa.CCHID = this.PrimaryCCHID;
                fpa.Category = Category;
                if (UsedProviders != null && UsedProviders.Rows.Count > 0) {
                    fpa.SpecialtyID = Convert.ToInt16(UsedProviders.Rows[0]["specialtyID"]);
                    lblFairPriceAlternativeCategory.Text = getSpecialtyNameByID(Convert.ToInt32(UsedProviders.Rows[0]["specialtyID"]));
                }
                fpa.Lat = double.Parse(ThisSession.PatientLatitude);
                fpa.Lon = double.Parse(ThisSession.PatientLongitude);
                fpa.RowMax = 5;
                fpa.GetData();

                if (fpa.Tables.Count >= 1 && fpa.Tables[0].Rows.Count > 0)
                {
                    Providers = fpa.Tables[0];
                }
            }
            fairPriceProviders.DataSource = Providers;
            fairPriceProviders.DataBind();
        }