private void Form5_Load(object sender, EventArgs e)
{
comboBox1.SelectedIndex = 0;
DataSet dataSet1 = dbw1.ReadDataBaseToDataSet("QUIM", "select progName, CreationD_rep, percofend from Report where progName LIKE '" + g_reportName + "'");
this.Text = dataSet1.Tables[0].Rows[0].ItemArray[0].ToString() + " " + dataSet1.Tables[0].Rows[0].ItemArray[1].ToString();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
dataSet1 = dbw1.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select m.name_met from metric m, profile p, profile_metric pm where p.id_prof = pm.id_prof and m.id_met = pm.id_met and p.name_prof like '" + comboBox1.GetItemText(comboBox1.Items[comboBox1.SelectedIndex]) + "'");
foreach (int checkedItemIndex in checkedListBox1.CheckedIndices)
{
checkedListBox1.SetItemChecked(checkedItemIndex, false);
}
for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++)
{
checkedListBox1.SetItemChecked(checkedListBox1.Items.IndexOf(dataSet1.Tables[0].Rows[i].ItemArray[0].ToString()), true);
}
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
comboBox1.Enabled = true;
comboBox1_SelectedIndexChanged(comboBox1, null);
}
else
{
foreach (int checkedItemIndex in checkedListBox1.CheckedIndices)
{
checkedListBox1.SetItemChecked(checkedItemIndex, false);
}
dataSet1 = dbw1.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select m.name_met from metric m, metrInRep mr, report r where r.id_rep = mr.id_rep and m.id_met = mr.id_met and r.progName like '" + comboBox2.GetItemText(comboBox2.Items[lastSelect]) + "'");
for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++)
{
checkedListBox1.SetItemChecked(checkedListBox1.Items.IndexOf(dataSet1.Tables[0].Rows[i].ItemArray[0].ToString()), true);
}
comboBox1.Enabled = false;
}
}
private void Form6_Load(object sender, EventArgs e)
{
UseWaitCursor = true;
BindingSource bindingSource1 = new BindingSource();
DataSet dataSet1 = dbw1.ReadDataBaseToDataSet("QUIM", "select progName, CreationD_rep, percofend from Report where progName LIKE '" + g_reportName + "'");
this.Text = dataSet1.Tables[0].Rows[0].ItemArray[0].ToString() + " " + dataSet1.Tables[0].Rows[0].ItemArray[1].ToString();
dataSet21 = new DataSet();
adapter = new SqlDataAdapter();
dataSet11 = dbw1.ReadDataBaseToDataSet("QUIM", "select m.name_met, mr.MinValue, mr.Curvalue, MaxValue, mr.Rate, mr.Value, mr.Type from metric m, MetrInRep mr where m.id_met = mr.id_met and mr.id_rep in (select r.id_rep from report r where r.progName like '" + g_reportName + "')");
dataGridView8.DataSource = dataSet11.Tables[0];
dataGridView8.Columns[0].HeaderText = "NAME METRIC:";
dataGridView8.Columns[0].ReadOnly = true;
dataGridView8.Columns[1].HeaderText = "MIN VALUE:";
dataGridView8.Columns[2].HeaderText = "CUR VALUE:";
dataGridView8.Columns[3].HeaderText = "MAX VALUE:";
dataGridView8.Columns[4].HeaderText = "RATE:";
dataGridView8.Columns[5].HeaderText = "VALUE:";
dataGridView8.Columns[5].ReadOnly = true;
dataGridView8.Columns[6].HeaderText = "TYPE:";
adapter = dbw1.fillDataAdapter(SqlConnectionParametrs.DataBaseName, "select mr.MinValue, mr.Curvalue, MaxValue, mr.Rate, mr.Value, mr.Type from MetrInRep mr where mr.id_rep in (select r.id_rep from report r where r.progName like '" + g_reportName + "')");
cmdBuilder = new SqlCommandBuilder(adapter);
UseWaitCursor = false;
dataGridView8_Resize(dataGridView8, null);
try
{
dataSet21 = dataSet11.GetChanges();
if (dataSet21 != null)
{
adapter.Update(dataSet21);
}
}
catch (Exception)
{
dataSet21 = null;
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
//dbworker.Attatch_DataBase(SqlConnectionParametrs.DataBaseName, @"F:\TEMP\123\QUIM.mdf", @"F:\TEMP\123\QUIM_log.ldf"); //TEMP ATTATCHING!!!!!!!!!!!!!!!!!!!!!
DBwork dbw1 = new DBwork("QUIM", "");
DBwork dbw2 = new DBwork("QUIM", "SQLEXPRESS");
try
{
dbw1.ReadDataBaseToDataSet("master", "select * from spt_monitor");
SqlConnectionParametrs.DataBaseServiceName = "";
}
catch (Exception)
{
try
{
dbw2.ReadDataBaseToDataSet("master", "select * from spt_monitor");
SqlConnectionParametrs.DataBaseServiceName = "SQLEXPRESS";
}
catch (Exception)
{
throw new Exception("Data base server 2005 not found.");
}
}
dbworker = new DBwork(SqlConnectionParametrs.DataBaseName, SqlConnectionParametrs.DataBaseServiceName);
//attatching db
dbworker.Attatch_DataBase(SqlConnectionParametrs.DataBaseName, Environment.CurrentDirectory + "\\QUIM.mdf", Environment.CurrentDirectory + "\\QUIM_log.ldf");
//checking struck of db
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from factor");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from criteria");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from metric");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from profile");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from report");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from profile_metric");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from metrInRep");
dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from Factor_Criteria");
//collect garb. after temp selecting
GC.Collect();
}
