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 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(); } }