private void DeleteOldUserAccessTokens(decimal userId, DateTime now, DragonflyEntities context)
{
var userAccesses =
(from userAccess in context.User_Access
where userAccess.ID_User == userId &&
DbFunctions.TruncateTime(userAccess.Date_Expiration) < now.Date
select userAccess);
DeleteAccessTokens(userAccesses, context);
}
private Project RetrieveProjectById(decimal projectId, DragonflyEntities context)
{
try
{
return((from p in context.Project
where p.ID_Project == projectId
select p).FirstOrDefault());
}
catch (Exception ex)
{
throw new InvalidOperationException("Unable to retrieve a project.", ex);
}
}
private void DeleteAccessTokens(IQueryable <User_Access> userAccesses, DragonflyEntities context)
{
if (userAccesses.Count() > 0)
{
context.User_Access.RemoveRange(userAccesses);
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{//TODO log
}
}
private void SaveExistingProjectInDB(Project project, DragonflyEntities context)
{
try
{
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
context.Project.Remove(project);
List <ValidationError> validationErrors = ex.RetrieveValidationsErrors();
throw new InsertDbDataException(validationErrors);
}
catch (DbUpdateException ex)
{
context.Project.Remove(project);
throw new InvalidOperationException("Unable to save project", ex);
}
}
private void KeepUserProject(decimal projectId, User_Project usProj, DragonflyEntities context)
{
try
{
context.User_Project.Add(usProj);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
context.User_Project.Remove(usProj);
List <ValidationError> validationErrors = ex.RetrieveValidationsErrors();
DeleteProject(projectId);
throw new InsertDbDataException(validationErrors);
}
catch (DbUpdateException ex)
{
context.User_Project.Remove(usProj);
DeleteProject(projectId);
throw new InvalidOperationException("Unable to save user-project relation", ex);
}
}