public Project GetProjectWithActivities(int projectId)
{
DataSets.Project project = db.Projects.AsNoTracking()
.Include(k => k.Tasks)
.ThenInclude(k => k.TimeSheetTasks)
.ThenInclude(k => k.Activities)
.Include(k => k.Tasks)
.ThenInclude(k => k.TimeSheetTasks)
.ThenInclude(k => k.Activities)
.Where(k => k.ID == projectId).FirstOrDefault();
return(project == null ? null : _mapper.Map <DataContract.Project>(project));
}
private void AddRemoveTeamsProjects(ProjectSaveModel model, DataSets.Project dbProject)
{
// remove all items not in the model
dbProject.TeamsProjects.RemoveAll(k => !model.teamsIds.Contains(k.TeamId));
// remove all items in the model that are already in db
model.teamsIds.RemoveAll(k => dbProject.TeamsProjects.Any(t => t.TeamId == k));
// add the rest
if (model.teamsIds.Count > 0)
{
dbProject.TeamsProjects.AddRange(model.teamsIds.Select(k => new DataSets.TeamsProjects()
{
ProjectId = dbProject.ID,
TeamId = k
}));
}
}
public DateFilterModel GetProjectWithActivities(int projectId, int?year, int?month)
{
DateFilterModel model = new DateFilterModel();
DataSets.Project project = db.Projects.AsNoTracking()
.Include(k => k.Tasks)
.ThenInclude(k => k.TimeSheetTasks)
.ThenInclude(k => k.Activities)
.Where(k => k.ID == projectId)
.FirstOrDefault();
if (project == null)
{
return(model);
}
List <DateTime> dates = new List <DateTime>();
foreach (DataSets.ProjectTask item in project.Tasks)
{
foreach (DataSets.TimeSheetTask timeSheetProject in item.TimeSheetTasks)
{
foreach (DataSets.TimeSheetActivity timeSheetActivity in timeSheetProject.Activities)
{
if (timeSheetActivity.ToDate.HasValue)
{
dates.Add(timeSheetActivity.FromDate);
}
}
}
}
model = ParseDatesToFilterModel(dates, year, month);
return(model);
}
public async Task <Project> Save(ProjectSaveModel model)
{
if (model.categoryId == 0 || string.IsNullOrEmpty(model.title))
{
throw new ClientException("title and category are required");
}
if (model.startDate.HasValue)
{
if (model.plannedEnd.HasValue && model.plannedEnd.Value <= model.startDate.Value)
{
throw new ClientException("Planned Date must be greater than Start Date");
}
if (model.actualEnd.HasValue && model.actualEnd.Value <= model.startDate.Value)
{
throw new ClientException("Actual Date must be greater than Start Date");
}
}
if (model.id.HasValue)
{
// check if title already exist under the selected category
bool nameExist = db.Projects.Any(k => k.ID != model.id.Value && k.Title == model.title && k.CategoryId == model.categoryId);
if (nameExist)
{
throw new ClientException($"project exist under title {model.title} and the selected category");
}
// # save project #
// get project
var dbProject = db.Projects
.Include(k => k.TeamsProjects)
.Include(k => k.ProjectStatusModifications)
.FirstOrDefault(k => k.ID == model.id.Value);
if (dbProject == null)
{
throw new ClientException("record not found");
}
// check if status changed
bool statusChanged = dbProject.StatusCode != model.statusCode || dbProject.StatusByUserId != model.GetStatusByUserId();
if (statusChanged)
{
// append project's status modification
dbProject.ProjectStatusModifications.Add(new DataSets.ProjectStatusModification()
{
ProjectId = dbProject.ID,
StatusCode = dbProject.StatusCode,
DateModified = DateTime.Now,
ModifiedByUserId = dbProject.StatusByUserId
});
await NotifyAdmins(model.GetStatusByUserId(), $"project status was changed", dbProject.ID);
}
// update values
dbProject.Title = model.title;
dbProject.Description = model.description;
dbProject.CategoryId = model.categoryId;
dbProject.StartDate = model.startDate;
dbProject.PlannedEnd = model.plannedEnd;
dbProject.ActualEnd = model.actualEnd;
dbProject.LastModifiedDate = DateTime.Now;
dbProject.StatusCode = model.statusCode;
dbProject.StatusByUserId = model.GetStatusByUserId();
AddRemoveTeamsProjects(model, dbProject);
db.SaveChanges();
return(GetById(dbProject.ID));
}
else
{
// # new task #
// check if title already exist under the selected category
bool nameExist = db.Projects.Any(k => k.Title == model.title && k.CategoryId == model.categoryId);
if (nameExist)
{
throw new ClientException($"project exist under title {model.title} and the selected category");
}
DataSets.Project dbProject = new DataSets.Project()
{
Title = model.title,
Description = model.description,
DateAdded = DateTime.Now,
CategoryId = model.categoryId,
StartDate = model.startDate,
PlannedEnd = model.plannedEnd,
ActualEnd = model.actualEnd,
StatusCode = model.statusCode,
StatusByUserId = model.GetStatusByUserId(),
AddedByUserId = model.GetStatusByUserId()
};
// add the project
db.Projects.Add(dbProject);
// save changes on project
db.SaveChanges();
// add the teams to the saved project
db.TeamsProjects.AddRange(model.teamsIds.Select(k => new DataSets.TeamsProjects()
{
ProjectId = dbProject.ID,
TeamId = k
}));
// save changes on teamsprojects
db.SaveChanges();
// notify admin of new project
await NotifyAdmins(model.GetStatusByUserId(), $"new project was added", dbProject.ID);
return(GetById(dbProject.ID));
}
}
