示例#1
0
        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();
            }
        }