private void Delete_database_btn_Click(object sender, RoutedEventArgs e)
{
String dbName = Show_Database_Path.Content.ToString();
String serverName = Show_Server_Path.Content.ToString();
if (serverName.Equals(""))
{
MessageBox.Show("Please Select Server From Drop Down to Delete");
return;
}
if (dbName.Equals(""))
{
MessageBox.Show("Please Select Database From Drop Down to Delete");
return;
}
int selectedIndex = DatabaseComboBox.SelectedIndex;
DatabaseComboBox.Items.RemoveAt(selectedIndex);
DatabaseOperations.Delete_Database(serverName, dbName);
var countitem = DatabaseComboBox.Items.Count;
if (countitem == 0)
{
DatabaseComboBox.IsEnabled = false;
}
Show_Database_Path.Content = "";
connectionStringLabel.Text = CommanOperations.DisplayValueChange(connectionStringLabel.Text.ToString(), "", 2);
//DatabaseNameLabel.Content = "Database Name : ";
MessageBox.Show("Delete Database Successfully");
return;
}
private void PasswordChangedHandler(Object sender, RoutedEventArgs args)
{
int len = passwordtextbox.Password.Length;
String temp = "";
for (int i = 0; i < len; i++)
{
temp += "*";
}
connectionStringLabel.Text = CommanOperations.DisplayValueChange(connectionStringLabel.Text.ToString(), temp, 4);
return;
}
private void ServerComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//int selectedIndex = DatabaseComboBox.SelectedIndex;
ComboBox cbx = (ComboBox)sender;
string serverName = String.Empty;
if (cbx.SelectedValue == null)
{
serverName = cbx.SelectionBoxItem.ToString();
}
else
{
serverName = cboParser(cbx.SelectedValue.ToString());
}
Show_Server_Path.Content = serverName;
string serverValue = ServerOperations.Get_server_value(Show_Server_Path.Content.ToString());
//connectionStringLabel
connectionStringLabel.Text = CommanOperations.DisplayValueChange(connectionStringLabel.Text.ToString(), serverValue, 1);
DatabaseComboBox.Items.Clear();
Show_Database_Path.Content = "";
connectionStringLabel.Text = CommanOperations.DisplayValueChange(connectionStringLabel.Text.ToString(), "", 2);
//DatabaseNameLabel.Content = "Database Name : ";// + DatabaseOperations.Get_connection_string(Show_Server_Path.Content.ToString(), Show_Database_Path.Content.ToString());
DatabaseOperations.initializeDatabaseInComboBox(serverName, DatabaseComboBox);
var countitem = DatabaseComboBox.Items.Count;
if (countitem == 0)
{
DatabaseComboBox.IsEnabled = false;
}
else
{
DatabaseComboBox.IsEnabled = true;
}
return;
}
//public ComboBox DatabaseComboBox;
/*
* private void Select_Project_btn_Click(object sender, RoutedEventArgs e)
* {
*
* System.Windows.Forms.FolderBrowserDialog folderDialog = new System.Windows.Forms.FolderBrowserDialog();
* System.Windows.Forms.DialogResult result = folderDialog.ShowDialog();
*
* if (result == System.Windows.Forms.DialogResult.OK)
* {
* Show_Project_Path.Content = folderDialog.SelectedPath; //project_path
* }
* return;
*
* }
*/
private void DatabaseComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//int selectedIndex = DatabaseComboBox.SelectedIndex;
ComboBox cbx = (ComboBox)sender;
string dbname = String.Empty;
if (cbx.SelectedValue == null)
{
dbname = cbx.SelectionBoxItem.ToString();
}
else
{
dbname = cboParser(cbx.SelectedValue.ToString());
}
Show_Database_Path.Content = dbname;
string dbvalue = DatabaseOperations.Get_connection_string(Show_Server_Path.Content.ToString(), Show_Database_Path.Content.ToString());
connectionStringLabel.Text = CommanOperations.DisplayValueChange(connectionStringLabel.Text.ToString(), dbvalue, 2);
//DatabaseNameLabel.Content = "Database Name : " + DatabaseOperations.Get_connection_string(Show_Server_Path.Content.ToString(), Show_Database_Path.Content.ToString()); ;
return;
}
