public EditDocumentForm(Document doc) { InitializeComponent(); this.documentId = doc.ID; using (var db = new WereDesktopEntities()) { editDocumentSourceLookUpEdit.Properties.DataSource = db.Contragent.ToList(); editDocumentSourceLookUpEdit.EditValue = doc.SourceID; editDocumentDestinationLookUpEdit.Properties.DataSource = db.Contragent.ToList(); editDocumentDestinationLookUpEdit.EditValue = doc.DestinationID; editDocumentNumberTE.Text = doc.DocumentNumber.ToString(); editDocumentDateTE.Text = doc.Date.ToString(); var documents = db.Document.Where(d => d.ID == documentId).ToList(); foreach (Document d in documents) { document = d; } } //CheckUserInput(); }
public XtraReportDocument(Document document, List <DocumentRowCart> list) { InitializeComponent(); xrSourceContragentName.Text = document.Contragent.Name; xrSourceContragentBulstat.Text = document.Contragent.Bulstat; xrSourceContragentVATNumber.Text = document.Contragent.VatNumber; xrSourceContragentAddress.Text = document.Contragent.Address; xrSourceContragentCity.Text = document.Contragent.City; xrSourceContragentMrp.Text = document.Contragent.Mrp; xrSourceContragentPhoneNumber.Text = document.Contragent.PhoneNumber; xrDestinationContragentName.Text = document.Contragent1.Name; xrDestinationContragentBulstat.Text = document.Contragent1.Bulstat; xrDestinationContragentVATNumber.Text = document.Contragent1.VatNumber; xrDestinationContragentAddress.Text = document.Contragent1.Address; xrDestinationContragentCity.Text = document.Contragent1.City; xrDestinationContragentMrp.Text = document.Contragent1.Mrp; xrDestinationContragentPhoneNumber.Text = document.Contragent1.PhoneNumber; using (var db = new WereDesktopEntities()) { objectDataSource3.DataSource = list; } foreach (DocumentRowCart dr in list) { sum += dr.Sum; } sumWithoutDDS.Text = sum.ToString(); sumWithDDS.Text = (decimal.ToDouble(sum) * 1.2).ToString(); }
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 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 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 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 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 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 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); } } } }
public SelectContragentForm() { InitializeComponent(); using (var db = new WereDesktopEntities()) { contragentTreeListLookUpEdit.Properties.DataSource = db.Contragent.ToList(); } }
private void updateScreen(WereDesktopEntities db) { contragentBindingSource.DataSource = db.Contragent.ToList(); var selected = SelectedContragent; contragentBindingSource.DataSource = db.Contragent.ToList(); }
public XtraUserControlDocuments() { InitializeComponent(); using (var db = new WereDesktopEntities()) { documentBindingSource.DataSource = db.Document.Include(d => d.Contragent).Include(d => d.Contragent1).ToList(); } }
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); } }
public XtraUserControlContragents() { InitializeComponent(); using (var db = new WereDesktopEntities()) { contragentBindingSource.DataSource = db.Contragent.ToList(); } }
private void updateScreen(WereDesktopEntities db) { productBindingSource.DataSource = db.Product.ToList(); var selected = SelectedProduct; lotBindingSource1.DataSource = db.Lot.Where(l => l.ProductID == selected.ID).ToList(); barcodeBindingSource.DataSource = db.Barcode.Where(b => b.ProductID == selected.ID).ToList(); }
private void updateScreen(WereDesktopEntities db) { documentBindingSource.DataSource = db.Document.Include(d => d.Contragent).Include(d => d.Contragent1).ToList(); var selected = SelectedDocument; documentRowBindingSource.DataSource = db.DocumentRow.Where(dr => dr.DocumentID == selected.ID).ToList(); documentPaymentBindingSource.DataSource = db.DocumentPayment.Where(dp => dp.DocumentId == selected.ID).ToList(); }
private void productGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { var selected = SelectedProduct; using (var db = new WereDesktopEntities()) { lotBindingSource1.DataSource = db.Lot.Where(l => l.ProductID == selected.ID).ToList(); barcodeBindingSource.DataSource = db.Barcode.Where(b => b.ProductID == selected.ID).ToList(); } }
public AddProductToDocumentRowForm(List <Classes.DocumentRowCart> list) { this.documentRowsList = list; InitializeComponent(); using (var db = new WereDesktopEntities()) { productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList(); } CheckUserInput(); }
private void documentGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { var selected = SelectedDocument; using (var db = new WereDesktopEntities()) { documentRowBindingSource.DataSource = db.DocumentRow.Include(dr => dr.Product).Include(dr => dr.Lot).Where(dr => dr.DocumentID == selected.ID).ToList(); documentPaymentBindingSource.DataSource = db.DocumentPayment.Where(dp => dp.DocumentId == selected.ID).ToList(); } }
public XtraUserControlCreateDocument() { InitializeComponent(); using (var db = new WereDesktopEntities()) { //db.Lot.Load(); productBindingSource.DataSource = db.Product.Include(p => p.Lot).ToList(); } changeLabelValues(); }
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 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 productTreeListLookUpEdit_Properties_EditValueChanged(object sender, EventArgs e) { if (productTreeListLookUpEdit.EditValue != null) { var productID = productTreeListLookUpEdit.EditValue.ToString(); using (var db = new WereDesktopEntities()) { productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList(); lotTreeListLookUpEdit.Properties.DataSource = db.Lot.Where(l => l.ProductID == productID).ToList(); } } }
private void addContragent() { addForm = new AddContragentForm(); addForm.MaximizeBox = false; addForm.MinimizeBox = false; addForm.ShowDialog(); using (var db = new WereDesktopEntities()) { contragentBindingSource.DataSource = db.Contragent.ToList(); } }
private void addProduct() { addProductForm = new AddProductForm(); addProductForm.MaximizeBox = false; addProductForm.MinimizeBox = false; addProductForm.ShowDialog(); using (var db = new WereDesktopEntities()) { productBindingSource.DataSource = db.Product.ToList(); } }
public AddDocumentRowForm(string id) { InitializeComponent(); this.DocumentID = id; using (var db = new WereDesktopEntities()) { productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList(); lotTreeListLookUpEdit.Properties.DataSource = db.Lot.ToList(); } CheckUserInput(); }
private void editDocumentRowProductTreeListLookUpEdit_EditValueChanged(object sender, EventArgs e) { if (editDocumentRowProductTreeListLookUpEdit.EditValue != null) { var productID = editDocumentRowProductTreeListLookUpEdit.EditValue.ToString(); using (var db = new WereDesktopEntities()) { editDocumentRowProductTreeListLookUpEdit.Properties.DataSource = db.Product.ToList(); editDocumentRowLotTreeListLookUpEdit.Properties.DataSource = db.Lot.Where(l => l.ProductID == productID).ToList(); } } CheckUserInput(); }
private void editDocumentRow() { editDocumentRowForm = new EditDocumentRowForm(SelectedDocumentRow); editDocumentRowForm.MaximizeBox = false; editDocumentRowForm.MinimizeBox = false; if (editDocumentRowForm.ShowDialog() == DialogResult.OK) { using (var db = new WereDesktopEntities()) { updateScreen(db); } } }
private void documentsGridControl_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { deleteDocument(); } else if (e.KeyCode == Keys.F5) { using (var db = new WereDesktopEntities()) { 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 } }