protected void gvAssignRE_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "btnAssign")
            {
                var qry =
                    from wp in ff.WorkPackages
                    where (
                        wp.wpId == lblWPID2.Text
                        )
                    select new { wp.projId };

                int         row         = Convert.ToInt32(e.CommandArgument);
                GridViewRow selectedRow = gvAssignRE.Rows[row];

                EmployeeWorkPackage ewp = new EmployeeWorkPackage();
                ewp.empId  = Convert.ToInt32(selectedRow.Cells[0].Text);
                ewp.projId = qry.First().projId;
                ewp.wpId   = lblWPID2.Text;

                var qry2 =
                    from emp in ff.EmployeeWorkPackages
                    where (emp.projId == qry.First().projId&& emp.empId == ewp.empId)
                    select emp;
                if (qry2.ToArray().Length == 0)
                {
                    ff.EmployeeWorkPackages.InsertOnSubmit(ewp);
                }
                string username = selectedRow.Cells[1].Text + "_" + selectedRow.Cells[2].Text;
                WorkPackageResponsibleEngineer wpre = new WorkPackageResponsibleEngineer();
                wpre.projId = qry.First().projId;
                wpre.wpId   = lblWPID2.Text;
                wpre.responsibleEngineer = Convert.ToInt32(selectedRow.Cells[0].Text);
                ff.WorkPackageResponsibleEngineers.InsertOnSubmit(wpre);
                ff.SubmitChanges();
                divAssignRE.Visible = false;
                try
                {
                    Roles.AddUserToRole(username, "ResponsibleEngineer");
                }
                catch (Exception exception)
                {
                }
                populateManageWorkPackage();
            }
        }
        catch (Exception exception)
        {
            //  lblException.Text = exception.StackTrace;
        }
    }
 partial void DeleteWorkPackageResponsibleEngineer(WorkPackageResponsibleEngineer instance);
 partial void InsertWorkPackageResponsibleEngineer(WorkPackageResponsibleEngineer instance);
	private void detach_WorkPackageResponsibleEngineers(WorkPackageResponsibleEngineer entity)
	{
		this.SendPropertyChanging();
		entity.EmployeeWorkPackage = null;
	}
    protected void gvAssignRE_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "btnAssign")
            {
                var qry =
                    from wp in ff.WorkPackages
                    where (
                        wp.wpId == lblWPID2.Text
                    )
                    select new { wp.projId };

                int row = Convert.ToInt32(e.CommandArgument);
                GridViewRow selectedRow = gvAssignRE.Rows[row];

                EmployeeWorkPackage ewp = new EmployeeWorkPackage();
                ewp.empId = Convert.ToInt32(selectedRow.Cells[0].Text);
                ewp.projId = qry.First().projId;
                ewp.wpId = lblWPID2.Text;

                var qry2 =
                    from emp in ff.EmployeeWorkPackages
                    where (emp.projId == qry.First().projId && emp.empId == ewp.empId)
                    select emp;
                if (qry2.ToArray().Length == 0)
                {
                    ff.EmployeeWorkPackages.InsertOnSubmit(ewp);
                }
                string username = selectedRow.Cells[1].Text + "_" + selectedRow.Cells[2].Text;
                WorkPackageResponsibleEngineer wpre = new WorkPackageResponsibleEngineer();
                wpre.projId = qry.First().projId;
                wpre.wpId = lblWPID2.Text;
                wpre.responsibleEngineer = Convert.ToInt32(selectedRow.Cells[0].Text);
                ff.WorkPackageResponsibleEngineers.InsertOnSubmit(wpre);
                ff.SubmitChanges();
                divAssignRE.Visible = false;
                try
                {
                    Roles.AddUserToRole(username, "ResponsibleEngineer");
                }
                catch (Exception exception)
                {
                }
                populateManageWorkPackage();
            }
        }
        catch (Exception exception)
        {
          //  lblException.Text = exception.StackTrace;
        }
    }