//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 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 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;
}
