private void EditProduct_Load(object sender, EventArgs e) { var db = new OnlineStoreEntities(); comboBox1.DataSource = db.Supplier.ToList(); comboBox1.DisplayMember = "Name"; comboBox1.ValueMember = "ID"; comboBox2.DataSource = db.ProductType.ToList(); comboBox2.DisplayMember = "Category"; comboBox2.ValueMember = "ID"; if (this.edprod != null) { textBox1.Text = edprod.Name; comboBox1.SelectedValue = edprod.SupplierID; comboBox2.SelectedValue = edprod.ProductTypeID; textBox2.Text = edprod.Measure; } db.Dispose(); }
private void EditOrder_Load(object sender, EventArgs e) { var db = new OnlineStoreEntities(); comboBox1.DataSource = db.Client.ToList(); comboBox1.DisplayMember = "Fullname"; comboBox1.ValueMember = "ID"; comboBox2.DataSource = db.Product.ToList(); comboBox2.DisplayMember = "Name"; comboBox2.ValueMember = "ID"; comboBox3.DataSource = db.Delivery.ToList(); comboBox3.DisplayMember = "Name"; comboBox3.ValueMember = "ID"; if (ed != null) { comboBox1.SelectedValue = ed.ClientID; dateTimePicker1.Value = (DateTime)ed.Date; textBox1.Text = ed.Amount.ToString(); comboBox2.SelectedValue = ed.ProductID; comboBox3.SelectedValue = ed.DeliveryID; } db.Dispose(); }
private void toolStripButton1_Click(object sender, EventArgs e) { switch (tablename) { case "ProductType": EditProductType editpt = new EditProductType(); if (editpt.ShowDialog() == DialogResult.OK) { db.ProductType.Add(editpt.Result); } db.SaveChanges(); break; case "Client": EditClient editc = new EditClient(); if (editc.ShowDialog() == DialogResult.OK) { db.Client.Add(editc.Result); } db.SaveChanges(); break; case "Order": EditOrder edito = new EditOrder(); if (edito.ShowDialog() == DialogResult.OK) { db.Order.Add(edito.Result); } db.SaveChanges(); break; case "Delivery": EditDelivery editd = new EditDelivery(); if (editd.ShowDialog() == DialogResult.OK) { db.Delivery.Add(editd.Result); } db.SaveChanges(); break; case "Supplier": EditSupplier edits = new EditSupplier(); if (edits.ShowDialog() == DialogResult.OK) { db.Supplier.Add(edits.Result); } db.SaveChanges(); break; case "Product": EditProduct editp = new EditProduct(); if (editp.ShowDialog() == DialogResult.OK) { db.Product.Add(editp.Result); } db.SaveChanges(); break; } db.Dispose(); db = new OnlineStoreEntities(); UpdateTable(); }
private void Form1_FormClosing(object sender, FormClosingEventArgs e) { db.Dispose(); }