protected void btnDelegate_Click(object sender, EventArgs e)
{
int result;
TemporaryRole newTemporaryRole = new TemporaryRole();
newTemporaryRole.TemporaryRoleId = "ActHead";
newTemporaryRole.EmployeeId = Convert.ToInt32(hfSelectedEmployeeId.Value);
DateTime StartDate, EndDate;
if (!DateTime.TryParse(tbStartDate.Text, out StartDate) || !DateTime.TryParse(tbEndDate.Text, out EndDate))
{
result = 0;
}
else
{
newTemporaryRole.StartDate = StartDate;
newTemporaryRole.EndDate = EndDate;
}
result = authMgmt.CreateTemporaryAssignment(newTemporaryRole);
if (result != 0)
{
PanelGoodMessage.Visible = true;
lblGoodMessage.Text = "The delegation of Acting Department Head is successful.";
BindGrid();
}
else
{
PanelFailMessage.Visible = true;
lblFailMessage.Text = "The delegation of Acting Department Head is unsuccessful. Please try again.";
}
}
public string AddAssignment(Assignment a)
{
string result = "false";
DateTime StartDate, EndDate;
string format = "dd-MM-yyyy";
TemporaryRole temporaryRole = new TemporaryRole()
{
TemporaryRoleId = a.TemporaryRoleId,
EmployeeId = Convert.ToInt32(a.EmployeeId)
};
if (DateTime.TryParseExact(a.StartDate, format, CultureInfo.InvariantCulture, DateTimeStyles.None, out StartDate) && DateTime.TryParseExact(a.EndDate, format, CultureInfo.InvariantCulture, DateTimeStyles.None, out EndDate))
{
temporaryRole.StartDate = StartDate;
temporaryRole.EndDate = EndDate;
}
int outcome = tempRoleSer.CreateTemporaryRole(temporaryRole);
if (outcome == 1)
{
result = "true";
}
return(result);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int result;
int actingHeadEmpId = Convert.ToInt32(hfActingHeadEmployeeId.Value);
TemporaryRole existingTemporaryRole = authMgmt.SearchAssignmentByEmpId(actingHeadEmpId);
DateTime StartDate, EndDate;
if (!DateTime.TryParse(tbStartDate.Text, out StartDate) || !DateTime.TryParse(tbEndDate.Text, out EndDate))
{
result = 0;
}
else
{
existingTemporaryRole.StartDate = StartDate;
existingTemporaryRole.EndDate = EndDate;
}
result = authMgmt.UpdateTemporaryAssignment(existingTemporaryRole);
if (result > 0)
{
PanelGoodMessage.Visible = true;
lblGoodMessage.Text = "The delegation of Current Acting Department Head has been updated";
BindGrid();
}
else
{
PanelFailMessage.Visible = true;
lblFailMessage.Text = "The update of delegation of Current Acting Department Head is unsuccessful. Please try again.";
}
}
public int CreateAssignment(TemporaryRole temporaryRole)
{
try
{
ssae.TemporaryRoles.Add(temporaryRole);
return(ssae.SaveChanges()); // returns 1
}
catch (Exception)
{
return(0); // 0 rows added
}
}
public int DeleteAssignment(int empId)
{
try
{
TemporaryRole tr = ssae.TemporaryRoles.Where(x => x.EmployeeId == empId).FirstOrDefault();
ssae.TemporaryRoles.Remove(tr);
return(ssae.SaveChanges()); // returns 1
}
catch (Exception)
{
return(0); // 0 rows added
}
}
public IActionResult GiveTemporaryRole(int userId,
int roleId,
int eventId)
{
List <string> errors = new List <string>();
User user = Context.User.FirstOrDefault(f => f.Id == userId);
Role role = Context.Role.FirstOrDefault(f => f.Id == roleId);
Event @event = Context.Event.FirstOrDefault(ff => ff.Id == eventId);
if (role == null)
{
errors.Add("Role not found");
}
if (user == null)
{
errors.Add("User not found");
}
if (@event == null || [email protected]())
{
errors.Add("Event not found or expired");
}
if (errors.Count > 0)
{
return(NotFound(errors));
}
// Is already ann event ?
if (Context.TemporaryRoles.Any(tt => tt.EventId == eventId &&
tt.UserId == userId &&
tt.RoleId == roleId))
{
return(BadRequest("User Already has this role"));
}
TemporaryRole temp = new TemporaryRole()
{
RoleId = roleId,
EventId = eventId,
UserId = userId
};
try {
Context.TemporaryRoles.Add(temp);
Context.SaveChanges();
} catch (DbUpdateException e) {
return(BadRequest(e.InnerException.Message));
}
return(Ok());
}
public bool IsActingHead(string userName)
{
int empId = SearchEmployeeByUserName(userName).EmployeeId;
TemporaryRole temporaryRole = tempRoleSer.SearchTemporaryRoleByEmpId(empId);
if (temporaryRole == null || DateTime.Compare(DateTime.Now.Date, temporaryRole.StartDate.Date) < 0 || DateTime.Compare(DateTime.Now.Date, temporaryRole.EndDate.Date) > 0)
{
return(false);
}
else
{
return(true);
}
}
public int UpdateAssignment(TemporaryRole temporaryRole)
{
try
{
TemporaryRole tr = ssae.TemporaryRoles.Where(x => x.EmployeeId == temporaryRole.EmployeeId).FirstOrDefault();
tr.StartDate = temporaryRole.StartDate;
tr.EndDate = temporaryRole.EndDate;
return(ssae.SaveChanges()); // returns 1
}
catch (Exception)
{
return(0); // 0 rows updated
}
}
public IActionResult RemoveTempRole(int tempRoleId)
{
TemporaryRole temporary = Context.TemporaryRoles
.FirstOrDefault((arg) => arg.Id == tempRoleId);
if (temporary == null)
{
return(NotFound("Role not Found"));
}
try {
Context.TemporaryRoles.Remove(temporary);
Context.SaveChanges();
} catch (DbUpdateException e) {
return(BadRequest(e.InnerException.Message));
}
return(Ok());
}
private void BindGrid()
{
// Bind current acting director
actingHead = authMgmt.SearchCurrentActingHead(deptId);
if (actingHead != null)
{
temporaryRole = authMgmt.SearchAssignmentByEmpId(actingHead.EmployeeId);
tbEmpName.Text = actingHead.EmployeeName;
tbStartDate.Text = temporaryRole.StartDate.ToString("yyyy-MM-dd");
tbEndDate.Text = temporaryRole.EndDate.ToString("yyyy-MM-dd");
hfActingHeadEmployeeId.Value = actingHead.EmployeeId.ToString();
btnRemove.Visible = true;
btnUpdate.Visible = true;
btnDelegate.Visible = false;
if (DateTime.Compare(DateTime.Now.Date, temporaryRole.StartDate.Date) > 0)
{
tbStartDate.Enabled = false;
tbEndDate.Attributes["min"] = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
tbStartDate.Attributes["min"] = DateTime.Now.ToString("yyyy-MM-dd");
tbEndDate.Attributes["min"] = DateTime.Now.ToString("yyyy-MM-dd");
}
}
else
{
tbEmpName.Text = "";
tbStartDate.Text = "";
tbEndDate.Text = "";
hfActingHeadEmployeeId.Value = "";
btnRemove.Visible = false;
btnUpdate.Visible = false;
btnDelegate.Visible = true;
tbStartDate.Enabled = true;
tbStartDate.Attributes["min"] = DateTime.Now.ToString("yyyy-MM-dd");
tbEndDate.Attributes["min"] = DateTime.Now.ToString("yyyy-MM-dd");
}
BindGridView();
}
public Assignment SearchAssignment(string deptId)
{
Assignment assignment = null;
Employee emp = SearchCurrentActingHead(deptId);
if (emp != null)
{
TemporaryRole temporaryRole = tempRoleSer.SearchTemporaryRoleByEmpId(emp.EmployeeId);
if (temporaryRole != null)
{
assignment = new Assignment()
{
EmployeeName = emp.EmployeeName,
TemporaryRoleId = temporaryRole.TemporaryRoleId,
EmployeeId = temporaryRole.EmployeeId.ToString(),
StartDate = temporaryRole.StartDate.ToString("dd-MM-yyyy"),
EndDate = temporaryRole.EndDate.ToString("dd-MM-yyyy")
};
}
}
return(assignment);
}
public int CreateTemporaryRole(TemporaryRole temporaryRole)
{
return(tempRoleSer.CreateTemporaryRole(temporaryRole));
}
public int UpdateTemporaryRole(TemporaryRole temporaryRole)
{
return(tempRoleSer.UpdateTemporaryRole(temporaryRole));
}
public int CreateTemporaryAssignment(TemporaryRole temporaryRole)
{
return(tempRoleSer.CreateAssignment(temporaryRole));
}
