Ejemplo n.º 1
0
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            listBox1.Items.Clear();
            int       whID = int.Parse(comboBox1.Text);
            warehouse wh   = (from it in ent.warehouses
                              where it.warehouse_id == whID

                              select it).First();

            var supplying_permits = (from it in wh.supplying_permit
                                     select it);

            foreach (supplying_permit s in supplying_permits)
            {
                var items = (from it in s.supplying_permit_items
                             select it);
                foreach (supplying_permit_items i in items)
                {
                    listBox1.Items.Add(" item " + i.item_name.Trim() + " supplied with amount " + i.amout);
                }
            }
            var sell_per = (from it in wh.selling_permit
                            select it);

            foreach (selling_permit s in sell_per)
            {
                var items = (from it in s.selling_permit_items
                             select it);
                foreach (selling_permit_items i in items)
                {
                    listBox1.Items.Add(" item " + i.item_name.Trim() + " sold with amount " + i.amount);
                }
            }
            var ex_permit = (from it in wh.exchang_permit
                             select it);

            foreach (exchang_permit s in ex_permit)
            {
                var items = (from it in s.exchane_permit_items
                             select it);
                foreach (exchane_permit_items i in items)
                {
                    listBox1.Items.Add("item " + i.item_name.Trim() + "  exchanged into with amount " + i.amount);
                }
            }
            var ex_permit_out = (from it in wh.exchang_permit1
                                 select it);

            foreach (exchang_permit s in ex_permit_out)
            {
                var items = (from it in s.exchane_permit_items
                             select it);
                foreach (exchane_permit_items i in items)
                {
                    listBox1.Items.Add("item " + i.item_name.Trim() + " exchanged from with amount  " + i.amount);
                }
            }
        }
Ejemplo n.º 2
0
 private void button2_Click(object sender, EventArgs e)
 {
     try {
         warehouse w   = new warehouse();
         int       id  = int.Parse(textBox1.Text);
         entities  ent = new entities();
         w = (from wa in ent.warehouses
              where wa.warehouse_id == id
              select wa).First();
         w.warehouse_name = textBox2.Text;
         w.address        = textBox3.Text;
         w.mgr_id         = int.Parse(textBox4.Text);
         ent.SaveChanges();
         MessageBox.Show("warehouse updated");
         textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = string.Empty;
     }
     catch { MessageBox.Show("no warehouse with this id"); }
 }
Ejemplo n.º 3
0
 private void button1_Click(object sender, EventArgs e)
 {
     try {
         entities  ent = new entities();
         warehouse w   = new warehouse();
         w.warehouse_id   = int.Parse(textBox1.Text);
         w.warehouse_name = textBox2.Text;
         w.mgr_id         = int.Parse(textBox4.Text);
         w.address        = textBox3.Text;
         ent.warehouses.Add(w);
         ent.SaveChanges();
         MessageBox.Show("warehouse added");
         textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = string.Empty;
     }
     catch
     {
         MessageBox.Show("ID can't take this value");
     }
 }