private void btnReplace_Click(object sender, RoutedEventArgs e)
{
ConnectionAndDatabaseValidator valic = new ConnectionAndDatabaseValidator(userName, pass, port);
if (valic.WriteUserMasterLoginInfo())
{
lblvalid.Text = "saved";
lblvalid.Foreground = new SolidColorBrush(Colors.Yellow);
}
}
private void btnCreateDB_Click(object sender, RoutedEventArgs e)
{
ConnectionAndDatabaseValidator valic = new ConnectionAndDatabaseValidator(userName, pass, port);
Thread k = new Thread(valic.CreateDatabaseIfNotExsist);
k.Start(); //work on a new Thread
while (k.ThreadState == ThreadState.Running)
{
lbldbfound.Text = "Creating Database, Please Wait";
}
Console.WriteLine("Done");
lblvalid2.Text = correct;
lbldbfound.Text = "Database created, Press back";
btnCreateDB.Visibility = Visibility.Hidden;
}
private bool ChckDbandConnection()
{
ConnectionAndDatabaseValidator valic = new ConnectionAndDatabaseValidator(userName, pass, port);
bool cV = valic.CheckConnection();
bool cD = valic.DBConnection();
//if connection is valid
if (cV)
{
lblvalid.Text = correct;
lblCreditCorrect.Text = connectionOk;
lblvalid.Foreground = new SolidColorBrush(Colors.Yellow);
}
else
{
lblvalid.Text = incorrect;
lblCreditCorrect.Text = connectionError;
lblvalid.Foreground = new SolidColorBrush(Colors.Yellow);
}
//if db is valid
if (cD)
{
lblvalid2.Text = correct;
lbldbfound.Text = dbFound;
lblvalid2.Foreground = new SolidColorBrush(Colors.Yellow);
btnCreateDB.Visibility = Visibility.Hidden;
}
else
{
lblvalid2.Text = incorrect;
lbldbfound.Text = dbNotFound;
lblvalid2.Foreground = new SolidColorBrush(Colors.Yellow);
btnCreateDB.Visibility = Visibility.Visible;
}
return(cV && cD);
}
