public void TestSetup()
{
InitializeDB db = new InitializeDB();
Database.SetInitializer(db);
repository = new PhaseRepository();
}
private void button1_Click(object sender, EventArgs e)
{
setButtonPressed(button1);
InitializeDB uc = new InitializeDB();
openNewPanel(uc);
}
public void InitializeAnswersDBTest()
{
InitializeDB initializeDB = new InitializeDB();
var answers = initializeDB.InitializeAnswersDB();
Assert.IsNotNull(answers);
}
public User Authenticate(string code)
{
var initialize = new InitializeDB(this.configuration);
this.users = initialize.GetUsers();
user = this.users.SingleOrDefault(x => x.Code == code);
if (user == null)
{
return(null);
}
// аутентификация пройдена генерируем токен
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(this.appSettings.Secret);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.Id.ToString())
}),
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
user.Token = tokenHandler.WriteToken(token);
// удаляем код(пароль перед удалением)
user.Code = null;
return(user);
}
private void VerificaDB()
{
//string dataDirectory = AppDomain.CurrentDomain.GetData("DataDirectory") as string;
using (PavimentalContext db = new PavimentalContext())
{
//Se esiste verifico che sia compatibile
if (db.Database.Exists())
{
bool compatibile = db.Database.CompatibleWithModel(false);
if (!compatibile)
{
db.Database.Delete();
db.Database.Create();
InitializeDB.InitalizeAll();
}
}
else
{
db.Database.Create();
InitializeDB.InitalizeAll();
}
//Faccio questa query per ottimizzare le successive
var temp = db.ConoscenzaCompetenze.ToList();
}
}
public void TestSetup()
{
InitializeDB db = new InitializeDB();
System.Data.Entity.Database.SetInitializer(db);
EmployeesRepo = new BaseRepository <Employee>();
}
public bool AnswerQuestion(string json)
{
try
{
var answer = JsonConvert.DeserializeObject <Dictionary <string, string> >(json);
int question = 0;
Int32.TryParse(answer["Question"], out question);
string answers = answer["Answer"];
var inializeDb = new InitializeDB(this.configuration);
this.questions = inializeDb.InitializeQuestionsDB();
this.variants = inializeDb.InitializeAnswersDB();
var qId = this.questions.Where(x => x.Id == question)
.Select(x => x.Id).FirstOrDefault();
var qIdVariants = this.variants.Where(x => x.QuestionsId == qId)
.Select(x => new { Answer = x.Answer, Correct = x.Correct });
var verdict = qIdVariants.Where(x => x.Answer == answers)
.Select(x => x.Correct).FirstOrDefault();
return(verdict);
}
catch (System.Exception)
{
throw;
}
}
public Task Invoke(HttpContext httpContext, HotelContext db)
{
if (!(httpContext.Session.Keys.Contains("starting")))
{
InitializeDB.Initialize(db);
httpContext.Session.SetString("starting", "Yes");
}
return(_next.Invoke(httpContext));
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
GetAppTheme();
InitializeDB.InitializeDatabase();
CresteUserFolderIfNotExists();
}
protected override void Seed(PavimentalContext context)
{
base.Seed(context);
DbContextAdapter adapter = new DbContextAdapter(context);
InitializeDB initializer = new InitializeDB(context);
initializer.InitalizeAll();
}
void InizializzaDB()
{
using (PavimentalContext db = new PavimentalContext())
{
db.Database.Delete();
db.Database.Create();
}
InitializeDB.InitalizeAll();
}
public List <int> RandomQuestionIds()
{
var initializeDb = new InitializeDB(this.configuration);
var questionIds = initializeDb.InitializeQuestionsDB().Count;
var RandomIds = new List <int>(Enumerable.Range(1, questionIds));
RandomIds.Shuffle();
return(RandomIds);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
InitializeDB.CreateDBTable();
}
public void InitializeQuestionsDBTest()
{
// Arrange
InitializeDB initializeDB = new InitializeDB();
// Act
var questions = initializeDB.InitializeQuestionsDB();
// Assert
Assert.IsNotNull(questions);
}
public void GetUsersTest()
{
// Arrange
InitializeDB initializeDB = new InitializeDB();
// Act
var users = initializeDB.GetUsers();
// Assert
Assert.IsNotNull(users);
}
protected void Application_Start()
{
InitializeDB.Init();
var container = new ServiceContainer();
container.RegisterApiControllers();
container.EnableWebApi(GlobalConfiguration.Configuration);
RegisterServices(container);
GlobalConfiguration.Configure(WebApiConfig.Register);
}
public async Task <IActionResult> PopulateDb()
{
try
{
var populate = new InitializeDB(this.configuration);
await Task.Run(() => populate.InitializeData());
return(this.Ok(new { message = "База добавлена" }));
}
catch (System.Exception ex)
{
return(this.BadRequest(new { message = ex.ToString() }));
}
}
public string GetNextQuestion(int questionId)
{
if (questionId != 0)
{
var inializeDb = new InitializeDB(this.configuration);
this.questions = inializeDb.InitializeQuestionsDB();
this.variants = inializeDb.InitializeAnswersDB();
var question = this.questions.Where(x => x.Id == questionId).FirstOrDefault();
var answers = this.variants.Where(x => x.QuestionsId == questionId)
.Select(x => x.Answer).ToArray();
return(this.CreateJsonQuestion(question, answers));
}
return("Не верный id");
}
private static void CreateDbIfNotExists(IHost host)
{
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService <EventFinderDBC>();
context.Database.Migrate();
InitializeDB.SeedDB(context);
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred creating the DB.");
}
}
}
public static void Main(string[] args)
{
var host = CreateHostBuilder(args).Build();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService <MarcetContext>();
InitializeDB.Initialize(context);
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred seeding the DB.");
}
}
host.Run();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, DataContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseCors(x => x.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader());
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
InitializeDB.Initialize(context);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseDefaultFiles();
app.UseStaticFiles();
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
InitializeDB.InitDatabase(app);
}
public RepositoryTests()
{
_newMovie = new Movie
{
Cast = "Mock",
Description = "Mock",
Director = "Mocking Director",
Favourite = true,
IMDBRating = 1,
MovieId = Guid.Parse("11111111-1111-1111-1111-111111111111"),
Name = "Mock Movie",
Year = DateTime.Now
};
var options = new DbContextOptionsBuilder <MovieContext>().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
_movieContext = new MovieContext(options);
_movieContext.Database.EnsureCreated();
InitializeDB.Initialize(_movieContext);
_repository = new Repository <Movie>(_movieContext);
}
public void Setup()
{
InitializeDB.Init();
}
