private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { listBox1.Items.Clear(); string name = comboBox1.Text; Item it = (from ite in ent.Items where ite.Item_name == name select ite).First(); var supplying_permits = (from Supp in it.supplying_permit_items select Supp); foreach (supplying_permit_items s in supplying_permits) { supplying_permit s_p = (from sp in ent.supplying_permit where sp.supp_permit_id == s.supp_permit_id select sp).First(); listBox1.Items.Add(it.Item_name.Trim() + " has been supplied to warehouse : " + s_p.warehouse.warehouse_name.Trim() + " with amount of " + s.amout + " by : " + s_p.supplier_name); } var item_sell = it.selling_permit_items; foreach (selling_permit_items sell in item_sell) { selling_permit sell_permit = sell.selling_permit; listBox1.Items.Add(it.Item_name.Trim() + " has been sold to warehouse : " + sell_permit.warehouse.warehouse_name.Trim() + " with amount of " + sell.amount); } var item_exc = it.exchane_permit_items; foreach (exchane_permit_items ex in item_exc) { exchang_permit ex_permit = ex.exchang_permit; listBox1.Items.Add(it.Item_name.Trim() + " has been exchanged from : " + ex_permit.warehouse1.warehouse_name.Trim() + " to " + ex_permit.warehouse.warehouse_name.Trim() + " with amount of " + ex.amount); } }
private void button1_Click(object sender, EventArgs e) { try { entities ent = new entities(); supplying_permit s = new supplying_permit(); supplying_permit_items si = new supplying_permit_items(); s.supp_permit_id = int.Parse(comboBox1.Text); si.supp_permit_id = int.Parse(comboBox1.Text); s.warehouse_id = int.Parse(comboBox2.Text); s.supplier_name = comboBox3.Text; si.item_name = comboBox4.Text; si.prod_date = dateTimePicker1.Value; si.amout = int.Parse(textBox3.Text); si.exp_date = dateTimePicker2.Value; ent.supplying_permit.Add(s); ent.supplying_permit_items.Add(si); ent.SaveChanges(); comboBox1.Text = comboBox2.Text = comboBox3.Text = comboBox4.Text = textBox3.Text = string.Empty; } catch { MessageBox.Show("failed"); } }
private void button4_Click(object sender, EventArgs e) { try { supplying_permit s = new supplying_permit(); int id = int.Parse(comboBox1.Text); entities ent = new entities(); s = (from wa in ent.supplying_permit where wa.supp_permit_id == id select wa).First(); supplying_permit_items si = new supplying_permit_items(); si.supp_permit_id = id; si.item_name = comboBox4.Text; si.prod_date = dateTimePicker1.Value; si.amout = int.Parse(textBox3.Text); si.exp_date = dateTimePicker2.Value; ent.supplying_permit_items.Add(si); ent.SaveChanges(); comboBox1.Text = comboBox2.Text = comboBox3.Text = comboBox4.Text = textBox3.Text = string.Empty; MessageBox.Show("item added"); } catch { MessageBox.Show("enter a valid data"); } }
private void button2_Click(object sender, EventArgs e) { try { supplying_permit s = new supplying_permit(); int id = int.Parse(comboBox1.Text); entities ent = new entities(); s = (from wa in ent.supplying_permit where wa.supp_permit_id == id select wa).First(); s.warehouse_id = int.Parse(comboBox2.Text); s.supplier_name = comboBox3.Text; supplying_permit_items si = new supplying_permit_items(); string name = comboBox4.Text; si = (from wa in ent.supplying_permit_items where wa.supp_permit_id == id && wa.item_name == name select wa).First(); si.prod_date = dateTimePicker1.Value; si.amout = int.Parse(textBox3.Text); si.exp_date = dateTimePicker2.Value; ent.SaveChanges(); } catch { MessageBox.Show("enter a valid data"); } }