protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
db = null;
}
base.Dispose(disposing);
}
protected override void Dispose(bool disposing)
{
if (disposing && _db != null)
{
_db.Dispose();
_db = null;
}
base.Dispose(disposing);
}
protected virtual void Dispose(bool disposing)
{
if (disposing && _context != null)
{
_context.Dispose();
_context = null;
_disposed = true;
}
}
public ActionResult Index()
{
List <Product> product;
using (UpdateDbContext db = new UpdateDbContext())
{
// var products = db.Products.Include(p => p.Category);
product = db.Products.ToList();
var cat = db.Categorys.ToList();
string s = "sadsa";
}
return(View(product));
}
public override async Task ReassignCourseSpecializationsAsync(UpdateDbContext context, bool useArchiveData = false)
{
if (!IsInitialized)
{
throw new InvalidOperationException(Resources.InvalidOperation_PluralsightCatalog_InitializeMethodInvokeRequired);
}
if (context == null)
{
throw new ArgumentNullException("context");
}
var allCourses = await context.Courses
.Where(x => x.TrainingProviderId == TrainingProviderId && !x.IsDeleted)
.Select(x => new
{
x.Id,
x.UrlName,
CourseSpecializations = x.CourseSpecializations.ToList()
})
.AsNoTracking()
.ToListAsync();
var courseSpecializationsContainer = await GetCourseSpecializationsContainerAsync(useArchiveData);
try
{
context.Configuration.AutoDetectChangesEnabled = false;
foreach (var dbCourse in allCourses)
{
Specializations specializationsForCourse;
if (courseSpecializationsContainer.TryGetValue(dbCourse.UrlName, out specializationsForCourse))
{
var currentSpecializations = specializationsForCourse.GetFlags <Specializations>().ToList();
foreach (var dbCourseSpecialization in dbCourse.CourseSpecializations)
{
if (currentSpecializations.Contains(dbCourseSpecialization.Specialization))
{
currentSpecializations.Remove(dbCourseSpecialization.Specialization);
}
else
{
context.SetStateToDeleted(dbCourseSpecialization);
}
}
foreach (var specialization in currentSpecializations)
{
var courseSpecialization = new CourseSpecialization
{
CourseId = dbCourse.Id,
Specialization = specialization
};
context.SetStateToAdded(courseSpecialization);
}
}
}
}
finally
{
context.Configuration.AutoDetectChangesEnabled = true;
}
await context.SaveChangesAsync();
}
CreateUpdateProcessor(UpdateDbContext context, bool logUpdateToDb)
{
var updateProcessor = new PluralsightUpdateProcessor(TrainingProviderId, context, _backupProcessor, logUpdateToDb);
return(updateProcessor);
}
/// <exception cref="ArgumentNullException">
/// <paramref name="context" /> or
/// <paramref name="catalogBackupProcessor" /> is <see langword="null" />.</exception>
public PluralsightUpdateProcessor(int trainingProviderId, UpdateDbContext context,
ICatalogBackupProcessor <PluralsightCategory, PluralsightCourse, PluralsightAuthor> catalogBackupProcessor,
bool logUpdateToDb)
: base(trainingProviderId, context, catalogBackupProcessor, logUpdateToDb)
{
}
protected CatalogManagerBase(UpdateDbContext context)
{
_context = context;
}
public SyndicationFeedsManager(UpdateDbContext context)
: base(context)
{
}
public AuthorsManager(UpdateDbContext context)
: base(context)
{
}
public TrainingProvidersManager(UpdateDbContext context)
: base(context)
{
}
public LearningPlanManager(UpdateDbContext context)
: base(context)
{
}
public CategoriesManager(UpdateDbContext context)
: base(context)
{
}
public HomeManager(UpdateDbContext context) : base(context)
{
}
public CoursesManager(UpdateDbContext context)
: base(context)
{
}
