public ViewTable(string tablename)
{
this.tablename = tablename;
this.db = new OnlineStoreEntities();
bs = new BindingSource();
InitializeComponent();
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
switch (tablename)
{
case "ProductType":
ProductType rempt = db.ProductType.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.ProductType.Remove(rempt);
db.SaveChanges();
break;
case "Client":
Client remc = db.Client.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.Client.Remove(remc);
db.SaveChanges();
break;
case "Order":
Order remo = db.Order.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.Order.Remove(remo);
db.SaveChanges();
break;
case "Delivery":
Delivery remd = db.Delivery.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.Delivery.Remove(remd);
db.SaveChanges();
break;
case "Supplier":
Supplier rems = db.Supplier.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.Supplier.Remove(rems);
db.SaveChanges();
break;
case "Product":
Product remp = db.Product.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
db.Product.Remove(remp);
db.SaveChanges();
break;
}
db.Dispose();
db = new OnlineStoreEntities();
UpdateTable();
}
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 toolStripButton1_Click_1(object sender, EventArgs e)
{
switch (tablename)
{
case "ProductType":
ProductType rempt = db.ProductType.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditProductType editpt = new EditProductType(rempt);
if (editpt.ShowDialog() == DialogResult.OK)
{
rempt.Category = editpt.Result.Category;
rempt.Description = editpt.Result.Description;
db.SaveChanges();
}
break;
case "Client":
Client remc = db.Client.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditClient editc = new EditClient(remc);
if (editc.ShowDialog() == DialogResult.OK)
{
remc.Fullname = editc.Result.Fullname;
remc.Address = editc.Result.Address;
remc.City = editc.Result.City;
remc.Country = editc.Result.Country;
remc.Phonenumber = editc.Result.Phonenumber;
db.SaveChanges();
}
break;
case "Order":
Order remo = db.Order.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditOrder edito = new EditOrder(remo);
if (edito.ShowDialog() == DialogResult.OK)
{
remo.ClientID = edito.Result.ClientID;
remo.Date = edito.Result.Date;
remo.Amount = edito.Result.Amount;
remo.ProductID = edito.Result.ProductID;
remo.DeliveryID = edito.Result.DeliveryID;
db.SaveChanges();
}
break;
case "Delivery":
Delivery remd = db.Delivery.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditDelivery editd = new EditDelivery(remd);
if (editd.ShowDialog() == DialogResult.OK)
{
remd.Name = editd.Result.Name;
remd.Phonenumber = editd.Result.Phonenumber;
db.SaveChanges();
}
break;
case "Supplier":
Supplier rems = db.Supplier.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditSupplier edits = new EditSupplier(rems);
if (edits.ShowDialog() == DialogResult.OK)
{
rems.Name = edits.Result.Name;
rems.Address = edits.Result.Address;
rems.City = edits.Result.City;
rems.Phonenumber = edits.Result.Phonenumber;
rems.Email = edits.Result.Email;
db.SaveChanges();
}
break;
case "Product":
Product rem = db.Product.Find(dataGridView1.SelectedRows[0].Cells["ID"].Value);
EditProduct editform = new EditProduct(rem);
if (editform.ShowDialog() == DialogResult.OK)
{
rem.Name = editform.Result.Name;
rem.ProductTypeID = editform.Result.ProductTypeID;
rem.SupplierID = editform.Result.SupplierID;
rem.Measure = editform.Result.Measure;
db.SaveChanges();
}
break;
}
db.Dispose();
db = new OnlineStoreEntities();
UpdateTable();
}
public Form1()
{
InitializeComponent();
db = new OnlineStoreEntities();
}