private void csvExporter_DoWork(object sender, DoWorkEventArgs e) { string filename = (string)e.Argument; int pp = 0; ListViewWorker lw = new ListViewWorker(); foreach (ListView resultView in listViewExports) { resultView.Columns.Add("Group"); for (int ai = 0; ai < resultView.Items.Count; ai++) { resultView.Items[ai].SubItems.Add(listLabelExports[pp]); } if (pp == 0) { string firstCsv = lw.exportCsv(resultView, true); System.IO.File.WriteAllText(filename, firstCsv); } else { string nextCsv = lw.exportCsv(resultView, false); System.IO.File.AppendAllText(filename, nextCsv); } pp++; } }
public void setListView(ListView list) { if (list != null) { ListViewWorker Worker = new ListViewWorker(); Worker.copyListView(list, this.listView); } }
public void fillUpListView(string onJoin, ListView list) { if (list != null) { ListViewWorker Worker = new ListViewWorker(); Worker.fillListView(onJoin, list, this.listView); } }
public void joinListView(string onJoin, ListView list) { if (list != null) { ListViewWorker Worker = new ListViewWorker(); Worker.mergeListView(onJoin, list, this.listView); } }
public ListView getListView() { ListView list = new ListView(); ListViewWorker Worker = new ListViewWorker(); Worker.copyListView(this.listView, list); return(list); }
public string getSelectedRowEntry(string entry) { if (listView.SelectedItems.Count == 1) { ListViewWorker Worker = new ListViewWorker(); return(Worker.getEntry(listView, entry, listView.SelectedIndices[0])); } return(""); }
private void exportCsvToFile(string filename) { ListViewWorker Worker = new ListViewWorker(); this.setStatusMsg("Exporting to " + filename + " please wait"); string csvContent = Worker.exportCsv(this.listView); System.IO.File.WriteAllText(filename, csvContent); resetlabel(); }
private ListView buildSumList() { int pp = 0; ListView sumerizeListView = new ListView(); ListViewWorker lw = new ListViewWorker(); foreach (ListView resultView in listViewExports) { resultView.Columns.Add("Group"); statusLabel.Text = "writing group no.: " + pp; statusLabel.Invalidate(); Application.DoEvents(); for (int ai = 0; ai < resultView.Items.Count; ai++) { resultView.Items[ai].SubItems.Add(listLabelExports[pp]); } if (sumerizeListView.Columns.Count == 0) { lw.copyListView(resultView, sumerizeListView); } else { lw.addListView(resultView, sumerizeListView, 0, 0); } statusLabel.Text = "writing group no.: " + pp; statusLabel.Invalidate(); Application.DoEvents(); for (int ai = 0; ai < resultView.Items.Count; ai++) { resultView.Items[ai].SubItems.Add(listLabelExports[pp]); } pp++; } statusLabel.Text = "build done "; return(sumerizeListView); }
public ListView getResultAsListView() { ListView resultView = buildSumList(); resultView.View = View.Details; resultView.Width = MainView.Width - 60; resultView.Height = MainView.Width; resultView.Left = 10; resultView.Top = 30; resultView.AutoArrange = true; resultView.FullRowSelect = true; resultView.GridLines = true; ListView CopyThat = new ListView(); ListViewWorker Worker = new ListViewWorker(); Worker.copyListView(resultView, CopyThat); //return resultView; return(CopyThat); }
private void exportCsvFiles(string filename) { int pp = 0; ListViewWorker lw = new ListViewWorker(); if (listViewExports == null) { MessageBox.Show("No Data to export. Make sure youre Query is executed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } foreach (ListView resultView in listViewExports) { resultView.Columns.Add("Group"); statusLabel.Text = "writing group no.: " + pp; onStatusChange("csv ... write group no.: " + pp + " " + filename); statusLabel.Invalidate(); Application.DoEvents(); for (int ai = 0; ai < resultView.Items.Count; ai++) { resultView.Items[ai].SubItems.Add(listLabelExports[pp]); } if (pp == 0) { string firstCsv = lw.exportCsv(resultView, true); System.IO.File.WriteAllText(filename, firstCsv); } else { string nextCsv = lw.exportCsv(resultView, false); System.IO.File.AppendAllText(filename, nextCsv); } pp++; } statusLabel.Text = "writing DONE (" + filename + ") "; }
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(); } }
public string getEntry(string entry, int rownumber) { ListViewWorker Worker = new ListViewWorker(); return(Worker.getEntry(listView, entry, rownumber)); }