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
}