public Item Retrieve(int id)
{
SqlConnection sql = connection.Get();
DataTable dt = new DataTable();
SqlDataAdapter adapt = new SqlDataAdapter("select * from [Item_Table]", sql);
adapt.Fill(dt);
ItemsFactory itemsFactory = new ItemsFactory();
Item item = itemsFactory.CreateItem("Burger");
for (int i = 0; i < dt.Rows.Count; i++)
{
item.Id = Convert.ToInt32(dt.Rows[i][0]);//.Cells[0].Value.ToString()) ;
item.Name = dt.Rows[i][1].ToString();
item.price = dt.Rows[i][2].ToString();
item.Category = dt.Rows[i][3].ToString();
if (id == item.Id)
{
sql.Close();
return(item);
}
}
return(null);
////comboBox1.DataSource = dt;
////comboBox1.DisplayMember = "Name";
//ItemData = GetDict(dt);
//comboBox1.Items.AddRange(ItemData.Keys.ToArray());
}
private void button4_Click(object sender, EventArgs e)
{
ItemsFactory itemsFactory = new ItemsFactory();
item = itemsFactory.CreateItem(comboBox2.Text);
item.Id = Convert.ToInt32(textBox5.Text.Trim());
item.Name = textBox3.Text;
item.price = textBox4.Text;
item.Category = comboBox2.Text;
Item_Manager _Manager = new Item_Manager();
_Manager.DeleteItem(item);
v();
}
