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; } }