public static LanguageCollection SelectAll() { LanguageCollection List = new LanguageCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tbl_sp_tblLanguage_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
private static LanguageCollection DBMapping(DBLanguageCollection dbCollection) { if (dbCollection == null) return null; LanguageCollection collection = new LanguageCollection(); foreach (DBLanguage dbItem in dbCollection) { Language item = DBMapping(dbItem); collection.Add(item); } return collection; }
public static LanguageCollection Search(SearchFilter SearchKey) { LanguageCollection collection = new LanguageCollection(); using (var reader = SqlHelper.ExecuteReader("tblLanguage_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { Language obj = new Language(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
private static LanguageCollection DBMapping(DBLanguageCollection dbCollection) { if (dbCollection == null) { return(null); } LanguageCollection collection = new LanguageCollection(); foreach (DBLanguage dbItem in dbCollection) { Language item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Updates the context result with the given Language Collection /// </summary> /// <param name="result"></param> /// <param name="context"></param> private static void UpdateContext(LanguageCollection result, CallContext context) { if (result != null) { LanguageCollection currentResult = context.CurrentResult as LanguageCollection; if (currentResult != null) { Language[] languageArray = (Language[])MainUtil.AddArrays(currentResult.ToArray(), result.ToArray(), typeof(Language)); result = new LanguageCollection(); for (int i = 0; i < languageArray.Length; i++) { result.Add(languageArray[i]); } } context.CurrentResult = result; } context.SetNextIndex(context.Index + 1); }
public static LanguageCollection GetbyUser(string CreatedUser, int CompanyID) { LanguageCollection collection = new LanguageCollection(); Language obj; var sqlParams = new SqlParameter[] { new SqlParameter("@CreatedUser", CreatedUser), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("tblLanguage_GetAll_byUser", sqlParams)) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static LanguageCollection GetAllItem(int CompanyID) { LanguageCollection collection = new LanguageCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("tblLanguage_GetAll", sqlParams)) { while (reader.Read()) { Language obj = new Language(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
/// <summary> /// Gets all the languages available in the current database /// </summary> /// <returns></returns> protected virtual LanguageCollection LoadLanguages() { #region VARIABLES LanguageCollection oLanguages; List <LanguageContract> oGenLanguages; ID oLanguageOriginItemId; Language oLanguage; #endregion oLanguages = null; using (var oContentService = new GenContentServiceProxy()) { oGenLanguages = oContentService.GetLanguages(this.CurrentDatabase); } if (oGenLanguages != null) { oLanguages = new LanguageCollection(); foreach (LanguageContract sGenLanguage in oGenLanguages) { if (!string.IsNullOrEmpty(sGenLanguage.OriginItemId) && !string.IsNullOrEmpty(sGenLanguage.Name) && !string.Equals(sGenLanguage.Name, "*") && ID.TryParse(sGenLanguage.OriginItemId, out oLanguageOriginItemId)) { if (Language.TryParse(sGenLanguage.Name, out oLanguage) && !oLanguages.Contains(oLanguage)) { oLanguage.Origin.ItemId = oLanguageOriginItemId; oLanguages.Add(oLanguage); } } } } return(oLanguages); }
public LanguageCollection LoadLanguages() { var languages = Provider.GetItemsByTemplate(TemplateIDs.Language.Guid); LanguageCollection languageCollection = new LanguageCollection(); foreach (var language in languages.Where(x=>!string.IsNullOrEmpty(x.Name))) { Language result; if (Language.TryParse(language.Name, out result) && !languageCollection.Contains(result)) { result.Origin.ItemId = new ID(language.Id); languageCollection.Add(result); } } return languageCollection; }
void BOkClick(object sender, EventArgs e) { LanguageCollection checkedFromLanguages = new LanguageCollection(); LanguageCollection checkedToLanguages = new LanguageCollection(); foreach(LanguageDataContainer ldc in lbFrom.CheckedItems) { if(ldc.Language != Language.Any) checkedFromLanguages.Add(ldc.Language); } foreach(LanguageDataContainer ldc in lbTo.CheckedItems) { if(ldc.Language != Language.Any) checkedToLanguages.Add(ldc.Language); } if(checkedFromLanguages.Count == 0) { MessageBox.Show(FindForm(), TranslateString("Please select at least one source language"), Constants.AppName, MessageBoxButtons.OK, MessageBoxIcon.Warning); DialogResult = DialogResult.None; return; } if(checkedToLanguages.Count == 0) { MessageBox.Show(FindForm(), TranslateString("Please select at least one target language"), Constants.AppName, MessageBoxButtons.OK, MessageBoxIcon.Warning); DialogResult = DialogResult.None; return; } profile.DisabledSourceLanguages.Clear(); foreach(LanguageDataContainer ldc in lbFrom.Items) { if(ldc.Language != Language.Any && !checkedFromLanguages.Contains(ldc.Language)) { profile.DisabledSourceLanguages.Add(ldc.Language); } } profile.DisabledTargetLanguages.Clear(); foreach(LanguageDataContainer ldc in lbTo.Items) { if(ldc.Language != Language.Any && !checkedToLanguages.Contains(ldc.Language)) profile.DisabledTargetLanguages.Add(ldc.Language); } }
void LoadLanguages() { SuspendLayout(); lbFrom.Items.Clear(); lbTo.Items.Clear(); LanguageCollection fromLangs = new LanguageCollection(); LanguageCollection toLangs = new LanguageCollection(); foreach(LanguagePair lp in Manager.LanguagePairServiceItems.Keys) { if(!fromLangs.Contains(lp.From)) fromLangs.Add(lp.From); if(!toLangs.Contains(lp.To)) toLangs.Add(lp.To); } fromLangs.Sort(); string val = ""; int idx; val = "+" + TranslateString("Toggle all"); lbFrom.Items.Add(new LanguageDataContainer(Language.Any, val)); foreach(Language l in fromLangs) { val = LangPack.TranslateLanguage(l); idx = lbFrom.Items.Add(new LanguageDataContainer(l, val)); lbFrom.SetItemChecked(idx, !profile.DisabledSourceLanguages.Contains(l)); } lbFrom.SetItemChecked(0, lbFrom.CheckedItems.Count == fromLangs.Count); if(lbFrom.Items.Count > 0) lbFrom.SelectedIndex = 0; toLangs.Sort(); val = "+" + TranslateString("Toggle all"); lbTo.Items.Add(new LanguageDataContainer(Language.Any, val)); foreach(Language l in toLangs) { val = LangPack.TranslateLanguage(l); idx = lbTo.Items.Add(new LanguageDataContainer(l, val)); lbTo.SetItemChecked(idx, !profile.DisabledTargetLanguages.Contains(l)); } lbTo.SetItemChecked(0, lbTo.CheckedItems.Count == toLangs.Count); if(lbTo.Items.Count > 0) lbTo.SelectedIndex = 0; ResumeLayout(true); }
static GoogleTranslator() { languages = new LanguageCollection(); languages.Add(Language.Autodetect); languages.Add(Language.Arabic); languages.Add(Language.Bulgarian); languages.Add(Language.Catalan); languages.Add(Language.Chinese); languages.Add(Language.Chinese_CN); languages.Add(Language.Chinese_TW); languages.Add(Language.Croatian); languages.Add(Language.Czech); languages.Add(Language.Danish); languages.Add(Language.Dutch); languages.Add(Language.English); languages.Add(Language.Filipino); languages.Add(Language.Finnish); languages.Add(Language.French); languages.Add(Language.German); languages.Add(Language.Greek); languages.Add(Language.Hebrew); languages.Add(Language.Hindi); languages.Add(Language.Indonesian); languages.Add(Language.Italian); languages.Add(Language.Japanese); languages.Add(Language.Korean); languages.Add(Language.Latvian); languages.Add(Language.Lithuanian); languages.Add(Language.Norwegian); languages.Add(Language.Polish); languages.Add(Language.Portuguese); languages.Add(Language.Romanian); languages.Add(Language.Russian); languages.Add(Language.Serbian); languages.Add(Language.Slovak); languages.Add(Language.Slovenian); languages.Add(Language.Spanish); languages.Add(Language.Swedish); languages.Add(Language.Ukrainian); languages.Add(Language.Vietnamese); char[] delimiterChars = { ',', '.', ';', '\n', '!', '?'}; delimiterCharsList = new List<char>(delimiterChars); delimiterCharsList.Sort(); }
private void BindVnData() { IsMainBinding = true; try { Globals.StatusBar.ProgressText = "Loading Main Data"; double ProgressIncrement = 11.11111111111111; Globals.StatusBar.ProgressPercentage = 0; Globals.StatusBar.IsWorkProcessing = true; using (var context = new DatabaseContext()) { #region VnInfo foreach (VnInfo vnInfo in context.VnInfo.Where(t => t.Title == (_selectedVn))) { Globals.VnId = vnInfo.VnId; foreach (string language in GetLangauges(vnInfo.Languages)) { LanguageCollection.Add(new LanguagesCollection { VnMainModel = new VnMainModel { Languages = new BitmapImage(new Uri(language)) } }); } foreach (string platform in GetPlatforms(vnInfo.Platforms)) { PlatformCollection.Add(new PlatformCollection { VnMainModel = new VnMainModel { Platforms = new BitmapImage(new Uri(platform)) } }); } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } foreach (string language in GetLangauges(vnInfo.OriginalLanguage)) { OriginalLanguagesCollection.Add(new OriginalLanguagesCollection { VnMainModel = new VnMainModel { OriginalLanguages = new BitmapImage(new Uri(language)) } }); } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } VnMainModel.Description = ConvertTextBBcode.ConvertText(vnInfo.Description); if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } BindCoverImage(Convert.ToBoolean(vnInfo.ImageNsfw)); if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } VnMainModel.Name = vnInfo.Title; VnMainModel.Original = vnInfo.Original; VnMainModel.Released = vnInfo.Released; VnMainModel.Aliases = vnInfo.Aliases; switch (vnInfo.Length) { case "VeryShort": VnMainModel.Length = "Very short"; break; case "VeryLong": VnMainModel.Length = "Very long"; break; default: VnMainModel.Length = vnInfo.Length; break; } VnMainModel.Popularity = Math.Round(Convert.ToDouble(vnInfo.Popularity), 2); VnMainModel.Rating = Convert.ToInt32(vnInfo.Rating); break; } #endregion #region VnIcon VnMainModel.VnIcon = LoadIcon(); if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } #endregion #region VnAnime foreach (var anime in context.VnInfoAnime.Where(v => v.VnId == Globals.VnId)) { VnInfoAnimeCollection.Add( new VnInfoAnime { Title = anime.TitleEng, OriginalName = anime.TitleJpn, Year = anime.Year, AnimeType = anime.AnimeType, AniDb = $"anidb.net/a{anime.AniDbId}", Ann = $"animenewsnetwork.com/encyclopedia/anime.php?id={anime.AnnId}", //TODO: AnimeNFo not added because of inconsistant url naming scheme }); } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } #endregion #region VnTags SetTags(); if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } #endregion #region VnLinks foreach (VnInfoLinks links in context.VnInfoLinks.Where(v => v.VnId == Globals.VnId)) { string wikipedia = String.Empty; string encubed = String.Empty; string renai = String.Empty; if (!string.IsNullOrEmpty(links.Wikipedia)) { wikipedia = $@"[url=https://en.wikipedia.org/wiki/{links.Wikipedia}]Wikipedia[/url]"; } if (!string.IsNullOrEmpty(links.Encubed)) { encubed = $@"[url=http://novelnews.net/tag/{links.Encubed}]Encubed[/url]"; } if (!string.IsNullOrEmpty(links.Renai)) { renai = $@"[url=https://renai.us/game/{links.Renai}]Renai[/url]"; } List <string> combinedList = new List <string> { wikipedia, encubed, renai }; string combined = string.Join(", ", combinedList.Where(s => !string.IsNullOrEmpty(s))); VnMainModel.Links = combined; } #endregion #region VnRelations foreach (VnInfoRelations relation in context.VnInfoRelations.Where(v => v.VnId == Globals.VnId)) { VnInfoRelation.Add( new VnInfoRelation { Title = relation.Title, Original = relation.Original, Relation = relation.Relation, Official = relation.Official }); } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } #endregion #region VnUserData foreach (var userData in context.VnUserData.Where(v => v.VnId == Globals.VnId)) { if (string.IsNullOrEmpty(userData.LastPlayed)) { VnMainModel.LastPlayed = "Never"; } else { if ((Convert.ToDateTime(userData.LastPlayed) - DateTime.Today).Days > -7) //need to set to negative, for the difference in days { if (Convert.ToDateTime(userData.LastPlayed) == DateTime.Today) { VnMainModel.LastPlayed = "Today"; } else if ((Convert.ToDateTime(userData.LastPlayed) - DateTime.Today).Days > -2 && (Convert.ToDateTime(userData.LastPlayed) - DateTime.Today).Days < 0) { VnMainModel.LastPlayed = "Yesterday"; } else { VnMainModel.LastPlayed = Convert.ToDateTime(userData.LastPlayed).DayOfWeek.ToString(); } } else { VnMainModel.LastPlayed = userData.LastPlayed; } } string[] splitPlayTime = userData.PlayTime.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List <int> timeList = new List <int>(4); timeList.AddRange(splitPlayTime.Select(time => Convert.ToInt32(time))); TimeSpan timeSpan = new TimeSpan(timeList[0], timeList[1], timeList[2], timeList[3]); if (timeSpan < new TimeSpan(0, 0, 0, 1)) { VnMainModel.PlayTime = "Never"; } if (timeSpan < new TimeSpan(0, 0, 0, 60)) { VnMainModel.PlayTime = "Less than 1 minute"; } else { string formatted = $"{(timeSpan.Duration().Days > 0 ? $"{timeSpan.Days:0} day{(timeSpan.Days == 1 ? string.Empty : "s")}, " : string.Empty)}" + $"{(timeSpan.Duration().Hours > 0 ? $"{timeSpan.Hours:0} hour{(timeSpan.Hours == 1 ? string.Empty : "s")}, " : string.Empty)}" + $"{(timeSpan.Duration().Minutes > 0 ? $"{timeSpan.Minutes:0} minute{(timeSpan.Minutes == 1 ? string.Empty : "s")} " : string.Empty)}"; VnMainModel.PlayTime = formatted; } } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = (double)Globals.StatusBar.ProgressPercentage + ProgressIncrement; } #endregion } if (Globals.StatusBar.ProgressPercentage != null) { Globals.StatusBar.ProgressPercentage = 100; } Globals.StatusBar.ProgressText = "Done"; Task.Delay(1500).Wait(); Globals.StatusBar.ProgressPercentage = null; Globals.StatusBar.IsDbProcessing = false; Globals.StatusBar.IsWorkProcessing = false; Globals.StatusBar.ProgressText = string.Empty; } catch (Exception exception) { Globals.Logger.Error(exception); throw; } finally { IsMainBinding = false; } }
public LiveTranslator() { CharsLimit = 15000; WordsLimit = 500; Name = "_translator"; AddSupportedSubject(SubjectConstants.Common); LanguageCollection tmp = new LanguageCollection(); LanguageCollection languages = new LanguageCollection(); foreach(KeyValuePair<Language, string> kvp in langToKey) { if(kvp.Key != Language.English_GB && kvp.Key != Language.English_US) { tmp.Add(kvp.Key); languages.Add(kvp.Key); } } foreach(Language from in languages) { foreach(Language to in tmp) { if(from != to && to != Language.Autodetect) { if(from == Language.English) { AddSupportedTranslationFromEnglish(to); } else if(to == Language.English) { AddSupportedTranslationToEnglish(from); } else { AddSupportedTranslation(from, to); } } } } }