コード例 #1
0
        public async Task SaveSessionDataAsync(ApiRegInfo apiRegInfo, Manufacturer manufacturer, int numberOfResult, int startingRecord, Proxy proxy)
        {
            ApiSearchSession apiSearchSession = await _context.ApiSearchSessions.FirstOrDefaultAsync(a => a.ApiRegInfo == apiRegInfo && a.Date == DateTime.Today && a.Manufacturer == manufacturer);

            if (apiSearchSession != null)
            {
                apiSearchSession.CountOfRequests++;
                apiSearchSession.Manufacturer = manufacturer;
                //apiSearchSession.NumberOfResult = numberOfResult;
                //apiSearchSession.StartingRecord = startingRecord;
                apiSearchSession.Proxy = proxy;
            }
            else
            {
                _context.ApiSearchSessions.Add(new ApiSearchSession
                {
                    Date            = DateTime.Today,
                    ApiRegInfo      = apiRegInfo,
                    CountOfRequests = 1,
                    Manufacturer    = manufacturer,
                    //NumberOfResult = numberOfResult,
                    //StartingRecord = startingRecord,
                    Proxy = proxy
                });
            }
            await _context.SaveChangesAsync();
        }
コード例 #2
0
        private async void simpleButton5_Click(object sender, EventArgs e)
        {
            using (Domain.ApplicationContext context = new Domain.ApplicationContext())
            {
                List <Manufacturer> manufacturers = await context.Manufacturers.Where(m => m.MouserID != 0 && m.SearchText == null).ToListAsync();

                ApiRegInfo apiRegInfo = await context.ApiRegInfos.FirstOrDefaultAsync(a => a.IsActive);

                Proxy proxy = await context.Proxies.FirstOrDefaultAsync(p => p.IsActive);

                string[] alphabet = { ".", "1", "2", "3", "4", "5", "6", "7", "8", "9" };

                foreach (Manufacturer manufacturer in manufacturers)
                {
                    foreach (string letter in alphabet)
                    {
                        this.labelControl4.Text = "[" + letter + "] - " + manufacturer.MouserID + " - " + manufacturer.NameAPI;
                        this.Refresh();

                        Thread.Sleep(1500);
                        await Mouser.Service.Api.Methods.SearchByKeywordMfrRequestSetResulCountAsync(context, proxy, apiRegInfo, letter, manufacturer);
                    }
                }
            }
            MessageBox.Show("Done!");
        }
コード例 #3
0
        public async Task AddIterationAsync(ApiRegInfo apiRegInfo, Manufacturer manufacturer, Proxy proxy)
        {
            ApiSearchSession apiSearchSession = await _context.ApiSearchSessions
                                                .FirstOrDefaultAsync(a => a.ApiRegInfo == apiRegInfo && a.Date == DateTime.Today && a.Proxy == proxy && a.Manufacturer == manufacturer);

            if (apiSearchSession != null)
            {
                apiSearchSession.CountOfRequests++;
            }
            else
            {
                _context.ApiSearchSessions.Add(new ApiSearchSession
                {
                    Date            = DateTime.Today,
                    ApiRegInfo      = apiRegInfo,
                    CountOfRequests = 1
                });
            }
            await _context.SaveChangesAsync();
        }
コード例 #4
0
        public static async Task SearchByKeywordMfrRequestAsync(ApplicationContext context, Proxy proxy, ApiRegInfo apiRegInfo, string keyword, Manufacturer manufacturer, int records, int startingRecord)
        {
            using (var searchAPI = new SearchAPI())
            {
                var header = new MouserHeader();
                header.AccountInfo           = new AccountInfo();
                header.AccountInfo.PartnerID = apiRegInfo.PartnerId;
                searchAPI.MouserHeaderValue  = header;

                WebProxy wp = new WebProxy(proxy.IPAddress, true);
                if (proxy.UserName != "")
                {
                    ICredentials credentials = new NetworkCredential(proxy.UserName, proxy.Password);
                    wp.Credentials = credentials;
                }
                searchAPI.Proxy = wp;

                ResultParts resultParts = searchAPI.SearchByKeywordAndManufacturer(keyword, manufacturer.MouserID, records, startingRecord, String.Empty, String.Empty);

                EFManufacturer eFManufacturer = new EFManufacturer(context);
                manufacturer.StartingRecord = startingRecord;
                manufacturer.NumberOfResult = resultParts.NumberOfResult;
                await eFManufacturer.AddOrUpdateAsync(manufacturer, manufacturer.Id);

                foreach (var resultPart in resultParts.Parts.ToList())
                {
                    await SaveGoodAsync(context, resultPart, manufacturer);
                }
            }
        }
コード例 #5
0
        private async Task StartProcessAsync()
        {
            int maxIteration = 10;

            using (Domain.ApplicationContext context = new Domain.ApplicationContext())
                using (StreamWriter sw = new StreamWriter(writePath, true, System.Text.Encoding.UTF8))
                {
                    sw.WriteLine(DateTime.Now.ToString() + " Start");

                    ApiSearchSession   apiSearchSession   = null;
                    EFApiSearchSession eFApiSearchSession = new EFApiSearchSession(context);

                    try
                    {
                        //Получаем PartnerID
                        EFApiRegInfo eFApiRegInfo        = new EFApiRegInfo(context);
                        ApiRegInfo   availableApiRegInfo = await eFApiRegInfo.GetAvailableParnterIdAsync();

                        sw.WriteLine(availableApiRegInfo.PartnerId);
                        //Получаем прокси
                        EFProxy eFProxy        = new EFProxy(context);
                        Proxy   availableProxy = eFProxy.GetAvailableProxyAsync().Result;
                        sw.WriteLine(availableProxy.IPAddress);
                        //Получаем свободного производителя
                        EFManufacturer eFManufacturer        = new EFManufacturer(context);
                        Manufacturer   availableManufacturer = eFManufacturer.GetAvailableManufacturerAsync().Result;
                        sw.WriteLine(availableManufacturer.MouserID);
                        //if (availableApiRegInfo != null && availableProxy != null && availableManufacturer != null)
                        //{
                        //Создаем очередь
                        apiSearchSession = new ApiSearchSession
                        {
                            ApiRegInfo   = availableApiRegInfo,
                            Date         = DateTime.Today,
                            IsBusy       = true,
                            Manufacturer = availableManufacturer,
                            Proxy        = availableProxy
                        };
                        eFApiSearchSession.AddOrUpdateAsync(apiSearchSession, -1).Wait();
                        //Запускаем запросы api
                        int count = 1;
                        while (count <= maxIteration)
                        {
                            count++;
                        }
                        eFApiSearchSession.SetNotBusyAsync(apiSearchSession).Wait();
                        System.Environment.Exit(1);
                        //}
                    }
                    catch (Exception ex)
                    {
                        sw.WriteLine(DateTime.Now.ToString() + " " + ex.Message + ex.InnerException.Message);
                    }
                    finally
                    {
                        //Очередь освобождаем
                        if (apiSearchSession != null)
                        {
                            eFApiSearchSession.SetNotBusyAsync(apiSearchSession).Wait();
                        }

                        System.Environment.Exit(1);
                    }
                }
        }
コード例 #6
0
        //private static string writePath = @"D:\MouserClient\MouserClientApi" + Guid.NewGuid() + ".log";

        static async Task Main(string[] args)
        {
            ApiSearchSession apiSearchSession = null;

            try
            {
                int maxIteration = 5;

                using (Domain.ApplicationContext context = new Domain.ApplicationContext())
                //using (StreamWriter sw = new StreamWriter(writePath, true, System.Text.Encoding.UTF8))
                {
                    //sw.WriteLine(DateTime.Now.ToString() + " Start");
                    EFApiSearchSession eFApiSearchSession = new EFApiSearchSession(context);

                    //Получаем PartnerID
                    EFApiRegInfo eFApiRegInfo        = new EFApiRegInfo(context);
                    ApiRegInfo   availableApiRegInfo = await eFApiRegInfo.GetAvailableParnterIdAsync();

                    //sw.WriteLine(availableApiRegInfo?.PartnerId);

                    try
                    {
                        //Получаем прокси
                        EFProxy eFProxy        = new EFProxy(context);
                        Proxy   availableProxy = await eFProxy.GetAvailableProxyAsync();

                        //sw.WriteLine(availableProxy?.IPAddress);
                        //Получаем свободного производителя
                        EFManufacturer eFManufacturer        = new EFManufacturer(context);
                        Manufacturer   availableManufacturer = await eFManufacturer.GetAvailableManufacturerAsync();

                        //sw.WriteLine(availableManufacturer?.MouserID);
                        if (availableApiRegInfo != null && availableProxy != null && availableManufacturer != null &&
                            !context.ApiSearchSessions.Where(a => a.IsBusy && a.Date == DateTime.Today).Select(a => a.Manufacturer.Id).Contains(availableManufacturer.Id))
                        {
                            //Создаем очередь
                            apiSearchSession = new ApiSearchSession
                            {
                                ApiRegInfo   = availableApiRegInfo,
                                Date         = DateTime.Today,
                                IsBusy       = true,
                                Manufacturer = availableManufacturer,
                                Proxy        = availableProxy,
                                MachineName  = Environment.MachineName,
                                CreateDate   = DateTime.Now
                            };
                            await eFApiSearchSession.AddOrUpdateAsync(apiSearchSession, -1);

                            //Запускаем запросы api
                            int count          = 1;
                            int countIteration = availableManufacturer.StartingRecord != 0 ? (availableManufacturer.StartingRecord - 1) / 50 + 1 : 0;
                            int startingRecord = 0;
                            while (count <= maxIteration && (startingRecord == 0 || startingRecord < availableManufacturer.NumberOfResult))
                            {
                                startingRecord = countIteration != 0 ? countIteration * 50 + 1 : 0;
                                await Mouser.Service.Api.Methods.SearchByKeywordMfrRequestAsync
                                    (context, availableProxy, availableApiRegInfo, availableManufacturer.SearchText ?? ".", availableManufacturer, 50, startingRecord);

                                await eFApiSearchSession.AddIterationAsync(apiSearchSession);

                                count++;
                                countIteration++;
                            }
                            await eFApiSearchSession.SetNotBusyAsync(apiSearchSession);

                            //sw.WriteLine(DateTime.Now.ToString() + " Stop");
                        }
                    }
                    catch (Exception ex)
                    {
                        if (ex.Message.Contains("Error Code: 429") || ex.Message.Contains("Invalid unique identifier"))
                        {
                            availableApiRegInfo.IsActive = false;
                            await eFApiRegInfo.AddOrUpdateAsync(availableApiRegInfo, availableApiRegInfo.Id);
                        }

                        if (apiSearchSession != null)
                        {
                            apiSearchSession.Description = ex.Message + ex.InnerException?.Message;
                            await eFApiSearchSession.AddOrUpdateAsync(apiSearchSession, apiSearchSession.Id);

                            await eFApiSearchSession.SetNotBusyAsync(apiSearchSession);
                        }
                        //using (StreamWriter sw = new StreamWriter(writePath, true, System.Text.Encoding.UTF8))
                        //{
                        //    sw.WriteLine(DateTime.Now.ToString() + " " + ex.Message + ex.InnerException?.Message);
                        //    sw.WriteLine(DateTime.Now.ToString() + " Error Stop (2)");
                        //}
                    }
                    finally
                    {
                        //Очередь освобождаем
                        if (apiSearchSession != null)
                        {
                            await eFApiSearchSession.SetNotBusyAsync(apiSearchSession);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                //using (StreamWriter sw = new StreamWriter(writePath, true, System.Text.Encoding.UTF8))
                //{
                //    sw.WriteLine(DateTime.Now.ToString() + " " + ex.Message + ex.InnerException?.Message);
                //    sw.WriteLine(DateTime.Now.ToString() + " Error Stop (2)");
                //}
            }
        }