//SyncDB private void buttonConnectSyncDB_Click(object sender, EventArgs e) { bool connectionFound = false; try { if (comboBoxSyncLocation.Text.Equals("Repository")) { switch (repositoryType) { case "Remote": syncDBSerializer = new MS_SqlServerIPSerializer(textBoxUserName.Text, textBoxPassword.Text, textBoxRepository.Text, textBoxPort.Text, textBoxSyncName.Text); break; case "Local WA": syncDBSerializer = new MS_SqlServerWASerializier(textBoxRepository.Text, textBoxSyncName.Text); break; case "Local SQL": syncDBSerializer = new MS_SqlServerSerializer(textBoxUserName.Text, textBoxPassword.Text, textBoxRepository.Text, textBoxSyncName.Text); break; default: Exception f = new Exception(); throw f; } connectionFound = true; } if (comboBoxSyncLocation.Text.Equals("Mobile")) { syncDBSerializer = new MS_SqlCeSerializer(syncDBConnectionPath); connectionFound = true; } if (connectionFound == false) { Exception f = new Exception(); throw f; } } catch (Exception f) { MessageBox.Show("Connection not possible. Please check values"); return; } syncDBSerializer.RegisterTypes(syncTypes); syncDBSerializer.Activate(); { buttonConnectSyncDB.BackColor = System.Drawing.SystemColors.Info; buttonConnectSyncDB.Text = "Connected"; activationCheck(); } }
private void connectRepoitoryButton_Click(object sender, EventArgs e) { repositorySerializer = new MS_SqlServerIPSerializer("Schneider", "TS@AI4-UB#7768", "141.84.65.107", "5432", "DiversityCollection_Monitoring", "[DiversityCollection_Monitoring].[dbo]."); repositorySerializer.RegisterTypes(divMobiTypes); repositorySerializer.Activate(); syncDBSerializer = new MS_SqlServerIPSerializer("Schneider", "TS@AI4-UB#7768", "141.84.65.107", "5432", "Synchronisation_Test", String.Empty); String syncIt = "[AGRambold2].SyncItem"; MappingDictionary.Mapping.Add(typeof(SyncItem), syncIt); syncDBSerializer.RegisterType(typeof(SyncItem)); syncDBSerializer.Activate(); this.connectRepoitoryButton.Text = "Connected to repository"; }
private void buttonConnectTaxDB_Click(object sender, EventArgs e) { string connString = "Data Source=\"" + sdfPath + "\";Max Database Size=128;Default Lock Escalation=100;"; SerMobile = new MS_SqlCeSerializer(@sdfPath); SerMobile.RegisterType(typeof(TaxonNames)); SerMobile.Activate(); buttonConnectMobile.Text = "Connected"; buttonConnectMobile.BackColor = Color.Yellow; buttonSelect.Enabled = false; buttonSelect.BackColor = Color.DarkGray; buttonSelect.Text = "Closed"; mobileConnection = true; startcheck(); }
private void buttonConnect_Click(object sender, RoutedEventArgs e) { /* * OpenFileDialog ofd=new OpenFileDialog(); * ofd.Filter = "Mobile Datenbanken |*.sdf"; * if (ofd.ShowDialog() == true) * { * mobSer = new MS_SqlCeSerializer(ofd.FileName); * } * else return; */ repSer = new MS_SqlServerLocalSerializer("127.0.0.1", "5432", "DiversityCollection_Base"); repSer.RegisterTypes(divMobiTypes); repSer.Activate(); mobSer.RegisterTypes(divMobiTypes); mobSer.Activate(); }
private void connectMobileButton_Click(object sender, EventArgs e) { OpenFileDialog dbConnectionDialog = new OpenFileDialog(); dbConnectionDialog.Filter = "sdf files (*.sdf)|*.sdf"; //Im Moment wird nur das DB-Format von DiversityMobile unterstützt if (dbConnectionDialog.ShowDialog() == DialogResult.OK) { String mobileDBPath = @dbConnectionDialog.FileName; mobileDBSerializer = new MS_SqlCeSerializer(mobileDBPath); mobileDBSerializer.RegisterTypes(divMobiTypes); mobileDBSerializer.Activate(); this.connectMobileButton.Text = "Connected to SDF"; } else { return; } }
private void buttonConnectRepository_Click(object sender, EventArgs e) { try { switch (repositoryType) { case "Remote": repositorySerializer = new MS_SqlServerIPSerializer(textBoxUserName.Text, textBoxPassword.Text, textBoxRepository.Text, textBoxPort.Text, textBoxDBName.Text); break; case "Local WA": repositorySerializer = new MS_SqlServerWASerializier(textBoxRepository.Text, textBoxDBName.Text); break; case "Local SQL": repositorySerializer = new MS_SqlServerSerializer(textBoxUserName.Text, textBoxPassword.Text, textBoxRepository.Text, textBoxDBName.Text); break; default: Exception f = new Exception(); throw f; } } catch (Exception f) { MessageBox.Show("Connection not possible. Please check values"); return; } repositorySerializer.RegisterTypes(divMobiTypes); repositorySerializer.Activate(); { buttonConnectRepository.BackColor = System.Drawing.SystemColors.Info; buttonConnectRepository.Text = "Connected"; activationCheck(); } }
private void buttonConnectRepository_Click(object sender, EventArgs e) { try { switch(repositoryType) { case "Remote": repositorySerializer=new MS_SqlServerIPSerializer(textBoxUserName.Text,textBoxPassword.Text,textBoxRepository.Text,textBoxPort.Text,textBoxDBName.Text); break; case "Local WA": repositorySerializer=new MS_SqlServerWASerializier(textBoxRepository.Text,textBoxDBName.Text); break; case "Local SQL": repositorySerializer=new MS_SqlServerSerializer(textBoxUserName.Text,textBoxPassword.Text,textBoxRepository.Text,textBoxDBName.Text); break; default: Exception f=new Exception(); throw f; } } catch (Exception f) { MessageBox.Show("Connection not possible. Please check values"); return; } repositorySerializer.RegisterTypes(divMobiTypes); repositorySerializer.Activate(); { buttonConnectRepository.BackColor = System.Drawing.SystemColors.Info; buttonConnectRepository.Text = "Connected"; activationCheck(); } }
//static ConnectedType(Serializer ser, Serializer taxSer) //{ // SERIALIZER = ser; // TaxonomySERIALIZER = taxSer; // registerTypes(); //} private static void registerTypes() { try { SERIALIZER.RegisterType(typeof(Analysis)); SERIALIZER.RegisterType(typeof(AnalysisTaxonomicGroup)); SERIALIZER.RegisterType(typeof(CollectionAgent)); SERIALIZER.RegisterType(typeof(CollectionEvent)); SERIALIZER.RegisterType(typeof(CollectionEventImage)); SERIALIZER.RegisterType(typeof(CollEventImageType_Enum)); SERIALIZER.RegisterType(typeof(CollectionEventLocalisation)); SERIALIZER.RegisterType(typeof(CollectionSpecimen)); SERIALIZER.RegisterType(typeof(CollectionSpecimenImage)); SERIALIZER.RegisterType(typeof(CollSpecimenImageType_Enum)); SERIALIZER.RegisterType(typeof(CollTaxonomicGroup_Enum)); SERIALIZER.RegisterType(typeof(Identification)); SERIALIZER.RegisterType(typeof(IdentificationUnit)); SERIALIZER.RegisterType(typeof(IdentificationUnitAnalysis)); SERIALIZER.RegisterType(typeof(LocalisationSystem)); SERIALIZER.RegisterType(typeof(CollectionEventProperty)); SERIALIZER.RegisterType(typeof(Property)); SERIALIZER.RegisterType(typeof(CollCircumstances_Enum)); SERIALIZER.RegisterType(typeof(CollUnitRelationType_Enum)); SERIALIZER.RegisterType(typeof(CollectionEventSeries)); SERIALIZER.RegisterType(typeof(UserProfile)); //Bis hier: Korrepondiert zu DBVersion 20 //SERIALIZER.RegisterType(typeof(CollectionEventSeriesImage)); //SERIALIZER.RegisterType(typeof(CollEventSeriesImageType_Enum)); //Bis hier: Korrepondiert zu DBVersion 22 SERIALIZER.RegisterType(typeof(CollIdentificationCategory_Enum)); //SERIALIZER.RegisterType(typeof(CollTypeStatus_Enum)); SERIALIZER.RegisterType(typeof(CollIdentificationQualifier_Enum)); //Bis hier: Korrepondiert zu DBVersion 25 //SERIALIZER.RegisterType(typeof(CollLabelTranscriptionState_Enum)); //SERIALIZER.RegisterType(typeof(CollLabelType_Enum)); //Bis hier: Korrepondiert zu DBVersion 27 //SERIALIZER.RegisterType(typeof(Collection)); SERIALIZER.RegisterType(typeof(CollectionProject)); //SERIALIZER.RegisterType(typeof(CollectionSpecimenPart)); //SERIALIZER.RegisterType(typeof(CollMaterialCategory_Enum)); //Bis hier: Korrepondiert zu DBVersion 31 //SERIALIZER.RegisterType(typeof(AnalysisDisplayOrder)); SERIALIZER.RegisterType(typeof(IdentificationUnitGeoAnalysis)); SERIALIZER.RegisterType(typeof(AnalysisResult)); SERIALIZER.RegisterType(typeof(UserTaxonomicGroupTable)); //Bis hier: Korrepondiert zu DBVersion 34 SERIALIZER.Activate(); TaxonomySERIALIZER.RegisterType(typeof(TaxonNames)); TaxonomySERIALIZER.RegisterType(typeof(PropertyNames)); TaxonomySERIALIZER.Activate(); } catch (Exception) { throw new ConnectionCorruptedException("Error while registering Types."); } }
private void connectRepoitoryButton_Click(object sender, EventArgs e) { repositorySerializer = new MS_SqlServerIPSerializer("Schneider", "TS@AI4-UB#7768","141.84.65.107","5432", "DiversityCollection_Monitoring", "[DiversityCollection_Monitoring].[dbo]."); repositorySerializer.RegisterTypes(divMobiTypes); repositorySerializer.Activate(); syncDBSerializer = new MS_SqlServerIPSerializer("Schneider", "TS@AI4-UB#7768", "141.84.65.107", "5432", "Synchronisation_Test", String.Empty); String syncIt = "[AGRambold2].SyncItem"; MappingDictionary.Mapping.Add(typeof(SyncItem), syncIt); syncDBSerializer.RegisterType(typeof(SyncItem)); syncDBSerializer.Activate(); this.connectRepoitoryButton.Text="Connected to repository"; }
private void connectMobileButton_Click(object sender, EventArgs e) { OpenFileDialog dbConnectionDialog = new OpenFileDialog(); dbConnectionDialog.Filter = "sdf files (*.sdf)|*.sdf"; //Im Moment wird nur das DB-Format von DiversityMobile unterstützt if (dbConnectionDialog.ShowDialog() == DialogResult.OK) { String mobileDBPath = @dbConnectionDialog.FileName; mobileDBSerializer = new MS_SqlCeSerializer(mobileDBPath); mobileDBSerializer.RegisterTypes(divMobiTypes); mobileDBSerializer.Activate(); this.connectMobileButton.Text = "Connected to SDF"; } else return; }
private void buttonConnect_Click(object sender, RoutedEventArgs e) { /* OpenFileDialog ofd=new OpenFileDialog(); ofd.Filter = "Mobile Datenbanken |*.sdf"; if (ofd.ShowDialog() == true) { mobSer = new MS_SqlCeSerializer(ofd.FileName); } else return; */ repSer = new MS_SqlServerLocalSerializer("127.0.0.1", "5432", "DiversityCollection_Base"); repSer.RegisterTypes(divMobiTypes); repSer.Activate(); mobSer.RegisterTypes(divMobiTypes); mobSer.Activate(); }
private bool startMobileConnection(bool copy) { try { // copy mobile database to work directory? if (copy) { if (activesync == true) { if (rapi.DevicePresent && rapi.Connected) this.mobileRapiDesktop(); else return false; } else { if (System.IO.File.Exists(mobileDBPath)) { System.IO.File.Copy(mobileDBPath, progPath, true); if (Directory.Exists(mobilePicturePath)) { String[] pictures = System.IO.Directory.GetFiles(mobilePicturePath); foreach (String pic in pictures) { String fileName = String.Empty; String destPath = String.Empty; try { String sourcPath = pic; fileName = pic.Replace(mobilePicturePath, ""); destPath = progPicturePath + fileName; File.Copy(sourcPath, destPath, false); } catch (Exception) { if (!File.Exists(destPath)) MessageBox.Show("Unable to copy the following picture:" + fileName); } } } } else return false; } } mobileDBSerializer = new MS_SqlCeSerializer(progPath); mobileDBSerializer.RegisterTypes(divMobiTypes); mobileDBSerializer.RegisterType(typeof(UserProfile)); mobileDBSerializer.Activate(); } catch (Exception ex) { MessageBox.Show("The Database could not be connected. Perhaps the DB is in not a DiversityMobile DB."); MessageBox.Show("startMobileConnection: " + ex.Message); if (ex.InnerException != null) MessageBox.Show("startMobileConnection Inner Exception: " + ex.InnerException.Message); mobileDBSerializer = null; mobileDBPath = null; this.labelConnectionMobile.Text = "Not Connected to MobileDB"; return false; } return true; }