private void URL_Test_Click(object sender, EventArgs e)
{
//link exist let's check if it works
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + URL_Link.Text + Properties.Settings.Default.password;
//check if we can access remote DB
int remote_version = AccessDB.version_num(connectionString);
if (remote_version < 0)
{
URL_Note.Text = "Not Valid Link to database";
}
else
{
URL_Note.Text = "Valid Link to database, and Database index= " + remote_version.ToString();
}
}
int check_DB()
{
//here i should test if local db exist by check its index
int current_version;
int remote_version;
//below function will return -1 in case of error
current_version = AccessDB.version_num(Properties.Settings.Default.LocalDB);
if (current_version < 0)
{ //check if no link to remote DB exist
if (Properties.Settings.Default.Remote_file == "")
{
//call DB_location form with close status
DB_Location.status = "close";
DB_Location.comment = "Local Database is not exist, and no valid link to remote database. Note if you press cancel or close this window application will automatically close.";
DB_Location DB_loc = new DB_Location();
DB_loc.ShowDialog();
if (DB_Location.app_close == 1)
{
return(3);
}
return(1);
}
else
{
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Properties.Settings.Default.Remote_file + Properties.Settings.Default.password;
//check if we can access remote DB
remote_version = AccessDB.version_num(connectionString);
if (remote_version < 0)
{
//not valid link
DB_Location.status = "close";
DB_Location.comment = "Local Database is not exist, and current link to remote database is not valid. Note if you press cancel or close this window application will automatically close.";
DB_Location DB_loc = new DB_Location();
DB_loc.ShowDialog();
if (DB_Location.app_close == 1)
{
return(3);
}
return(1);
}
else
{
//here i should copy remote database to local directory.
string local_file = Application.StartupPath + "\\SMB.accdb";
string remote_file = Properties.Settings.Default.Remote_file;
try
{
File.Copy(remote_file, local_file, true);
}
catch (Exception)
{
//incase of error in copying aplication should close
MessageBox.Show("Error happen while updating local Database, Please make sure you run this application as adminstrator");
this.Close();
}
DB_index.Text = remote_version.ToString();
DB_status.Text = "Online";
MessageBox.Show("DataBase update to index: " + remote_version.ToString());
return(0);
}
}
}
else
{
//if local database exist,check if link exist
if (Properties.Settings.Default.Remote_file == "")
{
DB_status.Text = "Offline";
DB_index.Text = current_version.ToString();
MessageBox.Show("No valid link for remote DB, Please update link from (DB Location) Button below. You now can work with local database, but it may be not the last update!!");
return(0);
}
else
{
//link exist let's check if it works
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Properties.Settings.Default.Remote_file + Properties.Settings.Default.password;
//check if we can access remote DB
remote_version = AccessDB.version_num(connectionString);
if (remote_version < 0)
{
DB_status.Text = "Offline";
DB_index.Text = current_version.ToString();
MessageBox.Show("error in connection to Database, Please update link from (DB Location) button below or check your network connection. You now can work with local database, but it may be not the last update!!");
return(0);
}
else
{
//here local DB exist and remote DB exist
//lets validate
if (remote_version > current_version)
{
//here should replace local database
string local_file = Application.StartupPath + "\\SMB.accdb";
string remote_file = Properties.Settings.Default.Remote_file;
try
{
File.Delete(local_file);
File.Copy(remote_file, local_file, true);
}
catch (Exception)
{
MessageBox.Show("Error happen while updating local Database, Please make sure you run this application as adminstrator");
this.Close();
}
MessageBox.Show("DataBase update From index: " + current_version.ToString() + " to index: " + remote_version.ToString());
DB_index.Text = remote_version.ToString();
DB_status.Text = "Online";
return(0);
}
else
{
DB_index.Text = remote_version.ToString();
DB_status.Text = "Online";
return(0);
}
}
}
}
}
