protected void Assignments_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
Assignments_grid.EditIndex = int.Parse(e.CommandArgument.ToString());
Assignments_grid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (WindchimeEntities wce = new WindchimeEntities())
{
foreach (Issue i in wce.PermissionableEntities.OfType <Issue>())
{
Issue_list.Items.Add(new ListItem(String.Format("{0} ({1})",
i.Name,
i.Date.ToShortDateString()),
i.EntityID.ToString()));
}
Issue_list.Items.Insert(0, new ListItem("Any Issue", ""));
var assignments = from Assignment a in wce.PermissionableEntities.OfType <Assignment>()
select a;
if (!string.IsNullOrEmpty(Issue_list.SelectedValue))
{
int issueid = int.Parse(Issue_list.SelectedValue);
assignments = from Assignment a in assignments
from Issue i in a.Parents.OfType <Issue>()
where i.EntityID == issueid
select a;
}
if (!string.IsNullOrEmpty(Keywords_box.Text))
{
assignments = from Assignment a in assignments
where a.Name.Contains(Keywords_box.Text) ||
a.Summary.Contains(Keywords_box.Text) ||
a.Location.Contains(Keywords_box.Text)
select a;
}
if (!string.IsNullOrEmpty(Author_box.Text))
{
assignments = from Assignment a in assignments
from Creator c in a.Creators
where (c.FirstName + " " + c.LastName).StartsWith(Author_box.Text)
select a;
}
Assignments_grid.DataSource = assignments;
Assignments_grid.DataBind();
}
}
