Пример #1
0
        private async void addPurchaseButton_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                //Customer
                var dt = QueryForSQLServer.GetCustomerByTel(customerTelTextBox.Text.ToString());
                if (dt.Rows.Count == 0)
                {
                    var _newCustomer = new Customer
                    {
                        Tel           = customerTelTextBox.Text.ToString(),
                        Customer_Name = customerNameTextBox.Text.ToString()
                    };
                    QueryForSQLServer.InsertCustomer(_newCustomer);
                }
                else
                {
                    customerNameTextBox.Text = dt.Rows[0].ItemArray[0].ToString();
                }


                //Purchase
                var purchase = new Purchase()
                {
                    Created_At   = DateTime.Now,
                    Total        = list.Sum((dynamic p) => p.SubTotal as Nullable <decimal>),
                    Customer_Tel = customerTelTextBox.Text.ToString(),
                    Status       = (PurchaseStatus)(purchaseStatesComboBox.SelectedIndex + 1)
                };
                var p_id = QueryForSQLServer.InsertPurchase(purchase);

                //PurchaseDetail
                if (p_id == -1)
                {
                    var messageDialog = await new MessageDialog("Failed", "Confirm").ShowAsync();
                    return;
                }
                else
                {
                    foreach (dynamic item in list)
                    {
                        purchase.PurchaseDetails.Add(new PurchaseDetail()
                        {
                            Purchase_ID = p_id,
                            Product_ID  = item.Product_ID,
                            Price       = item.Unit_Price,
                            Quantity    = item.Quantity,
                            Total       = item.SubTotal
                        });
                    }
                    foreach (dynamic item in purchase.PurchaseDetails)
                    {
                        QueryForSQLServer.InsertPurchaseDetail(item);
                    }
                }


                var messageDialog2 = await new MessageDialog("Success", "Confirm").ShowAsync();
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
            }
        }