private void bthSearch_Click(object sender, RoutedEventArgs e)
        {
            string pstateid   = "0";
            string pregionids = "0";
            string pbrandids  = "0";
            string active     = "2";

            if (cmbActive.Text.ToUpper() == "ACTIVE")
            {
                active = "1";
            }
            else if (cmbActive.Text.ToUpper() == "INACTIVE")
            {
                active = "0";
            }

            DateTime effectivedate = dteEffectiveDate.SelectedDate ?? DateTime.Now;

            if (cmbState.SelectedValue != null)
            {
                pstateid = cmbState.SelectedValue.ToString();
            }
            else
            {
                pstateid = loginstateid.ToString();
            }
            if (cmbRegion.SelectedItems != null)
            {
                pregionids = cr.getIDsSelected(cmbRegion.SelectedItems);
            }

            if (cmbBrand.SelectedItems != null)
            {
                pbrandids = cr.getIDsSelected(cmbBrand.SelectedItems);
            }
            cr.LoadBasePriceHoldingDays(pstateid, pregionids, pbrandids, effectivedate, active);
        }