private void btnDeleteEx_Click(object sender, EventArgs e) { FExportBill fExportBill = new FExportBill(); var IDEx1 = Convert.ToInt32(dgrvEx.CurrentRow.Cells["ID"].Value.ToString()); var list = db.ProductDetails.Where(x => x.IDExBill == IDEx1).ToList(); foreach (var item in list) { FProductDetail dt = new FProductDetail(); dt.Delete(item.ID); } fExportBill.Delete(IDEx1); BindingdgrvEx(); }
private void btnEdit_Click(object sender, EventArgs e) { ExportBill entity = new ExportBill(); entity.ID = IDExBill; entity.Bill = txtBillName.Text; entity.IDWareHouse = Convert.ToInt32(cbWH.SelectedValue); entity.Date = dateTimePicker.Value; entity.Quantity = Convert.ToInt32(txtQuantity.Text); entity.TotalPrice = Convert.ToInt32(txtMoney.Text); FExportBill Ex = new FExportBill(); var result = Ex.Update(entity); var listolder = (from dt in db.ProductDetails.Where(x => x.IDExBill == IDExBill).ToList() from pr in db.Products.Where(x => x.ID == dt.IDProduct).ToList() from com in db.Companies.Where(x => x.ID == pr.IDCompany).ToList() select new { IDProductDetail = dt.ID, ID = pr.ID, Product1 = pr.Product1, Quantity = dt.Quantity, OrdinaryPrice = pr.OrdinaryPrice } ).ToList(); foreach (var item in lprodt) { var search = listolder.Find(x => x.ID == item.IDProduct); if (search == null) { FProductDetail dt = new FProductDetail(); dt.Insert(item); } else { item.ID = search.IDProductDetail; FProductDetail dt = new FProductDetail(); dt.Update(item); } } if (result == true) { MessageBox.Show("Sửa phiếu nhập thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnAdd_Click(object sender, EventArgs e) { ExportBill entity = new ExportBill(); entity.Bill = txtBillName.Text; entity.IDWareHouse = Convert.ToInt32(cbWH.SelectedValue); entity.Date = dateTimePicker.Value; entity.Quantity = Convert.ToInt32(txtQuantity.Text); entity.TotalPrice = Convert.ToInt32(txtMoney.Text); FExportBill Ex = new FExportBill(); var result = Ex.Insert(entity); foreach (var item in lprodt) { item.IDExBill = entity.ID; FProductDetail dt = new FProductDetail(); dt.Insert(item); } if (result == true) { MessageBox.Show("Thêm phiếu nhập thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }