private void saveSpouse() { var listChildren = new List <Children>(); if ((childrenBindingSource != null) && (childrenDataGridView != null)) { foreach (Children item in childrenBindingSource) { var c = new Children { ChildrenNo = item.ChildrenNo, ChildrenLastName = item.ChildrenLastName, ChildrenFirstName = item.ChildrenFirstName, ChildrenMiddleName = item.ChildrenMiddleName, ChildrenBirthDate = item.ChildrenBirthDate, SpouseNo = item.SpouseNo }; listChildren.Add(c); } } if (spousBindingSource != null) { Validate(); ((Spous)spousBindingSource.Current).PersonnelNo = PersonnelNo; spousBindingSource.EndEdit(); var iResult = SpouseManagement.Save((Spous)spousBindingSource.Current); if (iResult > 0) { var iCount = 0; foreach (var item in listChildren) { var c = new Children { ChildrenNo = item.ChildrenNo, ChildrenLastName = item.ChildrenLastName, ChildrenFirstName = item.ChildrenFirstName, ChildrenMiddleName = item.ChildrenMiddleName, ChildrenBirthDate = item.ChildrenBirthDate, modifieddate = DateTime.Now, SpouseNo = iResult }; if (ChildrenManagement.Save(c) > 0) { iCount += 1; } } if (listChildren.Count == iCount) { MessageBox.Show(@"Record was successfully saved.", @"Save", MessageBoxButtons.OK, MessageBoxIcon.Information); spouseSurNameTextBox.Focus(); } else { MessageBox.Show(@"There was problem on the children record on saving.", @"Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show(@"Error occurred in saving.", @"Save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }