public EditCategoryForm()
{
InitializeComponent();
comboBox1.Items.AddRange(ConnectionDB.Select("select cat.ID_cat, cat.Name from category cat").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
cat_id = comboBox1.SelectedItem.ToString().Split(' ')[0];
textBoxName.Text = ConnectionDB.SelectOne("select Name from category where ID_cat=" + cat_id);
}
public EditDiseaseForm()
{
InitializeComponent();
comboBox1.Items.AddRange(ConnectionDB.Select("select dis.ID_disease, dis.Name from disease dis").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
dis_id = comboBox1.SelectedItem.ToString().Split(' ')[0];
textBoxName.Text = ConnectionDB.SelectOne("select Name from disease where ID_disease=" + dis_id);
}
public EditSymptomForm()
{
InitializeComponent();
comboBox1.Items.AddRange(ConnectionDB.Select("select sym.ID_symptom, sym.Name from symptom sym").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
sym_id = comboBox1.SelectedItem.ToString().Split(' ')[0];
textBoxName.Text = ConnectionDB.SelectOne("select Name from symptom where ID_symptom=" + sym_id);
}
public AddMedicamentForm()
{
InitializeComponent();
comboBoxIDCat.Items.AddRange(ConnectionDB.Select("select cat.ID_cat, cat.Name from category cat").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
comboBoxDis.Items.AddRange(ConnectionDB.Select("select dis.ID_disease, dis.Name from disease dis").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
comboBoxSym.Items.AddRange(ConnectionDB.Select("select sym.ID_symptom, sym.Name from symptom sym").Split(new[] { '$' }, StringSplitOptions.RemoveEmptyEntries));
}
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();
}
