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