protected void gvEmployees_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "btnDelete")
{
ff.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues);
int row = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = gvEmployees.Rows[row];
EmployeeWorkPackage empwp = ff.EmployeeWorkPackages.Where(emp => emp.empId == (Convert.ToInt32(selectedRow.Cells[0].Text)) && emp.wpId == lblWPID2.Text).First();
ff.EmployeeWorkPackages.DeleteOnSubmit(empwp);
ff.SubmitChanges();
populateManageWorkPackage();
}
}
protected void populateManageProject()
{
try
{
ff.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues);
if (Session["projID"] == null)
{
Response.Redirect("~/PM/ProjectList.aspx");
}
if (Session["wpID"] != null)
{
Session["wpID"] = null;
}
if (divChangeAlloc.Visible == false)
{
divOriginalAlloc.Visible = true;
}
divChangeAlloc.Visible = false;
lblProjID2.Text = Session["projID"].ToString();
//Get project name
var proj =
from p in ff.Projects
where p.projId == Convert.ToInt32(Session["projID"])
select p;
lblProjName2.Text = proj.First().projName;
try
{
lblProjectManager2.Text = ff.Employees
.Where(a => a.empId == proj.First().manager).First().firstName + " " +
ff.Employees
.Where(a => a.empId == proj.First().manager).First().lastName;
}
catch (Exception e)
{
lblProjectManager2.Text = "";
}
if (proj.First().allocated_dollars == null)
{
lblAlloc2.Text = "UNDEFINED";
}
else
{
lblAlloc2.Text = proj.First().allocated_dollars.ToString();
}
if (proj.First().unallocated_dollars == null)
{
lblUnalloc2.Text = "UNDEFINED";
}
else
{
lblUnalloc2.Text = proj.First().unallocated_dollars.ToString();
}
getAllActiveWP();
getAllUnactiveWP();
identifyRole();
string[] name = lblProjectManager2.Text.Split(' ');
var query =
(from emp in ff.Employees
where emp.firstName == name[0] && emp.lastName == name[1]
select new { emp.empId }).First();
try
{
Roles.AddUserToRole(name[0].ToLower() + "_" + name[1].ToLower(), "ProjectManager");
}
catch (Exception exception)
{
}
try
{
EmployeeProject ep = new EmployeeProject();
ep.projId = Convert.ToInt32(lblProjID2.Text);
ep.empId = query.empId;
ff.EmployeeProjects.InsertOnSubmit(ep);
ff.SubmitChanges();
}
catch (Exception exception) {
}
}
catch (Exception exception)
{
//lblException.Text = exception.StackTrace;
}
}