protected void Page_Load(object sender, EventArgs e)
{
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
GenderDDL.Items.Add("Male");
GenderDDL.Items.Add("Female");
//EmployeeType
EmployeeType empType = new EmployeeType();
DT = bindComboBox.BindDropdown(empType.SearchEmployeeTypes(), "Employee_Type_Name", "Employee_Type_Number");
EmployeeTypeDDL.DataSource = DT;
EmployeeTypeDDL.DataValueField = "Employee_Type_Name";
EmployeeTypeDDL.DataTextField = "Employee_Type_Number";
EmployeeTypeDDL.DataBind();
}
protected void VehicleDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DBConnection db = new DBConnection();
ClientVehicle ClientV = new ClientVehicle();
DateDDL.DataTextField = "Project_StartDateTime";
DateDDL.DataValueField = "Project_Number";
DateDDL.DataSource = db.BindDropdown("SELECT Project.Project_Number, Project.Project_StartDateTime, Project.Project_TotalCost FROM Project WHERE Client_Vehicle_Number = " + VehicleDDL.SelectedItem.Value, "Project_StartDateTime", "Project_Number");
DateDDL.DataBind();
DateDDL.Items.Insert(0, "");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Application["username"] == null)
{
Response.Redirect("/Login");
}
if(!IsPostBack)
{
usernumber = Convert.ToInt32(Application["UserNumber"]);
VehicleDDL.Items.Clear();
DBConnection db = new DBConnection();
ClientVehicle cv = new ClientVehicle();
VehicleDDL.DataTextField = "Vehicle";
VehicleDDL.DataValueField = "Client_Vehicle_Number";
VehicleDDL.DataSource = db.BindDropdown(cv.SearchClientVehicles(usernumber), "GVehicle_Model", "Client_Vehicle_Number");
VehicleDDL.DataBind();
VehicleDDL.Items.Insert(0, "");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Client c = new Client();
c.SearchClients("");
List<Cli> myLi = new List<Cli>();
foreach (Client inC in ClientBindingList.MyClientList)
{
userNumbersList.Add(inC.UserNumber);
Cli me = new Cli();
me.FirstName = inC.FirstName;
me.Surname = inC.Surname;
me.ContactNumber = inC.ContactNumber;
myLi.Add(me);
}
gvwStudents.DataSource = myLi;
gvwStudents.DataBind();
//City
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
GenderDDL.Items.Add("Male");
GenderDDL.Items.Add("Female");
}