private void FillMilitaryForces(FirebirdFilePath dbFile)
{
List <VID_VS> entities;
using (Old2014_1Context ctxFB = new Old2014_1Context(dbFile.ConnectionString))
{
entities = ctxFB.VID_VS.ToList();
}
using (BrandNewContext ctxg = new BrandNewContext())
{
foreach (var entity in entities)
{
if (!ctxg.MilitaryForces.Any(mf => mf.Name.Equals(entity.NAME)))
{
ctxg.MilitaryForces.AddObject(new MilitaryForces()
{
Name = entity.NAME
});
}
}
ctxg.SaveChanges();
}
}
private void Init()
{
string generalDBConnectionString = ConfigurationManager
.ConnectionStrings["Old2014_1Context"]
.ConnectionString;
FirebirdFilePath generalDBFile = new FirebirdFilePath(generalDBConnectionString, true);
var fs = Directory.GetFiles(generalDBFile.ExternalDirectory);
List <FirebirdFilePath> DBFiles = fs
.Reverse()
.Select(f => new FirebirdFilePath(f, false))
.ToList();
//string curYear = newDBFiles[0].Year;
//int fCnt = newDBFiles.Count();
//for (int i = 0; i < fCnt; i++)
//{
// if (newDBFiles[i].Year != curYear)
// {
// var separator = new FirebirdFilePath() { Path = "-" };
// newDBFiles.Insert(i, separator);
// i++;
// curYear = newDBFiles[i].Year;
// fCnt++;
// }
//}
//SelectDBComboBox.ItemsSource = newDBFiles;
//var defaultSeason = newDBFiles.First(f => f.Year.Equals(defaultYear) && f.Number.Equals(defaultNumber));
//if (defaultSeason != null)
// SelectDBComboBox.SelectedItem = defaultSeason;
//FillTables.FillCompetency();
//FillTables.FillMilitaryTitle();
foreach (var fbf in DBFiles)
{
//FillMilitaryForces(fbf);
//FillTables.FillSeason(fbf);
//FillTables.FillDepartment(fbf);
//FillTables.FillChosenRecruit(fbf);
}
}
