private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
dbw1.ChangeDataInDataBase("QUIM", "insert into report (progName, PercOfEnd, CreationD_rep) values('" + textBox1.Text + "', 0.0, 2342645)");
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
dbw1.ChangeDataInDataBase(SqlConnectionParametrs.DataBaseName, "insert into MetrInRep (id_rep, id_met) select (select id_rep from report where ProgName like '" + textBox1.Text + "'), (select id_met from metric where name_met like '" + checkedListBox1.CheckedItems[i].ToString() + "')");
}
//dbw1.ReadDataBaseToDataSet(temp.name_db, "select * from factor, criteria, metric, profile, report");
}
private void button1_Click(object sender, EventArgs e)
{
Metrics = new String[checkedListBox1.CheckedItems.Count];
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
Metrics[i] = checkedListBox1.CheckedItems[i].ToString();
}
dbw1.ChangeDataInDataBase(SqlConnectionParametrs.DataBaseName, "update report set progName = '" + comboBox2.Text + "' where progName like '" + comboBox2.GetItemText(comboBox2.Items[lastSelect]) + "'");
dbw1.UpdateMetrics(comboBox2.Text, Metrics);
this.Close();
}
