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); } }