// Удалить записи о ребенке
public static void RemoveChild(int ChildID)
{
List <int> Parents = DBOperations.GetParentsByChild(ChildID);
DBOperations.RemoveChild(ChildID);
foreach (int Parent in Parents)
{
if (!DBOperations.ChildrenLeft(Parent))
{
DBOperations.RemoveParent(Parent);
}
}
}
// Загрузить информацию о детях, занимающихся в указанной группе, и их родителях
public static void LoadChildren(string GroupName, DataGridView Info)
{
List <int> ChildrenID = DBOperations.GetChildrenIDFromGroup(GroupName);
for (int i = 0; i < ChildrenID.Count; i++)
{
object[] ChildInfo = DBOperations.ReadChildInfo(ChildrenID[i]);
Info.Rows.Add();
Info.Rows[i].Cells[0].Value = ChildInfo[0];
Info.Rows[i].Cells[1].Value = ChildInfo[1];
Info.Rows[i].Cells[2].Value = ChildInfo[2];
Info.Rows[i].Cells[3].Value = ChildInfo[3];
Info.Rows[i].Cells[4].Value = (int)ChildInfo[4] == 1;
List <int> Parents = DBOperations.GetParentsByChild(ChildrenID[i]);
for (int j = 0; j < 2; j++)
{
object[] ParentInfo = DBOperations.ReadParentInfo(Parents[j]);
Info.Rows[i].Cells[5 + j * 3].Value = ParentInfo[0];
Info.Rows[i].Cells[6 + j * 3].Value = ParentInfo[1];
Info.Rows[i].Cells[7 + j * 3].Value = ParentInfo[2];
}
}
}
