private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MetroFramework.MetroMessageBox.Show(this, "Are you sure you want to Delete this Customer?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
try
{
//Get CustomerID
SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString);
sqlcon.Open();
string Select = "SELECT CustomerID FROM Customers WHERE CustomerFullName ='" + listBox1.Text.ToString() + "'";
SqlCommand sqlcom = new SqlCommand(Select, sqlcon);
SqlDataReader reader;
reader = sqlcom.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
CustomerID = Convert.ToInt32((reader["CustomerID"]));
}
}
reader.Close();
sqlcon.Close();
SqlConnection sqlcon2 = new SqlConnection(Globals_Class.ConnectionString);
sqlcon2.Open();
string cmd = "DELETE FROM Customers WHERE CustomerID ='" + CustomerID.ToString() + "'";
SqlCommand sqlcom2 = new SqlCommand(cmd, sqlcon2);
sqlcom2.ExecuteNonQuery();
sqlcon2.Close();
MetroFramework.MetroMessageBox.Show(this, "Customer Successfully Deleted!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
btnDelete.Enabled = false;
listBox1.Items.Clear();
SqlConnection sqlcon3 = new SqlConnection(Globals_Class.ConnectionString);
sqlcon3.Open();
string CMD3 = "SELECT CustomerFullName FROM Customers";
SqlCommand sqlcom3 = new SqlCommand(CMD3, sqlcon3);
SqlDataReader Reader3;
Reader3 = sqlcom3.ExecuteReader();
if (Reader3.HasRows)
{
while (Reader3.Read())
{
listBox1.Items.Add(Reader3["CustomerFullName"].ToString());
}
}
Reader3.Close();
sqlcon3.Close();
}
catch
{
MetroFramework.MetroMessageBox.Show(this, "Could not Connect to the Database!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public Form3()
{
InitializeComponent();
string myConnnection = "datasource=localhost; port=3306;username=root;password=Sercan.123; ";
MySqlConnection myConn = new MySqlConnection(myConnnection);
myConn.Open();
MySqlCommand command = new MySqlCommand();
command = myConn.CreateCommand();
command.CommandText = "SELECT schema_name FROM information_schema.schemata where schema_name not like '%_schema' and schema_name not like 'mysql';";
MySqlDataReader Reader1;
Reader1 = command.ExecuteReader();
while (Reader1.Read())
{
string row = "";
for (int i = 0; i < Reader1.FieldCount; i++)
{
row += Reader1.GetValue(i).ToString();
}
trV1.Nodes.Add(row);
}
for (int i = 0; i < trV1.Nodes.Count; i++)
{
trV1.Nodes[i].Nodes.Add("Tables");
trV1.Nodes[i].Nodes.Add("Views");
trV1.Nodes[i].Nodes.Add("Stored Procedure");
trV1.Nodes[i].Nodes.Add("Functions ");
}
Reader1.Close();
Reader1.Dispose();
myConn.Close();
myConn.Open();
MySqlCommand command_table = new MySqlCommand();
command_table = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_table.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_schema ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader2;
Reader2 = command_table.ExecuteReader();
while (Reader2.Read())
{
string table = "";
for (int j = 0; j < Reader2.FieldCount; j++)
{
table += Reader2.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[0].Nodes.Add(table);
}
Reader2.Close();
Reader2.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_view = new MySqlCommand();
command_view = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_view.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_type='VIEW' AND table_schema ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader3;
Reader3 = command_view.ExecuteReader();
while (Reader3.Read())
{
string view = "";
for (int j = 0; j < Reader3.FieldCount; j++)
{
view += Reader3.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[1].Nodes.Add(view);
}
Reader3.Close();
Reader3.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_procedure = new MySqlCommand();
command_procedure = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_procedure.CommandText = "SHOW PROCEDURE STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader4;
Reader4 = command_procedure.ExecuteReader();
while (Reader4.Read())
{
string procedure = "";
for (int j = 0; j < Reader4.FieldCount; j++)
{
procedure += Reader4.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[2].Nodes.Add(procedure);
}
Reader4.Close();
Reader4.Dispose();
}
myConn.Close();
myConn.Open();
MySqlCommand command_function = new MySqlCommand();
command_function = myConn.CreateCommand();
for (int i = 0; i < trV1.Nodes.Count; i++)
{
command_function.CommandText = "SHOW FUNCTION STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' ";
MySqlDataReader Reader5;
Reader5 = command_function.ExecuteReader();
while (Reader5.Read())
{
string function = "";
for (int j = 0; j < Reader5.FieldCount; j++)
{
function += Reader5.GetValue(j).ToString();
}
trV1.Nodes[i].Nodes[3].Nodes.Add(function);
}
Reader5.Close();
Reader5.Dispose();
}
ContextMenuStrip docMenu = new ContextMenuStrip();
ToolStripMenuItem SelectRows = new ToolStripMenuItem();
SelectRows.Text = "Select Rows";
ToolStripMenuItem AlterTable = new ToolStripMenuItem();
AlterTable.Text = "Alter Table";
ToolStripMenuItem DropTable = new ToolStripMenuItem();
DropTable.Text = "Drop Table";
docMenu.Items.AddRange(new ToolStripMenuItem[] { SelectRows, AlterTable, DropTable });
for (int i = 0; i < trV1.Nodes.Count; i++)
{
for (int j = 0; j < trV1.Nodes[i].Nodes[0].Nodes.Count; j++)
{
trV1.Nodes[i].Nodes[0].Nodes[j].ContextMenuStrip = docMenu;
}
}
SelectRows.Click += SelectRows_Click;
void SelectRows_Click(object sender, System.EventArgs e)
{
MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=Sercan.123");
connection.Open();
try
{
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM " + trV1.SelectedNode.Parent.Parent.Text + "." + trV1.SelectedNode.Text + " ", connection);
DataSet ds = new DataSet();
adapter.Fill(ds, trV1.SelectedNode.Text);
dataGridView1.DataSource = ds.Tables[trV1.SelectedNode.Text];
string a = ds.Tables[0].Columns.ToString();
//MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM blm437.ogrenci ", connection);
//DataSet ds = new DataSet();
//adapter.Fill(ds, "ogrenci");
//dataGridView1.DataSource = ds.Tables["ogrenci"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void listBox1_Click(object sender, EventArgs e)
{
SqlConnection sqlcon1 = new SqlConnection(Globals_Class.ConnectionString);
sqlcon1.Open();
string Select = "SELECT UserID From Users WHERE UserName ='******'";
SqlCommand sqlcom1 = new SqlCommand(Select, sqlcon1);
SqlDataReader Reader;
Reader = sqlcom1.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
isAdmin = Convert.ToInt32((Reader["UserID"]));
if (isAdmin == 1)
{
MetroFramework.MetroMessageBox.Show(this, "The Admin Account Cannot be Deleted!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
DialogResult dialogResult = MetroFramework.MetroMessageBox.Show(this, "Are you sure you want to delete this user?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
try
{
SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString);
sqlcon.Open();
string Command = "DELETE FROM Users WHERE UserName ='******'";
SqlCommand sqlcom = new SqlCommand(Command, sqlcon);
sqlcom.ExecuteNonQuery();
MetroFramework.MetroMessageBox.Show(this, "The Selected User was Deleted Successfully!", "Message", MessageBoxButtons.OK, MessageBoxIcon.None);
listBox1.Items.Clear();
SqlConnection sqlcon2 = new SqlConnection(Globals_Class.ConnectionString);
sqlcon2.Open();
string CMD2 = "SELECT UserName FROM Users";
SqlCommand sqlcom2 = new SqlCommand(CMD2, sqlcon2);
SqlDataReader Reader2;
Reader2 = sqlcom2.ExecuteReader();
if (Reader2.HasRows)
{
while (Reader2.Read())
{
listBox1.Items.Add(Reader2["UserName"].ToString());
}
}
Reader2.Close();
sqlcon2.Close();
}
catch
{
MetroFramework.MetroMessageBox.Show(this, "An Error Occurred whislt Deleting the User!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
listBox1.Items.Clear();
SqlConnection sqlcon3 = new SqlConnection(Globals_Class.ConnectionString);
sqlcon3.Open();
string CMD3 = "SELECT UserName FROM Users";
SqlCommand sqlcom3 = new SqlCommand(CMD3, sqlcon3);
SqlDataReader Reader3;
Reader3 = sqlcom3.ExecuteReader();
if (Reader3.HasRows)
{
while (Reader3.Read())
{
listBox1.Items.Add(Reader3["UserName"].ToString());
}
}
Reader3.Close();
sqlcon3.Close();
}
}
}
}
}
}
