private void BT1_Click(object sender, EventArgs e)
{
var form = new LoginUser();
form.ShowDialog();
if(form.connect==null)
return;
Usermanager.Connection.MySqlConnection=new MySqlConnection(form.connect);
if (Usermanager.Connection.ConnectionString!=null||Usermanager.Connection.ConnectionStatus().Confirmation)
{
if (form.SuccesLogin)
{
Usermanager.Connection.Userinfo(form.TBUser.Text, form.TBPass.Text, form.TBDatabase.Text,
form.TBServer.Text);
for (int i = 0; i < treeView1.Nodes[0].Nodes.Count; i++)
{
treeView1.Nodes[0].Nodes[i].Nodes.Clear();
}
if (treeView1.Nodes.Count>1)
{
treeView1.Nodes[1].Remove();
}
LoadTree();
}
}
else
{
Usermanager = new UserManager(new ConnectionManager(connect));
Usermanager.Connection.ConnectionStatus();
}
}
public DataTable MySqlQuery(UserManager currentUserrData, String Query)
{
var datatable = new DataTable();
currentUserrData.Connection.MySqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.CommandTimeout = 200;
mySqlCommand.CommandText = Query;
mySqlCommand.Connection = currentUserrData.Connection.MySqlConnection;
MySqlDataReader mySqlReader;
try
{
mySqlReader = mySqlCommand.ExecuteReader();
if (mySqlReader.HasRows)
{
datatable.Load(mySqlReader);
mySqlReader.Close();
}
SuccessQuery = true;
}
catch (Exception e)
{
Errormessage = e.Message;
MessageBox.Show(e.Message);
SuccessQuery = false;
}
currentUserrData.Connection.MySqlConnection.Close();
return datatable;
}
public bool CheckquerySyntax(UserManager currentUserrData, String Query)
{
var datatable= new DataTable();
currentUserrData.Connection.MySqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.CommandTimeout = 200;
mySqlCommand.CommandText = Query;
mySqlCommand.Connection = currentUserrData.Connection.MySqlConnection;
MySqlDataReader mySqlReader;
try
{
mySqlReader = mySqlCommand.ExecuteReader();
if (mySqlReader.HasRows)
{
datatable.Load(mySqlReader);
mySqlReader.Close();
}
}
catch (Exception e)
{
if (!e.Message.EndsWith("exists"))
{
currentUserrData.Connection.MySqlConnection.Close();
return false;
}
}
currentUserrData.Connection.MySqlConnection.Close();
return true;
}
public Table_ColumnView(UserManager user)
{
this.user = user;
edited = false;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[ScintillaNET.Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[ScintillaNET.Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[ScintillaNET.Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[ScintillaNET.Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[ScintillaNET.Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
}
public Form1()
{
InitializeComponent();
Usermanager = new UserManager(new ConnectionManager(connect));
Console.WriteLine(Usermanager.Connection.ConnectionStatus().message);
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0,Words.Reserved1);
Editbox.SetKeywords(1,Words.Reserved2);
LoadtreeDB();
}
public NewDatabase(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE SCHEMA 'new_schema' " + "\n";
}
public NewTable(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text ="CREATE TABLE 'TableName' ('Column Name' 'ColumnType' 'NOT NULL' 'AUTO_INCREMENT',Repeat" +
",PRIMARY KEY ('columnName'))";
}
public DDLView(UserManager user,string text)
{
this.user = user;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
Editbox.Text = text;
current = text;
button1.Show();
button2.Show();
}
public NewProcedure(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE PROCEDURE 'new_procedure' ()" +"\n"+
"BEGIN" +"\n "+
"END";
}
public NewIndex(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE INDEX 'your_index_name' " + "\n" +
"ON 'your_table_name'('your_column_name')" + "\n" + "USING BTREE;";
this.RBNonUnique.Checked = true;
}
public NewTrigger(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.RBBefore.Checked = true;
this.comboBox1.Text = comboBox1.Items[0].ToString();
this.Editbox.Text = "CREATE TRIGGER 'trigger_name' 'trigger_time'" + "\n" + "'trigger_event' ON table_name FOR EACH ROW" +
"\n" +
"BEGIN" + "\n" + "END";
}
public CreateUser(UserManager user,ToolManager tool)
{
InitializeComponent();
Usermanager = user;
ToolManager = tool;
}