private void deleteLot() { var deleteLot = SelectedLot; DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избраната партида?", "Потвърждение", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { //delete row from database or datagridview... using (var db = new WereDesktopEntities()) { if (deleteLot != null) { foreach (var docRow in db.DocumentRow.Where(row => row.LotID == deleteLot.ID)) { db.DocumentRow.Remove(docRow); } db.SaveChanges(); deleteLot.DocumentRow = null; db.Lot.Attach(deleteLot); db.Lot.Remove(deleteLot); db.SaveChanges(); updateScreen(db); } } } else if (dr == DialogResult.No) { //Nothing to do } }
private void deleteDocument() { var documentToDelete = SelectedDocument; if (documentToDelete != null) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete selected entry?", "Warning", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { using (var db = new WereDesktopEntities()) { var rowsToDelete = db.DocumentRow.Where(r => r.DocumentID == documentToDelete.ID).ToList(); var paymentsToDelete = db.DocumentPayment.Where(p => p.DocumentId == documentToDelete.ID).ToList(); foreach (DocumentPayment p in paymentsToDelete) { db.DocumentPayment.Attach(p); db.DocumentPayment.Remove(p); db.SaveChanges(); } foreach (DocumentRow r in rowsToDelete) { using (var dbForLotUpdate = new WereDesktopEntities()) { Lot lotToUpdate = new Lot(); var lots = dbForLotUpdate.Lot.Where(l => l.ID == r.LotID).ToList(); foreach (Lot lot in lots) { lotToUpdate = lot; } lotToUpdate.Quantity += r.Quantity; dbForLotUpdate.Lot.AddOrUpdate(lotToUpdate); dbForLotUpdate.SaveChanges(); db.DocumentRow.Attach(r); db.DocumentRow.Remove(r); db.SaveChanges(); } } using (var bd = new WereDesktopEntities()) { var docs = bd.Document.Where(d => d.ID == documentToDelete.ID).ToList(); foreach (Document d in docs) { bd.Document.Attach(d); bd.Document.Remove(d); bd.SaveChanges(); } } } using (var db = new WereDesktopEntities()) { updateScreen(db); } } } }
private void addDocumentButton_Click(object sender, EventArgs e) { try { decimal input = decimal.Parse(inCashET.Text); if (input >= sum) { using (var db = new WereDesktopEntities()) { Document document = new Document(); Guid id = Guid.NewGuid(); document.ID = id.ToString(); document.SourceID = SelectedContragent.SourceContragentID; document.DestinationID = SelectedContragent.contragent.ID; document.DocumentNumber = GenerateDocumentNumber.generateDocumentNumber(); document.Date = DateTime.Now; db.Document.AddOrUpdate(document); db.SaveChanges(); foreach (DocumentRowCart dr in documentRowsList) { DocumentRow docRow = new DocumentRow(); docRow.ID = dr.ID; docRow.ProductID = dr.ProductID; docRow.LotID = dr.LotID; docRow.Quantity = dr.Quantity; docRow.Sum = dr.Sum; docRow.DocumentID = document.ID; db.DocumentRow.Add(docRow); db.SaveChanges(); } DocumentPayment dp = new DocumentPayment(); id = Guid.NewGuid(); dp.ID = id.ToString(); dp.DocumentId = document.ID; dp.MethodOfPayment = "cash"; dp.Price = sum; db.DocumentPayment.Add(dp); db.SaveChanges(); this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void deleteContragent() { using (var db = new WereDesktopEntities()) { var contragentToDelete = SelectedContragent; DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete selected entry?", "Warning", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { if (contragentToDelete != null) { foreach (var doc in db.Document.Where(d => d.SourceID == contragentToDelete.ID || d.DestinationID == contragentToDelete.ID)) { foreach (var payment in db.DocumentPayment.Where(p => p.DocumentId == doc.ID).ToList()) { db.DocumentPayment.Remove(payment); } foreach (var row in db.DocumentRow.Where(r => r.DocumentID == doc.ID).ToList()) { using (var dbForLotUpdate = new WereDesktopEntities()) { Lot lotToUpdate = new Lot(); var lots = dbForLotUpdate.Lot.Where(l => l.ID == row.LotID).ToList(); foreach (Lot lot in lots) { lotToUpdate = lot; } lotToUpdate.Quantity += row.Quantity; dbForLotUpdate.Lot.AddOrUpdate(lotToUpdate); dbForLotUpdate.SaveChanges(); } db.DocumentRow.Remove(row); } doc.DocumentPayment = null; doc.DocumentRow = null; db.Document.Remove(doc); } db.SaveChanges(); contragentToDelete.Document = null; contragentToDelete.Document1 = null; db.Contragent.Attach(contragentToDelete); db.Contragent.Remove(contragentToDelete); db.SaveChanges(); updateScreen(db); } } } }
private void deleteProduct() { var deleteProduct = SelectedProduct; DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избрания продукт", "Потвърждение", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { //delete row from database or datagridview... using (var db = new WereDesktopEntities()) { if (deleteProduct != null) { foreach (var docRow in db.DocumentRow.Where(row => row.ProductID == deleteProduct.ID)) { db.DocumentRow.Remove(docRow); } db.SaveChanges(); foreach (var lot in db.Lot.Where(l => l.ProductID == deleteProduct.ID).ToList()) { db.Lot.Remove(lot); } db.SaveChanges(); foreach (var barcode in db.Barcode.Where(b => b.ProductID == deleteProduct.ID).ToList()) { db.Barcode.Remove(barcode); } db.SaveChanges(); deleteProduct.DocumentRow = null; deleteProduct.Lot = null; deleteProduct.Barcode = null; db.Product.Attach(deleteProduct); db.Product.Remove(deleteProduct); db.SaveChanges(); updateScreen(db); } } } else if (dr == DialogResult.No) { //Nothing to do } }
private void deleteRowTab4() { var deleteRow = SelectedRowTab1; DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избраната партида?", "Потвърждение", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { //delete row from database or datagridview... if (deleteRow != null) { var lotID = deleteRow.LotID; using (var db = new WereDesktopEntities()) { var lots = db.Lot.Where(l => l.ID == lotID).ToList(); foreach (Lot lot in lots) { lot.Quantity = lot.Quantity + deleteRow.Quantity; db.Lot.AddOrUpdate(lot); db.SaveChanges(); } } tab4DocumentRowsList.Remove(deleteRow); changeLabelValues(); documentRowCartBindingSource3.DataSource = tab4DocumentRowsList; documentRowsTab4GridControl.RefreshDataSource(); } } else if (dr == DialogResult.No) { //Nothing to do } }
private void AddDocumentRowButton_Click(object sender, EventArgs e) { double quantity = double.Parse(quantityET.Text); var productID = productTreeListLookUpEdit.EditValue.ToString(); var lotID = lotTreeListLookUpEdit.EditValue.ToString(); using (var db = new WereDesktopEntities()) { var lots = db.Lot.Where(l => l.ID == lotID).ToList(); foreach (Lot lot in lots) { DocumentRow dr = new DocumentRow(); Guid id = Guid.NewGuid(); dr.ID = id.ToString(); dr.ProductID = productID; dr.LotID = lotID; dr.Quantity = quantity; dr.Sum = Convert.ToDecimal(quantity) * lot.Product.Price; dr.DocumentID = DocumentID; lot.Quantity = lot.Quantity - quantity; db.DocumentRow.AddOrUpdate(dr); db.Lot.AddOrUpdate(lot); db.SaveChanges(); this.Close(); } } }
private void ValidateForm() { bool bValidName = ValidateProductName(); bool bValidPrice = ValidateProductPrice(); bool bValidNumber = ValidateProductNumber(); if (bValidName && bValidPrice && bValidNumber) { var name = productNameET.Text; var price = Convert.ToDecimal(productPriceET.Text); var productNumber = productNumberET.Text; using (var db = new WereDesktopEntities()) { Product prod = new Product(); Guid id = Guid.NewGuid(); prod.ID = id.ToString(); prod.Name = name; prod.ProductNumber = productNumber; prod.Price = price; prod.Quantity = 0; db.Product.AddOrUpdate(prod); db.SaveChanges(); this.Close(); } } }
private void deleteBarcode() { var deleteBarcode = SelectedBarcode; DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избрания баркод?", "Потвърждение", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { //delete row from database or datagridview... using (var db = new WereDesktopEntities()) { if (deleteBarcode != null) { db.Barcode.Attach(deleteBarcode); db.Barcode.Remove(deleteBarcode); db.SaveChanges(); updateScreen(db); } } } else if (dr == DialogResult.No) { //Nothing to do } }
private void ValidateForm() { bool bValidBarcode = ValidateBarcode(); if (bValidBarcode) { if (Barcode.ID != null) { var barcodeNumber = barcodeNumberET.Text; using (var db = new WereDesktopEntities()) { Barcode barcode = new Barcode(); barcode.ID = Barcode.ID; barcode.ProductID = Barcode.ProductID; barcode.BarcodeNumber = barcodeNumber; db.Barcode.AddOrUpdate(barcode); db.SaveChanges(); this.Close(); } } } }
private void AddDocumentRowButton_Click(object sender, EventArgs e) { double quantity = double.Parse(quantityET.Text); var productID = productTreeListLookUpEdit.EditValue.ToString(); var lotID = lotTreeListLookUpEdit.EditValue.ToString(); using (var db = new WereDesktopEntities()) { var lots = db.Lot.Where(l => l.ID == lotID).ToList(); foreach (Lot lot in lots) { var products = db.Product.Where(p => p.ID == productID).ToList(); foreach (Product product in products) { if (lot.ID.Equals(lotID)) { quantity = Convert.ToDouble(quantityET.Text); } DocumentRowCart dr = new DocumentRowCart(); Guid id = Guid.NewGuid(); dr.ID = id.ToString(); dr.ProductID = productID; dr.ProductName = product.Name; dr.LotID = lotID; dr.LotNumber = lot.LotNumber; dr.Quantity = quantity; dr.Sum = Convert.ToDecimal(quantity) * lot.Product.Price; var lot1 = lotTreeListLookUpEdit.GetSelectedDataRow() as Lot; db.SaveChanges(); lot.Quantity = lot.Quantity - quantity; db.Lot.AddOrUpdate(lot); db.SaveChanges(); documentRowsList.Add(dr); this.Close(); } } } }
private void addDocumentToDatabaseToBankAccount(List <Classes.DocumentRowCart> list, decimal sum) { using (var db = new WereDesktopEntities()) { Document document = new Document(); Guid id = Guid.NewGuid(); document.ID = id.ToString(); document.SourceID = SelectedContragent.SourceContragentID; document.DestinationID = SelectedContragent.contragent.ID; document.DocumentNumber = GenerateDocumentNumber.generateDocumentNumber(); document.Date = DateTime.Now; db.Document.AddOrUpdate(document); db.SaveChanges(); foreach (DocumentRowCart dr in list) { DocumentRow docRow = new DocumentRow(); docRow.ID = dr.ID; docRow.ProductID = dr.ProductID; docRow.LotID = dr.LotID; docRow.Quantity = dr.Quantity; docRow.Sum = dr.Sum; docRow.DocumentID = document.ID; db.DocumentRow.Add(docRow); db.SaveChanges(); } DocumentPayment dp = new DocumentPayment(); id = Guid.NewGuid(); dp.ID = id.ToString(); dp.DocumentId = document.ID; dp.MethodOfPayment = "bank account"; dp.Price = sum; db.DocumentPayment.Add(dp); db.SaveChanges(); } }
private void editDocumentBtn_Click(object sender, EventArgs e) { document.DestinationID = editDocumentDestinationLookUpEdit.EditValue.ToString(); document.SourceID = editDocumentSourceLookUpEdit.EditValue.ToString(); using (var db = new WereDesktopEntities()) { db.Document.AddOrUpdate(document); db.SaveChanges(); } }
private void ValidateForm() { bool cValidName = ValidateContragentName(); bool cValidBulstat = ValidateContragentBulstat(); bool cValidVatNumber = ValidateContragentVatNumber(); bool cValidCity = ValidateContragentCity(); bool cValidAdresss = ValidateContragentAddress(); bool cValidateMrp = ValidateContragentMrp(); bool cValidatePhone = ValidateContragentPhoneNumber(); if (cValidName && cValidBulstat && cValidVatNumber && cValidCity && cValidAdresss && cValidateMrp && cValidatePhone) { var name = addContragentNameTE.Text; var bulstat = addContragentBulstatTE.Text; var vatNumber = addContragentVatNumberTE.Text; var city = addContragentCityTE.Text; var address = addContragentAddressTE.Text; var MRP = addContragentMrpTE.Text; var phoneNumber = addContragentPhoneNumberTE.Text; using (var db = new WereDesktopEntities()) { Contragent cont = new Contragent(); Guid id = Guid.NewGuid(); cont.ID = id.ToString(); cont.Name = name; cont.Bulstat = bulstat; cont.VatNumber = vatNumber; cont.City = city; cont.Address = address; cont.Mrp = MRP; cont.PhoneNumber = phoneNumber; db.Contragent.AddOrUpdate(cont); db.SaveChanges(); this.Close(); } } }
private void deleteDocumentRow() { using (var db = new WereDesktopEntities()) { var rowToDelete = SelectedDocumentRow; DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete selected entry?", "Warning", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { if (rowToDelete != null) { using (var bd = new WereDesktopEntities()) { Lot lotToUpdate = new Lot(); var lots = bd.Lot.Where(l => l.ID == rowToDelete.LotID).ToList(); foreach (Lot lot in lots) { lotToUpdate = lot; } lotToUpdate.Quantity += rowToDelete.Quantity; bd.Lot.AddOrUpdate(lotToUpdate); bd.SaveChanges(); } //var rows = db.DocumentRow.Where(r => r.ID == rowToDelete.LotID).ToList(); //foreach (DocumentRow row in rows) //{ //rowToDelete = row; //} db.DocumentRow.Attach(rowToDelete); db.DocumentRow.Remove(rowToDelete); db.SaveChanges(); updateScreen(db); } } } }
private void editDocumentRowBtn_Click(object sender, EventArgs e) { var id = documentId; double quantity; double.TryParse(editDocumentRowQuantityTE.Text, out quantity); originalLot.Quantity = originalLot.Quantity + originalQuantity; using (var db = new WereDesktopEntities()) { db.Lot.AddOrUpdate(originalLot); db.SaveChanges(); } selectedRow.ProductID = editDocumentRowProductTreeListLookUpEdit.EditValue.ToString(); selectedRow.LotID = editDocumentRowLotTreeListLookUpEdit.EditValue.ToString(); selectedRow.Quantity = quantity; using (var db = new WereDesktopEntities()) { var lotToUpdate = new Lot(); var lots = db.Lot.Where(l => l.ID == selectedRow.LotID).ToList(); foreach (Lot lot in lots) { lotToUpdate = lot; } lotToUpdate.Quantity = lotToUpdate.Quantity - selectedRow.Quantity; selectedRow.Sum = Convert.ToDecimal(selectedRow.Quantity) * lotToUpdate.Product.Price; db.DocumentRow.AddOrUpdate(selectedRow); db.SaveChanges(); } }
private void editContragentEditBtn_Click(object sender, EventArgs e) { var id = contragent.ID; var name = editContragentNameTE.Text; var bulstat = editContragentBulstatTE.Text; var vatNumber = editContragentVatnumberTE.Text; var city = editContragentCityTE.Text; var address = editContragentAddressTE.Text; var MRP = editContragentMrpTE.Text; var phoneNumber = editContragentPhoneTE.Text; using (var db = new WereDesktopEntities()) { Contragent cont = new Contragent(); cont.ID = id; cont.Name = name; cont.Bulstat = bulstat; cont.VatNumber = vatNumber; cont.City = city; cont.Address = address; cont.Mrp = MRP; cont.PhoneNumber = phoneNumber; db.Contragent.AddOrUpdate(cont); db.SaveChanges(); this.Close(); } }
private void ValidateForm() { bool bValidQuantity = ValidateLotQuantity(); bool bValidDate = ValidateLotDate(); bool bValidNumber = ValidateLotNumber(); if (bValidQuantity && bValidDate && bValidNumber) { if (Lot.ID != null) { var id = Lot.ID; double quantity = Convert.ToDouble(lotQuantityET.Text); var date = DateTime.Parse(lotDateEdit.Text); var lotNumber = lotNumberET.Text; using (var db = new WereDesktopEntities()) { Lot lot = new Lot(); lot.ID = id.ToString(); lot.ProductID = Lot.ProductID; lot.Quantity = quantity; lot.ExpirationDate = date; lot.LotNumber = lotNumber; db.Lot.AddOrUpdate(lot); db.SaveChanges(); this.Close(); } } } }