public void Add_File_Click(object sender, RoutedEventArgs e) { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); // Set filter for file extension and default file extension dlg.DefaultExt = ".png"; dlg.Filter = "XLSX Files (*.xlsx)|*.xlsx|CSV Files (*.csv)|*.csv"; // Display OpenFileDialog by calling ShowDialog method Nullable <bool> result = dlg.ShowDialog(); // Get the selected file name and display in a TextBox if (result == true) { // Open document filename = dlg.FileName; //Supported spreadsheet formats for reading include: XLSX, XLS, CSV and TSV WorkBook workbook = WorkBook.Load(filename); WorkSheet sheet = workbook.DefaultWorkSheet; //Select cells easily in Excel notation and return the calculated value, date, text or formula int cellValue = sheet["A2"].IntValue; // Read from Ranges of cells elegantly. bool stop = false; int row = 0; octopusEntities1 db = new octopusEntities1(); RangeRow rowdata; while (!stop) { // check if existing prior to inserting ObjectResult <Octopus.checkForExistingQuestion_Result> number = db.checkForExistingQuestion(quizid, (string)sheet.GetCellAt(0, row).Text.Trim()); if (number.ToArray().Length == 0) { db.insertQuestionToQuiz(quizid, (string)sheet.GetCellAt(0, row).Text.Trim(), (string)sheet.GetCellAt(1, row).Text.Trim(), (string)sheet.GetCellAt(2, row).Text.Trim(), "basic"); } else { Console.WriteLine("Question already existing"); } row++; } } }
public void Add_Question_Click(object sender, RoutedEventArgs e) { bool pass = true; octopusEntities1 db = new octopusEntities1(); if (newQuestion.Text.Trim() == "" || newAnswer.Text.Trim() == "" || newOptions.Text.Trim() == "") { pass = false; } if (pass) { db.insertQuestionToQuiz(quizid, newQuestion.Text, newAnswer.Text, newOptions.Text, "basic"); newQuestion.Text = ""; newAnswer.Text = ""; newOptions.Text = ""; MessageBox.Show("Question inserted!", "Validation"); } else { MessageBox.Show("Missing entry", "Validation"); } // insert question }