private void button4_Click(object sender, EventArgs e) { selling_permit s = new selling_permit(); int id = int.Parse(comboBox1.Text); entities ent = new entities(); s = (from wa in ent.selling_permit where wa.sell_permit_id == id select wa).First(); selling_permit_items si = new selling_permit_items(); si.sell_permit_id = id; si.item_name = comboBox4.Text; si.amount = int.Parse(textBox3.Text); ent.selling_permit_items.Add(si); ent.SaveChanges(); comboBox1.Text = comboBox2.Text = comboBox3.Text = comboBox4.Text = textBox3.Text = string.Empty; MessageBox.Show("item added"); }
private void button1_Click(object sender, EventArgs e) { try { entities ent = new entities(); selling_permit s = new selling_permit(); selling_permit_items si = new selling_permit_items(); s.sell_permit_id = int.Parse(comboBox1.Text); si.sell_permit_id = int.Parse(comboBox1.Text); s.warehouse_id = int.Parse(comboBox2.Text); s.permit_date = dateTimePicker3.Value; si.item_name = comboBox4.Text; si.supplier_name = comboBox3.Text; si.amount = int.Parse(textBox3.Text); ent.selling_permit.Add(s); ent.selling_permit_items.Add(si); ent.SaveChanges(); comboBox1.Text = comboBox2.Text = comboBox3.Text = comboBox4.Text = textBox3.Text = string.Empty; } catch { MessageBox.Show("failed"); } }
private void button2_Click(object sender, EventArgs e) { try { selling_permit s = new selling_permit(); int id = int.Parse(comboBox1.Text); entities ent = new entities(); s = (from wa in ent.selling_permit where wa.sell_permit_id == id select wa).First(); s.warehouse_id = int.Parse(comboBox2.Text); s.permit_date = dateTimePicker3.Value; selling_permit_items si = new selling_permit_items(); string name = comboBox4.Text; si = (from wa in ent.selling_permit_items where wa.sell_permit_id == id && wa.item_name == name select wa).First(); si.amount = int.Parse(textBox3.Text); si.supplier_name = comboBox3.Text; ent.SaveChanges(); } catch { MessageBox.Show("enter a valid data"); } }