private void buttonSave_Click(object sender, EventArgs e)
{
model.Name = textBoxForName.Text.Trim();
model.Number = Convert.ToInt32(textBoxForNumber.Text);
model.Manager = textBoxForManager.Text.Trim();
model.Faculty = textBoxForFaculty.Text.Trim();
using (EducationDBEntities db = new EducationDBEntities())
{
if (model.DepartmentId == 0)
{
db.Departments.Add(model);
}
else
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
Clear();
PopulateDataGridView();
MessageBox.Show("Отправлено успешно!");
}
private void buttonSave_Click(object sender, EventArgs e)
{
model.TeacherName = textBox1.Text.Trim();
model.Date = dateTimePicker.Value.Date;
model.Position = textBox3.Text.Trim();
model.Number = Int32.Parse(textBox4.Text);
model.Department = textBox5.Text.Trim();
model.Discipline = textBox6.Text.Trim();
using (EducationDBEntities db = new EducationDBEntities())
{
if (model.TeacherId == 0)
{
db.Teachers.Add(model);
}
else
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
Clear();
PopulateDataGridView();
MessageBox.Show("Отправлено успешно!");
}
private void buttonSave_Click(object sender, EventArgs e)
{
model.Name = textBoxForName.Text.Trim();
model.Code = textBoxForCode.Text.Trim();
model.Semester = Convert.ToInt32(textBoxForSemester.Text);
model.Speciality = textBoxForSpeciality.Text.Trim();
using (EducationDBEntities db = new EducationDBEntities())
{
if (model.DisciplineId == 0)
{
db.DIsciplines.Add(model);
}
else
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
Clear();
PopulateDataGridView();
MessageBox.Show("Отправлено успешно!");
}
private void PopulateDataGridView()
{
dataGridViewTeachers.AutoGenerateColumns = false;
using (EducationDBEntities db = new EducationDBEntities())
{
dataGridViewTeachers.DataSource = db.Teachers.ToList <Teachers>();
}
}
private void PopulateDataGridView()
{
dataGridViewDepartments.AutoGenerateColumns = false;
using (EducationDBEntities db = new EducationDBEntities())
{
dataGridViewDepartments.DataSource = db.Departments.ToList();
}
}
private void PopulateDataGridView()
{
dataGridViewDIsciplines.AutoGenerateColumns = false;
using (EducationDBEntities db = new EducationDBEntities())
{
dataGridViewDIsciplines.DataSource = db.DIsciplines.ToList <DIsciplines>();
}
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
string filterName = textBox2.Text;
if (filterName != "")
{
using (EducationDBEntities db = new EducationDBEntities())
{
dataGridViewTeachers.DataSource = db.Teachers.Where(teacher => teacher.Department == filterName).ToList();
}
}
else
{
PopulateDataGridView();
}
}
private void dataGridViewDepartments_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewDepartments.CurrentRow.Index != -1)
{
model.DepartmentId = Convert.ToInt32(dataGridViewDepartments.CurrentRow.Cells["departmentIdDataGridViewTextBoxColumn"].Value);
using (EducationDBEntities db = new EducationDBEntities())
{
model = db.Departments.Where(department => department.DepartmentId == model.DepartmentId).FirstOrDefault();
textBoxForName.Text = model.Name;
textBoxForNumber.Text = model.Number.ToString();
textBoxForManager.Text = model.Manager;
textBoxForFaculty.Text = model.Faculty;
}
buttonSave.Text = "Изменить";
buttonDelete.Enabled = true;
}
}
private void dataGridViewDIsciplines_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewDIsciplines.CurrentRow.Index != -1)
{
model.DisciplineId = Convert.ToInt32(dataGridViewDIsciplines.CurrentRow.Cells["disciplineIdDataGridViewTextBoxColumn"].Value);
using (EducationDBEntities db = new EducationDBEntities())
{
model = db.DIsciplines.Where(discipline => discipline.DisciplineId == model.DisciplineId).FirstOrDefault();
textBoxForName.Text = model.Name;
textBoxForCode.Text = model.Code;
textBoxForSemester.Text = model.Semester.ToString();
textBoxForSpeciality.Text = model.Speciality;
}
buttonSave.Text = "Изменить";
buttonDelete.Enabled = true;
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы действительно хотите удалить элемент?", "Операция удаления", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (EducationDBEntities db = new EducationDBEntities())
{
var entry = db.Entry(model);
if (entry.State == EntityState.Detached)
{
db.Teachers.Attach(model);
}
db.Teachers.Remove(model);
db.SaveChanges();
PopulateDataGridView();
Clear();
//MessageBox.Show("Удаление прошло успешно!");
}
}
}
private void buttonToDepartment_Click(object sender, EventArgs e)
{
string department = comboBoxFilter.Text;
List <string> disciplines = null;
using (EducationDBEntities db = new EducationDBEntities())
{
var teachers = db.Teachers.Where(teacher => teacher.Department == department);
disciplines = teachers.Select(x => x.Discipline).ToList();
}
if (disciplines == null)
{
MessageBox.Show("Дисциплин нет");
}
else
{
MessageBox.Show(string.Join("\n", disciplines), "Кафедра " + department);
}
}
private void dataGridViewTeachers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewTeachers.CurrentRow.Index != -1)
{
model.TeacherId = Convert.ToInt32(dataGridViewTeachers.CurrentRow.Cells["teacherIdDataGridViewTextBoxColumn"].Value);
using (EducationDBEntities db = new EducationDBEntities())
{
model = db.Teachers.Where(teacher => teacher.TeacherId == model.TeacherId).FirstOrDefault();
textBox1.Text = model.TeacherName;
dateTimePicker.Value = model.Date.Value;
textBox3.Text = model.Position;
textBox4.Text = model.Number.ToString();
textBox5.Text = model.Department;
textBox6.Text = model.Discipline;
}
buttonSave.Text = "Изменить";
buttonDelete.Enabled = true;
}
}
