private void LoadEditor()
{
using (WebhostEntities db = new WebhostEntities())
{
Credit credit = db.Credits.Where(c => c.id == CreditId).Single();
CreditTypeDDL.DataSource = GradeTableEntryListItem.GetDataSource(credit.CreditType.GradeTable.GradeTableEntries.Select(g => g.id).ToList());
CreditTypeDDL.DataTextField = "Text";
CreditTypeDDL.DataValueField = "ID";
CreditTypeDDL.DataBind();
CreditTypeDDL.ClearSelection();
CreditTypeDDL.SelectedValue = Convert.ToString(credit.CreditTypeId);
CreditValueDDL.DataSource = GradeTableEntryListItem.GetDataSource(credit.CreditValue.GradeTable.GradeTableEntries.Select(g => g.id).ToList());
CreditValueDDL.DataTextField = "Text";
CreditValueDDL.DataValueField = "ID";
CreditValueDDL.DataBind();
CreditValueDDL.ClearSelection();
CreditValueDDL.SelectedValue = Convert.ToString(credit.CreditValueId);
NotesInput.Text = credit.Notes;
UpdateAll.Checked = credit.Sections.Count > 1;
}
}
/// <summary>
/// Get a Datasource List for use in Web Controls.
///
/// DataTextField = "Text"
/// DataValueField = "Id"
///
/// Invalid IDs are dropped without notification.
///
/// </summary>
/// <param name="actids">List of WeekendActivity.id</param>
/// <returns></returns>
public static List <GradeTableEntryListItem> GetDataSource(List <int> actids)
{
List <GradeTableEntryListItem> items = new List <GradeTableEntryListItem>();
foreach (int id in actids)
{
GradeTableEntryListItem item = new GradeTableEntryListItem(id);
if (item.ID != -1)
{
items.Add(item);
}
}
return(items);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int year = DateRange.GetCurrentAcademicYear();
using (WebhostEntities db = new WebhostEntities())
{
StudentSelect.DataSource = StudentListItem.GetDataSource(db.Students.Where(s => s.isActive).OrderBy(s => s.GraduationYear).ThenBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList());
StudentSelect.DataTextField = "Text";
StudentSelect.DataValueField = "ID";
StudentSelect.DataBind();
CreditTypeDDL.DataSource = GradeTableEntryListItem.GetDataSource(db.GradeTables.Where(t => t.Name.Equals("Credit Types") && t.AcademicYearID == year).Single().GradeTableEntries.Select(d => d.id).ToList());
CreditTypeDDL.DataTextField = "Text";
CreditTypeDDL.DataValueField = "ID";
CreditTypeDDL.DataBind();
CreditValueDDL.DataSource = GradeTableEntryListItem.GetDataSource(db.GradeTables.Where(t => t.Name.Equals("Credit Values") && t.AcademicYearID == year).Single().GradeTableEntries.Select(d => d.id).ToList());
CreditValueDDL.DataTextField = "Text";
CreditValueDDL.DataValueField = "ID";
CreditValueDDL.DataBind();
}
}
}
