protected void Page_Load(object sender, EventArgs e)
{
using (var db = new TruckCompanyDBContainer())
{
var query = from b in db.JobSet
orderby b.JobId
select b;
foreach (var item in query)
{
LinkButton linkButton = new LinkButton();
linkButton.Text = item.JobTitle;
Panel2.Controls.Add(linkButton);
Panel2.Controls.Add(new LiteralControl("<br/>"));
Label salary_lb = new Label();
salary_lb.CssClass =
salary_lb.Text = item.Salary.ToString();
Panel2.Controls.Add(salary_lb);
Panel2.Controls.Add(new LiteralControl("<br/>"));
Label description_lb = new Label();
description_lb.Text = item.Description;
Panel2.Controls.Add(description_lb);
Panel2.Controls.Add(new LiteralControl("<br/><br/>"));
}
}
}
/// <summary>
/// This method has the function to populate the mini-form with information provides by databases
/// database name:TRUCKCOMPANYDB
/// </summary>
private void PopularDropDownList()
{
using (var db = new TruckCompanyDBContainer())
{
var query = (from b in db.CarSet
select b.Plate).Distinct();
foreach (var item in query)
{
/*PLATE*/
DropDownList.Items.Add(new ListItem(item));
/*LOCATION*/
//for (int i = 0; i < DropDownList3.Items.Count; i++)
//{
// if (!DropDownList3.Items[i].Value.Contains(item.Branche.Location))
// {
// DropDownList3.Items.Add(new ListItem(item.Branche.Location));
// }
//}
//if (!DropDownList3.Items.Contains(item.Branche.Location)
//{
//}
//DropDownList3.Items.Add(new ListItem(item.Branche.Location));
}
//Years
var query1 = (from h in db.CarSet
select h.Year).Distinct();
foreach (var item in query1)
{
DropDownList1.Items.Add(new ListItem(item.ToString()));
}
//brand
var query2 = (from i in db.CarSet
select i.Brand).Distinct();
foreach (var item in query2)
{
DropDownList2.Items.Add(new ListItem(item));
}
//Locations
var query3 = (from a in db.BrancheSet
select a.Location).Distinct();
foreach (var item in query3)
{
DropDownList3.Items.Add(new ListItem(item));
}
}
}
