private void checkTeacher() { conn = new SqlConnection(connectionString); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select [№ преподавателя] from Преподаватель where Фамилия = '" + textBox1.Text + "' and Имя = '" + textBox2.Text + "' and Отчество = '" + textBox3.Text + "' and Пароль = '" + textBox4.Text + "'"; SqlDataReader rdr = comm.ExecuteReader(); if (rdr.HasRows) { label6.Visible = false; rdr.Read(); menuPrepod tw = new menuPrepod(rdr[0].ToString()); tw.Show(); this.Hide(); } else { label6.Visible = true; clearColumns(); } rdr.Close(); conn.Close(); }
private void выходToolStripMenuItem_Click(object sender, EventArgs e) { menuPrepod menupr = new menuPrepod(numTeacher.ToString()); menupr.Show(); this.Hide(); }
private void выйтиToolStripMenuItem_Click(object sender, EventArgs e) { menuPrepod rf = new menuPrepod(numPrepod); rf.Show(); this.Hide(); }
private void btnExit_Click(object sender, EventArgs e) { menuPrepod menupr = new menuPrepod(numPrepod.ToString()); menupr.Show(); this.Hide(); }
private void btnPrev_Click(object sender, EventArgs e) { this.Hide(); menuPrepod menuPr = new menuPrepod(numTeacher.ToString()); menuPr.Show(); }
private void btnTestDone_Click(object sender, EventArgs e) { if (SaveTest == false) { string pathprepod; conn = new SqlConnection(connectionString); using (conn) { conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; try { comm.CommandText = "select [Путь к папке] from Преподаватель where [№ преподавателя]=" + "'" + NumTeacher.ToString() + "'"; comm.ExecuteNonQuery(); SqlDataReader rdr = comm.ExecuteReader(); rdr.Read(); pathprepod = rdr[0].ToString(); rdr.Close(); } finally { conn.Close(); } Pictures=false; for (int pop = 0; pop <= Questions.Count-1;pop++) { if (PicturePaths[pop] != null) Pictures = true; } if (Pictures == true) { System.IO.Directory.CreateDirectory(Application.StartupPath + pathprepod + "Тесты\\" + NameTest); writer = new XmlTextWriter(Application.StartupPath + pathprepod + "Тесты\\" + NameTest + "\\" + NameTest + ".xml", Encoding.UTF8); writer.Formatting = Formatting.Indented; tempstring=""; for (int pop = 0; pop <= Questions.Count-1;pop++) { if (PicturePaths[pop]!=null) { tempstring=PicturePaths[pop].Substring(PicturePaths[pop].LastIndexOf(@"\")); //tempstring = tempstring.Remove(0, 1); File.Copy(PicturePaths[pop], Application.StartupPath + pathprepod + "Тесты\\" + NameTest + tempstring); //tek.question = Application.StartupPath + pathprepod + "Тесты\\" + NameTest + tempstring; Questions[pop].question = Application.StartupPath + pathprepod + "Тесты\\" + NameTest + tempstring; } //1--получить имя //2--скопировать в папку //3 заменить путь в tek на новый } //File.Copy(PicturePath, Application.StartupPath + pathprepod + "Тесты\\" + NameTest); } else { writer = new XmlTextWriter(Application.StartupPath + pathprepod + "Тесты\\" + NameTest + ".xml", Encoding.UTF8); writer.Formatting = Formatting.Indented; } writer.WriteStartDocument(); writer.WriteStartElement("Test"); writer.WriteStartElement("Discription"); writer.WriteString(DescrTest); writer.WriteEndElement(); writer.WriteStartElement("Theme"); writer.WriteString(ThemeTest); writer.WriteEndElement(); writer.WriteStartElement("Discipline"); writer.WriteString("C#"); writer.WriteEndElement(); writer.WriteStartElement("Questions"); //------- writer.WriteStartAttribute("Number"); int p = Questions.Count; writer.WriteString(p.ToString()); writer.WriteEndAttribute(); for (int i = 0; i <= Questions.Count - 1; i++) { writer.WriteStartElement("Question" + Questions[i].num); writer.WriteStartElement("Text"); writer.WriteString(Questions[i].question); writer.WriteEndElement(); #region TypeAnswer //writer.WriteStartAttribute("Type Answer"); writer.WriteStartElement("TypeAnswer"); if (Questions[i].type_question == "Один вариант ответа") { writer.WriteString("One"); Questions[i].price = Int32.Parse(numList1.Value.ToString()); } else if (Questions[i].type_question == "Несколько вариантов ответа") { writer.WriteString("Several"); Questions[i].price = Int32.Parse(numList2.Value.ToString()); } else if (Questions[i].type_question == "Выстроить последовательность") { writer.WriteString("Sequence"); Questions[i].price = Int32.Parse(numList3.Value.ToString()); } else if (Questions[i].type_question == "Свободный ответ") { writer.WriteString("Writing"); Questions[i].price = Int32.Parse(numList4.Value.ToString()); } else { writer.WriteString("Comparison"); Questions[i].price = Int32.Parse(numList5.Value.ToString()); } //writer.WriteEndAttribute(); writer.WriteEndElement(); #endregion #region Answers //writer.WriteStartAttribute("Answers"); writer.WriteStartElement("Answers"); if (Questions[i].answ2 != null) writer.WriteString(Questions[i].answ1 + "|" + Questions[i].answ2 + "|" + Questions[i].answ3 + "|" + Questions[i].answ4); else writer.WriteString(Questions[i].answ1); //writer.WriteEndAttribute(); writer.WriteEndElement(); #endregion #region RightAnswer //Записываем правильный ответ в атрибут Right answer //writer.WriteStartAttribute("Right answer"); writer.WriteStartElement("RightAnswer"); if (Questions[i].type_question == "Один вариант ответа") { for (int h = 0; h <= 3; h++) { if (Questions[i].rightans[h] != null) writer.WriteString(Questions[i].rightans[h]); } } else if (Questions[i].type_question == "Несколько вариантов ответа") { string tmp = null; for (int h = 0; h <= 3; h++) { if (Questions[i].rightans[h] != null) { tmp = tmp + Questions[i].rightans[h]; tmp = tmp + "|"; } } for (int h = 0; h <= 3; h++) { if (tmp != null) if (tmp.LastIndexOf("|") == tmp.Length - 1) tmp = tmp.Remove(tmp.Length - 1, 1); } writer.WriteString(tmp); } else if (Questions[i].type_question == "Выстроить последовательность") { string tmp = null; for (int h = 0; h <= 3; h++) { if (Questions[i].rightans[h] != null) { tmp = tmp + Questions[i].rightans[h]; tmp = tmp + "|"; } } if (tmp.LastIndexOf("|") == tmp.Length - 1) tmp = tmp.Remove(tmp.Length - 1, 1); writer.WriteString(tmp); } else if (Questions[i].type_question == "Свободный ответ") writer.WriteString(Questions[i].rightans[0]); else { string tmp = null; tmp = Questions[i].rightans[0] + "==" + Questions[i].rightans[1]; tmp = tmp + "|" + Questions[i].rightans[2] + "==" + Questions[i].rightans[3]; writer.WriteString(tmp); } //writer.WriteEndAttribute(); writer.WriteEndElement(); #endregion #region Part //writer.WriteStartAttribute("Part"); writer.WriteStartElement("Part"); string temp = null; for (int u = 0; u <= 9; u++) { if (Questions[i].part[u] != null) { temp = temp + Questions[i].part[u]; temp = temp + "|"; } } //if(temp!=null) // if (temp.LastIndexOf("|") == temp.Length - 1) // temp.Remove(temp.Length - 1, 1); for (int h = 0; h <= 9; h++) { if (temp != null) if (temp.LastIndexOf("|") == temp.Length - 1) temp.Remove(temp.Length - 1, 1); } if (temp == null) temp = ""; writer.WriteString(temp); //writer.WriteEndAttribute(); writer.WriteEndElement(); #endregion #region Price //writer.WriteStartAttribute("Price"); writer.WriteStartElement("Price"); writer.WriteString(Questions[i].price.ToString()); //writer.WriteEndAttribute(); writer.WriteEndElement(); #endregion writer.WriteEndElement(); } writer.WriteEndElement(); //Завершение записи writer.WriteStartElement("Time"); writer.WriteString(numTime.Value.ToString()); writer.WriteEndElement(); writer.WriteStartElement("Report"); writer.WriteString(cBOtch.Text); writer.WriteEndElement(); //Завершаем написание документа writer.WriteEndElement(); //Закрывем основной тэг - test writer.WriteEndDocument(); //Закрываем документ writer.Close(); MessageBox.Show("Тест был успешно создан!", "Выход"); insertTask(); insertTest(); SaveTest = true; // } menuPrepod newmenu = new menuPrepod(NumTeacher.ToString()); this.Hide(); newmenu.Show(); } conn.Close(); } else { MessageBox.Show("Тест уже сохранен.", "Ошибка!"); } }
private void taskEditor_FormClosed(object sender, FormClosedEventArgs e) { menuPrepod mp = new menuPrepod(numPrepod); mp.Show(); }