protected void Page_Load(object sender, EventArgs e) { if (Application["username"] == null) { Response.Redirect("/Login"); } if (!IsPostBack) { usernumber = Convert.ToInt32(Application["UserNumber"].ToString()); ClientVehicle cv = new ClientVehicle(); VehicleDDL.DataValueField = "Client_Vehicle_Number"; VehicleDDL.DataTextField = "Vehicle"; VehicleDDL.DataSource = db.BindDropdown(cv.SearchClientVehicles(usernumber), "GVehicle_Model", "Client_Vehicle_Number"); VehicleDDL.DataBind(); db.LoadClientVehicles(usernumber); foreach (ClientVehicle ClientV in ClientVehicleBindingList.ClientVehicleList) { if (ClientV.ClientVehicleNumber == Convert.ToInt32(VehicleDDL.SelectedValue)) { txtName.Text = ClientV.ClientVehicleName; txtColour.Text = ClientV.ClientVehicleColour; txtLicensePlate.Text = ClientV.RegistrationNumber; clientVehicleNumber = ClientV.ClientVehicleNumber; break; } } //Client Vehicle Products ClientVehicle cvProducts = new ClientVehicle(); gvwStudents.DataSource = db.SearchQuery(cvProducts.SearchClientVehicleProducts(clientVehicleNumber), "ProductTable"); gvwStudents.DataMember = "ProductTable"; gvwStudents.DataBind(); } }
protected void VehicleDDL_SelectedIndexChanged(object sender, EventArgs e) { usernumber = Convert.ToInt32(Application["UserNumber"].ToString()); gvwStudents.DataSource = null; gvwStudents.DataBind(); txtName.Text = ""; txtColour.Text = ""; txtLicensePlate.Text = ""; db.LoadClientVehicles(usernumber); foreach (ClientVehicle ClientV in ClientVehicleBindingList.ClientVehicleList) { if (ClientV.ClientVehicleNumber == Convert.ToInt32(VehicleDDL.SelectedValue)) { txtName.Text = ClientV.ClientVehicleName; txtColour.Text = ClientV.ClientVehicleColour; txtLicensePlate.Text = ClientV.RegistrationNumber; clientVehicleNumber = ClientV.ClientVehicleNumber; break; } } //Client Vehicle Products ClientVehicle cvProducts = new ClientVehicle(); gvwStudents.DataSource = db.SearchQuery(cvProducts.SearchClientVehicleProducts(clientVehicleNumber), "ProductTable"); gvwStudents.DataMember = "ProductTable"; gvwStudents.DataBind(); }