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 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 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 Save(List <Answer> saveList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
saveList.ForEach(o =>
{
o.idQuestion = Question.id;
db.Answer.Add(o);
});
db.SaveChanges();
}
}
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 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 buttonDelete_Click(object sender, EventArgs e)
{
if (selectedTest == null)
{
MessageBox.Show("Элемент не выбран");
return;
}
var deleteTest = new Test()
{
id = (int)selectedTest.id,
Name = selectedTest.Name,
PassMark = (short)selectedTest.PassMark
};
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.Entry(deleteTest).State = EntityState.Deleted;
db.SaveChanges();
}
Clear();
LoadData();
}
private void Update(List <Answer> updateList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
try
{
updateList.ForEach(o =>
{
var p = db.Answer.Where(z => z.Id == o.Id).FirstOrDefault();
p.isCorrect = o.isCorrect;
p.idQuestion = o.idQuestion;
p.Text = o.Text;
//db.Entry(p).State = EntityState.Modified;
});
db.SaveChanges();
}
catch (Exception j)
{
Console.Write(j.ToString());
}
}
}
private void Save(Subjects subject, List <Question> saveList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
saveList.ForEach(o =>
{
o.idSubjects = subject.id;
db.Question.Add(o);
});
db.SaveChanges();
saveList.ForEach(o =>
{
o = db.Question.Where(z => o.idSubjects == z.idSubjects & o.Mark == z.Mark & o.Text == z.Text).FirstOrDefault();
string query = @"INSERT into Question_Test(idQuestion,idTest) VALUES
(@idQuestion, @idTest)";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idQuestion", o.id));
sqlParameters.Add(new SqlParameter("@idTest", test.id));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
});
}
}
private void Update(List <Question> updateList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
try
{
updateList.ForEach(o =>
{
var entity = db.Question.Where(z => z.id == o.id).FirstOrDefault();
if (entity == null)
{
return;
}
db.Entry(entity).CurrentValues.SetValues(o);
});
db.SaveChanges();
}
catch (Exception j)
{
Console.Write(j.ToString());
}
}
}