private void button1_Click(object sender, EventArgs e)
{
TestDataSet.OtvetyRow row = testDataSet1.Otvety.NewOtvetyRow();
row.textOtveta = textBox1.Text;
testDataSet1.Otvety.AddOtvetyRow(row);
otvetyTableAdapter1.Update(testDataSet1.Otvety);
int idOtveta = (int)otvetyTableAdapter1.LastInsertId();
TestDataSet.OtvetyUchenikaRow row1 = testDataSet1.OtvetyUchenika.NewOtvetyUchenikaRow();
row1.id_Olimpiady = Convert.ToInt32(comboBox1.SelectedValue);
row1.id_Otveta = idOtveta;
row1.id_Uchenika = Convert.ToInt32(comboBox3.SelectedValue);
row1.id_Voprosa = Convert.ToInt32(comboBox2.SelectedValue);
row1.otvetUchenika = textBox1.Text;
testDataSet1.OtvetyUchenika.AddOtvetyUchenikaRow(row1);
}
private void button2_Click(object sender, EventArgs e)
{
if (_act != 'u')
{
try
{
TestDataSet.VoprosyRow row = testDataSet1.Voprosy.NewVoprosyRow();
row.bally_zaVopros = Convert.ToInt32(textBox3.Text);
row.id_oblastVoprosa = Convert.ToInt32(comboBox2.SelectedValue);
row.id_tipVoprosa = Convert.ToInt32(comboBox1.SelectedValue);
row.izobrazhenie = textBox4.Text;
row.slozhnostVoprosa = Convert.ToInt32(numericUpDown1.Value);
List <Otvety> _otvety = _questionPanel.GetData();
row.textVoprosa = _otvety[0].textOtveta;
testDataSet1.Voprosy.AddVoprosyRow(row);
voprosyTableAdapter1.Update(testDataSet1.Voprosy);
int id = (int)voprosyTableAdapter1.LastInsertId();
testDataSet1.AcceptChanges();
//вставка ответов
for (int i = 1; i < _otvety.Count; i++)
{
TestDataSet.OtvetyRow row1 = testDataSet1.Otvety.NewOtvetyRow();
row1.textOtveta = _otvety[i].textOtveta;
testDataSet1.Otvety.AddOtvetyRow(row1);
otvetyTableAdapter1.Update(testDataSet1.Otvety);
int idOtveta = (int)otvetyTableAdapter1.LastInsertId();
TestDataSet.Otvety_naVoprosyRow row2 = testDataSet1.Otvety_naVoprosy.NewOtvety_naVoprosyRow();
row2.id_Otveta = idOtveta;
row2.id_Voprosa = id;
row2.rightOtvet = _otvety[i].isWright;
testDataSet1.Otvety_naVoprosy.AddOtvety_naVoprosyRow(row2);
otvety_naVoprosyTableAdapter1.Update(testDataSet1.Otvety_naVoprosy);
}
MessageBox.Show("Вопрос успешно добавлен!", "Уведомление", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
