partial void DeleteEmployeePersonLevel(EmployeePersonLevel instance);
partial void InsertEmployeePersonLevel(EmployeePersonLevel instance);
partial void UpdateEmployeePersonLevel(EmployeePersonLevel instance);
private void detach_EmployeePersonLevels(EmployeePersonLevel entity)
{
this.SendPropertyChanging();
entity.PersonLevel = null;
}
//Fills changed information into object and submits changes to DB
protected void buttonDetailsSubmit_Click(object sender, EventArgs e)
{
Employee ManagedEmployee = ff.Employees.Where(em => em.empId == Convert.ToInt32(lblEmpId.Text)).First();
ManagedEmployee.firstName = tbFirstName.Text;
ManagedEmployee.lastName = tbLastName.Text;
ManagedEmployee.supervisor = Convert.ToInt32(lbSupervisors.SelectedValue);
ManagedEmployee.approver = Convert.ToInt32(lbApprovers.SelectedValue);
ManagedEmployee.minHoursPerWeek = Convert.ToDecimal(tbMinHours.Text);
ManagedEmployee.vacationLeave = Convert.ToInt32(tbVacation.Text);
ManagedEmployee.sickDays = Convert.ToInt32(tbSickDays.Text);
ManagedEmployee.flexHours = Convert.ToDecimal(tbFlexHours.Text);
if (cbActiveUser.Checked)
{
ManagedEmployee.isActive = 1;
}
else
{
ManagedEmployee.isActive = 0;
}
#region Add/Remove Roles
List<string> rolesToAdd = new List<string>();
List<string> rolesToRemove = new List<string>();
foreach (ListItem r in cblUserRoles.Items)
{
if (r.Selected)
{
rolesToAdd.Add(r.Text);
}
else
{
rolesToRemove.Add(r.Text);
}
}
foreach (string r in rolesToAdd)
{
try
{
Roles.AddUserToRole(lblUsername.Text, r);
}
catch (Exception ex) { Trace.Write(ex.Message); }
}
foreach (string r in rolesToRemove)
{
try
{
Roles.RemoveUserFromRole(lblUsername.Text, r);
}
catch (Exception ex) { Trace.Write(ex.Message); }
}
#endregion
string approverUsername = ff.vw_EmployeeInRolewFirstLastNameEmpIDUserIDs
.Where(em => em.empId == Convert.ToInt32(lbApprovers.SelectedValue))
.Select(u => u.UserName).First();
if (!Roles.IsUserInRole(approverUsername, "TimesheetApprover"))
{
Roles.AddUserToRole(approverUsername, "TimesheetApprover");
}
//P-Level update
//if exists on dateupdated, update
if (ff.EmployeePersonLevels
.Where(ep => (ep.empId == Convert.ToInt32(lblEmpId.Text)) && ep.dateUpdated == DateTime.Now.Date)
.Count() > 0)
{
EmployeePersonLevel epl = ff.EmployeePersonLevels
.Where(ep => (ep.empId == Convert.ToInt32(lblEmpId.Text)) && ep.fiscalYear == DateTime.Now.Year)
.OrderByDescending(ep => ep.dateUpdated)
.First();
epl.pLevel = ddlPLevel.SelectedValue;
epl.dateUpdated = DateTime.Now.Date;
}
//if does not exist on dateupdated, create new
else
{
EmployeePersonLevel epl = new EmployeePersonLevel()
{
empId = Convert.ToInt32(lblEmpId.Text),
fiscalYear = DateTime.Now.Year,
pLevel = ddlPLevel.SelectedValue,
dateUpdated = DateTime.Now.Date
};
ff.EmployeePersonLevels.InsertOnSubmit(epl);
}
//DB SubmitChanges
try
{
ff.SubmitChanges();
}
catch (Exception ex)
{
lblUserEditError.Text = ex.Message;
lblUserEditError.ForeColor = System.Drawing.Color.Red;
return;
}
lblUserEditError.Text = "User Has been updated. Show all users to see changes.";
lblUserEditError.ForeColor = System.Drawing.Color.ForestGreen;
}
//Adds the newly created user to the Employee table and links them together in EmployeeMembership
protected void cuwCreateUser_CreatedUser(object sender, EventArgs e)
{
string tmpFirstName = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("FirstName")).Text;
string tmpLastName = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("LastName")).Text;
string tmpSupervisor = ((ListBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("SupervisorList")).SelectedValue;
string tmpApprover = ((ListBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("ApproverList")).SelectedValue;
string tmpEmpID = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("EmployeeID")).Text;
CheckBoxList tempCheck = (CheckBoxList)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("RoleList");
for (int i = 0; i < tempCheck.Items.Count; i++)
{
if (tempCheck.Items[i].Selected)
{
Roles.AddUserToRole(((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("UserName")).Text
, tempCheck.Items[i].Text);
}
}
Employee emp = new Employee()
{
firstName = tmpFirstName,
lastName = tmpLastName,
empId = Convert.ToInt32(tmpEmpID),
supervisor = Convert.ToInt32(tmpSupervisor),
approver = Convert.ToInt32(tmpApprover),
minHoursPerWeek = 0,
vacationLeave = 0,
sickDays = 0,
flexHours = 0,
isActive = 1
};
//Employee table updated
ff.Employees.InsertOnSubmit(emp);
//EmployeeMembership updated (link created here)
ff.EmployeeMemberships.InsertOnSubmit(new EmployeeMembership
{
empId = Convert.ToInt32(tmpEmpID),
userId = ff.aspnet_Users
.Where(u => u.UserName == ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("UserName")).Text)
.ToArray()[0].UserId
});
//PLevel Entry Created and submitted
EmployeePersonLevel epl = new EmployeePersonLevel()
{
dateUpdated = DateTime.Now.Date,
empId = Convert.ToInt32(tmpEmpID),
//Fiscal Year is not DateTime.Now.Year but for lack of time it will be
fiscalYear = DateTime.Now.Year,
pLevel = ((DropDownList)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("ddlPLevel")).SelectedValue,
};
ff.EmployeePersonLevels.InsertOnSubmit(epl);
ff.SubmitChanges();
//Adds selected Approver to the TSApprover Role if they are not in it already
string approverUsername = ff.vw_EmployeeInRolewFirstLastNameEmpIDUserIDs.Where(em => em.empId == Convert.ToInt32(tmpApprover)).Select(u => u.UserName).First();
if (!Roles.IsUserInRole(approverUsername, "TimesheetApprover"))
{
Roles.AddUserToRole(approverUsername, "TimesheetApprover");
}
}
//Fills changed information into object and submits changes to DB
protected void buttonDetailsSubmit_Click(object sender, EventArgs e)
{
Employee ManagedEmployee = ff.Employees.Where(em => em.empId == Convert.ToInt32(lblEmpId.Text)).First();
ManagedEmployee.firstName = tbFirstName.Text;
ManagedEmployee.lastName = tbLastName.Text;
ManagedEmployee.supervisor = Convert.ToInt32(lbSupervisors.SelectedValue);
ManagedEmployee.approver = Convert.ToInt32(lbApprovers.SelectedValue);
ManagedEmployee.minHoursPerWeek = Convert.ToDecimal(tbMinHours.Text);
ManagedEmployee.vacationLeave = Convert.ToInt32(tbVacation.Text);
ManagedEmployee.sickDays = Convert.ToInt32(tbSickDays.Text);
ManagedEmployee.flexHours = Convert.ToDecimal(tbFlexHours.Text);
if (cbActiveUser.Checked)
{
ManagedEmployee.isActive = 1;
}
else
{
ManagedEmployee.isActive = 0;
}
#region Add/Remove Roles
List <string> rolesToAdd = new List <string>();
List <string> rolesToRemove = new List <string>();
foreach (ListItem r in cblUserRoles.Items)
{
if (r.Selected)
{
rolesToAdd.Add(r.Text);
}
else
{
rolesToRemove.Add(r.Text);
}
}
foreach (string r in rolesToAdd)
{
try
{
Roles.AddUserToRole(lblUsername.Text, r);
}
catch (Exception ex) { Trace.Write(ex.Message); }
}
foreach (string r in rolesToRemove)
{
try
{
Roles.RemoveUserFromRole(lblUsername.Text, r);
}
catch (Exception ex) { Trace.Write(ex.Message); }
}
#endregion
string approverUsername = ff.vw_EmployeeInRolewFirstLastNameEmpIDUserIDs
.Where(em => em.empId == Convert.ToInt32(lbApprovers.SelectedValue))
.Select(u => u.UserName).First();
if (!Roles.IsUserInRole(approverUsername, "TimesheetApprover"))
{
Roles.AddUserToRole(approverUsername, "TimesheetApprover");
}
//P-Level update
//if exists on dateupdated, update
if (ff.EmployeePersonLevels
.Where(ep => (ep.empId == Convert.ToInt32(lblEmpId.Text)) && ep.dateUpdated == DateTime.Now.Date)
.Count() > 0)
{
EmployeePersonLevel epl = ff.EmployeePersonLevels
.Where(ep => (ep.empId == Convert.ToInt32(lblEmpId.Text)) && ep.fiscalYear == DateTime.Now.Year)
.OrderByDescending(ep => ep.dateUpdated)
.First();
epl.pLevel = ddlPLevel.SelectedValue;
epl.dateUpdated = DateTime.Now.Date;
}
//if does not exist on dateupdated, create new
else
{
EmployeePersonLevel epl = new EmployeePersonLevel()
{
empId = Convert.ToInt32(lblEmpId.Text),
fiscalYear = DateTime.Now.Year,
pLevel = ddlPLevel.SelectedValue,
dateUpdated = DateTime.Now.Date
};
ff.EmployeePersonLevels.InsertOnSubmit(epl);
}
//DB SubmitChanges
try
{
ff.SubmitChanges();
}
catch (Exception ex)
{
lblUserEditError.Text = ex.Message;
lblUserEditError.ForeColor = System.Drawing.Color.Red;
return;
}
lblUserEditError.Text = "User Has been updated. Show all users to see changes.";
lblUserEditError.ForeColor = System.Drawing.Color.ForestGreen;
}
//Adds the newly created user to the Employee table and links them together in EmployeeMembership
protected void cuwCreateUser_CreatedUser(object sender, EventArgs e)
{
string tmpFirstName = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("FirstName")).Text;
string tmpLastName = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("LastName")).Text;
string tmpSupervisor = ((ListBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("SupervisorList")).SelectedValue;
string tmpApprover = ((ListBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("ApproverList")).SelectedValue;
string tmpEmpID = ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("EmployeeID")).Text;
CheckBoxList tempCheck = (CheckBoxList)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("RoleList");
for (int i = 0; i < tempCheck.Items.Count; i++)
{
if (tempCheck.Items[i].Selected)
{
Roles.AddUserToRole(((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("UserName")).Text
, tempCheck.Items[i].Text);
}
}
Employee emp = new Employee()
{
firstName = tmpFirstName,
lastName = tmpLastName,
empId = Convert.ToInt32(tmpEmpID),
supervisor = Convert.ToInt32(tmpSupervisor),
approver = Convert.ToInt32(tmpApprover),
minHoursPerWeek = 0,
vacationLeave = 0,
sickDays = 0,
flexHours = 0,
isActive = 1
};
//Employee table updated
ff.Employees.InsertOnSubmit(emp);
//EmployeeMembership updated (link created here)
ff.EmployeeMemberships.InsertOnSubmit(new EmployeeMembership
{
empId = Convert.ToInt32(tmpEmpID),
userId = ff.aspnet_Users
.Where(u => u.UserName == ((TextBox)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("UserName")).Text)
.ToArray()[0].UserId
});
//PLevel Entry Created and submitted
EmployeePersonLevel epl = new EmployeePersonLevel()
{
dateUpdated = DateTime.Now.Date,
empId = Convert.ToInt32(tmpEmpID),
//Fiscal Year is not DateTime.Now.Year but for lack of time it will be
fiscalYear = DateTime.Now.Year,
pLevel = ((DropDownList)wsEmployeeAccountInfo.ContentTemplateContainer.FindControl("ddlPLevel")).SelectedValue,
};
ff.EmployeePersonLevels.InsertOnSubmit(epl);
ff.SubmitChanges();
//Adds selected Approver to the TSApprover Role if they are not in it already
string approverUsername = ff.vw_EmployeeInRolewFirstLastNameEmpIDUserIDs.Where(em => em.empId == Convert.ToInt32(tmpApprover)).Select(u => u.UserName).First();
if (!Roles.IsUserInRole(approverUsername, "TimesheetApprover"))
{
Roles.AddUserToRole(approverUsername, "TimesheetApprover");
}
}
