public override bool EditingEntity(TestingSystemEntities db)
{
int idCategory = Convert.ToInt32(this.Tag);
var editCategory = db.Category
.Where(x => x.Id == idCategory)
.FirstOrDefault();
WindowEdit windowEdit = new WindowEdit(editCategory);
windowEdit.gridEditCategory.Visibility = Visibility.Visible;
windowEdit.textBoxCategoryName.Focus();
windowEdit.CategoryName = editCategory.Name;
windowEdit.textBoxCategoryName.MaxLength = 30;
bool?result = windowEdit.ShowDialog();
if (result == true)
{
// Запишем в базу
editCategory.Name = windowEdit.CategoryName;
db.SaveChanges();
return(true);
}
return(false);
}
public override bool EditingEntity(TestingSystemEntities db)
{
int idQuestion = Convert.ToInt32(this.Tag);
var editQuestion = db.Question
.Where(x => x.Id == idQuestion)
.FirstOrDefault();
WindowEdit windowEdit = new WindowEdit(editQuestion);
windowEdit.gridEditQuestion.Visibility = Visibility.Visible;
windowEdit.textBoxQuestionName.Focus();
windowEdit.textBoxQuestionName.MaxLength = 500;
// Заполняем поле вопроса
windowEdit.QuestionName = editQuestion.QuestionText;
bool?result = windowEdit.ShowDialog();
if (result == true)
{
editQuestion.QuestionText = windowEdit.QuestionName;
db.SaveChanges();
return(true);
}
return(false);
}
public override bool AddEntity(TestingSystemEntities db)
{
WindowEdit windowAdd = new WindowEdit(this.TestId);
windowAdd.gridEditQuestion.Visibility = Visibility.Visible;
windowAdd.textBoxQuestionName.Focus();
windowAdd.buttonOk.Content = "Добавить";
windowAdd.Title = "Добавление вопроса";
windowAdd.textBoxQuestionName.MaxLength = 500;
bool?result = windowAdd.ShowDialog();
if (result == true)
{
Question addQuestion = new Question();
addQuestion.QuestionText = windowAdd.QuestionName;
addQuestion.TestId = Convert.ToInt16(this.TestId);
db.Question.Add(addQuestion);
db.SaveChanges();
return(true);
}
return(false);
}
public override bool AddEntity(TestingSystemEntities db)
{
WindowEdit windowAdd = new WindowEdit();
windowAdd.gridEditCategory.Visibility = Visibility.Visible;
windowAdd.textBoxCategoryName.Focus();
windowAdd.buttonOk.Content = "Добавить";
windowAdd.Title = "Добавление категории";
windowAdd.textBoxCategoryName.MaxLength = 30;
bool?result = windowAdd.ShowDialog();
if (result == true)
{
Category category = new Category();
category.Name = windowAdd.CategoryName;
db.Category.Add(category);
db.SaveChanges();
return(true);
}
return(false);
}
public override bool AddEntity(TestingSystemEntities db)
{
WindowEdit windowAdd = new WindowEdit(this.CategoryId);
windowAdd.gridEditTest.Visibility = Visibility.Visible;
windowAdd.textBoxTestName.Focus();
windowAdd.buttonOk.Content = "Добавить";
windowAdd.Title = "Добавление теста";
// Настройка comboBox названия категорий.
// узнаем существующие категории
var categoriesTest
= (
from category in db.Category
select category
)
.ToList();
// Заполняем названия доступных категорий.
windowAdd.comboBoxTestCategories.ItemsSource
= categoriesTest;
// Выводим только имена категорий.
windowAdd.comboBoxTestCategories.DisplayMemberPath
= "Name";
// Выбираем категорию соответствующую
// тесту который редактируем.
windowAdd.comboBoxTestCategories.SelectedItem
= categoriesTest
.Where(x => x.Id == this.CategoryId)
.FirstOrDefault();
windowAdd.comboBoxTestCategories.IsEnabled
= false;
windowAdd.textBoxTestName.MaxLength = 60;
bool?result = windowAdd.ShowDialog();
if (result == true)
{
Test addTest = new Test();
addTest.Name = windowAdd.TestName;
addTest.CategoryId
= (windowAdd.comboBoxTestCategories
.SelectedItem as Category).Id;
db.Test.Add(addTest);
db.SaveChanges();
return(true);
}
return(false);
}
public override bool EditingEntity(TestingSystemEntities db)
{
int idTest = Convert.ToInt32(this.Tag);
var editTest = db.Test
.Where(x => x.Id == idTest)
.FirstOrDefault();
WindowEdit windowEdit = new WindowEdit(editTest);
windowEdit.gridEditTest.Visibility = Visibility.Visible;
windowEdit.textBoxTestName.Focus();
windowEdit.textBoxTestName.MaxLength = 60;
var categoriesTest
= (
from category in db.Category
select category
)
.ToList();
// Заполняем название теста.
windowEdit.TestName = editTest.Name;
// Заполняем названия доступных категорий.
windowEdit.comboBoxTestCategories.ItemsSource
= categoriesTest;
// Выводим только имена категорий.
windowEdit.comboBoxTestCategories.DisplayMemberPath
= "Name";
// Выбираем категорию соответствующую
// тесту который редактируем.
windowEdit.comboBoxTestCategories.SelectedItem
= editTest.Category;
bool?result = windowEdit.ShowDialog();
if (result == true)
{
editTest.Name = windowEdit.TestName;
editTest.CategoryId
= (windowEdit.comboBoxTestCategories
.SelectedItem as Category).Id;
db.SaveChanges();
return(true);
}
return(false);
}
private void BtnEdit_Click(object sender, RoutedEventArgs e)
{
if (dttWorker.SelectedItems.Count > 0)
{
tWorker worker = dttWorker.SelectedItem as tWorker;
if (worker == null)
{
return;
}
WindowEdit windowEdit = new WindowEdit(worker, db);
windowEdit.ShowDialog();
db.Dispose();
LoadData();
}
}
private void BtnEdit_OnClick(object sender, RoutedEventArgs e)
{
var obj = DataGridEnterprise.SelectedCells;
enterprises ent = new enterprises();
ent.fullname = ((DataRowView)obj[0].Item).Row.ItemArray[1].ToString();
//WARNING! DO NOT UNCOMMIT
//ent.shortname = new ForeignKeyModel() { name = ((DataRowView)obj[0].Item).Row.ItemArray[2].ToString(), nameForeignColumn = "_type_name", nameForeignTable = "type_premises" };
ent.shortname = ((DataRowView)obj[0].Item).Row.ItemArray[2].ToString();
int id = int.Parse(((DataRowView)obj[0].Item).Row.ItemArray[0].ToString());
string condition = " code = " + id;
WindowEdit windowEdit = new WindowEdit(ent, new List<string>() { "Полное название", "Краткое название" }, condition);
if(windowEdit.ShowDialog() == true)
loadData();
}
public override bool EditingEntity(TestingSystemEntities db)
{
int idAnswer = Convert.ToInt32(this.Tag);
var editAnswer = db.Answer
.Where(x => x.Id == idAnswer)
.FirstOrDefault();
WindowEdit windowEdit = new WindowEdit(editAnswer);
windowEdit.gridEditAnswer.Visibility = Visibility.Visible;
windowEdit.textBoxAnswerText.Focus();
windowEdit.textBoxAnswerText.MaxLength = 300;
// Заполняем поле ответа
windowEdit.textBoxAnswerText.Text = editAnswer.ResponseText;
// Ставим значение
windowEdit.comboBoxAnswerValue.SelectedIndex
= editAnswer.CorrectAnswer == true
? (int)Result.Correct : (int)Result.NotCorrect;
bool?result = windowEdit.ShowDialog();
if (result == true)
{
this.SwitchingOtherAnswersToWrong(db,
windowEdit.comboBoxAnswerValue.SelectedIndex,
editAnswer.QuestionId);
editAnswer.ResponseText = windowEdit.textBoxAnswerText.Text;
editAnswer.CorrectAnswer
= windowEdit.comboBoxAnswerValue.SelectedIndex == (int)Result.Correct
? true : false;
db.SaveChanges();
this.EntityActivitySwitching(db, editAnswer);
return(true);
}
return(false);
}
public override bool AddEntity(TestingSystemEntities db)
{
WindowEdit windowAdd = new WindowEdit(this.QuestionId);
windowAdd.gridEditAnswer.Visibility = Visibility.Visible;
windowAdd.textBoxAnswerText.Focus();
windowAdd.buttonOk.Content = "Добавить";
windowAdd.Title = "Добавление ответа";
windowAdd.textBoxAnswerText.MaxLength = 300;
// Ставим значение по умолчанию
windowAdd.comboBoxAnswerValue.SelectedIndex = (int)Result.NotCorrect;
bool?result = windowAdd.ShowDialog();
if (result == true)
{
this.SwitchingOtherAnswersToWrong(db,
windowAdd.comboBoxAnswerValue.SelectedIndex,
this.QuestionId);
Answer addAnswer = new Answer();
addAnswer.ResponseText = windowAdd.AnswerName;
addAnswer.CorrectAnswer
= windowAdd
.comboBoxAnswerValue.SelectedIndex == (int)Result.Correct
? true : false;
addAnswer.QuestionId = this.QuestionId;
db.Answer.Add(addAnswer);
db.SaveChanges();
// Установка Active
this.EntityActivitySwitching(db, addAnswer);
return(true);
}
return(false);
}
