public Dictionary <int, string> dserializePartsOfFood(int id) { Dictionary <int, string> result = new Dictionary <int, string>(); DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from Food where id=" + id); sdr.Read(); string partsOfFood = sdr.GetString(4); string[] solePartOfFood = partsOfFood.Split(new[] { ';' }, System.StringSplitOptions.RemoveEmptyEntries); foreach (string item in solePartOfFood) { string[] partsOfFoodInfo = item.Split('x'); // [0]number; [1]PartOfFoodsId sdr = dbh.read("select * from PartsOfFood where id=" + partsOfFoodInfo[1]); sdr.Read(); string name = sdr.GetString(1); int mui = sdr.GetInt32(4); sdr = dbh.read("select * from MeasurementUnits where id=" + mui); sdr.Read(); result.Add(Int32.Parse(partsOfFoodInfo[1]), name + partsOfFoodInfo[0] + " " + sdr.GetString(1)); } return(result); }
private void refreshFoodInfo() { int currId = idAndActualIdPairs[listBox1.SelectedIndex]; DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from Food where id=" + currId); sdr.Read(); label6.Text = sdr.GetString(2); int measurementUnitId = sdr.GetInt32(1); int howPrepareId = sdr.GetInt32(3); string partsOfFood = sdr.GetString(4); sdr = dbh.read("select * from MeasurementUnits where id=" + measurementUnitId); sdr.Read(); label8.Text = sdr.GetString(1); string[] solePartOfFood = partsOfFood.Split(new[] { ';' }, System.StringSplitOptions.RemoveEmptyEntries); listBox2.Items.Clear(); foreach (string item in solePartOfFood) { string[] partsOfFoodInfo = item.Split('x'); sdr = dbh.read("select * from PartsOfFood where id=" + partsOfFoodInfo[1]); sdr.Read(); string name = sdr.GetString(1); int mui = sdr.GetInt32(4); label1.Text = mui.ToString(); sdr = dbh.read("select * from MeasurementUnits where id=" + mui); sdr.Read(); //listBox2.Items.Add(name + partsOfFoodInfo[0] + " " + sdr.GetString(1)); listBox2.Items.Add(name + partsOfFoodInfo[0] + " " + sdr.GetString(1)); } sdr = dbh.read("select * from HowPrepare where id=" + howPrepareId); sdr.Read(); label7.Text = sdr.GetString(1); }
public void addItemsToComboBox(ComboBox comBox, int keyPosition, int valuePosition, string table, int conditionPosition, bool compareConditionTo = true) { try { openConnection(); DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from " + table); Dictionary <int, string> comboboxItems = new Dictionary <int, string>(); if (conditionPosition != -1) { while (sdr.Read()) { if (sdr.GetBoolean(conditionPosition) == compareConditionTo) { comboboxItems.Add(sdr.GetInt32(keyPosition), sdr.GetString(valuePosition)); } else { } } } else { while (sdr.Read()) { comboboxItems.Add(sdr.GetInt32(keyPosition), sdr.GetString(valuePosition)); } } comBox.DataSource = new BindingSource(comboboxItems, null); comBox.DisplayMember = "Value"; comBox.ValueMember = "Key"; } catch {} }
private void listBox1_MouseClick(object sender, MouseEventArgs e) { int currId = idAndActualIdPairs[listBox1.SelectedIndex]; DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from PartsOfFood where id=" + currId); sdr.Read(); label6.Text = sdr.GetString(1); label3.Text = sdr.GetInt32(2).ToString(); label5.Text = sdr.GetInt32(3).ToString(); int measurementUnitId = sdr.GetInt32(4); int howPrepareId = sdr.GetInt32(5); sdr = dbh.read("select * from MeasurementUnits where id=" + measurementUnitId); sdr.Read(); label8.Text = sdr.GetString(1); sdr = dbh.read("select * from HowPrepare where id=" + howPrepareId); sdr.Read(); label10.Text = sdr.GetString(1); }
private void listBox2_SelectedIndexChanged(object sender, EventArgs e) { DbHandler dbh = new DbHandler(); dbh.refreshListBox(listBox1, "foodChange", searchResults[listBox2.SelectedIndex]); SqlDataReader sdr = dbh.read("select * from Food where id=" + searchResults[listBox2.SelectedIndex]); sdr.Read(); comboBox1.SelectedValue = sdr.GetInt32(1); comboBox3.SelectedValue = sdr.GetInt32(3); }
private void refreshFields() { DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from PartsOfFood where id=" + searchResults[listBox2.SelectedIndex]); sdr.Read(); textBox4.Text = sdr.GetInt32(2).ToString(); textBox3.Text = sdr.GetInt32(3).ToString(); comboBox1.SelectedValue = sdr.GetInt32(4); comboBox2.SelectedValue = sdr.GetInt32(5); }
private void refreshFields() { DbHandler dbh = new DbHandler(); int pofId = ((KeyValuePair <int, string>)comboBox3.SelectedItem).Key; SqlDataReader sdr = dbh.read("select * from PartsOfFood where id=" + pofId); sdr.Read(); textBox4.Text = sdr.GetInt32(2).ToString(); textBox3.Text = sdr.GetInt32(3).ToString(); comboBox1.SelectedValue = sdr.GetInt32(4); comboBox2.SelectedValue = sdr.GetInt32(5); }
public AddPartOfFood() { InitializeComponent(); //List<string> fields = new List<string>(){"int", "int", "string", "string", "int"}; DbHandler dbh = new DbHandler(); List <List <string> > result = dbh.read((int)DbHandler.TableNames.MeasurementUnits); foreach (List <string> list in result) { comboBox1.Items.Add(list[0]); } }
public Form1() { InitializeComponent(); DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from Food"); for (int i = 0; sdr.Read(); i++) { listBox1.Items.Add(sdr.GetString(2)); idAndActualIdPairs.Add(i, sdr.GetInt32(0)); } listBox2.Items.Clear(); label6.Text = ""; label8.Text = ""; label7.Text = ""; }
public PartOfFood() { InitializeComponent(); DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from PartsOfFood"); for (int i = 0; sdr.Read(); i++) { listBox1.Items.Add(sdr.GetString(1)); idAndActualIdPairs.Add(i, sdr.GetInt32(0)); } label6.Text = ""; label3.Text = ""; label5.Text = ""; label8.Text = ""; label10.Text = ""; }
private void textBox2_TextChanged(object sender, EventArgs e) { DbHandler dbh = new DbHandler(); SqlDataReader sdr = dbh.read("select * from Food"); Regex regularExpression = new Regex(textBox2.Text); listBox2.Items.Clear(); searchResults.Clear(); int i = 0; while (sdr.Read()) { string tmp = regularExpression.Match(sdr.GetString(2)).ToString(); if (tmp != "") { searchResults.Add(i, sdr.GetInt32(0)); listBox2.Items.Add(sdr.GetString(2)); i++; } } }