protected void CreateAssignmentPerson(int assignment_id)
{
try
{
var rightperson = ctx.person.Where(p => p.username == ticket.Name).SingleOrDefault();
var rightassignment = ctx.assignment.Where(a => a.amt_id == assignment_id).SingleOrDefault();
if (rightperson != null && rightassignment != null)
{
var assignmentperson = new assignment_person
{
person_id = rightperson.person_id,
amt_id = rightassignment.amt_id,
project_id = rightassignment.project_id
};
rightperson.assignment_person.Add(assignmentperson);
rightassignment.assignment_person.Add(assignmentperson);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
lbmessages.Text = ex.Message;
}
}
protected void gvPersons_SelectedIndexChanged(object sender, EventArgs e)
{
// Add the selected person to the assignment
string username = (gvPersons.SelectedRow.Cells[0].Controls[0] as LinkButton).Text;
string assignment_id = String.Empty;
string project_id = String.Empty;
// Fill the group_member database table as well
try
{
assignment_id = Request.QueryString["Assignment"];
project_id = Request.QueryString["Project"];
int to_add_assignmentid = int.Parse(assignment_id);
int to_add_projectid = int.Parse(project_id);
if (assignment_id != String.Empty && project_id != String.Empty)
{
var addedperson = ctx.person.Where(p => p.username == username).SingleOrDefault();
var addedassignment = ctx.assignment.Where(amt => amt.amt_id == to_add_assignmentid).SingleOrDefault();
if (addedperson != null && addedassignment != null)
{
var aspe = new assignment_person
{
amt_id = addedassignment.amt_id,
project_id = to_add_projectid,
person_id = addedperson.person_id
};
addedassignment.edited = DateTime.Now;
addedperson.edited = DateTime.Now;
addedassignment.assignment_person.Add(aspe);
addedperson.assignment_person.Add(aspe);
ctx.SaveChanges();
}
}
else
{
lbMessages.Text = "No Person Specified";
}
}
catch (Exception ex)
{
lbMessages.Text = ex.Message;
}
if (assignment_id != String.Empty && project_id != String.Empty)
{
Response.Redirect(String.Format(Request.ApplicationPath + "Assignment.aspx?Assignment={0}&Project={1}", assignment_id, project_id));
}
}
