using System;
using Database.Database;
using Microsoft.EntityFrameworkCore;

namespace CMS.Worker.Utils
{
    public class DbHelper
    {
        private ModelContext _dbContext;

        private DbContextOptions<ModelContext> GetAllOptions(string connection)
        {
            DbContextOptionsBuilder<ModelContext> optionsBuilder =
                new DbContextOptionsBuilder<ModelContext>();

            string connectionString = connection;

            optionsBuilder.UseOracle(connectionString);

            return optionsBuilder.Options;
        }

        public ModelContext GetDbContext(string connection)
        {
            return new ModelContext(GetAllOptions(connection));
        }
    }
}