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(); }