// Use this for initialization
void Start()
{
//Debug.Log("running start routine for ViewNotesPanel");
//Assign ViewController object
manager = GameObject.Find("SpatioManager");
dbloader = manager.GetComponent <DBLoader>();
}
public RepairAirplanesDataManager(RepairAirplanesConnection connection)
{
this.Connection = connection;
AirplaneDataLoader = new DBLoader <Airplane>(connection);
EngineDataLoader = new DBLoader <Engine>(connection);
RepairListDataLoader = new DBLoader <Repair_list>(connection);
FlightLogListDataLoader = new DBLoader <Flight_log>(connection);
EngineFuelTypeDataLoader = new DBLoader <Engines_fuel_type>(connection);
FuelTypeDataLoader = new DBLoader <Fuel_type>(connection);
PersonDataLoader = new DBLoader <Person>(connection);
RepairStatusDataLoader = new DBLoader <Repair_status>(connection);
RepairWorkDataLoader = new DBLoader <Repair_work>(connection);
RepairPartDataLoader = new DBLoader <Repair_part>(connection);
RequiredRepairPartDataLoader = new DBLoader <Required_repair_part>(connection);
RequiredRepairWorkDataLoader = new DBLoader <Required_repair_work>(connection);
PermissionDataLoader = new DBLoader <Permission>(connection);
PermissionGroupDataLoader = new DBLoader <Permission_group>(connection);
AuthorizationDataLoader = new DBLoader <Authorization>(connection);
CoolingSystemDataLoader = new DBLoader <Cooling_system>(connection);
EngineerDataLoader = new DBLoader <Engineer>(connection);
PilotDataLoader = new DBLoader <Pilot>(connection);
StudentPilotDataLoader = new DBLoader <Student_pilot>(connection);
InstructorDataLoader = new DBLoader <Instructor>(connection);
StudyGroupListDataLoader = new DBLoader <Study_group>(connection);
TryOpenConnection();
}
public MainController()
{
_model = new MainViewModel();
_nodes = new Dictionary <long, Node>();
_ways = new ConcurrentBag <Way>();
_watch = new Stopwatch();
timerRefresh = new Timer(500);
timerRefresh.Elapsed += TimerRefreshElapsed;
timerRefresh.Start();
_xmlOSMFileLoader = new XmlOSMFileLoader(_ways);
_dbLoader = new DBLoader(_ways, Model.QueryString);
_phase = MainControllerStates.None;
//load current Query String
var v = ConfigurationManager.ConnectionStrings["CS"];
if (v != null)
{
Model.QueryString = v.ConnectionString;
}
}
private void ChouseCardInit()
{
Loader = new DBLoader();
battlegrd.AllCards = Loader.LoadCards();
battlegrd.Fractions = Loader.Fractions;
GetChouseCardControls(battlegrd.AllCards, battlegrd.Fractions);
Loader.Dispose();
}
//making this method to tie button commands to push new updates of the notes
public void CallUpdateNotes()
{
if (dbloader == null)
{
//Debug.Log("CallUpdateNotes");
//Assign ViewController object
manager = GameObject.Find("SpatioManager");
dbloader = manager.GetComponent <DBLoader>();
}
dbloader.StartNoteDownload();
}
public void LoadTest(string tableName)
{
DBLoader loader = new DBLoader();
object result = loader.Load(tableName);
IList expectedResult = (IList)CreateExpectedResultForLoadTest(tableName);
IList ilResult = (IList)result;
Assert.AreEqual(expectedResult.Count, ilResult.Count);
for (int i = 0; i < ilResult.Count; ++i)
{
Assert.AreEqual(expectedResult[i].GetType(), ilResult[i].GetType());
Assert.AreEqual(expectedResult[i], ilResult[i]);
}
}
// Use this for initialization
void Start()
{
sets = FindObjectsOfType <SpatioSet> ();
slider = GetComponentInChildren <Slider>();
database = gameObject.GetComponent <DBLoader>();
slider.minValue = start.Year;
slider.maxValue = end.Year;
foreach (SpatioSet rs in sets)
{
rs.manager = this;
}
varies = false;
date = start;
changed = true;
}
private void buttonExe_Click(object sender, RoutedEventArgs e)
{
DBContext_CFL _context = DBContext_CFL.Instance;
Defunt dft = null;
//var select = new DBSelect<Defunt>("*")
// .Where
// (
// new MemberPath(()=>dft.Identite), "=", new DBSelect().From("identite").Where
// (
// new MemberPath(()=>((Identite)null).Nom), "=", new DBValue("DUPONT3"),
// "or", new MemberPath(()=>dft.Identite.Nom), "=", new DBValue("DUPONT2")
// ),
// "or",
// new MemberPath(()=>dft.Pouvoir), "=", new DBSelect().From("pouvoir").Where
// (
// new MemberPath(()=>dft.Pouvoir.Identite), "=", new DBSelect().From("identite").Where
// (
// new MemberPath(()=>((Identite)null).Nom), "==", new DBValue("POUVOIR4"),
// "and", new MemberPath(()=>((Defunt)null).Pouvoir.Identite.Prenom), "==", new DBValue("Pouvoir4")
// )
// )
// )
// ;
DBSelect _select = new DBSelect("*").From("defunt")
.Where
(
new DBOnList(() => ((Defunt)null).OperationsFuneraires)
.Contains
(
new DBSelect().From("inhumation").Where
(
new MemberPath(() => ((Inhumation)null).date), "=", new DBValue(new DateTime(2017, 12, 6))
)
)
);
string query = _select.Query();
List <Base> dfts = new DBLoader(_context.Connection, _context).IncludeCascade().ToList(_select);
}
private void LoadProject()
{
GraphProject _project = null;
DBContext_CFL dbContext = DBContext_CFL.instance;
_project = new DBLoader <GraphProject>
(dbContext.Connection, dbContext).First
(new DBSelect <GraphProject>("*").Where("ProjectName = 'Configuration entreprise'"));
if (_project != null)
{
foreach (ShapeTypeInfo _shapeInfo in _project.ShapeInfos)
{
__graphControl.TypesDescription.CompleteShapeTypeInfo(_shapeInfo);
}
}
__graphControl.Project = _project;
}
public ParserWorker(IParser <T> parser)
{
this.parser = parser;
this.dbLoader = new DBLoader(new ViDBContext());
}
private void GetData(bool skipCache, bool skipTFS)
{
if (IsWorking)
{
return;
}
IsWorking = true;
int?lastId = null;
if (!skipCache)
{
lock (SqliteConnection)
{
SqliteConnection.Open();
Debug.WriteLine("Getting HistoryItems from Cache");
var historyItems = DBLoader.GetHistoryItems();
if (historyItems.Any())
{
HistoryItems.AddRangeWithoutNotification(historyItems);
/*foreach (var item in historyItems)
* {
* item.GotWorkItems += ItemOnGotWorkItems;
* }*/
}
Debug.WriteLine($"Got {historyItems.Count()} HistoryItems from Cache");
if (historyItems.Any())
{
lastId = historyItems.Max(x => x.ChangeSetId);
}
Debug.WriteLine("Getting WorkItems from Cache");
var workItems = DBLoader.GetWorkItems(Settings);
if (workItems.Any())
{
WorkItems.AddRangeWithoutNotification(workItems);
}
Debug.WriteLine($"Got {workItems.Count()} WorkItems from Cache");
SqliteConnection.Close();
// Resolve CachedWorkItems in HistoryItems
foreach (var item in HistoryItems)
{
var resolvedWorkItems = new List <WorkItem>();
foreach (int id in item.CachedWorkItemIds)
{
var resolvedWorkItem = WorkItems.FirstOrDefault(x => x.Id == id);
if (resolvedWorkItem != null)
{
resolvedWorkItems.Add(resolvedWorkItem);
}
}
item.CachedWorkItems = resolvedWorkItems.ToArray();
item.CachedWorkItemIds = resolvedWorkItems.Select(x => x.Id).ToArray();
}
HistoryItems.NotifyReset();
WorkItems.NotifyReset();
}
}
if (!skipTFS)
{
GetDataFromTfs(lastId, lastId.HasValue ? Int32.MaxValue : InitialItemSize);
}
IsWorking = false;
}
