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