/**
* init database handler by seperate
* information
* no auto connect
*
**/
/* public MysqlHandler(string username,string password,string host, string table)
* {
* this.userName = username;
* this.userPassword = password;
* this.host = host;
* this.table = table;
* getConnStr();
* this.connection = new MySql.Data.MySqlClient.MySqlConnection();
*
* }*/
/**
* init databasehandler with information from profile
*/
public MysqlHandler(Profil dbProfil)
{
this.currentProfil = dbProfil;
this.userName = dbProfil.getProperty(ProfilProps.DB_USERNAME);
this.userPassword = dbProfil.getProperty(ProfilProps.DB_PASSWORD);
this.host = dbProfil.getProperty(ProfilProps.DB_HOST);
this.table = dbProfil.getProperty(ProfilProps.DB_SCHEMA);
string timeOutStr = dbProfil.getProperty(ProfilProps.DB_TIMEOUT);
if (null != timeOutStr)
{
this.timeOut = long.Parse(timeOutStr);
}
getConnStr();
this.connection = new MySql.Data.MySqlClient.MySqlConnection();
}
private void selectExistsTables()
{
Profil dbProf = new Profil();
ColorCalc cCalc = new ColorCalc();
string groupId = groupName.Text;
if (this.currentGroups.Contains(groupId))
{
groupName.ForeColor = Color.DarkGreen;
groupName.BackColor = Color.LightSeaGreen;
List <string> members = Config.getListWidthDefault(PConfig.KEY_GROUPS_MEMBERS + "." + groupId, new List <string>());
for (int i = 0; i < this.GroupedDatabases.Items.Count; i++)
{
this.GroupedDatabases.Items[i].Checked = (members.Contains(this.GroupedDatabases.Items[i].Text));
dbProf.changeProfil(this.GroupedDatabases.Items[i].Text);
if (dbProf.getProperty("set_bgcolor") != null && dbProf.getProperty("set_bgcolor").Length > 2)
{
Color rowCol = Color.FromArgb(int.Parse(dbProf.getProperty("set_bgcolor")));
cCalc.setBaseColor(rowCol);
this.GroupedDatabases.Items[i].BackColor = cCalc.LightenBy(50);
this.GroupedDatabases.Items[i].ForeColor = cCalc.DarkenBy(50);
}
}
manipulateBtn.Image = Projector.Properties.Resources.delete_16;
GroupedDatabases.Enabled = true;
}
else
{
groupName.ForeColor = Color.DarkRed;
groupName.BackColor = Color.LightYellow;
manipulateBtn.Image = Projector.Properties.Resources.add16;
for (int i = 0; i < this.GroupedDatabases.Items.Count; i++)
{
this.GroupedDatabases.Items[i].Checked = false;
}
GroupedDatabases.Enabled = false;
}
}
private void checkConnection(Profil testProfil)
{
MysqlHandler TestConnect = new MysqlHandler(testProfil);
try
{
TestConnect.connect();
}
catch (Exception)
{
//throw;
}
if (TestConnect.lastSqlErrorMessage.Length > 0)
{
errorLabel.Text = TestConnect.lastSqlErrorMessage;
}
else
{
errorLabel.Text = Projector.Properties.Resources.MysqlConnectionTestSucces;
TestConnect.disConnect();
}
}
public static statusResult checkConnection(Profil testProfil)
{
statusResult result = new statusResult();
MysqlHandler TestConnect = new MysqlHandler(testProfil);
TestConnect.connect();
if (TestConnect.lastSqlErrorMessage.Length > 0)
{
result.message = TestConnect.lastSqlErrorMessage;
result.status = false;
result.StatusKey = 0;
return(result);
}
else
{
TestConnect.disConnect();
result.message = Projector.Properties.Resources.MysqlConnectionTestSucces;;
result.status = true;
result.StatusKey = 1;
return(result);
}
}
private void fireSql(Profil dbProfil, string sql)
{
MysqlHandler database = new MysqlHandler(dbProfil);
database.connect();
if (database.isConnected())
{
ListViewWorker listTool = new ListViewWorker();
GroupBox instGroup = new GroupBox();
instGroup.Width = MainView.Width - 30;
instGroup.BackColor = SystemColors.Info;
//instGroup.Height = 350;
instGroup.Text = currentProfileName;
instGroup.AutoSize = true;
Label infoData = new Label();
infoData.AutoSize = true;
infoData.Text = dbProfil.getProperty("db_username") + "@" + dbProfil.getProperty("db_host") + "/" + dbProfil.getProperty("db_schema");
infoData.Top = 15;
infoData.Left = 15;
ListView resultView = new ListView();
resultView.View = View.Details;
resultView.Width = MainView.Width - 60;
resultView.Height = 300;
resultView.Left = 10;
resultView.Top = 30;
resultView.FullRowSelect = true;
resultView.GridLines = true;
MySql.Data.MySqlClient.MySqlDataReader dbResult = database.sql_select(sql);
if (database.lastSqlErrorMessage != "")
{
Label noData = new Label();
noData.Top = 30;
noData.Left = 15;
noData.Text = database.lastSqlErrorMessage;
noData.AutoSize = true;
noData.Font = new Font("Courier New", 10, FontStyle.Bold);
instGroup.Controls.Add(noData);
instGroup.Controls.Add(infoData);
instGroup.Height = 60;
instGroup.BackColor = Color.LightPink;
}
else
{
if (dbResult != null && dbResult.HasRows)
{
database.sql_data2ListView(dbResult, resultView);
for (int i = 0; i < resultView.Columns.Count; i++)
{
resultView.Columns[i].AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize);
}
listTool.setRowColors(resultView, Color.LightBlue, Color.LightGreen);
resultView.Height = (resultView.Items.Count * 13) + 50;
if (resultView.Height > 700)
{
resultView.Height = 700;
}
listLabelExports.Add(instGroup.Text);
listViewExports.Add(resultView);
instGroup.Controls.Add(resultView);
instGroup.Controls.Add(infoData);
}
else
{
Label noData = new Label();
noData.Top = 30;
noData.Left = 15;
noData.Text = "No Result for this query ";
noData.AutoSize = true;
instGroup.Controls.Add(noData);
instGroup.Height = 60;
instGroup.BackColor = Color.LightYellow;
instGroup.Controls.Add(infoData);
}
}
MainView.Controls.Add(instGroup);
MainView.Refresh();
}
database.disConnect();
}
//ProgressChangedEventArgs
private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
if (e.UserState != null)
{
asyncSql bgWorkerObj = (asyncSql)e.UserState;
Profil dbProfil = bgWorkerObj.dbProfil;
string sql = bgWorkerObj.sql;
ListViewWorker listTool = new ListViewWorker();
GroupBox instGroup = new GroupBox();
instGroup.Width = MainView.Width - 30;
instGroup.BackColor = SystemColors.Info;
currentProfileName = dbProfil.getName();
instGroup.Text = dbProfil.getName();
instGroup.AutoSize = true;
Label infoData = new Label();
infoData.AutoSize = true;
infoData.Text = dbProfil.getProperty("db_username") + "@" + dbProfil.getProperty("db_host") + "/" + dbProfil.getProperty("db_schema");
infoData.Top = 15;
infoData.Left = 15;
ListView resultView = bgWorkerObj.resultListView;
resultView.View = View.Details;
resultView.Width = MainView.Width - 60;
resultView.Height = 300;
resultView.Left = 10;
resultView.Top = 30;
resultView.FullRowSelect = true;
resultView.GridLines = true;
if (bgWorkerObj.lastError != "")
{
Label noData = new Label();
noData.Top = 30;
noData.Left = 15;
noData.Text = bgWorkerObj.lastError;
noData.AutoSize = true;
noData.Font = new Font("Courier New", 10, FontStyle.Bold);
instGroup.Controls.Add(noData);
instGroup.Controls.Add(infoData);
instGroup.Height = 60;
instGroup.BackColor = Color.LightPink;
this.onStatusChange("Error on " + infoData.Text);
}
else
{
if (bgWorkerObj.haseRows)
{
for (int i = 0; i < resultView.Columns.Count; i++)
{
resultView.Columns[i].AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize);
}
listTool.setRowColors(resultView, Color.LightBlue, Color.LightGreen);
resultView.Height = (resultView.Items.Count * 13) + 50;
if (resultView.Height > 700)
{
resultView.Height = 700;
}
listLabelExports.Add(instGroup.Text);
listViewExports.Add(resultView);
instGroup.Controls.Add(resultView);
instGroup.Controls.Add(infoData);
this.onStatusChange(resultView.Items.Count + " rows from " + infoData.Text);
}
else
{
Label noData = new Label();
noData.Top = 30;
noData.Left = 15;
noData.Text = "No Result for this query ";
noData.AutoSize = true;
instGroup.Controls.Add(noData);
instGroup.Height = 60;
instGroup.BackColor = Color.LightYellow;
instGroup.Controls.Add(infoData);
this.onStatusChange(" no rows reported from " + infoData.Text);
}
}
MainView.Controls.Add(instGroup);
MainView.Refresh();
Application.DoEvents();
}
}
private void fireAsyncQuery(Profil dbProfil, string sql)
{
fireAsyncQuery(dbProfil, sql, false);
}
public void setTables(Profil useProfil, string source)
{
this.db = new MysqlHandler(useProfil);
init(db, source);
}
