Example #1
0
        private static void writeToBeachedLanguageTable(CSVRow row, HashSet<ADDITIONAL_LANGUAGE> hashSetAttidionalLanguage)
        {
            foreach (var item in hashSetAttidionalLanguage)
            {
                using (var context = new LPPEntities())
                {
                    context.Database.Log = Console.Write;

                    var beached = context.BEACHEDs.FirstOrDefault(s => s.BEACHED_ID.Equals(row.BeachedClass.BEACHED_ID));
                    var language = context.ADDITIONAL_LANGUAGE.FirstOrDefault(s => s.LANG_NAME.Equals(item.LANG_NAME));

                    beached.BEACHED_LANGUAGE.Add(new BEACHED_LANGUAGE
                    {

                        FLUENCY = 2,
                        BEACHED = beached,
                        ADDITIONAL_LANGUAGE = language
                    });



                    context.SaveChanges();
                }
            }
        }
Example #2
0
        private CSVRow RowToCSVRowObject(string[] fields)
        {
            CSVRow currentCSVRow = new CSVRow();
            currentCSVRow.AdditionalLanuageClass = RowToAdditionalLanguageObject(fields);
            currentCSVRow.BeachedClass = RowToBeachedObject(fields);
            currentCSVRow.BeachedLanguageClass = RowToBeachedLanguageObject(currentCSVRow.AdditionalLanuageClass, currentCSVRow.BeachedClass);

            return currentCSVRow;
        }
Example #3
0
        public static bool writeRowToDatabase(CSVRow Row)
        {

            try
            {
                writeToAdditionalLanguageTable(Row.AdditionalLanuageClass);
                writeToBeachedTable(Row.BeachedClass);
                writeToBeachedLanguageTable(Row, Row.AdditionalLanuageClass);


            }
            catch (Exception e)
            {
                Console.WriteLine(e.StackTrace);
                return false;
            }

            return true;

        }