public AddTestForm(User user, IEnumerable <HandbookTest> handbookTests, IEnumerable <HandbookSubjects> handbookSubjects, TestForm testForm, HandbookTest handbookTest)
{
InitializeComponent();
cbSubjectAndGrade.DropDownStyle = ComboBoxStyle.DropDownList;
this.user = user;
this.testForm = testForm;
this.txtId.Text = handbookTest.Id.ToString();
this.txtSubjectId.Text = handbookTest.SubjectId.ToString();
this.txtName.Text = handbookTest.Name.ToString();
this.cbSubjectAndGrade.Text = handbookTest.SubjectName.ToString() + " " + handbookTest.GradeName.ToString();
this.txtQuantity.Text = handbookTest.Quantity.ToString();
this.txtQuantityPass.Text = handbookTest.QuantityPass.ToString();
subject = handbookSubjects.ToList().Where(s => s.Id == handbookTest.SubjectId).FirstOrDefault();
var indexOfIntegerValue = handbookSubjects.ToList().IndexOf(subject);
foreach (var subject in handbookSubjects)
{
cbSubjectAndGrade.Items.Add(subject.Name + " " + subject.GradeNumber + subject.GradeName);
}
cbSubjectAndGrade.SelectionChangeCommitted += delegate
{
var index = cbSubjectAndGrade.SelectedIndex;
var list = handbookSubjects.ToList();
subject = list[index];
};
cbSubjectAndGrade.SelectedItem = cbSubjectAndGrade.Items[indexOfIntegerValue];
}
private async void btnAdd_Click(object sender, EventArgs e)
{
var grade = this.grade;
HandbookSubjects handbookSubjects = new HandbookSubjects();
if (txtId.Text != "")
{
handbookSubjects.Id = Int32.Parse(txtId.Text);
}
handbookSubjects.Name = txtName.Text;
handbookSubjects.GradeNumber = grade.Number;
handbookSubjects.GradeName = grade.Name;
handbookSubjects.Grade = grade.Id;
HandbookSubjectsService handbookSubjectsService = new HandbookSubjectsService();
await handbookSubjectsService.Add(user.Login, user.Password, handbookSubjects);
SubjectForm.dataGridView.Rows.Clear();
ApplicationViewModel applicationViewModel = new ApplicationViewModel();
await applicationViewModel.GetSubjects(user.Login, user.Password);
foreach (var subject in applicationViewModel.handbookSubjects)
{
var rowNumber = SubjectForm.dataGridView.Rows.Add();
SubjectForm.dataGridView.Rows[rowNumber].Cells["Id"].Value = subject.Id;
SubjectForm.dataGridView.Rows[rowNumber].Cells["subjectName"].Value = subject.Name;
SubjectForm.dataGridView.Rows[rowNumber].Cells["Grade"].Value = subject.Grade;
SubjectForm.dataGridView.Rows[rowNumber].Cells["GradeNumber"].Value = subject.GradeNumber;
SubjectForm.dataGridView.Rows[rowNumber].Cells["GradeName"].Value = subject.GradeName;
}
this.Close();
}
public AddTestForm(User user, IEnumerable <HandbookTest> handbookTests, IEnumerable <HandbookSubjects> handbookSubjects, TestForm testForm)
{
if (!String.IsNullOrEmpty(Properties.Settings.Default.Language))
{
// ВАЖНО: Устанавливать язык нужно до создания элементов формы!
// Это можно сделать глобально, в рамках приложения в классе Program (см. файл Program.cs).
System.Threading.Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.GetCultureInfo(Properties.Settings.Default.Language);
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.GetCultureInfo(Properties.Settings.Default.Language);
}
InitializeComponent();
cbSubjectAndGrade.DropDownStyle = ComboBoxStyle.DropDownList;
this.user = user;
this.testForm = testForm;
foreach (var subject in handbookSubjects)
{
cbSubjectAndGrade.Items.Add(subject.Name + " " + subject.GradeNumber + subject.GradeName);
}
cbSubjectAndGrade.SelectionChangeCommitted += delegate
{
var index = cbSubjectAndGrade.SelectedIndex;
var list = handbookSubjects.ToList();
subject = list[index];
};
}
private async void toolStripButton1_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show(MyStrings.Sure, "", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
bool success;
HandbookSubjects handbookSubjects = new HandbookSubjects();
int id = Int32.Parse(txtId.Text);
ApplicationViewModel applicationViewModel = new ApplicationViewModel();
success = await applicationViewModel.DeleteSubject(user.Login, user.Password, id);
dataGridView.Rows.Clear();
await applicationViewModel.GetSubjects(user.Login, user.Password);
foreach (var subject in applicationViewModel.handbookSubjects)
{
var rowNumber = dataGridView.Rows.Add();
dataGridView.Rows[rowNumber].Cells["Id"].Value = subject.Id;
dataGridView.Rows[rowNumber].Cells["subjectName"].Value = subject.Name;
dataGridView.Rows[rowNumber].Cells["Grade"].Value = subject.Grade;
dataGridView.Rows[rowNumber].Cells["GradeNumber"].Value = subject.GradeNumber;
dataGridView.Rows[rowNumber].Cells["GradeName"].Value = subject.GradeName;
}
if (success)
{
MessageBox.Show(MyStrings.Delete);
}
else
{
MessageBox.Show(MyStrings.Cant);
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
public async Task <IActionResult> PostUser([FromBody] HandbookSubjects handbookSubjects)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Subjects subjects = new Subjects();
Grade grade = new Grade();
Grade gradeId = new Grade();
Subjects subjectId = new Subjects();
gradeId = _context.Grade.AsNoTracking().Where(g => g.Name == handbookSubjects.GradeName && g.Number == handbookSubjects.GradeNumber).FirstOrDefault();
subjectId = _context.Subjects.AsNoTracking().Where(s => s.Name == handbookSubjects.Name).FirstOrDefault();
if (handbookSubjects.Id == 0)
{
if (gradeId == null)
{
grade.Name = handbookSubjects.GradeName;
grade.Number = handbookSubjects.GradeNumber;
_context.Grade.Add(grade);
_context.SaveChanges();
subjects.Name = handbookSubjects.Name;
subjects.Grade = grade.Id;
_context.Subjects.Add(subjects);
}
else
{
subjects.Name = handbookSubjects.Name;
subjects.Grade = gradeId.Id;
_context.Subjects.Add(subjects);
}
}
else
{
if (gradeId == null)
{
grade.Name = handbookSubjects.GradeName;
grade.Number = handbookSubjects.GradeNumber;
_context.Grade.Add(grade);
_context.SaveChanges();
subjects.Name = handbookSubjects.Name;
subjects.Grade = grade.Id;
subjects.Id = handbookSubjects.Id;
_context.Entry(subjects).State = EntityState.Modified;
}
else
{
subjects.Name = handbookSubjects.Name;
subjects.Grade = handbookSubjects.Grade;
subjects.Id = handbookSubjects.Id;
try
{
_context.Entry(subjects).State = EntityState.Modified;
}
catch (Exception e)
{
int ff = 1;
}
await _context.SaveChangesAsync();
}
}
await _context.SaveChangesAsync();
return(Ok(handbookSubjects));
}
