protected void Page_Load(object sender, EventArgs e) { if (Session["compHeaderID"] != null) { Session["compHeaderID"] = Request.QueryString["compHeaderID"]; } using (SSIRentEntities context = new SSIRentEntities()) { Jobroles.DataSource = context.EmployeeJobRoles.ToList().OrderBy(x => x.JobRole); Jobroles.DataBind(); RadComboBoxJobResp.DataSource = context.EmployeeQualifications.ToList().OrderBy(x => x.Qualification); RadComboBoxJobTitles.DataSource = context.EmployeeJobTitles.ToList().OrderBy(x => x.JobTitle); RadComboBoxUOM.DataSource = context.SchedulingRecurrenceUOMs.Where(b => b.SchedulingNotAvailable == true).ToList(); RadComboBoxFUOM.DataSource = context.SchedulingRecurrenceUOMs.Where(b => b.SchedulingNotAvailable == true).ToList(); RadComboBoxJobTitles.DataBind(); RadComboBoxJobResp.DataBind(); RadComboBoxUOM.DataBind(); RadComboBoxFUOM.DataBind(); } using (SSITrainingEntities context = new SSITrainingEntities()) { var allGroups = context.CompetencyGroups.OrderBy(i => i.GroupName); RadComboBoxTrainingTypes.DataSource = context.TrainingTypes.ToList().OrderBy(x => x.TrainingType); RadComboBoxTrainingTypes.DataBind(); rptTabs.DataSource = allGroups.ToList(); rptTabs.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { using (SSIRentEntities context = new SSIRentEntities()) { Jobroles.DataSource = context.EmployeeJobRoles.ToList().OrderBy(x => x.JobRole); Jobroles.DataBind(); RadComboBoxJobResp.DataSource = context.EmployeeQualifications.ToList().OrderBy(x => x.Qualification); RadComboBoxJobTitles.DataSource = context.EmployeeJobTitles.ToList().OrderBy(x => x.JobTitle); RadComboBoxUOM.DataSource = context.SchedulingRecurrenceUOMs.ToList(); RadComboBoxFUOM.DataSource = context.SchedulingRecurrenceUOMs.ToList(); RadComboBoxJobTitles.DataBind(); RadComboBoxJobResp.DataBind(); RadComboBoxUOM.DataBind(); RadComboBoxFUOM.DataBind(); } using (SSITrainingEntities context = new SSITrainingEntities()) { var allGroups = context.CompetencyGroups.OrderBy(i => i.GroupName); rptTabs.DataSource = allGroups.ToList(); rptTabs.DataBind(); } }