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);
}
}
}
}
}