Ejemplo n.º 1
0
        public bool RemoveDeleted(List <long> userIds)
        {
            bool result = true;
            int  i      = 1;

            var languagesQuery = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            var languagesIds   = Enum.GetValues(typeof(LanguageShortName)).Cast <LanguageShortName>()
                                 .Where(e => languagesQuery.GetByShortName(e) != null)
                                 .Select(e => languagesQuery.GetByShortName(e).Id).ToList();

            foreach (long userId in userIds)
            {
                foreach (var languageId in languagesIds)
                {
                    IUserKnowledgeQuery userKnowledgeQuery = new UserKnowledgeQuery(userId, languageId);
                    if (!userKnowledgeQuery.RemoveDeleted())
                    {
                        Console.WriteLine("Не удалось удалить знания пользователя {0} по языку {1}!", userId);
                        result = false;
                    }
                }
                if (i % 100 == 0)
                {
                    Console.WriteLine("Удалены старые данные для {0} пользователей из {1}!", i, userIds.Count);
                }
                i++;
            }
            return(result);
        }
Ejemplo n.º 2
0
        public void Create(string file)
        {
            var csvReader = new CsvReader(file);

            var      languages = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language from      = languages.GetByShortName(_from);
            Language russian   = languages.GetByShortName(LanguageShortName.Ru);

            //заголовок не учитывать
            string[] firstLine = csvReader.ReadLine();

            var popularWordsQuery = new PopularWordsQuery();

            do
            {
                string[] line = csvReader.ReadLine();
                if (line == null)
                {
                    break;
                }
                if (line.Length < 2)
                {
                    continue;
                }

                SourceWithTranslation popularWord = popularWordsQuery.GetOrCreate(CreateWordForUser(line[0], from),
                                                                                  CreateWordForUser(line[1], russian),
                                                                                  _type);
                Console.WriteLine("{0}: {1}", popularWord != null ? "Сохранено" : "Не сохранено",
                                  line.Aggregate((e1, e2) => e1 + " -> " + e2));
            } while (true);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Возвращает перевод для слова
        /// </summary>
        /// <param name="sourceLanguage">язык, на котором введено слово</param>
        /// <param name="destinationLanguage">язык, на который нужно перевести слово</param>
        /// <param name="word">слово, которое нужно перевести</param>
        /// <returns>переведенное слово</returns>
        public ActionResult Translation(string sourceLanguage, string destinationLanguage, string word)
        {
            const string ACTION_NAME = "Index";

            if (WebSettingsConfig.Instance.IsSectionForbidden(SectionId))
            {
                return(RedirectToAction("Index", RouteConfig.MAIN_CONTROLLER_NAME));
            }

            var languages = new LanguagesQuery(WebSettingsConfig.Instance.DefaultLanguageFrom,
                                               WebSettingsConfig.Instance.DefaultLanguageTo);

            LanguageShortName source        = LanguagesQuery.ParseShortName(sourceLanguage);
            LanguageShortName destination   = LanguagesQuery.ParseShortName(destinationLanguage);
            UserLanguages     userLanguages = languages.GetLanguagesByShortNames(source, destination);

            if (UserLanguages.IsInvalid(userLanguages) || string.IsNullOrEmpty(word))
            {
                return(RedirectToAction(ACTION_NAME, ControllerName));
            }

            List <PronunciationForUser> translationWords = GetTranslationsByQuery(userLanguages, word);

            return(View(ACTION_NAME, new TranslatorModel(userLanguages, word, translationWords)));
        }
Ejemplo n.º 4
0
        public ActionResult Translation(long userId, long?sourceId, long?translationId)
        {
            if (WebSettingsConfig.Instance.IsSectionForbidden(_sectionId))
            {
                return(RedirectToAction("Index", RouteConfig.MAIN_CONTROLLER_NAME));
            }

            if (!sourceId.HasValue || !translationId.HasValue)
            {
                return(RedirectToAction(_viewName));
            }
            List <SourceWithTranslation> sourceWithTranslations = _query.GetExact(userId,
                                                                                  sourceId.Value,
                                                                                  translationId.Value);

            if (sourceWithTranslations == null || sourceWithTranslations.Count == 0)
            {
                return(RedirectToAction(_viewName));
            }
            var languages = new LanguagesQuery(WebSettingsConfig.Instance.DefaultLanguageFrom,
                                               WebSettingsConfig.Instance.DefaultLanguageTo);
            SourceWithTranslation currentSentence = sourceWithTranslations.Single(e => e.IsCurrent);
            UserLanguages         userLanguages   = languages.GetLanguages(new List <long> {
                currentSentence.Source.LanguageId,
                currentSentence.Translation.LanguageId
            });

            if (UserLanguages.IsInvalid(userLanguages))
            {
                return(RedirectToAction(_viewName));
            }
            return(View(_viewName, new ShuffleModel(userLanguages, sourceWithTranslations)));
        }
Ejemplo n.º 5
0
        private void SetLanguages()
        {
            var      languages = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language english   = languages.GetByShortName(LanguageShortName.En);
            Language russian   = languages.GetByShortName(LanguageShortName.Ru);

            _englishLanguageId = english.Id;
            _russianLanguageId = russian.Id;
        }
Ejemplo n.º 6
0
        private static UserLanguages GetUserLanguages()
        {
            var languagesQuery = new LanguagesQuery(WebSettingsConfig.Instance.DefaultLanguageFrom,
                                                    WebSettingsConfig.Instance.DefaultLanguageTo);
            UserLanguages userLanguages = languagesQuery.GetLanguagesByShortNames(LanguageShortName.En,
                                                                                  LanguageShortName.Ru);

            return(userLanguages);
        }
Ejemplo n.º 7
0
        public void Create(string file)
        {
            var csvReader = new CsvReader(file);
            //var sentences = IoCModule.Create<SentencesQuery>();
            var      languages = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language from      = languages.GetByShortName(_from);
            Language russian   = languages.GetByShortName(LanguageShortName.Ru);

            string[] firstLine = csvReader.ReadLine();
            if (firstLine == null || EnumerableValidator.IsEmpty(firstLine))
            {
                return;
            }

            string groupName = TextFormatter.FirstUpperCharAndTrim(firstLine[0]);

            if (string.IsNullOrEmpty(groupName) || groupName.Length < 2)
            {
                return;
            }
            var groupsQuery = new GroupsQuery(from.Id);

            string fileName = firstLine.Length > 1 && !string.IsNullOrWhiteSpace(firstLine[1])
                                  ? firstLine[1].Trim()
                                  : groupName;
            string imageFileName = Path.Combine(@"C:\Projects\StudyLanguages\Источники для групп\Источники картинок\",
                                                fileName + ".jpg");

            //создает или получает раннее созданную группу
            byte[]       image        = !string.IsNullOrEmpty(imageFileName) ? File.ReadAllBytes(imageFileName) : null;
            GroupForUser groupForUser = groupsQuery.GetOrCreate(GroupType, groupName, image);

            do
            {
                string[] line = csvReader.ReadLine();
                if (line == null)
                {
                    break;
                }
                if (line.Length < 2)
                {
                    continue;
                }
                image = line.Length > 2 && !string.IsNullOrEmpty(line[2]) ? File.ReadAllBytes(line[2]) : null;
                int?rating = null;
                int rat;
                if (line.Length > 3 && int.TryParse(line[3], out rat))
                {
                    rating = rat;
                }

                bool isSuccess = Create(groupForUser, line, from, russian, image, rating);
                Console.WriteLine("{0}: {1}", isSuccess ? "Сохранено" : "Не сохранено",
                                  line.Aggregate((e1, e2) => e1 + " -> " + e2));
            } while (true);
        }
Ejemplo n.º 8
0
        public async Task Get()
        {
            var logger = testConfig.GetLoggerFactory().CreateLogger <LanguageGetHandler>();

            LanguageGetHandler eventHandlers = new LanguageGetHandler(testConfig.GetDbContext(), logger);
            LanguagesQuery     query         = new LanguagesQuery();
            IList <Language>   res           = await eventHandlers.Handle(query, new CancellationToken());

            Assert.AreEqual(2, res.Count);
        }
Ejemplo n.º 9
0
        public override void OnActionExecuting(ActionExecutingContext filterContext)
        {
            List <long> parsedLanguagesIds = GetLanguagesIdsFromCookie(filterContext);
            var         languages          = new LanguagesQuery(WebSettingsConfig.Instance.DefaultLanguageFrom,
                                                                WebSettingsConfig.Instance.DefaultLanguageTo);
            UserLanguages userLanguages = languages.GetLanguages(parsedLanguagesIds);

            filterContext.ActionParameters[_userLanguagesParamName] = userLanguages;
            filterContext.RouteData.Values[_userLanguagesParamName] = userLanguages;
        }
Ejemplo n.º 10
0
        private void LoadLanguages()
        {
            if (DefaultUserLanguages != null)
            {
                return;
            }
            var languages = new LanguagesQuery(DefaultLanguageFrom,
                                               DefaultLanguageTo);

            DefaultUserLanguages = languages.GetLanguages(null);
        }
Ejemplo n.º 11
0
        public TVSeriesCreator(LanguageShortName language,
                               string outputPath,
                               string origSeriesName,
                               string transSeriesName)
        {
            _outputPath      = outputPath;
            _origSeriesName  = origSeriesName;
            _transSeriesName = transSeriesName;
            var languagesQuery = new LanguagesQuery(language, LanguageShortName.Ru);

            _languageId  = languagesQuery.GetByShortName(language).Id;
            _seriesQuery = new TVSeriesQuery(_languageId);
        }
Ejemplo n.º 12
0
        public static void Fill()
        {
            var      languages         = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language language          = languages.GetByShortName(LanguageShortName.En);
            long     englishLanguageId = language.Id;

            IPronunciationQuery pronunciationQuery = new SentencesQuery();

            pronunciationQuery.FillSpeak(englishLanguageId);

            pronunciationQuery = new WordsQuery();
            pronunciationQuery.FillSpeak(englishLanguageId);
        }
Ejemplo n.º 13
0
        public static void Fill(string groupName, string folder)
        {
            var      languages = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language english   = languages.GetByShortName(LanguageShortName.En);
            Language russian   = languages.GetByShortName(LanguageShortName.Ru);
            //первую строку пропускаем

            string        imagePath  = Path.Combine(folder, groupName);
            List <string> imageFiles = Directory.GetFiles(imagePath, "*.*")
                                       .Where(file => file.ToLower().EndsWith("jpg") || file.ToLower().EndsWith("jpeg"))
                                       .ToList();

            new DbAdapter().ActionByContext(c => {
                int i = 1;
                foreach (string imageFile in imageFiles)
                {
                    string englishWord = Path.GetFileNameWithoutExtension(imageFile);
                    ImageConverter.ResizeSmallImages(imageFile);

                    Image image      = Image.FromFile(imageFile);
                    var memoryStream = new MemoryStream();
                    image.Save(memoryStream, ImageFormat.Jpeg);
                    byte[] imageBytes = memoryStream.ToArray();

                    IQueryable <WordTranslation> wordTranslations = (from wt in c.WordTranslation
                                                                     join w1 in c.Word on wt.WordId1 equals w1.Id
                                                                     join w2 in c.Word on wt.WordId2 equals w2.Id
                                                                     join gw in c.GroupWord on wt.Id equals
                                                                     gw.WordTranslationId
                                                                     join g in c.Group on gw.GroupId equals g.Id
                                                                     where
                                                                     g.Name == groupName &&
                                                                     ((w1.Text == englishWord &&
                                                                       w1.LanguageId == english.Id) ||
                                                                      (w2.Text == englishWord &&
                                                                       w2.LanguageId == english.Id))
                                                                     select wt);
                    List <WordTranslation> wordsTranslation = wordTranslations.ToList();
                    foreach (WordTranslation wordTranslation in wordsTranslation)
                    {
                        wordTranslation.Image = imageBytes;
                        c.SaveChanges();
                        Console.WriteLine("{0}. {1} сохранено", i, englishWord);
                    }
                    i++;
                }
                ;
            });
        }
Ejemplo n.º 14
0
        private void LoadLanguages()
        {
            if (_userLanguages != null)
            {
                return;
            }

            var languagesQuery = new LanguagesQuery(LanguageShortName.Ru,
                                                    LanguageShortName.En);

            _userLanguages = languagesQuery.GetLanguages(null);

            AddToShortName(languagesQuery, _userLanguages.From.Id);
            AddToShortName(languagesQuery, _userLanguages.To.Id);
        }
        public bool RemoveWithoutData(List <long> userIds)
        {
            bool result = true;
            int  i      = 1;

            var         languagesQuery = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            List <long> languagesIds   =
                Enum.GetValues(typeof(LanguageShortName)).Cast <LanguageShortName>().Where(e => languagesQuery.GetByShortName(e) != null).Select(
                    e => languagesQuery.GetByShortName(e).Id).ToList();

            foreach (long userId in userIds)
            {
                foreach (long languageId in languagesIds)
                {
                    IUserRepetitionKnowledgeQuery repetitionQuery = new UserRepetitionKnowledgeQuery(userId, languageId,
                                                                                                     KnowledgeDataType.
                                                                                                     All);
                    IUserRepetitionIntervalQuery userRepetitionIntervalQuery = new UserRepetitionIntervalQuery(userId,
                                                                                                               languageId,
                                                                                                               KnowledgeSourceType
                                                                                                               .
                                                                                                               Knowledge,
                                                                                                               repetitionQuery,
                                                                                                               RepetitionType
                                                                                                               .All);
                    if (!userRepetitionIntervalQuery.RemoveWithoutData())
                    {
                        Console.WriteLine(
                            "Не удалось удалить данные о повторениях для пользователя {0} для языка {1}!", userId,
                            languageId);
                        result = false;
                    }
                }
                if (i % 100 == 0)
                {
                    Console.WriteLine("Удалены данные о повторениях для {0} несуществующих пользователей из {1}!", i,
                                      userIds.Count);
                }
                i++;
            }
            return(result);
        }
Ejemplo n.º 16
0
        public void Fill()
        {
            var csvReader = new CsvReader(@"C:\Projects\StudyLanguages\1.csv");

            string[] line;
            var      sentences = new SentencesQuery();
            var      languages = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language english   = languages.GetByShortName(LanguageShortName.En);
            Language russian   = languages.GetByShortName(LanguageShortName.Ru);

            do
            {
                line = csvReader.ReadLine();
                if (line != null)
                {
                    SourceWithTranslation sentenceWithTranslation =
                        sentences.GetOrCreate(SentenceType.Separate,
                                              new PronunciationForUser(IdValidator.INVALID_ID, line[0],
                                                                       false, english.Id),
                                              new PronunciationForUser(IdValidator.INVALID_ID, line[1],
                                                                       false, russian.Id),
                                              null, null);
                    Console.WriteLine("{0}: {1}", sentenceWithTranslation != null ? "Сохранено" : "Не сохранено",
                                      line.Aggregate((e1, e2) => e1 + " -> " + e2));
                }
            } while (line != null);

            /* for (int i = 1; i <= 100000; i++) {
             *  SentenceWithTranslation sentenceWithTranslation =
             *      sentences.CreateSentencencesWithTranslation(english, "Test sentence number " + i, russian,
             *                                                  "Тестовое предложение № " + i);
             *  if (sentenceWithTranslation == null) {
             *      Console.WriteLine("Не удалось сохранить предложение {0}. Нажмите Enter...", i);
             *      Console.ReadLine();
             *  }
             *
             *  if (i % 10000 == 0) {
             *      Console.WriteLine("Сохранено {0} предложений", i);
             *  }
             * }*/
        }
Ejemplo n.º 17
0
        public void Fill(VideoForUser videoForUser)
        {
            long languageId =
                new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown).GetByShortName(
                    LanguageShortName.En).Id;

            string title    = videoForUser.Title;
            string htmlCode = videoForUser.HtmlCode;

            byte[] image = GetImage(title, htmlCode);

            var          videosQuery = new VideosQuery(languageId);
            VideoForUser result      = videosQuery.GetOrCreate(VideoType.Clip, videoForUser, image, null);

            if (result != null)
            {
                Console.WriteLine("Видео \"{0}\" успешно добавлено", title);
            }
            else
            {
                Console.WriteLine("Не удалось добавить видео \"{0}\"!!!", title);
            }
        }
Ejemplo n.º 18
0
        public void Create(string fileName, string pathToImagePattern)
        {
            var csvReader = new CsvReader(fileName);

            var      languages            = new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown);
            Language from                 = languages.GetByShortName(_from);
            Language to                   = languages.GetByShortName(LanguageShortName.Ru);
            var      representationsQuery = new RepresentationsQuery(from.Id);

            string[] line = csvReader.ReadLine();
            if (line.Length < 1 || string.IsNullOrEmpty(line[0]))
            {
                Console.WriteLine("Некорректная первая строка в файле {0}!", fileName);
                return;
            }

            int imageIndex = 0;

            if (line.Length >= 2 && !string.IsNullOrEmpty(line[1]))
            {
                imageIndex = 1;
            }

            string imageFileName = string.Format(pathToImagePattern, line[imageIndex].Trim());
            Image  image         = Image.FromFile(imageFileName);
            var    memoryStream  = new MemoryStream();

            image.Save(memoryStream, ImageFormat.Jpeg);
            byte[] imageBytes = memoryStream.ToArray();

            string visualDictionaryName = line[0];

            byte?widthPercent = null;

            if (line.Length > 2)
            {
                byte w;
                if (byte.TryParse(line[2], out w) && w > 0 && w <= 100)
                {
                    widthPercent = w;
                }
            }
            visualDictionaryName = char.ToUpper(visualDictionaryName[0]) + visualDictionaryName.Substring(1);

            var representationForUser = new RepresentationForUser(IdValidator.INVALID_ID, visualDictionaryName,
                                                                  imageBytes,
                                                                  new Size(image.Size.Width, image.Size.Height),
                                                                  widthPercent);
            bool hasErrors = false;

            do
            {
                line = csvReader.ReadLine();
                if (line != null)
                {
                    if (line.Length < 6)
                    {
                        hasErrors = true;
                        break;
                    }

                    PronunciationForUser englishWord = CreateWordForUser(line[0], from);
                    PronunciationForUser russianWord = CreateWordForUser(line[1], to);

                    Point leftTopPoint     = CreatePoint(line[2], line[3]);
                    Point rightBottomPoint = CreatePoint(line[4], line[5]);

                    if (englishWord == null || russianWord == null || leftTopPoint == null || rightBottomPoint == null)
                    {
                        hasErrors = true;
                        break;
                    }

                    var representationArea = new RepresentationAreaForUser(IdValidator.INVALID_ID, leftTopPoint,
                                                                           rightBottomPoint)
                    {
                        Source = russianWord, Translation = englishWord
                    };
                    representationForUser.AddArea(representationArea);
                }
            } while (line != null);

            if (hasErrors)
            {
                Console.WriteLine("В файле {0} возникли ошибки! Файл не будет сохранен", fileName);
                return;
            }

            RepresentationForUser savedRepresentation = representationsQuery.GetOrCreate(representationForUser);

            Console.WriteLine("Визуальный словарь {0} {1}", representationForUser.Title,
                              savedRepresentation != null ? "сохранен" : "НЕ сохранен!");
        }
        public byte[] Generate(LanguageShortName from, LanguageShortName to, HashSet <long> visualDictionariesIds)
        {
            var           languagesQuery       = new LanguagesQuery(from, to);
            UserLanguages userLanguages        = languagesQuery.GetLanguagesByShortNames(from, to);
            var           representationsQuery = new RepresentationsQuery(userLanguages.From.Id);

            List <RepresentationForUser> allRepresentations = representationsQuery.GetBought(userLanguages,
                                                                                             visualDictionariesIds);

            PdfGenerator commonPdfGenerator = allRepresentations.Count > 1
                                                  ? new PdfGenerator(_fontPath, _domain, "Все визуальные словари")
                                                  : null;

            var zipKey = GetZipKey(allRepresentations, @from, to);
            var result = _cache.Get(zipKey);

            if (result != null)
            {
                return(result);
            }

            var painter          = new Painter();
            var partImageCreator = new PartImageCreator(painter);

            foreach (RepresentationForUser representation in allRepresentations)
            {
                var tableData = new TableData(3, true);
                tableData.AddHeader(string.Empty, "Слово", "Перевод");

                string title = representation.Title;

                /*if (pictureName != "Лицо" /*&& pictureName != "Человек"#1#) {
                 *  continue;
                 * }*/

                var   byteStream  = new MemoryStream(representation.Image);
                Image image       = Image.FromStream(byteStream);
                var   wordsWriter = new WordsWriter(painter, image.Width, image.Height);

                foreach (RepresentationAreaForUser area in representation.Areas)
                {
                    Point leftCorner  = area.LeftUpperCorner;
                    Point rightCorner = area.RightBottomCorner;

                    string partKey = representation.Id + "_part_" + area.Id + "_"
                                     + representation.SortInfo.LastModified.Ticks + "_" + from + "_" + to + ".jpeg";
                    byte[] partImageBytes = _cache.Get(partKey);
                    if (partImageBytes == null)
                    {
                        PartImageData partImageData = partImageCreator.CutImage(leftCorner, rightCorner, image);

                        partImageBytes = ImageToBytes(partImageData.Bitmap);
                        WriteToCache(partKey, partImageBytes);
                    }
                    tableData.AddRow(new[] {
                        TableDataCell.CreateImage(partImageBytes), TableDataCell.CreateText(area.Source.Text),
                        TableDataCell.CreateText(area.Translation.Text)
                    });

                    wordsWriter.AddRectangle(leftCorner, rightCorner, area);
                }

                string fullKey = representation.Id + "_" + representation.SortInfo.LastModified.Ticks + "_" + from + "_" + to + ".jpeg";

                byte[] imageResult = _cache.Get(fullKey);
                if (imageResult == null)
                {
                    Image imageWithSign = wordsWriter.GetImageWithSigns(image);
                    imageResult = ImageToBytes(imageWithSign);

                    WriteToCache(fullKey, imageResult);
                }

                var    pdfFileName = title + ".pdf";
                string pdfKey      = representation.Id + "_" + representation.SortInfo.LastModified.Ticks + "_" + from + "_" + to + "_" + pdfFileName;
                byte[] pdfContent  = _cache.Get(pdfKey);

                if (pdfContent == null)
                {
                    var pdfGenerator = new PdfGenerator(_fontPath, _domain, string.Format(
                                                            "Визуальный словарь на тему {0}",
                                                            title));
                    WriteDataToPdf(pdfGenerator, title, imageResult, tableData);
                    pdfContent = pdfGenerator.GetAsBytes();
                    WriteToCache(pdfKey, pdfContent);
                }
                _zipCompressor.AddFileToArchive(pdfFileName, pdfContent);

                if (commonPdfGenerator != null)
                {
                    WriteDataToPdf(commonPdfGenerator, title, imageResult, tableData);
                    commonPdfGenerator.NewPage();
                }
            }
            if (commonPdfGenerator != null)
            {
                WritePdfToArchive(commonPdfGenerator, "Всё в одном файле.pdf");
            }

            result = _zipCompressor.GetArchive();
            WriteToCache(zipKey, result);
            return(result);
        }
Ejemplo n.º 20
0
        public void Process()
        {
            long languageId =
                new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown).GetByShortName(
                    _shortName).Id;

            const int MAX_DOMAIN_TO_PROCESS = 10;

            List <Tuple <string, List <string> > > linksByDomains = _linksHelper.Analyze();

            foreach (var tuple in linksByDomains.Take(MAX_DOMAIN_TO_PROCESS))
            {
                IVideoDataGetter videoDataGetter = GetVideoDataGetterByDomain(tuple.Item1);
                if (videoDataGetter == null)
                {
                    continue;
                }

                int           failCount    = 0;
                int           successCount = 0;
                List <string> links        = tuple.Item2;
                foreach (string link in links)
                {
                    string encodedLink = FileHelper.EncodeFileName(link);

                    IVideoData videoData = GetVideoDataFromCache(videoDataGetter, encodedLink);
                    if (videoData == null)
                    {
                        //для этой ссылки данных нет в кэше - получить их от Getter'а
                        videoData = videoDataGetter.GetVideoData(link);
                    }

                    if (videoData == null)
                    {
                        Console.WriteLine("Для ссылки {0} НЕ удалось получить данные!", link);
                        failCount++;
                        continue;
                    }

                    SaveVideoDataToCache(videoDataGetter, encodedLink, videoData);

                    if (videoDataGetter.IsInvalid(videoData, _shortName))
                    {
                        Console.WriteLine("Для ссылки {0} данные некорректны!", link);
                        failCount++;
                        continue;
                    }

                    var videosQuery  = new VideosQuery(languageId);
                    var videoForUser = new VideoForUser(videoData.Title, videoData.HtmlCode);
                    //TODO: поиск дубликатов видео

                    //TODO: сохранять дополнительную информацию в БД
                    VideoForUser result = videosQuery.GetOrCreate(VideoType.Movie, videoForUser, videoData.ThumnailImage, videoData.Rating);
                    if (result != null)
                    {
                        successCount++;
                    }
                    else
                    {
                        Console.WriteLine("Не удалось добавить видео \"{0}\"!!!", videoData.Title);
                    }
                }
                Console.WriteLine("Обработан домен {0} из {1} ссылок успешно сохранены {2}, не удалось сохранить {3}",
                                  tuple.Item1, links.Count, successCount, failCount);
            }
        }
Ejemplo n.º 21
0
        public async Task <IList <Language> > Handle(LanguagesQuery query, CancellationToken cancellationToken)
        {
            IList <Language> result = await db.Languages.ToListAsync();

            return(result);
        }
Ejemplo n.º 22
0
        public void Fill(LanguageShortName languageShortName, string fileName)
        {
            long languageId =
                new LanguagesQuery(LanguageShortName.Unknown, LanguageShortName.Unknown).GetByShortName(languageShortName).Id;
            var crossReferencesQuery = new CrossReferencesQuery(languageId);

            bool hasErrors = false;
            var  ids       = new HashSet <long>();
            var  csvReader = new CsvReader(fileName);
            int  i         = 0;

            do
            {
                i++;
                string[] line = csvReader.ReadLine();
                if (line == null)
                {
                    break;
                }

                if (line.Length != 4)
                {
                    ShowError(
                        "Некорректное кол-во полей в строке {0}: Ожидаем 4, а полей {1}. Для продолжения нажмите Enter...",
                        i, line.Length);
                    continue;
                }

                string             source          = GetTrimmed(line[0]);
                CrossReferenceType sourceType      = GetCrossType(line[1]);
                string             destination     = GetTrimmed(line[2]);
                CrossReferenceType destinationType = GetCrossType(line[3]);

                if (string.IsNullOrEmpty(source) || string.IsNullOrEmpty(destination) ||
                    sourceType == CrossReferenceType.Unknown || destinationType == CrossReferenceType.Unknown)
                {
                    ShowError("Некорректные данные в строке {0}: {1}. Для продолжения нажмите Enter...", i,
                              string.Join(";", line));
                    continue;
                }

                long id = crossReferencesQuery.Add(source, sourceType, destination, destinationType);
                if (IdValidator.IsValid(id))
                {
                    ids.Add(id);
                    Console.WriteLine("Обработана строка под номером {0}", i);
                }
                else
                {
                    hasErrors = true;
                    ShowError(
                        "Не удалось сохранить данные из строки {0}. Источник {1}, тип источника {2}, приемник {3}, тип источника {4}. Для продолжения нажмите Enter...",
                        i, source, sourceType, destination, destinationType);
                }
            } while (true);
            if (!hasErrors)
            {
                crossReferencesQuery.RemoveAllExceptIds(ids);
            }

            Console.WriteLine("С ссылками все");
            Console.ReadLine();
        }