Example #1
0
        public List <Word> ImportTo(DatabaseManagement manager)
        {
            string fileType = GetFileType();
            // create a list to contain words that not existed in database
            // used to add its to datagridview but not reload all words from database
            List <Word> addedList = new List <Word>();
            List <Word> dataList  = new List <Word>();

            if (fileType.Equals(".xlsx"))
            {
                ExcelManagement exl = new ExcelManagement(path);
                // the dataList is the list which contains words readed from file
                dataList = exl.ReadFile();
                exl.Close();
            }
            else if (fileType.Equals(".csv"))
            {
                CsvFileManagement csv = new CsvFileManagement(path);
                dataList = csv.ReadFile();
            }
            for (int i = 0; i < dataList.Count; i++)
            {
                try
                {
                    // if the words has already existed in database, it will throw a exception
                    manager.AddWord(dataList[i].word_o, dataList[i].type_id, dataList[i].word_m);
                    addedList.Add(dataList[i]);
                }
                catch (Exception)
                {
                    continue;
                }
            }
            return(addedList);
        }
Example #2
0
        private void WriteToExcel(string path, List <Word> list)
        {
            ExcelManagement exl = new ExcelManagement(path);

            exl.ClearData();
            exl.WriteFile(list);
            exl.Save();
            exl.Close();
            MessageBox.Show("Completed to export selected data to " + path);
        }