Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }