private void butAdd_Click(object sender, EventArgs e)
{
string sql = "insert into MEDICAMENT values('" + textBoxIDMed.Text + "','" + textBoxName.Text + "')";
ConnectionDB.Insert(sql);
Close();
}
private void button1_Click(object sender, EventArgs e)
{
int dis_id = int.Parse(ConnectionDB.SelectOne("select max(ID_disease) from disease"));
dis_id++;
string sql = "insert into disease values('" + dis_id + "','" + textBox1.Text + "')";
ConnectionDB.Insert(sql);
Close();
}
private void butAdd_Click(object sender, EventArgs e)
{
int cat_id = int.Parse(ConnectionDB.SelectOne("select max(ID_symptom) from symptom"));
cat_id++;
string sql = "insert into category values('" + cat_id + "','" + textBoxName.Text + "')";
ConnectionDB.Insert(sql);
Close();
}
private void button1_Click(object sender, EventArgs e)
{
int sym_id = int.Parse(ConnectionDB.Select("select max(ID_symptom) from symptom"));
sym_id++;
string sql = "insert into symptom values('" + sym_id + "','" + textBox1.Text + "')";
ConnectionDB.Insert(sql);
Close();
}
private void butAdd_Click(object sender, EventArgs e)
{
// (1,3,'парацетамол','15/10/19',null)
string cat_id = comboBoxIDCat.SelectedItem.ToString().Split(' ')[0];
string sym_id = comboBoxDis.SelectedItem.ToString().Split(' ')[0];
string dis_id = comboBoxSym.SelectedItem.ToString().Split(' ')[0];
int med_id = int.Parse(ConnectionDB.SelectOne("select max(ID_med) from medicament"));
med_id++;
string sql = "insert into MEDICAMENT values(" + med_id + "," +
cat_id + ",'" + textBoxName.Text + "','" + dateTimePicker1.Value.ToString("dd/MM/yy") + "', null)";
string sql1 = "insert into medicament_disease values(" + med_id + "," + dis_id + ")";
string sql2 = "insert into MEDICAMENT values(" + med_id + "," + sym_id + ")";
ConnectionDB.Insert(sql);
ConnectionDB.Insert(sql1);
ConnectionDB.Insert(sql2);
Close();
}