private void saveToDB()
{
var dataContext = new ITSkillsDataContext();
var employee = dataContext.Employees.SingleOrDefault(e => e.Id == this.employeeID);
employee.Name = nameTextBox.Text;
employee.LastName = lastNameTextBox.Text;
if (patronymicTextBox.Text == "")
{
employee.Patronymic = null;
}
else
{
employee.Patronymic = patronymicTextBox.Text;
}
employee.DateOfBirth = birthDateTimePicker.Value;
string newProfession = professionComboBox.SelectedItem.ToString();
employee.ProfessionID = dataContext.Professions.SingleOrDefault(p => p.Profession == newProfession).Id;
removeEmployeeSkillsFromDB();
foreach (string skill in employeeSkillsListBox.Items)
{
EmployeesSkills employeeSkill = new EmployeesSkills();
employeeSkill.EmployeeID = this.employeeID;
employeeSkill.SkillID = dataContext.Skills.SingleOrDefault(s => s.Skill == skill).Id;
var alreadyInDB = from es in dataContext.EmployeesSkills
where es.EmployeeID == employeeSkill.EmployeeID
where es.SkillID == employeeSkill.SkillID
select es;
if (alreadyInDB.Count() == 0)
{
dataContext.EmployeesSkills.InsertOnSubmit(employeeSkill);
}
}
dataContext.SubmitChanges();
}
private void detach_EmployeesSkills(EmployeesSkills entity)
{
this.SendPropertyChanging();
entity.Skills = null;
}
partial void DeleteEmployeesSkills(EmployeesSkills instance);
partial void UpdateEmployeesSkills(EmployeesSkills instance);
partial void InsertEmployeesSkills(EmployeesSkills instance);
private void attach_EmployeesSkills(EmployeesSkills entity)
{
this.SendPropertyChanging();
entity.Employees = this;
}
