private void b_delete_Click(object sender, EventArgs e)
{
if (idDep > 0)
{
ProfDataSet.DepartmentsDataTable dt = new ProfDataSet.DepartmentsDataTable();
departmentsTableAdapter1.FillByDepChild(dt, idDep);
ProfDataSet.PeopleDepartmentDataTable dtp = new ProfDataSet.PeopleDepartmentDataTable();
peopleDepartmentTableAdapter1.FillByDep(dtp, idDep);
int childDep = dt.Rows.Count;
int countPeople = dtp.Rows.Count;
if (childDep == 0)
{
if (countPeople == 0)
{
departmentsTableAdapter1.DeleteByDep(idDep);
MessageBox.Show("Информация удалена!");
loadDepartmentsGrid();
}
else
{
MessageBox.Show("Вы не можете удалить данное подразделение, т.к. у него есть члены профсоюза!");
}
}
else
{
MessageBox.Show("Вы не можете удалить данное подразделение, т.к. у него есть дочерние подразделения!");
}
}
else
{
MessageBox.Show("Не выбрано подразделение!");
}
}
private void loadPeople(int idDepart)
{
cb_people.Enabled = false;
dgv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Raised;
dgv.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
ProfDataSet.PeopleDepartmentDataTable dt = new ProfDataSet.PeopleDepartmentDataTable();
peopleDepartmentTableAdapter1.FillByDep(dt, idDepart);
DataTable dt_n = new DataTable();
dt_n.Columns.Add("id", typeof(int));
dt_n.Columns.Add("fio", typeof(string));
foreach (DataRow dr in dt.Rows)
{
DataRow dr_n = dt_n.NewRow();
dr_n["id"] = dr["pid"];
dr_n["fio"] = $"{decryptoStr(dr["famil"].ToString())} {decryptoStr(dr["name"].ToString())} {decryptoStr(dr["otch"].ToString())}";
dt_n.Rows.Add(dr_n);
}
cb_people.DataSource = dt_n;
cb_people.DisplayMember = "fio";
cb_people.ValueMember = "id";
cb_people.Enabled = true;
}
private void b_search_Click(object sender, EventArgs e)
{
ProfDataSet.PeopleDataTable dtPeople = new ProfDataSet.PeopleDataTable();
peopleTableAdapter1.Fill(dtPeople);
dgv.Rows.Clear();
if (dtPeople.Rows.Count != 0)
{
int i = 0;
foreach (DataRow pers in dtPeople.Rows)
{
if (decryptoStr(pers["famil"].ToString()).ToLower().StartsWith(tb_search.Text.Trim().ToLower()))
{
ProfDataSet.PeopleDepartmentDataTable dtDep = new ProfDataSet.PeopleDepartmentDataTable();
peopleDepartmentTableAdapter1.FillByPers(dtDep, (int)pers["id"]);
if (!dtDep.Rows[0].IsNull("idDepartment"))
{
dgv.Rows.Add();
ProfDataSet.PeopleWorkDataTable dtWork = new ProfDataSet.PeopleWorkDataTable();
peopleWorkTableAdapter1.FillByPeopleId(dtWork, (int)pers["id"]);
DataRow dr = dtWork.FirstOrDefault(p => p.isActual == "T" && p.isWorked == "T");
string workPlace = "";
string doljn = "";
if (dr != null)
{
workPlace = dr["workPlace"].ToString();
doljn = dr["doljn"].ToString();
}
dgv[0, i].Value = (int)pers["id"];
dgv[1, i].Value = decryptoStr(pers["famil"].ToString()) + " " + decryptoStr(pers["name"].ToString()) + " " + decryptoStr(pers["otch"].ToString());
dgv[2, i].Value = workPlace;
dgv[3, i].Value = doljn;
i++;
}
}
}
if (i == 0)
{
b_move.Visible = false;
MessageBox.Show("Не найден!");
}
else
{
b_move.Visible = true;
}
}
}
