public void Delete(int id) { clQuestion question = getItem(id); list.Remove(question); question.Delete(); }
private void LoadFromSql() { sql sql1 = new sql(); DataTable dt = sql1.GetRecords("exec Question_Select"); list.Clear(); foreach (DataRow row in dt.Rows) { clQuestion question = new clQuestion(row); Add(question); } }
public void Add(clQuestion question) { list.Add(question); }
private void загрузитьEmailToolStripMenuItem_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.InitialDirectory = @"C:\"; openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; openFileDialog.FilterIndex = 2; openFileDialog.RestoreDirectory = true; openFileDialog.Multiselect = false; if (openFileDialog.ShowDialog() == DialogResult.OK) { ExcelDoc excelDoc = new ExcelDoc(openFileDialog.FileName); int err = 0; int i = 2; try { bool quest = true; string s1; clQuestion question = new clQuestion(globalData.UserID); while (excelDoc.getValue("A" + i.ToString(), "A" + i.ToString()) != null) { s1 = excelDoc.getValue("A" + i.ToString(), "A" + i.ToString()).ToString().Replace("\"", "'"); if (quest) { question = new clQuestion(globalData.UserID); question.Text = s1; question.Save(); quest = false; } else { clAnswer answer = question.CreateAnswed(); answer.Right = (excelDoc.getValue("B" + i.ToString(), "B" + i.ToString()) != null); answer.Text = s1; answer.Save(); } i++; if (excelDoc.getValue("A" + i.ToString(), "A" + i.ToString()) == null) { i++; quest = true; } } } catch (Exception ex) { MessageBox.Show("Ошибка при чтении файла. Системная ошибка: " + ex.Message + " В строке " + i.ToString()); err++; } finally { if (err == 0) { excelDoc.Dispose(); } else { MessageBox.Show("Загрузка завершена. Найдено " + err.ToString() + " ошибок."); excelDoc.Show(); } } } }
private void LoadFromSql() { Sql sql1 = new Sql(); DataTable dt = sql1.GetRecords("exec Question_Select"); list.Clear(); foreach (DataRow row in dt.Rows) { clQuestion question = new clQuestion(row); Add(question); } }