public BaseEntity BuildMostUsedLanguague(Dictionary <string, object> row)
{
var languague = new Languague
{
languague = GetStringValue(row, DB_COL_LANGUAGUE)
};
return(languague);
}
public BaseEntity BuildObject(Dictionary <string, object> row)
{
var languague = new Languague
{
IdLanguague = GetIntValue(row, DB_COL_ID_LANGUAGUE),
languague = GetStringValue(row, DB_COL_LANGUAGUE)
};
return(languague);
}
/// <summary>
/// Parse google supported language
/// </summary>
/// <param name="lang"></param>
/// <returns></returns>
public static string Parse(this Languague lang)
{
switch (lang)
{
case Languague.English:
return("en");
case Languague.Vietnamese:
return("vi");
default:
throw new NotImplementedException("Lang: " + lang);
}
}
/// <summary>
/// Call the api and generate temp audio file
/// </summary>
/// <param name="text"></param>
/// <param name="lang"></param>
/// <returns></returns>
public static string DownloadFile(string text, Languague lang)
{
var result = Request(text, lang);
var tmpFile = Path.GetTempFileName();
tmpFile = Path.Combine(Path.GetTempPath(), $"yeuai_{Path.GetFileNameWithoutExtension(tmpFile)}.mp3");
using (var file = File.OpenWrite(tmpFile))
using (var stream = new MemoryStream(result))
{
stream.CopyTo(file);
file.Flush();
file.Close();
}
return(tmpFile);
}
/// <summary>
/// Call the api and return buffer
/// </summary>
/// <param name="text"></param>
/// <param name="lang"></param>
/// <returns></returns>
public static byte[] Request(string text, Languague lang)
{
if (string.IsNullOrEmpty(text))
{
throw new ArgumentNullException("text");
}
using (var client = new WebClient())
{
client.Headers.Add("user-agent", MOZILLA_USER_AGENT);
client.UseDefaultCredentials = true;
client.QueryString.Add("ie", "UTF-8");
client.QueryString.Add("client", "tw-ob");
client.QueryString.Add("tl", lang.Encode());
client.QueryString.Add("q", text);
var response = client.DownloadData(API_URL_GOOGLE_TTS);
return(response);
}
}
public static void DoIt()
{
try
{
var mng = new UserManagement();
var mngLng = new LanguagueManagement();
var mngTrans = new TranslationManagement();
var mgnTransHistory = new TranslationHistoryManagement();
var user = new User();
var languague = new Languague();
Console.WriteLine("TranslationBot");
Console.WriteLine("1.Añadir usuario");
Console.WriteLine("2.Añadir idioma");
Console.WriteLine("3.Traductor");
Console.WriteLine("4.Idiomas disponibles");
Console.WriteLine("5.Obtener idioma mas popular");
Console.WriteLine("6.Obtener 1000 palabras mas populares");
Console.WriteLine("Choose an option: ");
var option = Console.ReadLine();
switch (option)
{
case "1":
Console.WriteLine("***************************");
Console.WriteLine("***** Añadir Usuario *******");
Console.WriteLine("***************************");
Console.WriteLine("Escribe el nombre de usuario");
var info = Console.ReadLine();
//var infoArray = info.Split(',');
user = new User(info);
mng.Create(user);
Console.WriteLine("Usuario añadido");
break;
case "2":
Console.WriteLine("***************************");
Console.WriteLine("***** Añadir idioma *****");
Console.WriteLine("***************************");
Console.WriteLine("Escribe el idioma que desea añadir");
var infoLang = Console.ReadLine();
languague = new Languague(infoLang);
mngLng.Create(languague);
Console.WriteLine("Idioma añadido");
//var lstCustomers = mng.RetrieveAll();
//var count = 0;
//foreach (var c in lstCustomers)
//{
// count++;
// Console.WriteLine(count + " ==> " + c.GetEntityInformation());
//}
break;
case "3":
Console.WriteLine("***************************");
Console.WriteLine("***** Traducir*****");
Console.WriteLine("***************************");
Console.WriteLine("Ingrese su Id de usuario");
var infoId = Console.ReadLine();
int infoIdUser = Int32.Parse(infoId);
user = new User(infoIdUser);
user = mng.RetrieveById(user);
if (user == null)
{
Console.WriteLine("El usuario no existe desea agregarlo?");
Console.WriteLine("Agregar? Y/N");
var addUser = Console.ReadLine();
if (addUser.Equals("Y", StringComparison.CurrentCultureIgnoreCase))
{
Console.WriteLine("Escriba el nombre del usuario");
var userName = Console.ReadLine();
var user1 = new User
{
Name = userName
};
mng.Create(user1);
Console.WriteLine("Usuario añadido");
user = searchUser();
}
else
{
DoIt();
}
}
Console.WriteLine("***************************");
Console.WriteLine("***** Hola " + user.Name + "*****");
Console.WriteLine("***************************");
Console.WriteLine("Estos son los idiomas disponibles");
var lstLanguagues = mngLng.RetrieveAll();
var count = 0;
foreach (var l in lstLanguagues)
{
count++;
Console.WriteLine(count + "==>" + l.GetEntityInformation());
}
Console.WriteLine("Ingrese el idioma que desea traducir");
var lng = Console.ReadLine();
languague = new Languague(lng);
languague = mngLng.RetrieveById(languague);
if (languague == null)
{
Console.WriteLine("Idioma no existe desea agregarlo?");
Console.WriteLine("Agregar? Y/N");
var addLanguague = Console.ReadLine();
if (addLanguague.Equals("Y", StringComparison.CurrentCultureIgnoreCase))
{
var languague1 = new Languague
{
languague = lng
};
mngLng.Create(languague1);
Console.WriteLine("Idioma añadido");
}
else
{
DoIt();
}
}
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("Escriba la palabra o palabras que desea traducir separadas por un menos: " + " Ejemplo: palabra-palabra-palabra");
var word = Console.ReadLine();
var infoArray = word.Split('-');
for (var i = 0; i < infoArray.Length; i++)
{
var item = infoArray[i];
languague = new Languague
{
languague = lng
};
var languagueTranslate = mngLng.RetrieveById(languague);
var translations = new Translations
{
word = item,
FkLanguagueId = languagueTranslate.IdLanguague
};
var translatedWord = mngTrans.RetrieveById(translations);
if (translatedWord == null)
{
Console.WriteLine("La palabra: " + item + " no existe en el idioma: " + languague.languague + " desea añadirla?");
Console.WriteLine("Agregar? Y/N");
var addTranslation = Console.ReadLine();
if (addTranslation.Equals("Y", StringComparison.CurrentCultureIgnoreCase))
{
Console.WriteLine("Ingrese la traduccion de la palabra: " + item + " en el idioma " + languague.languague);
string tranWord = Console.ReadLine();
var translation = new Translations
{
translationAmount = 1,
word = item,
translatedDate = System.DateTime.Now,
translatedWord = tranWord,
FkLanguagueId = languagueTranslate.IdLanguague
};
mngTrans.Create(translation);
var translationHistory = new TranslationsHistory
{
word = item,
translatedDate = System.DateTime.Now,
translatedWord = tranWord,
FkUserId = user.IdUser,
FkLanguagueId = languagueTranslate.IdLanguague
};
var user2 = new User {
IdUser = user.IdUser, Name = user.Name, amountTranslatedWords = user.amountTranslatedWords + 1
};
mgnTransHistory.Create(translationHistory);
mng.Update(user2);
Console.WriteLine("Palabra añadida");
}
else
{
DoIt();
}
}
else
{
var translatedWord1 = new Translations
{
word = translatedWord.word,
translatedWord = translatedWord.translatedWord,
translationAmount = translatedWord.translationAmount + 1,
FkLanguagueId = translatedWord.FkLanguagueId
};
var translationHistory = new TranslationsHistory
{
word = item,
translatedDate = System.DateTime.Now,
translatedWord = translatedWord.translatedWord,
FkUserId = user.IdUser,
FkLanguagueId = translatedWord.FkLanguagueId
};
var user2 = new User {
IdUser = user.IdUser, Name = user.Name, amountTranslatedWords = user.amountTranslatedWords + 1
};
mng.Update(user2);
mgnTransHistory.Create(translationHistory);
mngTrans.Update(translatedWord1);
var sentence = translatedWord.translatedWord;
Console.WriteLine(sentence);
}
}
//Console.WriteLine("Type the customer id:");
//customer.Id = Console.ReadLine();
//customer = mng.RetrieveById(customer);
//if (customer != null)
//{
// Console.WriteLine(" ==> " + customer.GetEntityInformation());
//}
break;
case "4":
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("*****Mostrar Idiomas*******");
Console.WriteLine("***************************");
Console.WriteLine("***************************");
var lang = mngLng.RetrieveAll();
var count1 = 0;
foreach (var c in lang)
{
count1++;
Console.WriteLine(count1 + "===>" + c.GetEntityInformation());
}
break;
case "5":
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("*****Idioma mas popular*******");
Console.WriteLine("***************************");
Console.WriteLine("***************************");
var languague2 = mngLng.RetrieveMostPopularLanguague();
if (languague != null)
{
Console.WriteLine("El idioma mas utilizado es: " + languague2.languague);
}
else
{
Console.WriteLine("Algo salio mal");
}
break;
case "6":
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("*****Palabras mas populares*******");
Console.WriteLine("***************************");
Console.WriteLine("***************************");
var lstMostUSedWords = mgnTransHistory.RetrieveTopHundredWords();
var count3 = 0;
foreach (var c in lstMostUSedWords)
{
count3++;
Console.WriteLine(count3 + " ==> " + c.word);
}
break;
case "7":
Console.WriteLine("***************************");
Console.WriteLine("***************************");
Console.WriteLine("*****Idioma mas popular*******");
Console.WriteLine("***************************");
Console.WriteLine("***************************");
break;
}
}
catch (Exception ex)
{
Console.WriteLine("***************************");
Console.WriteLine("ERROR: " + ex.Message);
Console.WriteLine(ex.StackTrace);
Console.WriteLine("***************************");
}
finally
{
Console.WriteLine("Continue? Y/N");
var moreActions = Console.ReadLine();
if (moreActions.Equals("Y", StringComparison.CurrentCultureIgnoreCase))
{
DoIt();
}
}
}
internal void Delete(Languague languague)
{
crudLanguague.Delete(languague);
}
internal void Update(Languague languague)
{
crudLanguague.Update(languague);
}
public Languague RetrieveById(Languague languague)
{
return(crudLanguague.Retrieve <Languague>(languague));
}
public void Create(Languague languague)
{
crudLanguague.Create(languague);
}
/// <summary>
/// Parse google supported language
/// </summary>
/// <param name="lang"></param>
/// <returns></returns>
public static string Encode(this Languague lang)
{
return(Parse(lang));
}
