private bool IsProfessionCanBeDeleted() { ITSkillsDataContext dataContext = new ITSkillsDataContext(); string professionName = professionsListBox.SelectedItem.ToString(); int professionID = dataContext.Professions.SingleOrDefault(p => p.Profession == professionName).Id; var employeesWithThisProfessions = from e in dataContext.Employees where e.ProfessionID == professionID select e; if (employeesWithThisProfessions.Count() == 0) { return(true); } else { MessageBox.Show( "Удаление невозможно, так как имеются сотрудники с данной профессией.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); return(false); } }
private void addButton_Click(object sender, EventArgs e) { this.ValidateChildren(); if (FormValidator.IsValidated(this, errorProvider1)) { var dataContext = new ITSkillsDataContext(); Employees employee = new Employees(); 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; dataContext.Employees.InsertOnSubmit(employee); dataContext.SubmitChanges(); this.Close(); } }
internal int getProfessionsCount() { var dataContext = new ITSkillsDataContext(); var professions = from p in dataContext.Professions select p; return(professions.Count()); }
private void DeleteProfession() { ITSkillsDataContext dataContext = new ITSkillsDataContext(); string professionName = professionsListBox.SelectedItem.ToString(); var profession = dataContext.Professions.SingleOrDefault(p => p.Profession == professionName); dataContext.Professions.DeleteOnSubmit(profession); dataContext.SubmitChanges(); InitProfessionsList(); }
private void DeleteEmloyee() { int employeeID = Convert.ToInt32(EmployeesGrid.Rows[EmployeesGrid.CurrentCell.RowIndex].Cells[3].Value); var dataContext = new ITSkillsDataContext(); var employee = dataContext.Employees.SingleOrDefault(e => e.Id == employeeID); dataContext.Employees.DeleteOnSubmit(employee); dataContext.SubmitChanges(); FillEmployeeGrid(); }
private void removeEmployeeSkillsFromDB() { var dataContext = new ITSkillsDataContext(); var employeeSkills = from es in dataContext.EmployeesSkills where es.EmployeeID == this.employeeID select es; dataContext.EmployeesSkills.DeleteAllOnSubmit(employeeSkills); dataContext.SubmitChanges(); }
private void InitProfessionsList() { professionsListBox.Items.Clear(); var dataContext = new ITSkillsDataContext(); var professions = from p in dataContext.Professions select p.Profession.ToString(); foreach (string profession in professions) { professionsListBox.Items.Add(profession); } }
private void FillProfessionComboBoxValues() { var dataContext = new ITSkillsDataContext(); var professions = from p in dataContext.Professions select p.Profession.ToString(); foreach (string profession in professions) { professionComboBox.Items.Add(profession); } ; }
private void FillEmployeeSkillsList() { var dataContext = new ITSkillsDataContext(); var skills = from s in dataContext.Skills join es in dataContext.EmployeesSkills on s.Id equals es.SkillID where es.EmployeeID == this.employeeID select s.Skill; employeeSkillsListBox.Items.Clear(); foreach (string skill in skills) { employeeSkillsListBox.Items.Add(skill); } }
private void DeleteSkill() { ITSkillsDataContext dataContext = new ITSkillsDataContext(); string profession = professionsListBox.SelectedItem.ToString(); int professionID = dataContext.Professions.SingleOrDefault(p => p.Profession == profession).Id; if (skillsListBox.SelectedItems.Count == 1) { string skillName = skillsListBox.SelectedItem.ToString(); var skill = dataContext.Skills.SingleOrDefault(s => s.Skill == skillName && s.ProfessionID == professionID); dataContext.Skills.DeleteOnSubmit(skill); dataContext.SubmitChanges(); } ShowSkills(); }
private void ShowSkills() { skillsListBox.Items.Clear(); var dataContext = new ITSkillsDataContext(); string profession = professionsListBox.SelectedItem.ToString(); int professionID = dataContext.Professions.SingleOrDefault(p => p.Profession == profession).Id; var skills = from s in dataContext.Skills where s.ProfessionID == professionID select s.Skill.ToString(); foreach (string skill in skills) { skillsListBox.Items.Add(skill); } }
private void FillEmployeeGrid() { var dataContext = new ITSkillsDataContext(); var employee = from e in dataContext.Employees join p in dataContext.Professions on e.ProfessionID equals p.Id select new { FullName = String.Format(@"{0} {1} {2}", e.Name, e.LastName, e.Patronymic), DateOfBirth = e.DateOfBirth, Profession = p.Profession, Id = e.Id }; EmployeesGrid.DataSource = employee; EmployeesGrid.Columns[0].HeaderText = "ФИО"; EmployeesGrid.Columns[1].HeaderText = "Дата рождения"; EmployeesGrid.Columns[2].HeaderText = "Профессия"; EmployeesGrid.Columns[3].Visible = false; }
internal static void AddProfession() { string newProfessionName = InputDialog.Show("Введите название профессии", "Создание профессии"); if (!String.IsNullOrWhiteSpace(newProfessionName)) { ITSkillsDataContext dataContext = new ITSkillsDataContext(); var alreadyInDB = from p in dataContext.Professions where p.Profession == newProfessionName select p; if (alreadyInDB.Count() == 0) { Professions newProfession = new Professions(); newProfession.Profession = newProfessionName; dataContext.Professions.InsertOnSubmit(newProfession); dataContext.SubmitChanges(); } } }
private void FillInformation() { var dataContext = new ITSkillsDataContext(); var employees = from e in dataContext.Employees join p in dataContext.Professions on e.ProfessionID equals p.Id where e.Id == this.employeeID select new { Name = e.Name.ToString(), LastName = e.LastName.ToString(), Patronymic = e.Patronymic.ToString(), BirthDate = e.DateOfBirth, Profession = p.Profession.ToString() }; var employee = employees.First(); nameTextBox.Text = employee.Name; lastNameTextBox.Text = employee.LastName; patronymicTextBox.Text = employee.Patronymic; birthDateTimePicker.Value = employee.BirthDate; professionComboBox.SelectedItem = employee.Profession; }
private void AddSkill() { string newSkillName = InputDialog.Show("Введите название навыка", "Создание навыка"); if (!String.IsNullOrWhiteSpace(newSkillName)) { ITSkillsDataContext dataContext = new ITSkillsDataContext(); string profession = professionsListBox.SelectedItem.ToString(); int professionID = dataContext.Professions.SingleOrDefault(p => p.Profession == profession).Id; var alreadyInDB = from s in dataContext.Skills where s.Skill == newSkillName select s; if (alreadyInDB.Count() == 0) { Skills newSkill = new Skills(); newSkill.Skill = newSkillName; newSkill.ProfessionID = professionID; dataContext.Skills.InsertOnSubmit(newSkill); dataContext.SubmitChanges(); } } ShowSkills(); }
private void FillProfessionSkillsList() { var dataContext = new ITSkillsDataContext(); /*var allSkills = from s in dataContext.Skills * join e in dataContext.Employees on s.ProfessionID equals e.ProfessionID * where e.Id == this.employeeID * select s.Skill;*/ string profession = professionComboBox.SelectedItem.ToString(); int professionID = dataContext.Professions.SingleOrDefault(p => p.Profession == profession).Id; var allSkills = from s in dataContext.Skills where s.ProfessionID == professionID select s.Skill; var employeeSkills = from s in dataContext.Skills join es in dataContext.EmployeesSkills on s.Id equals es.SkillID where es.EmployeeID == this.employeeID select s.Skill; professionSkillsListBox.Items.Clear(); foreach (string skill in allSkills.Except <string>(employeeSkills)) { professionSkillsListBox.Items.Add(skill); } }
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(); }