/// <summary>
/// Method for fetching an activity by id
/// </summary>
/// <param name="activityId"></param>
/// <param name="currentUser"></param>
/// <returns></returns>
public async Task <StaffPlannerAc> GetStaffPlanByIdAsync(int plannerId, ApplicationUser currentUser)
{
int currentUserInstituteId = await _instituteUserMappingHelperService.GetUserCurrentSelectedInstituteIdAsync(currentUser.Id, true);
StaffPlanner staffPlan = await _imsDbContext.StaffPlanners
.Include(x => x.Staff)
.Include(x => x.PlannerAttendeeMappings)
.FirstOrDefaultAsync(x => x.Id == plannerId && x.InstituteId == currentUserInstituteId);
StaffPlannerAc staffPlanAc = new StaffPlannerAc
{
Id = staffPlan.Id,
Name = staffPlan.Name,
Description = staffPlan.Description,
DateOfPlan = staffPlan.DateOfPlan,
IsActive = staffPlan.IsActive,
StaffId = staffPlan.StaffId,
StaffName = staffPlan.Staff.FirstName,
InstituteId = staffPlan.InstituteId,
PlannerAttendeeList = new List <StaffPlannerAttendeeMappingAc>()
};
List <ApplicationUser> plannerAttendeesList = await _imsDbContext.PlannerAttendeeMappings
.Where(x => x.PlannerId == plannerId)
.Include(x => x.Attendee)
.Select(x => x.Attendee)
.ToListAsync();
List <StudentBasicInformation> studentBasicInformationList = await _imsDbContext.StudentBasicInformation.Where(x => x.InstituteId == currentUserInstituteId).ToListAsync();
List <StaffBasicPersonalInformation> staffBasicPersonalInformationList = await _imsDbContext.StaffBasicPersonalInformation.Where(x => x.InstituteId == currentUserInstituteId).ToListAsync();
foreach (PlannerAttendeeMapping plannerAttendeeMapping in staffPlan.PlannerAttendeeMappings)
{
string attendeeName = plannerAttendeesList.FirstOrDefault(x => x.Id == plannerAttendeeMapping.AttendeeId)?.Name;
if (plannerAttendeeMapping.ActivityAttendeeType == ActivityAttendeeTypeEnum.Staff)
{
attendeeName = staffBasicPersonalInformationList.FirstOrDefault(x => x.UserId == plannerAttendeeMapping.AttendeeId).FirstName;
}
else if (plannerAttendeeMapping.ActivityAttendeeType == ActivityAttendeeTypeEnum.Student)
{
attendeeName = studentBasicInformationList.FirstOrDefault(x => x.UserId == plannerAttendeeMapping.AttendeeId).FirstName;
}
staffPlanAc.PlannerAttendeeList.Add(new StaffPlannerAttendeeMappingAc
{
PlannerId = staffPlan.Id,
PlannerName = staffPlan.Name,
PlannerAttendeeType = plannerAttendeeMapping.ActivityAttendeeType,
PlannerAttendeeTypeString = EnumHelperService.GetDescription(plannerAttendeeMapping.ActivityAttendeeType),
AttendeeId = plannerAttendeeMapping.AttendeeId,
AttendeeName = attendeeName
});
}
return(staffPlanAc);
}
/// <summary>
/// Method for updating an existing activity
/// </summary>
/// <param name="activityId"></param>
/// <param name="updatedStaffActivity"></param>
/// <param name="currentUser"></param>
/// <returns></returns>
public async Task <dynamic> UpdateStaffPlanAsync(int planId, StaffPlannerAc updatedStaffPlanAc, ApplicationUser currentUser)
{
int currentUserInstituteId = await _instituteUserMappingHelperService.GetUserCurrentSelectedInstituteIdAsync(currentUser.Id, true);
StaffPlanner existingStaffPlan = await _imsDbContext.StaffPlanners.FirstOrDefaultAsync(x => x.Id == planId && x.InstituteId == currentUserInstituteId);
if (existingStaffPlan == null)
{
return(new { Message = "No plan exist with this id", HasError = true });
}
else if (await _imsDbContext.StaffPlanners.AnyAsync(x => x.Id != planId && x.InstituteId == currentUserInstituteId &&
x.Name.ToLowerInvariant().Equals(updatedStaffPlanAc.Name.ToLowerInvariant()) &&
x.DateOfPlan == updatedStaffPlanAc.DateOfPlan))
{
return(new { Message = "Plan already exist with this name on the selected date", HasError = true });
}
else
{
// Update planner
existingStaffPlan.Name = updatedStaffPlanAc.Name;
existingStaffPlan.Description = updatedStaffPlanAc.Description;
existingStaffPlan.DateOfPlan = updatedStaffPlanAc.DateOfPlan;
existingStaffPlan.IsActive = updatedStaffPlanAc.IsActive;
existingStaffPlan.StaffId = updatedStaffPlanAc.StaffId;
_imsDbContext.StaffPlanners.Update(existingStaffPlan);
await _imsDbContext.SaveChangesAsync();
// Update planner attendee
List <PlannerAttendeeMapping> plannerAttendeeMappingsList = await _imsDbContext.PlannerAttendeeMappings
.Where(x => x.PlannerId == existingStaffPlan.Id).ToListAsync();
_imsDbContext.PlannerAttendeeMappings.RemoveRange(plannerAttendeeMappingsList);
await _imsDbContext.SaveChangesAsync();
await AddPlannerAttendeeAsync(existingStaffPlan.Id, updatedStaffPlanAc.PlannerAttendeeList);
// Add notification
if (existingStaffPlan.IsActive)
{
await AddNotificationsAsync(currentUserInstituteId, currentUser, updatedStaffPlanAc);
}
return(new { Message = "Plan updated successfully" });
}
}
/// <summary>
/// Method for adding new activity
/// </summary>
/// <param name="newStaffActivity"></param>
/// <param name="currentUser"></param>
/// <returns></returns>
public async Task <dynamic> AddStaffPlanAsync(StaffPlannerAc newStaffPlanAc, ApplicationUser currentUser)
{
int currentUserInstituteId = await _instituteUserMappingHelperService.GetUserCurrentSelectedInstituteIdAsync(currentUser.Id, true);
if (await _imsDbContext.StaffPlanners.AnyAsync(x => x.InstituteId == currentUserInstituteId &&
x.Name.ToLowerInvariant().Equals(newStaffPlanAc.Name.ToLowerInvariant()) && x.DateOfPlan == newStaffPlanAc.DateOfPlan))
{
return(new { Message = "Plan already exist with this name on the selected date", HasError = true });
}
else
{
// Add activity
StaffPlanner newStaffPlan = new StaffPlanner
{
CreatedOn = DateTime.UtcNow,
DateOfPlan = newStaffPlanAc.DateOfPlan,
Description = newStaffPlanAc.Description,
InstituteId = currentUserInstituteId,
IsActive = newStaffPlanAc.IsActive,
Name = newStaffPlanAc.Name,
StaffId = newStaffPlanAc.StaffId
};
_imsDbContext.StaffPlanners.Add(newStaffPlan);
await _imsDbContext.SaveChangesAsync();
// Add activity attendee
await AddPlannerAttendeeAsync(newStaffPlan.Id, newStaffPlanAc.PlannerAttendeeList);
// Add notification
if (newStaffPlan.IsActive)
{
await AddNotificationsAsync(currentUserInstituteId, currentUser, newStaffPlanAc);
}
return(new { Message = "Plan created successfully" });
}
}
