protected void inserting_cityperdiem(object sender, EventArgs e)
        {
            var    city = tbxCity.Text;
            var    rate = tbxCityPerDiemRate.Text;
            double rateDouble;

            if (!double.TryParse(rate, out rateDouble))
            {
                return;
            }

            var billingController                  = new BillingDefaultCityRateController();
            var billingCityRateController          = new BillingCityRateController();
            var billingPeriodAccountJoinController = new BillingPeriodAccountsJoinController();

            var newDefaultCityRate       = billingController.InsertObjReturn(Convert.ToInt32(BillingAccountDropDown.SelectedValue), rateDouble, city);
            var openPeriodAccountJoinCol =
                billingPeriodAccountJoinController.FetchOpenPeriodByAccountId(
                    Convert.ToInt32(BillingAccountDropDown.SelectedValue));

            //add new city to active billing periods
            foreach (var openPeriod in openPeriodAccountJoinCol)
            {
                billingCityRateController.Insert(newDefaultCityRate.Id, openPeriod.Id, rateDouble);
            }

            tbxCity.Text            = string.Empty;
            tbxCityPerDiemRate.Text = string.Empty;

            CityPerDiemGridView.DataBind();
        }
        protected void BillingAccountSelected(object sender, EventArgs e)
        {
            SelectedBillingAccountID.Value  = BillingAccountDropDown.SelectedValue;
            SelectedBillingAccountName.Text = BillingAccountDropDown.SelectedItem.Text;
            BillingAccountNameChanger.Text  = BillingAccountDropDown.SelectedItem.Text;

            DefaultBillingRatesRepeater.DataBind();

            PerDiem_Textbox.Text           = GetDefaultPerDiemRate().ToString();
            PerDiemStatus.Text             = string.Empty;
            Mileage_Textbox.Text           = GetDefaultMileageRate().ToString();
            MileageStatus.Text             = string.Empty;
            EditPeriodBillingPanel.Visible = true;
            tbxCity.Text            = string.Empty;
            tbxCityPerDiemRate.Text = string.Empty;

            CityPerDiemGridView.DataBind();
        }