private void btnConvert_Click(object sender, RoutedEventArgs e) { try { tbOracleConnectionStringText = TbOracleConnectionString.Text; TbCmsConnectionStringText = TbCmsConnectionString.Text; string conn = TbCmsConnectionStringText; //get thread safe klayer if (conn != null) { // Code that runs on application startup DevExpress.Xpo.Metadata.XPDictionary dict = new DevExpress.Xpo.Metadata.ReflectionDictionary(); dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly); DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault .GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists); store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store)); var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store); Tsdl = layer; } if (Tsdl == null) { //DevExpress.XtraEditors.XtraMessageBox.Show($"Couldn't create dl"); return; } // MAINWorker.Connect(tsdl); } catch (Exception ex) { NewNetServices.Module.Core.StaticHelperMethods.WriteOut($"{ex}"); } BtnConvert.IsEnabled = false; Task.Factory .StartNew(() => { Task.WhenAll(BeginWork()); Dispatcher.Invoke(() => BtnConvert.IsEnabled = true); }); }
void CreateDataLayer() { TbCmsConnectionStringText = TbCmsConnectionString.Text; string conn = TbCmsConnectionStringText; //get thread safe klayer if (conn != null) { // Code that runs on application startup DevExpress.Xpo.Metadata.XPDictionary dict = new DevExpress.Xpo.Metadata.ReflectionDictionary(); dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly); DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault .GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists); store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store)); var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store); Tsdl = layer; } }
private void btnConvert_Click(object sender, RoutedEventArgs e) { try { dbName = TbDb.Text; if (!wcTable.Contains(dbName)) { wcTable = dbName + "." + wcTable; oltTable = dbName + "." + oltTable; oltPortsTable = dbName + "." + oltPortsTable; splitterTable = dbName + "." + splitterTable; splitterPortsTable = dbName + "." + splitterPortsTable; oltSplitterDpTable = dbName + "." + oltSplitterDpTable; outdPairsTable = dbName + "." + outdPairsTable; assignmentPrimlocTable = dbName + "." + assignmentPrimlocTable; assignmentDPairsTable = dbName + "." + assignmentDPairsTable; assignmentSplitPortTable = dbName + "." + assignmentSplitPortTable; assignmentOltTable = dbName + "." + assignmentOltTable; addressTable = dbName + "." + addressTable; cablesWithOUTSpansTable = dbName + "." + cablesWithOUTSpansTable; conTable = dbName + ".Conduits"; CABLEPAIR_Table = dbName + ".CablePairs"; dgroupTable = dbName + ".DesignationGroups"; cpdpTable = dbName + ".CABLEPAIRDESIGNATIONPAIR"; dpTable = dbName + ".DesignationPairs"; junkTable = dbName + ".JUNCTIONS"; subTable = dbName + ".Subscribers"; } tbOracleConnectionStringText = TbOracleConnectionString.Text; TbCmsConnectionStringText = TbCmsConnectionString.Text; string conn = TbCmsConnectionStringText; //get thread safe klayer if (conn != null) { // Code that runs on application startup DevExpress.Xpo.Metadata.XPDictionary dict = new DevExpress.Xpo.Metadata.ReflectionDictionary(); dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly); DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault .GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists); store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store)); var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store); Tsdl = layer; } if (Tsdl == null) { //DevExpress.XtraEditors.XtraMessageBox.Show($"Couldn't create dl"); return; } // MAINWorker.Connect(tsdl); } catch (Exception ex) { NewNetServices.Module.Core.StaticHelperMethods.WriteOut($"{ex}"); } using (UnitOfWork uow = new UnitOfWork(Tsdl)) { //using (UnitOfWork uow = MAINWorker.OptimisticLockingReadBehavior = LockingOption) // uow = MAINWorker. LockingOption STATE = (DefaultFields this.state = DefaultFields.GetBusinessObjectDefault <State>(uow, new List <Tuple <string, object> >() { new Tuple <string, object>("ShortName", State), new Tuple <string, object>("LongName", (State == "IA" ? "Iowa" : State == "ND"? "North Dakota" :"")) }) .Oid; } BtnConvert.IsEnabled = false; Task.Factory .StartNew(() => { Task.WhenAll(BeginWork()); Dispatcher.Invoke(() => BtnConvert.IsEnabled = true); }); //if (ToggleStep.IsChecked.HasValue && ToggleStep.IsChecked.Value) //{ // Dispatcher.Invoke(() => ProgressBar.Maximum = 0); // WorkBeginning?.Invoke("GID GUID Matching..", null); // HandleStep2<Location>(); // HandleStep2<Cable>(); //} //else //{ }