public IEnumerable <LanguageCard> GetAllWords()
{
List <LanguageCard> languageCards = new List <LanguageCard>();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["GearHost"].ConnectionString;
string sqlGet = "SELECT * FROM hindiKannadaWords";
SqlCommand command = new SqlCommand(sqlGet, conn);
try
{
conn.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
LanguageCard card = new LanguageCard();
card.CardId = Convert.ToInt16(reader[0].ToString());
card.HindiText = reader[1].ToString();
card.KannadaText = reader[2].ToString();
languageCards.Add(card);
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
return(languageCards);
}
public IEnumerable <LanguageCard> GetCardsFrom(string category)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["GearHost"].ConnectionString;
string sqlGet = "spGetWordsFromCategory";
SqlCommand command = new SqlCommand(sqlGet, conn);
//command.CommandText = sqlGet;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@category", category);
List <LanguageCard> languageCards = new List <LanguageCard>();
using (conn)
{
conn.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
LanguageCard card = new LanguageCard();
//card.CardId = Convert.ToInt16(reader[0].ToString());
card.HindiText = reader[0].ToString();
card.KannadaText = reader[1].ToString();
languageCards.Add(card);
}
}
return(languageCards);
}
public IEnumerable <LanguageCard> GetAllPronouns()
{
List <LanguageCard> pronouns = new List <LanguageCard>();
LanguageCard pronoun1 = new LanguageCard();
pronoun1.HindiText = "main";
pronoun1.KannadaText = "nanu";
LanguageCard pronoun2 = new LanguageCard();
pronoun2.HindiText = "hum";
pronoun2.KannadaText = "navu";
LanguageCard pronoun3 = new LanguageCard();
pronoun3.HindiText = "mera";
pronoun3.KannadaText = "nanna";
LanguageCard pronoun4 = new LanguageCard();
pronoun4.HindiText = "humara";
pronoun4.KannadaText = "namma";
LanguageCard pronoun5 = new LanguageCard();
pronoun5.HindiText = "mujhko";
pronoun5.KannadaText = "nanage";
LanguageCard pronoun6 = new LanguageCard();
pronoun6.HindiText = "humko";
pronoun6.KannadaText = "namage";
pronouns.Add(pronoun1);
pronouns.Add(pronoun2);
pronouns.Add(pronoun3);
pronouns.Add(pronoun4);
pronouns.Add(pronoun5);
pronouns.Add(pronoun6);
return(pronouns);
}
public List <LanguageCard> GetAllCards()
{
List <LanguageCard> languageCards = new List <LanguageCard>();
LanguageCard card1 = new LanguageCard();
card1.HindiText = "namaste";
card1.KannadaText = "namaskara";
LanguageCard card2 = new LanguageCard();
card2.HindiText = "doodh";
card2.KannadaText = "halu";
LanguageCard card3 = new LanguageCard();
card3.HindiText = "dijiye";
card3.KannadaText = "kodi";
LanguageCard card4 = new LanguageCard();
card4.HindiText = "kidhar";
card4.KannadaText = "yelli";
LanguageCard card5 = new LanguageCard();
card5.HindiText = "gobhi";
card5.KannadaText = "hukosu";
LanguageCard card6 = new LanguageCard();
card6.HindiText = "gobhi";
card6.KannadaText = "hukosu";
LanguageCard card7 = new LanguageCard();
card7.HindiText = "gobhi";
card7.KannadaText = "hukosu";
LanguageCard card8 = new LanguageCard();
card8.HindiText = "gobhi";
card8.KannadaText = "hukosu";
LanguageCard card9 = new LanguageCard();
card9.HindiText = "gobhi";
card9.KannadaText = "hukosu";
LanguageCard card10 = new LanguageCard();
card10.HindiText = "gobhi";
card10.KannadaText = "hukosu";
LanguageCard card11 = new LanguageCard();
card11.HindiText = "gobhi";
card11.KannadaText = "hukosu";
languageCards.Add(card1);
languageCards.Add(card2);
languageCards.Add(card3);
languageCards.Add(card4);
languageCards.Add(card5);
languageCards.Add(card6);
languageCards.Add(card7);
languageCards.Add(card8);
languageCards.Add(card9);
languageCards.Add(card10);
languageCards.Add(card11);
//languageCards.Add(card12);
return(languageCards);
}
