public BaseEntity BuilHundredMostusedWord(Dictionary <string, object> row)
{
var translationsHistory = new TranslationsHistory
{
word = GetStringValue(row, DB_COL_WORD),
};
return(translationsHistory);
}
public BaseEntity BuildObject(Dictionary <string, object> row)
{
var translationsHistory = new TranslationsHistory
{
translationHistoryId = GetIntValue(row, DB_COL_ID_TRANSLATION_HISTORY),
word = GetStringValue(row, DB_COL_WORD),
translatedDate = GetDateValue(row, DB_COL_TRANSLATED_DATE),
translatedWord = GetStringValue(row, DB_COL_TRANSLATED_WORD),
FkUserId = GetIntValue(row, DB_COL_FK_USER_ID),
FkLanguagueId = GetIntValue(row, DB_COL_FK_LANGUAUGE_ID)
};
return(translationsHistory);
}
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(TranslationsHistory translationsHistory)
{
crudTranslationHistory.Delete(translationsHistory);
}
internal void Update(TranslationsHistory translationsHistory)
{
crudTranslationHistory.Update(translationsHistory);
}
public TranslationsHistory RetrieveById(TranslationsHistory translationsHistory)
{
return(crudTranslationHistory.Retrieve <TranslationsHistory>(translationsHistory));
}
public void Create(TranslationsHistory translationHistory)
{
crudTranslationHistory.Create(translationHistory);
}
