база данных сотруднико it компании

Close(); }privatevoidотделыToolStripMenuItem_Click(object sender, EventArgs e) { Form DepartForm = newDepartForm(); DepartForm.Owner = this;DepartForm.ShowDialog();OutData(); }privatevoidпроектыToolStripMenuItem_Click(object sender, EventArgs e) { Form ProjectForm = newProjectForm(); ProjectForm.Owner = this;ProjectForm.ShowDialog();OutData(); }privatevoidязыкиToolStripMenuItem_Click(object sender, EventArgs e) { Form LanguageForm = newLanguageForm(); LanguageForm.Owner = this;LanguageForm.ShowDialog();OutData(); }privatevoid AddEmployerbtn_Click(object sender, EventArgs e) {idEmployer = 0; Form AddEmployerForm = newAddEmployerForm(); AddEmployerForm.Owner = this;AddEmployerForm.ShowDialog();idEmployer = 0;OutData(); }privatevoid AddEmployerToProjectbtn_Click(object sender, EventArgs e) {idEmployer = tEmployers[EmployersdGV.CurrentRow.Index].Id; Form AddEmployerToProjectForm = newAddEmployerToProjectForm(); AddEmployerToProjectForm.Owner = this;AddEmployerToProjectForm.ShowDialog();OutData(); }privatevoid AddLanguageToEmployerbtn_Click(object sender, EventArgs e) {idEmployer = tEmployers[EmployersdGV.CurrentRow.Index].Id; Form AddLanguageToEmployerForm = newAddLanguageToEmployerForm(); AddLanguageToEmployerForm.Owner = this;AddLanguageToEmployerForm.ShowDialog();OutData(); }privatevoid EmployersdGV_CellClick(object sender, DataGridViewCellEventArgs e) {idEmployer = tEmployers[EmployersdGV.CurrentRow.Index].Id;OutData(); }privatevoid DelEmployerbtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеif (tEmployers.Count > 0) {if (EmployersdGV.CurrentRow.Index >= 0){//убираем все связанные записи из списка сотрудников, занятых на проектахint i = 0;while (i < tProjEmp.Count) { if (tProjEmp[i].IdEmployer == tEmployers[EmployersdGV.CurrentRow.Index].Id){ tProjEmp.RemoveAt(i); } i++; }//убираем все связанные записи из списка языков у сотрудниковi = 0;while (i < tEmpLang.Count) {if (tEmpLang[i].IdEmployer == tEmployers[EmployersdGV.CurrentRow.Index].Id){ tEmpLang.RemoveAt(i); } i++; }//удаляем сотрудника из спискаtEmployers.RemoveAt(EmployersdGV.CurrentRow.Index);idEmployer = 0;OutData(); }else {MessageBox.Show("Выберитесотрудникаизсписка!"); } }else {return; } }privatevoid EditEmployerbtn_Click(object sender, EventArgs e) {idEmployer = EmployersdGV.CurrentRow.Index; Form AddEmployerForm = newAddEmployerForm(); AddEmployerForm.Owner = this;AddEmployerForm.ShowDialog();idEmployer = 0;OutData(); }publicint GetProject(string name) //возврщаетпорядковыйномерпроектавспискепоегоназванию {int i = -1;foreach (ProjectCompany imp in tProjects) {i++;if (imp.NameProject == name) { return i; } }return -1; }publicint GetLanguage(string name) //возврщаетпорядковыйномерязыкавспискепоегоимени {int i = -1;foreach (Language imp in tLanguages) {i++;if (imp.Name == name) {return i; } }return -1; }privatevoid DelEmployerToProjectbtn_Click(object sender, EventArgs e){//удаляет сотрудника из проекта// проверка, есть ли вообще записи в таблицеif (tEmployers.Count > 0) {if (EmployersdGV.CurrentRow.Index >= 0 && ProjectsEmployerdGV.CurrentRow.Index >= 0) {int i = -1;int n = -1;foreach (ProjectEmployers imp in tProjEmp) {i++;if (imp.IdEmployer == tEmployers[EmployersdGV.CurrentRow.Index].Id && ProjectsEmployerdGV.Rows[ProjectsEmployerdGV.CurrentRow.Index].Cells[0].Value.ToString() == GetProject(imp.IdProject)) { n = i;break; } }tProjEmp.RemoveAt(i);idEmployer = 0;OutData(); }else {MessageBox.Show("Выберитесотрудникаипроектизсписков!"); } }else {return; } }privatevoid DelLanguageToEmployerbtn_Click(object sender, EventArgs e){//удаляет язык программирования у сотрудника// проверка, есть ли вообще записи в таблицеif (tEmployers.Count > 0) {if (EmployersdGV.CurrentRow.Index >= 0 && LanguagesToEmployerdGV.CurrentRow.Index >= 0) {int i = -1;int n = -1;foreach (EmployersLanguage imp in tEmpLang) {i++;if (imp.IdEmployer == tEmployers[EmployersdGV.CurrentRow.Index].Id && LanguagesToEmployerdGV.Rows[LanguagesToEmployerdGV.CurrentRow.Index].Cells[0].Value.ToString() == GetLanguage(imp.IdLanguage)) { n = i;break; } }tEmpLang.RemoveAt(i);idEmployer = 0;OutData(); }else {MessageBox.Show("Выберитесотрудникаипроектизсписков!"); } }else {return; } }privatevoidсуммарнаяСтоимостьПроектовToolStripMenuItem_Click(object sender, EventArgs e){//вычисляет суммарную стоимость проектовif (tProjects.Count > 0){int sum = 0;foreach (ProjectCompany imp in tProjects) {sum = sum + imp.Sum; }MessageBox.Show("Суммарнаястоимостьтекущихпроектовравна " + sum.ToString() + " руб.");}else MessageBox.Show("База данных пуста, загрузите данные!");} }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassAddEmployerForm : Form {public Employer tmp;publicint id;publicAddEmployerForm() {InitializeComponent(); }privatevoid Cancelbtn_Click(object sender, EventArgs e) {this.Close(); }privatevoid OKbtn_Click(object sender, EventArgs e) {if (SurnametxtBox.Text != "" && FirstnametxtBox.Text != ""&&LastnametxtBox.Text != "" && BirthdaydateTimePicker.Value<=DateTime.Today&& PassporttxtBox.Text != "" && AdresstxtBox.Text != "" && PhonetxtBox.Text != "" && EmailtxtBox.Text != "" && DepartcomboBox.SelectedIndex>=0) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tEmployers.Count > 0) {id = main.tEmployers[main.tEmployers.Count - 1].Id + 1; }else { id = 1; }if (main.idEmployer != 0) {main.tEmployers[main.idEmployer].Surname= SurnametxtBox.Text;main.tEmployers[main.idEmployer].Firstname= FirstnametxtBox.Text;main.tEmployers[main.idEmployer].Lastname= LastnametxtBox.Text;main.tEmployers[main.idEmployer].Birthday= BirthdaydateTimePicker.Value;main.tEmployers[main.idEmployer].Passport= PassporttxtBox.Text;main.tEmployers[main.idEmployer].Adress= AdresstxtBox.Text;main.tEmployers[main.idEmployer].Phone= PhonetxtBox.Text;main.tEmployers[main.idEmployer].Email= EmailtxtBox.Text;main.tEmployers[main.idEmployer].IdDepart = main.tDeparts[DepartcomboBox.SelectedIndex].Id; }else { Employer tmp = newEmployer(id, SurnametxtBox.Text, FirstnametxtBox.Text, LastnametxtBox.Text, BirthdaydateTimePicker.Value, PassporttxtBox.Text, AdresstxtBox.Text, PhonetxtBox.Text, EmailtxtBox.Text, main.tDeparts[DepartcomboBox.SelectedIndex].Id);main.tEmployers.Add(tmp); } main.idEmployer = 0;this.Close(); } }else { MessageBox.Show("Не все данные заполнены или заполнены некорректно!");return; } }privatevoid AddEmployerForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tDeparts.Count > 0) {foreach (Depart imp in main.tDeparts) {string[] s = imp.GetInfo(); DepartcomboBox.Items.Add(s[1]); } }if (main.idEmployer != 0) { SurnametxtBox.Text = main.tEmployers[main.idEmployer].Surname; FirstnametxtBox.Text = main.tEmployers[main.idEmployer].Firstname; LastnametxtBox.Text = main.tEmployers[main.idEmployer].Lastname; BirthdaydateTimePicker.Value = main.tEmployers[main.idEmployer].Birthday; PassporttxtBox.Text = main.tEmployers[main.idEmployer].Passport; AdresstxtBox.Text = main.tEmployers[main.idEmployer].Adress; PhonetxtBox.Text = main.tEmployers[main.idEmployer].Phone; EmailtxtBox.Text = main.tEmployers[main.idEmployer].Email;int k = -1;string s;if (main.tDeparts.Count > 0) {foreach (Depart imp in main.tDeparts) {k++;if (imp.Id == main.tEmployers[main.idEmployer].IdDepart) { s = imp.NameDepart; DepartcomboBox.SelectedItem = s; } } } } } }privatevoid PassporttxtBox_KeyPress(object sender, KeyPressEventArgs e) {//вводтолькоцифри backspaceif (!Char.IsDigit(e.KeyChar) && e.KeyChar != Convert.ToChar(8)) { e.Handled = true; } }privatevoid PhonetxtBox_KeyPress(object sender, KeyPressEventArgs e) {//вводтолькоцифри backspaceif (!Char.IsDigit(e.KeyChar) && e.KeyChar != Convert.ToChar(8)) { e.Handled = true; } } }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassDepartForm : Form {public Depart tmp;publicint id;publicDepartForm() {InitializeComponent(); }privatevoid OutData() { MainForm main = this.Owner as MainForm;if (main != null) {DepartdGV.Rows.Clear();int k = 0;foreach (Depart imp in main.tDeparts) {DepartdGV.Rows.Add();string[] s = imp.GetInfo(); DepartdGV.Rows[k].Cells[0].Value = s[0]; DepartdGV.Rows[k].Cells[1].Value = s[1];k++; } } }privatevoid Exitbtn_Click(object sender, EventArgs e) {this.Close(); }privatevoid DepartForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {OutData(); } Savebtn.Enabled = false; }privatevoid AddDepartbtn_Click(object sender, EventArgs e) {if (NameDeparttxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tDeparts.Count > 0) {id = main.tDeparts[main.tDeparts.Count - 1].Id + 1; }else { id = 1; } Depart tmp = newDepart(id, NameDeparttxtBox.Text);main.tDeparts.Add(tmp);OutData();} }else { MessageBox.Show("Введите название отдела!");return; } }privatevoid DelDepartbtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (main.tDeparts.Count > 0) {if (DepartdGV.CurrentRow.Index >= 0) {main.tDeparts.RemoveAt(DepartdGV.CurrentRow.Index);OutData(); }else {MessageBox.Show("Выберитеотделизсписка!"); } }else {return; } } }privatevoid Savebtn_Click(object sender, EventArgs e) {if (NameDeparttxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {main.tDeparts[id].NameDepart = NameDeparttxtBox.Text;OutData(); Savebtn.Enabled = false; } }else {MessageBox.Show("Не все данные заполнены!");return; } }privatevoid EditDepartbtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (DepartdGV.CurrentRow.Index >= 0) { NameDeparttxtBox.Text = main.tLanguages[DepartdGV.CurrentRow.Index].Name;id = DepartdGV.CurrentRow.Index; Savebtn.Enabled = true; } } } }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassProjectForm : Form {public ProjectCompany tmp;publicint id;publicProjectForm() {InitializeComponent(); }privatevoid OutData() { MainForm main = this.Owner as MainForm;if (main != null) {ProjectdGV.Rows.Clear();int k = 0;foreach (ProjectCompany imp in main.tProjects) {ProjectdGV.Rows.Add();string[] s = imp.GetInfo(); ProjectdGV.Rows[k].Cells[0].Value = s[0]; ProjectdGV.Rows[k].Cells[1].Value = s[1]; ProjectdGV.Rows[k].Cells[2].Value = s[2];k++; } } }privatevoid Exitbtn_Click(object sender, EventArgs e) {this.Close(); }privatevoid AddProjectbtn_Click(object sender, EventArgs e) {if (NameProjecttxtBox.Text != "" && SumtxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tProjects.Count > 0) {id = main.tProjects[main.tProjects.Count - 1].Id + 1; }else { id = 1; } ProjectCompany tmp = newProjectCompany(id, NameProjecttxtBox.Text, Convert.ToInt32(SumtxtBox.Text));main.tProjects.Add(tmp);OutData();} }else { MessageBox.Show("Не все данные заполнены!");return; } }privatevoid ProjectForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {OutData(); } Savebtn.Enabled = false; }privatevoid SumtxtBox_KeyPress(object sender, KeyPressEventArgs e) {//вводтолькоцифри backspaceif (!Char.IsDigit(e.KeyChar) && e.KeyChar != Convert.ToChar(8)) { e.Handled = true; } }privatevoid DelProjectbtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (main.tProjects.Count > 0){if (ProjectdGV.CurrentRow.Index >= 0) {//убираем все связанные записи из списка сотрудников, занятых на проектахint i = 0;while (i < main.tProjEmp.Count) {if (main.tProjEmp[i].IdProject == main.tProjects[ProjectdGV.CurrentRow.Index].Id) {main.tProjEmp.RemoveAt(i); }i++; }//убираемвыбранныйпроектmain.tProjects.RemoveAt(ProjectdGV.CurrentRow.Index);OutData(); }else { MessageBox.Show("Выберите название проекта из списка!");} }else {return; } } }privatevoid EditProjectbtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (ProjectdGV.CurrentRow.Index >= 0) { NameProjecttxtBox.Text = main.tProjects[ProjectdGV.CurrentRow.Index].NameProject; SumtxtBox.Text = main.tProjects[ProjectdGV.CurrentRow.Index].Sum.ToString();id = ProjectdGV.CurrentRow.Index; Savebtn.Enabled = true; } } }privatevoid Savebtn_Click(object sender, EventArgs e) {if (NameProjecttxtBox.Text != "" && SumtxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {main.tProjects[id].NameProject = NameProjecttxtBox.Text;main.tProjects[id].Sum=Convert.ToInt32(SumtxtBox.Text);OutData(); Savebtn.Enabled = false; } }else {MessageBox.Show("Не все данные заполнены!");return; } } }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassLanguageForm : Form {public Language tmp;publicint id;publicLanguageForm() {InitializeComponent(); }privatevoid OutData() { MainForm main = this.Owner as MainForm;if (main != null) {LanguagedGV.Rows.Clear();int k = 0;foreach (Language imp in main.tLanguages) {LanguagedGV.Rows.Add();string[] s = imp.GetInfo(); LanguagedGV.Rows[k].Cells[0].Value = s[0]; LanguagedGV.Rows[k].Cells[1].Value = s[1];k++; } } }privatevoid AddLanguagebtn_Click(object sender, EventArgs e) {if (NameLanguagetxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tLanguages.Count > 0) {id = main.tLanguages[main.tLanguages.Count - 1].Id + 1; }else { id = 1; } Language tmp = newLanguage(id, NameLanguagetxtBox.Text);main.tLanguages.Add(tmp);OutData();} }else { MessageBox.Show("Введите название отдела!");return; } }privatevoid LanguageForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {OutData(); } Savebtn.Enabled = false; }privatevoid Exitbtn_Click(object sender, EventArgs e) {this.Close(); }privatevoid DelLanguagebtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (main.tLanguages.Count > 0){if (LanguagedGV.CurrentRow.Index >= 0) {//убираем все связанные записи из списка языков у сотрудниковint i = 0;while (i < main.tEmpLang.Count) {if (main.tEmpLang[i].IdLanguage == main.tLanguages[LanguagedGV.CurrentRow.Index].Id) {main.tEmpLang.RemoveAt(i); }i++; }//удаляемвыбранныйязыкmain.tLanguages.RemoveAt(LanguagedGV.CurrentRow.Index);OutData(); }else {MessageBox.Show("Выберитеязыкизсписка!");} }else {return; } } }privatevoid Savebtn_Click(object sender, EventArgs e) {if (NameLanguagetxtBox.Text != "") { MainForm main = this.Owner as MainForm;if (main != null) {main.tLanguages[id].Name = NameLanguagetxtBox.Text;OutData(); Savebtn.Enabled = false; } }else {MessageBox.Show("Не все данные заполнены!");return; } }privatevoid EditLanguagebtn_Click(object sender, EventArgs e){// проверка, есть ли вообще записи в таблицеMainForm main = this.Owner as MainForm;if (main != null) {if (LanguagedGV.CurrentRow.Index >= 0) { NameLanguagetxtBox.Text = main.tLanguages[LanguagedGV.CurrentRow.Index].Name;id = LanguagedGV.CurrentRow.Index; Savebtn.Enabled = true;} } } }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassAddEmployerToProjectForm : Form {public ProjectEmployers tmp;publicint id;publicAddEmployerToProjectForm() {InitializeComponent(); }privatevoid Cancelbtn_Click(object sender, EventArgs e){this.Close(); }privatevoid AddEmployerToProjectForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tProjects.Count > 0) {foreach (ProjectCompany imp in main.tProjects) {string[] s = imp.GetInfo(); ProjectNamecomboBox.Items.Add(s[1]); } }if (main.tEmployers.Count > 0) { FIOtxtBox.Text = main.GetFIO(main.idEmployer); } } }privatevoid AddEmployerToProjectbtn_Click(object sender, EventArgs e) {if (ProjectNamecomboBox.SelectedIndex>=0) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tProjEmp.Count > 0) {id = main.tProjEmp[main.tProjEmp.Count - 1].Id + 1; }else { id = 1; } ProjectEmployers tmp = newProjectEmployers(id, main.tProjects[ProjectNamecomboBox.SelectedIndex].Id, main.idEmployer);main.tProjEmp.Add(tmp);this.Close();} }else { MessageBox.Show("Выберите название проекта!");return; } } }}using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace ITCompanyApp{publicpartialclassAddLanguageToEmployerForm : Form {public EmployersLanguage tmp;publicint id;publicAddLanguageToEmployerForm() {InitializeComponent(); }privatevoid Cancelbtn_Click(object sender, EventArgs e) {this.Close(); }privatevoid AddLanguageToEmployerForm_Load(object sender, EventArgs e) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tLanguages.Count > 0) {foreach (Language imp in main.tLanguages) {string[] s = imp.GetInfo(); LanguagetNamecomboBox.Items.Add(s[1]); } }if (main.tEmployers.Count > 0) { FIOtxtBox.Text = main.GetFIO(main.idEmployer); } } }privatevoid AddEmployerToProjectbtn_Click(object sender, EventArgs e) {if (LanguagetNamecomboBox.SelectedIndex >= 0) { MainForm main = this.Owner as MainForm;if (main != null) {if (main.tEmpLang.Count > 0) {id = main.tEmpLang[main.tEmpLang.Count - 1].Id + 1; }else { id = 1; } EmployersLanguage tmp = newEmployersLanguage(id, main.idEmployer, main.tLanguages[LanguagetNamecomboBox.SelectedIndex].Id);main.tEmpLang.Add(tmp);this.Close();} }else { MessageBox.Show("Выберите название проекта!");return; } } }}