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