C# (CSharp) PriKey_Orders_Recordset Examples

Example #1

        public EditOrderWindow(EditOrderViewModel view_model)
        {
            ViewModel = view_model;

            InitializeComponent();

            if (ViewModel.Mode == EditOrderViewModel.ModelMode.Edit)
            {
                PriKey_Orders_Recordset prikey = new PriKey_Orders_Recordset();

                prikey.ExecSql(ViewModel.OrderID);

                if (prikey.RecordCount != 1)
                {
                    throw new Exception($"Order {ViewModel.OrderID} not found.");
                }

                ViewModel.CustomerID      = prikey.CustomerID;
                ViewModel.OrderDate       = prikey.OrderDate.Substring(0, 10); // cut off the time part
                ViewModel.ShipAddress     = prikey.ShipAddress;
                ViewModel.ShipCity        = prikey.ShipCity;
                ViewModel.ShipPostalCode  = prikey.ShipPostalCode;
                ViewModel.ShipCountryCode = prikey.ShipCountryCode;

                textblockTitle.Text = $"Edit order {prikey.OrderID}";
            }
            else // new
            {
                ViewModel.OrderID         = 0;
                ViewModel.CustomerID      = 117501458387;
                ViewModel.OrderDate       = DateTime.Now.ToString("yyyyMMdd");
                ViewModel.ShipAddress     = "";
                ViewModel.ShipCity        = "";
                ViewModel.ShipPostalCode  = "";
                ViewModel.ShipCountryCode = "US";

                textblockTitle.Text = "New order";
            }

            UpdateShipCountryInfo();

            Loaded += EditOrderWindow_Loaded;
        }