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");
}
}
