public static async Task <int> ImportCustomers()
        {
            var imp = new QuickBookImportCustomers();
            await Task.Run(() => imp.Start());

            var list = imp.Customers;

            if (list.Count == 0)
            {
                return(0);
            }

            var dt = new DataTable();

            dt.Columns.Add("Name", typeof(string));
            foreach (var name in list)
            {
                dt.Rows.Add(name);
            }

            DbObject.ExecStoredProc("ImportAdvertisersFromQb", (cmd) =>
            {
                cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@advertisers", SqlDbType.Structured)
                {
                    Value = dt
                });
            });

            Advertizer.ReloadAllFromDb();

            return(list.Count);
        }
Beispiel #2
0
        private void ShowEditAdvertizerWindow(Advertizer a)
        {
            var w = new EditAdvertizerWindow();

            w.DataContext = new EditAdvertizerViewModel(a);
            w.ShowDialog();
        }
        private void RequestConnect(object sender, ConnectionInfo connection)
        {
            Advertizer.OutboundReq.Add(connection);
            connection.InvokeOutboundRequest();

            Advertizer.SendRequest(connection);
        }
 public ConnectGame()
 {
     InitializeComponent();
     Advertizer.ClearConnections();
     Advertizer.StartAdvertize();
     GameConnection.ListenForGame();
     GameConnection.GameConnected += GameConnection_GameConnected;
     Advertizer.AdvertizersGotten += LoadAdvertizers;
     Advertizer.NewConnection     += (object s, ConnectionInfo e) => { Application.Current.Dispatcher.Invoke(new Action <ConnectionInfo>(AddConnection), e); };
     Unloaded += ConnectGame_Unloaded;
     Advertizer.GetNameAction = new Func <string>(GetPreferedName);
 }
 private void BtnReload_Click(object sender, RoutedEventArgs e)
 {
     Advertizer.StartGetAdvertizers();
     ConnectionList.IsEnabled = false;
     BtnReload.IsEnabled      = false;
 }
 private void ConnectGame_Unloaded(object sender, RoutedEventArgs e)
 {
     Advertizer.StopAdvertize();
     Advertizer.AdvertizersGotten -= LoadAdvertizers;
     GameConnection.StopListening();// this is not needed but used if the connectionListener never stops.
 }
Beispiel #7
0
 public EditAdvertizerViewModel(Advertizer ad)
 {
     _ad = ad;
 }
Beispiel #8
0
 public void RefreshAdvertizers()
 {
     Advertizer.ReloadAllFromDb();
     RaisePropertyChangedEvent("AllAdvertisers");
 }