public void addProven(List <string> lista, int id, List <OwnedProductView> dataOwnedProduct, int deliveryNoteID) { ProvenProduct provenProduct = new ProvenProduct(); Product product = new Product(); foreach (string serial in lista) { product = context.Product.FirstOrDefault(c => c.serialNo == serial); if (product == null) { string message = "Zeskanowano serial (" + serial + "), który nie widnieje na fakturze.\nCzy chcesz go dodać?"; const string caption = "Edycja"; var result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { addIncorrectProven(id, deliveryNoteID, serial); } } else { addCorrectProven(id, deliveryNoteID, serial); } } dataGridViewProvenProduct.DataSource = null; dataGridViewProvenProduct.DataSource = (from c in context.OwnedProductView where c.deliveryNoteID == deliveryNoteID select c).ToList(); offTheList(); dataGridViewProvenProduct.Columns["deliveryNoteID"].Visible = false; }
public List <OwnedProductView> loadProducts(int deliveryNoteID) { this.dataOwnedProduct = (from c in context.OwnedProductView where c.deliveryNoteID == deliveryNoteID select c).ToList(); dataGridViewProvenProducts.DataSource = this.dataOwnedProduct; dataGridViewProvenProducts.Columns["deliveryNoteID"].Visible = false; foreach (DataGridViewRow row in dataGridViewProducts.Rows) { var dataGridViewProductCell = row.Cells[0].Value.ToString().Trim(); pProduct = context.ProvenProduct.FirstOrDefault(c => c.cSerialNo == dataGridViewProductCell); if ((pProduct != null) && (pProduct.cSerialNo.Trim().Equals(dataGridViewProductCell))) { row.DefaultCellStyle.BackColor = Color.Green; } } { foreach (DataGridViewRow row in dataGridViewProvenProducts.Rows) { if (row.Cells[4].Value.Equals(true)) { row.DefaultCellStyle.BackColor = Color.Red; } } } return(this.dataOwnedProduct); }
public void addIncorrectProven(int id, int deliveryNoteID, string serial) { ProvenProduct provenProduct = new ProvenProduct(); provenProduct.usersID = id; provenProduct.checkDate = DateTime.Now; provenProduct.deliveryNoteID = deliveryNoteID; provenProduct.cSerialNo = serial.Trim(); provenProduct.cCompany = ""; provenProduct.cOrderNumber = ""; provenProduct.cItemNumber = 0; provenProduct.cProductCode = ""; provenProduct.cProductName = "Produkt nieznany"; provenProduct.offTheList = true; context.ProvenProduct.Add(provenProduct); context.SaveChanges(); }
public void addCorrectProven(int id, int deliveryNoteID, string serial) { ProvenProduct provenProduct = new ProvenProduct(); Product product = new Product(); product = context.Product.FirstOrDefault(c => c.serialNo == serial); provenProduct.usersID = id; provenProduct.checkDate = DateTime.Now; provenProduct.deliveryNoteID = deliveryNoteID; provenProduct.cSerialNo = serial.Trim(); provenProduct.cCompany = product.company; provenProduct.cOrderNumber = product.orderNumber; provenProduct.cItemNumber = product.itemNumber; provenProduct.cProductCode = product.productCode; provenProduct.cProductName = product.productName; provenProduct.offTheList = false; context.ProvenProduct.Add(provenProduct); context.SaveChanges(); }