public bool AddAssignment(Assignment dataToAdd, out int id)
{
try
{
using (var context = new TrainingTrackerEntities())
{
EntityFramework.Assignment newEntity = new EntityFramework.Assignment
{
Name = dataToAdd.Name,
Description = dataToAdd.Description,
AddedBy = dataToAdd.AddedBy,
IsActive = dataToAdd.IsActive,
CreatedOn = dataToAdd.CreatedOn,
AssignmentAsset = dataToAdd.AssignmentAsset
};
context.Assignments.Add(newEntity);
context.SaveChanges();
id = newEntity.Id;
AddAssignmentSubtopicMapping(id, dataToAdd.CourseSubtopicId);
return(true);
}
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
id = 0;
return(false);
}
}
public bool UpdateAssignment(Assignment dataToUpdate)
{
try
{
using (var context = new TrainingTrackerEntities())
{
var entity = context.Assignments.Where(a => a.IsActive && a.Id == dataToUpdate.Id).FirstOrDefault();
entity.AssignmentAsset = dataToUpdate.AssignmentAsset;
entity.Description = dataToUpdate.Description;
entity.Name = dataToUpdate.Name;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
return(false);
}
}
public bool UpdateAssignmentProgress(Assignment data)
{
try
{
using (var context = new TrainingTrackerEntities())
{
var entity = context.AssignmentUserMaps.Where(s => s.AssignmentId == data.Id && s.TraineeId == data.TraineeId).FirstOrDefault();
if (entity == null)
{
var newEntity = new EntityFramework.AssignmentUserMap
{
IsApproved = false,
IsCompleted = true,
AssignmentId = data.Id,
TraineeId = data.TraineeId
};
context.AssignmentUserMaps.Add(newEntity);
}
else if (!entity.IsApproved) // do not update the data if the assignment is already updated.
{
entity.IsCompleted = data.IsCompleted;
entity.IsApproved = data.IsApproved;
entity.ApprovedBy = data.ApprovedBy;
}
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
LogUtility.ErrorRoutine(ex);
return(false);
}
}
