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++;
}
}
}
