void Manufacture()
{
PhoneShopAppEntities db = new PhoneShopAppEntities();
cbxManufacturer.DataSource = db.manufacturers.ToList();
cbxManufacturer.DisplayMember = "Name";
cbxManufacturer.ValueMember = "ID";
}
void Product(int ID)
{
PhoneShopAppEntities db = new PhoneShopAppEntities();
listview.DataSource = db.products.Where(b => b.Manufacturer_ID == ID).ToList();
listview.Columns["ID"].Visible = false;
listview.Columns["Manufacturer"].Visible = false;
listview.Columns["Manufacturer_ID"].Visible = false;
}
void Manufacturer()
{
PhoneShopAppEntities db = new PhoneShopAppEntities();
cbxhangsx.DataSource = db.manufacturers.ToList();
cbxhangsx.ValueMember = "ID";
cbxhangsx.DisplayMember = "Name";
cbxhangsx.SelectedValue = 1;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ProductID == 0)
{
try
{
PhoneShopAppEntities db = new PhoneShopAppEntities();
product bk = new product();
bk.Product_Name = txtProduct.Text;
bk.Warranty = txtWarranty.Text;
bk.Price = txtPrice.Text;
bk.Situation = txtStuation.Text;
bk.Manufacturer_ID = (int)cbxManufacturer.SelectedValue;
ImageConverter converter = new ImageConverter();
byte[] image = (byte[])converter.ConvertTo(pictureBox.Image, typeof(byte[]));
product upload = new product();
upload.Image = image;
bk.Image = image;
db.products.Add(bk);
db.SaveChanges();
MessageBox.Show("Add new product success");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
try
{
PhoneShopAppEntities db = new PhoneShopAppEntities();
bkedit = db.products.Find(bkedit.ID);
bkedit.Product_Name = txtProduct.Text;
bkedit.Warranty = txtWarranty.Text;
bkedit.Price = txtPrice.Text;
bkedit.Situation = txtStuation.Text;
bkedit.Manufacturer_ID = (int)cbxManufacturer.SelectedValue;
ImageConverter converter = new ImageConverter();
byte[] image = (byte[])converter.ConvertTo(pictureBox.Image, typeof(byte[]));
product upload = new product();
upload.Image = image;
bkedit.Image = image;
db.Entry(bkedit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Edit product success");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (listview.SelectedRows.Count == 1)
{
if (MessageBox.Show("Do you want to delete this?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var row = listview.SelectedRows[0];
var cell = row.Cells["ID"];
int ID = (int)cell.Value;
PhoneShopAppEntities db = new PhoneShopAppEntities();
product bk = db.products.Single(b => b.ID == ID);
db.products.Remove(bk);
db.SaveChanges();
Product((int)cbxhangsx.SelectedValue);
ShowList();
}
}
}
