protected void DdlVehicle_SelectedIndexChanged(object sender, EventArgs e) { VehiclesTableAdapter vehicleAdapter = new VehiclesTableAdapter(); DropDownList ddlVehicle = (DropDownList)FvBookingView.FindControl("ddlVehicle"); TextBox txtDailyRate = (TextBox)FvBookingView.FindControl("txtDailyRateCharged"); Decimal rate = Convert.ToDecimal(vehicleAdapter.GetDataById(Convert.ToInt32(ddlVehicle.SelectedValue))[0]["DailyRate"].ToString()); txtDailyRate.Text = rate.ToString("C"); }
private void DdlVehicleRefresh(string VehicleValue = null) { VehiclesTableAdapter vehicleAdapter = new VehiclesTableAdapter(); DriversTableAdapter driverAdapter = new DriversTableAdapter(); // ************************************************ // Determine age from selected driver date of birth DropDownList ddlDriver = (DropDownList)FvBookingView.FindControl("ddlDriver"); DateTime dob = Convert.ToDateTime(driverAdapter.GetDataById(ddlDriver.SelectedValue)[0]["DateOfBirth"]); int age = DateTime.Now.Year - dob.Year; if (DateTime.Now.DayOfYear < dob.DayOfYear) { age = age - 1; } // ************************************************ // Determine date range for vehicle availability TextBox txtDateFrom = (TextBox)FvBookingView.FindControl("txtDateFrom"); TextBox txtDateDue = (TextBox)FvBookingView.FindControl("txtDateDue"); bool isDateFrom = DateTime.TryParse(txtDateFrom.Text, out DateTime dateFrom); bool isDateDue = DateTime.TryParse(txtDateDue.Text, out DateTime dateDue); //if (!isDateFrom) //{ // dateFrom = DateTime.Today; //} //if (!isDateDue) //{ // dateDue = DateTime.Today.AddDays(14); //} //Set end of dateDue dateDue = dateDue.AddMinutes(1439); // ************************************************ TextBox txtBookingID = (TextBox)FvBookingView.FindControl("txtBookingID"); int.TryParse(txtBookingID.Text, out int bookingid); DropDownList ddlVehicle = (DropDownList)FvBookingView.FindControl("ddlVehicle"); if (isDateFrom && isDateDue) { ddlVehicle.DataSource = vehicleAdapter.GetDataByAgeAndRange(Convert.ToByte(age), dateFrom, dateDue, bookingid); } else { ddlVehicle.DataSource = vehicleAdapter.GetDataAboveAge(Convert.ToByte(age)); } ddlVehicle.DataValueField = "ID"; ddlVehicle.DataTextField = "Details"; ddlVehicle.ClearSelection(); ddlVehicle.DataBind(); if ((VehicleValue == "" || VehicleValue == null) && ddlVehicle.Items.Count > 0) { VehicleValue = ddlVehicle.SelectedValue; ddlVehicle.SelectedValue = VehicleValue; ddlVehicle.SelectedIndex = 0; } // Revert DDL if previous SelectedValue in new list (must be done after a DataBind) if (ddlVehicle.Items.FindByValue(VehicleValue) != null) { ddlVehicle.SelectedValue = VehicleValue; } ddlVehicle.DataBind(); // if DailyRateCharged not set (but a value exists in DDL), set it initially TextBox txtDailyRate = (TextBox)FvBookingView.FindControl("txtDailyRateCharged"); if (txtDailyRate.Text == "" && ddlVehicle.SelectedIndex >= 0) { Decimal dailyRate = Convert.ToDecimal(vehicleAdapter.GetDataById(Convert.ToInt32(ddlVehicle.SelectedValue))[0]["DailyRate"].ToString()); txtDailyRate.Text = dailyRate.ToString("C"); } }