private void buttonUpdate_Click(object sender, EventArgs e) { if (selectedTest == null) { MessageBox.Show("Элемент не выбран"); return; } selectedTest.Name = tbName.Text; selectedTest.PassMark = Convert.ToInt16(tbPassMark.Text); var updateTest = new Test() { id = (int)selectedTest.id, Name = selectedTest.Name, PassMark = (short)selectedTest.PassMark }; using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.Test.Add(updateTest); db.Entry(updateTest).State = EntityState.Modified; db.SaveChanges(); } Clear(); LoadData(); }
private QuestionControl ConfigurateControl(Question question) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { var z = from a in db.Answer where a.idQuestion == question.id select new { Id = a.Id, idQuestion = a.idQuestion, Text = a.Text, isCorrect = a.isCorrect }; List <Answer> answers = new List <Answer>(); foreach (var o in z) { answers.Add(new Answer() { Id = o.Id, idQuestion = o.idQuestion, isCorrect = o.isCorrect, Text = o.Text }); } QuestionControl control = new QuestionControl(question, answers); control.Location = new System.Drawing.Point(28, 63); control.MaximumSize = new Size(Width, 0); control.Size = new System.Drawing.Size(Width, 28); control.Visible = true; return(control); } }
private void buttonAdd_Click(object sender, EventArgs e) { string selectedText = comboBoxAcSubs.SelectedItem.ToString().Trim(); AcademicSubject academicSubject = allAcademicSubjects.Find(item => item.Name.Trim().Equals(selectedText)); bool alreadyExist = false; var x = dataGridView1.Rows; for (int i = 0; i < x.Count; i++) { if (Convert.ToInt32(x[i].Cells["id"].Value) == academicSubject.id) { alreadyExist = true; } } if (academicSubject == null || alreadyExist) { MessageBox.Show("Данная связь уже существует или предмет не выбран"); return; } using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Insert Into Test_AcademicSubject Values (@idTest, @idAcademicSubject)"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idAcademicSubject", academicSubject.id)); sqlParameters.Add(new SqlParameter("@idTest", test.id)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); LoadData(); } }
private void LoadSubject() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { if (user.Role == UserRole.Teacher) { string query = @"Select DISTINCT s.id,s.Name from Subjects as s JOIN AcademicSubject as AcSu on s.id = AcSu.idSubjects JOIN AcademicSubject_Teacher as A_T on AcSu.id = A_T.idAcademicSubject JOIN Teacher as t on t.id = A_T.idTeacher where t.login = @Login"; SqlParameter parameter = new SqlParameter("@Login", user.Login); subjects = db.Database.SqlQuery <Subjects>(query, parameter).ToList(); subjects.ForEach(o => comboBoxSubjects.Items.Add(o.Name.Trim())); } else { db.Subjects.Load(); subjects = db.Subjects.Local.ToBindingList().ToList(); subjects.ForEach(o => comboBoxSubjects.Items.Add(o.Name.Trim())); } if (questionList.Count > 0) { Subjects subject = subjects.Find(item => item.id.Equals(questionList[0].idSubjects)); comboBoxSubjects.SelectedIndex = subjects.IndexOf(subject); } } }
private void buttonDelete_Click(object sender, EventArgs e) { if (selectedGroupTesting == null || updatedGroupTesting == null) { MessageBox.Show("Элемент не выбран"); return; } using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Delete GroupTesting where idTest=@idTest and idAcademicGroup=@selectIdAcademicGroup and isAvailable=@selectIsAvailable and expirationDate=@selectExpirationDate"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idTest", test.id)); sqlParameters.Add(new SqlParameter("@selectIdAcademicGroup", selectedGroupTesting.idAcademicGroup)); sqlParameters.Add(new SqlParameter("@selectIsAvailable", selectedGroupTesting.isAvailable)); sqlParameters.Add(new SqlParameter("@selectExpirationDate", selectedGroupTesting.expirationDate)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } Clear(); LoadData(); }
private void LoadAcSubs() { if (user.Role != UserRole.Admin) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Select AcS.id, AcS.Name, s.id As'idSubjects' from AcademicSubject as AcS JOIN AcademicSubject_Teacher as AS_T ON AS_T.idAcademicSubject = AcS.id JOIN Teacher as t on t.id = AS_T.idTeacher JOIN Subjects as s on s.id = AcS.idSubjects where t.login = @Login"; SqlParameter parameter = new SqlParameter("@Login", user.Login); academicSubjects = db.Database.SqlQuery <AcademicSubject>(query, parameter).ToList(); academicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim())); } } else { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.AcademicSubject.Load(); academicSubjects = db.AcademicSubject.Local.ToBindingList().ToList(); academicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim())); } } }
private void Statisticks_Load(object sender, EventArgs e) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Select ag.Name as AcademicGroup,s.Surname,s.Name,s.Patronymic,e.ExamDate,e.Mark, CONVERT(bit,(CASE WHEN e.Mark>=t.PassMark Then 1 ElSE 0 END)) As IsPassed from Examination as e JOIN Student as s on e.idStudent = s.id JOIN Test as t on t.id = e.idTest JOIN AcademicGroup as ag on s.idAcademicGroup = ag.id Where t.id = @idTest"; SqlParameter parameter = new SqlParameter("@idTest", test.id); var z = db.Database.SqlQuery <TestStatisticks>(query, parameter).ToList(); dataGridView1.DataSource = z.ToList(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["AcademicGroup"].HeaderText = "Группа"; dataGridView1.Columns["Surname"].HeaderText = "Фамилия"; dataGridView1.Columns["Name"].HeaderText = "Имя"; dataGridView1.Columns["Patronymic"].HeaderText = "Отчество"; dataGridView1.Columns["Mark"].HeaderText = "Балл"; dataGridView1.Columns["ExamDate"].HeaderText = "Дата сдачи теста"; dataGridView1.Columns["isPassed"].HeaderText = "Сдано"; } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { var data = from gt in db.GroupTesting join ag in db.AcademicGroup on gt.idAcademicGroup equals ag.id where gt.idTest == test.id select new { GroupName = ag.Name, gt.expirationDate, gt.isAvailable }; string query = "Select gt.idTest,gt.idAcademicGroup,gt.expirationDate,gt.isAvailable from GroupTesting as gt Where gt.idTest = @idTest"; SqlParameter parameter = new SqlParameter("@idTest", test.id); List <GroupTesting> groupTesting = db.Database.SqlQuery <GroupTesting>(query, parameter).ToList(); groupTestingList = groupTesting.ToList(); dataGridView1.DataSource = data.ToList(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["GroupName"].HeaderText = "Группа"; dataGridView1.Columns["expirationDate"].HeaderText = "Дата окончания тестирования"; dataGridView1.Columns["isAvailable"].HeaderText = "Доступен студентам"; } }
private void buttonAdd_Click(object sender, EventArgs e) { string selectedText = comboBox1.SelectedItem.ToString().Trim(); AcademicGroup academicGroup = academicGroups.Find(item => item.Name.Trim().Equals(selectedText)); bool alreadyExist = false; var x = dataGridView1.Rows; for (int i = 0; i < x.Count; i++) { if (Convert.ToString(x[i].Cells["GroupName"].Value) == academicGroup.Name) { alreadyExist = true; } } if (academicGroup == null || alreadyExist) { MessageBox.Show("Данная связь уже существует или предмет не выбран"); return; } using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"INSERT into GroupTesting(idTest,idAcademicGroup,expirationDate,isAvailable) VALUES (@idTest, @idAcademicGroup , @expirationDate, @isAvailable)"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idTest", test.id)); sqlParameters.Add(new SqlParameter("@idAcademicGroup", academicGroup.id)); sqlParameters.Add(new SqlParameter("@expirationDate", dateTimePicker1.Value)); sqlParameters.Add(new SqlParameter("@isAvailable", checkBox1.Checked)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } LoadData(); }
private void buttonAdd_Click(object sender, EventArgs e) { string selectedText = comboBox1.SelectedItem.ToString().Trim(); AcademicSubject academicSubject = academicSubjects.Find(item => item.Name.Trim().Equals(selectedText)); bool alreadyExist = false; var x = dataGridView1.Rows; for (int i = 0; i < x.Count; i++) { if (Convert.ToInt32(x[i].Cells["id"].Value) == academicSubject.id) { alreadyExist = true; } } if (academicSubject == null || alreadyExist) { MessageBox.Show("Данная связь уже существует или предмет не выбран"); return; } using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.AddAcSubjects(idTeacher, academicSubject.id); LoadData(); } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { SqlParameter param = new SqlParameter("idTest", test.id.ToString()); List <int> idQuestions = db.Database.SqlQuery <int>("Select q_t.idQuestion from Question_Test as q_t Where q_t.idTest = @idTest", param).ToList(); if (idQuestions.Count != 0) { var questions = from q in db.Question where idQuestions.Contains(q.id) select new { id = q.id, Text = q.Text, idSubjects = q.idSubjects, Mark = q.Mark }; questionList = new List <Question>(); foreach (var o in questions) { questionList.Add(new Question() { id = o.id, Text = o.Text, idSubjects = o.idSubjects, Mark = o.Mark }); } questionControls = AddControls(); ChangeSizeControls(questionControls); } } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { var x = from s in db.Student select new { s.id, s.Surname, s.Name, s.Patronymic, academicGroupName = s.AcademicGroup.Name, s.Login }; dataGridView1.DataSource = x.ToList(); dataGridView1.Columns["id"].Visible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["Surname"].HeaderText = "Фамилия"; dataGridView1.Columns["Name"].HeaderText = "Имя"; dataGridView1.Columns["Patronymic"].HeaderText = "Отчество"; dataGridView1.Columns["academicGroupName"].HeaderText = "Группа"; dataGridView1.Columns["Login"].HeaderText = "Логин"; } }
private void btnEnter_Click(object sender, EventArgs e) { bool allDataDontInserted = tbSurname.Text == null & tbName.Text == null & tbPatronymic.Text == null & tbLogin.Text == null & tbPassword.Text == null; if (allDataDontInserted) { return; } DialogResult result = MessageBox.Show("Вы уверены, что хотите сохранить изменения?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result != DialogResult.Yes) { return; } using (StudentTestingEntities1 db = new StudentTestingEntities1()) { using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand( "sp_addlogin @Login, @Password, @DBNAME", connection)) { command.Parameters.Add(new SqlParameter("@Login", tbLogin.Text)); command.Parameters.Add(new SqlParameter("@Password", tbPassword.Text)); command.Parameters.Add(new SqlParameter("@DBNAME", Properties.Settings.Default.DataBase)); SqlDataReader reader = command.ExecuteReader(); } using (SqlCommand command = new SqlCommand( "sp_adduser @Login, @Login, @Role", connection)) { command.Parameters.Add(new SqlParameter("@Login", tbLogin.Text)); command.Parameters.Add(new SqlParameter("@Role", "teacher")); SqlDataReader reader = command.ExecuteReader(); } } db.Teacher.Add(new Teacher() { Surname = tbSurname.Text, Name = tbName.Text, Patronymic = tbPatronymic.Text, Login = tbLogin.Text, }); db.SaveChanges(); } LoadData(); }
private void buttonDelete_Click(object sender, EventArgs e) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.DeleteAcSubjects(idTeacher, selectedAcademicSubject.id); } LoadData(); }
private void buttonAdd_Click(object sender, EventArgs e) { short passMark; bool text = tbName.Text.Equals(""); bool number = !Int16.TryParse(tbPassMark.Text, out passMark); bool acsub = comboBoxAcSubs.SelectedItem != null; if (text | number) { return; } if (acsub) { string selectedText = comboBoxAcSubs.SelectedItem.ToString().Trim(); AcademicSubject academicSubject = academicSubjects.Find(item => item.Name.Trim().Equals(selectedText)); using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"exec dbo.addtest @TextName, @PassMark, @IdAcSub"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@TextName", tbName.Name)); sqlParameters.Add(new SqlParameter("@PassMark", passMark)); sqlParameters.Add(new SqlParameter("@IdAcSub", academicSubject.id)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } Clear(); LoadData(); } else if (user.Role.Equals(UserRole.Admin)) { DialogResult result = MessageBox.Show("Предмет не задан! Тест не будет виден, пока ему его не присовоят.", "Предупреждение", MessageBoxButtons.OKCancel); if (result.Equals(DialogResult.OK)) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.Test.Add(new Test() { Name = tbName.Text, PassMark = passMark }); db.SaveChanges(); } Clear(); LoadData(); } else { return; } } else { MessageBox.Show("Предмет не задан!"); } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { var users = ( from s in db.Student select new { s.Surname, s.Name, s.Patronymic, s.Login, } ).Concat ( from t in db.Teacher select new { Surname = t.Surname, Name = t.Name, Patronymic = t.Patronymic, Login = t.Login } ); var userToList = new { Surname = users.First().Surname, Name = users.First().Name, Patronymic = users.First().Patronymic, Login = users.First().Login, role = db.GetRole(users.First().Login).FirstOrDefault() }; var UserList = new[] { userToList }.ToList(); UserList.Clear(); users.ToList().ForEach(o => { string currentRole = db.GetRole(o.Login).FirstOrDefault(); UserList.Add(new { Surname = o.Surname, Name = o.Name, Patronymic = o.Patronymic, Login = o.Login, role = currentRole }); }); dataGridView1.DataSource = UserList; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["Surname"].HeaderText = "Фамилия"; dataGridView1.Columns["Name"].HeaderText = "Имя"; dataGridView1.Columns["Patronymic"].HeaderText = "Отчество"; dataGridView1.Columns["Login"].HeaderText = "Логин"; dataGridView1.Columns["role"].HeaderText = "Роль"; } }
private void LoadAcGroups() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.AcademicGroup.Load(); academicGroups = db.AcademicGroup.Local.ToBindingList().ToList(); academicGroups.ForEach(o => comboBox1.Items.Add(o.Name.Trim())); } }
private void LoadAcSubjects() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.AcademicSubject.Load(); allAcademicSubjects = db.AcademicSubject.Local.ToBindingList().ToList(); allAcademicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim())); } }
private void Students_Load(object sender, EventArgs e) { LoadData(); using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.AcademicGroup.Load(); academicGroups = db.AcademicGroup.Local.ToBindingList().ToList(); academicGroups.ForEach(o => comboBox1.Items.Add(o.Name.Trim())); } }
private void LoadAllTest() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Select t.id, t.Name, t.PassMark from test as t"; tests = db.Database.SqlQuery <Test>(query).ToList(); dataGridView1.DataSource = tests; ConfigureDataGridView(); } }
private void UpdateAttributes() { if (!selectedGroupTesting.idAcademicGroup.Equals(updatedGroupTesting.idAcademicGroup)) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Update GroupTesting Set idAcademicGroup = @updateIdAcademicGroup where idTest=@idTest and idAcademicGroup=@selectIdAcademicGroup"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idTest", test.id)); sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup", updatedGroupTesting.idAcademicGroup)); sqlParameters.Add(new SqlParameter("@selectIdAcademicGroup", selectedGroupTesting.idAcademicGroup)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } } if (!selectedGroupTesting.expirationDate.Equals(updatedGroupTesting.expirationDate)) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Update GroupTesting Set expirationDate = @updateExpirationDate where idTest=@idTest and idAcademicGroup=@updateIdAcademicGroup and expirationDate=@selectExpirationDate"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idTest", test.id)); sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup ", updatedGroupTesting.idAcademicGroup)); sqlParameters.Add(new SqlParameter("@updateExpirationDate", updatedGroupTesting.expirationDate)); sqlParameters.Add(new SqlParameter("@selectExpirationDate", selectedGroupTesting.expirationDate)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } } if (!selectedGroupTesting.isAvailable.Equals(updatedGroupTesting.isAvailable)) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Update GroupTesting Set isAvailable = @updateIsAvailable where idTest=@idTest and idAcademicGroup=@updateIdAcademicGroup and isAvailable=@selectIsAvailable"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idTest", test.id)); sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup ", updatedGroupTesting.idAcademicGroup)); sqlParameters.Add(new SqlParameter("@updateIsAvailable", updatedGroupTesting.isAvailable)); sqlParameters.Add(new SqlParameter("@selectIsAvailable", selectedGroupTesting.isAvailable)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } } }
private void Save(List <Answer> saveList) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { saveList.ForEach(o => { o.idQuestion = Question.id; db.Answer.Add(o); }); db.SaveChanges(); } }
private static void Delete(List <Question> deleteList) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { deleteList.ForEach(o => { db.Question.Attach(o); db.Question.Remove(o); }); db.SaveChanges(); } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { var z = db.GetAcSubjects(idTeacher); dataGridView1.DataSource = z.ToList(); dataGridView1.Columns["id"].Visible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["Name"].HeaderText = "Предмет"; } }
private void Delete(List <Answer> deleteList) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { deleteList.ForEach(o => { db.Answer.Attach(o); db.Answer.Remove(o); }); db.SaveChanges(); } }
private User CreateUser() { User user; using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string login = db.GetLoginT().FirstOrDefault(); string role = db.GetRole(login).FirstOrDefault(); user = new User(login, role); } return(user); }
private void LoadTestWithOutAcSub() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Select t.id,t.Name,t.PassMark from Test_AcademicSubject as T_A RIGHT Outer JOIN Test as t on t.id = T_A.idTest Where T_A.idAcademicSubject is NULL"; tests = db.Database.SqlQuery <Test>(query).ToList(); dataGridView1.DataSource = tests; ConfigureDataGridView(); } }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.Teacher.Load(); dataGridView1.DataSource = db.Teacher.Local.ToBindingList(); dataGridView1.Columns["id"].Visible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["Surname"].HeaderText = "Фамилия"; dataGridView1.Columns["Name"].HeaderText = "Имя"; dataGridView1.Columns["Patronymic"].HeaderText = "Отчество"; dataGridView1.Columns["Login"].HeaderText = "Логин"; } }
private void buttonDelete_Click(object sender, EventArgs e) { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { string query = @"Delete from Test_AcademicSubject Where Test_AcademicSubject.idAcademicSubject = @idAcademicSubject and Test_AcademicSubject.idTest = @idTest"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@idAcademicSubject", selectedAcademicSubject.id)); sqlParameters.Add(new SqlParameter("@idTest", test.id)); db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray()); } LoadData(); }
private void LoadData() { using (StudentTestingEntities1 db = new StudentTestingEntities1()) { db.GetCurrentTest().Load(); tests = db.GetCurrentTest().ToList(); dataGridView1.DataSource = tests; dataGridView1.Columns["Name"].HeaderText = "Название теста"; dataGridView1.Columns["PassMark"].HeaderText = "Проходной балл"; dataGridView1.Columns["id"].Visible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }