private void btnUpdate_Click(object sender, RoutedEventArgs e) { if (!BaseDataBase.CurrentUser.CanUpdateFamily) { MyMessageBox.Show("ليس لديك صلاحية تعديل بيانات عائلة"); return; } MoveFocus(new TraversalRequest(FocusNavigationDirection.Next)); var f = cFamily.DataContext as Family; if (f.IsValidate()) { if (!(string.IsNullOrEmpty(f.FamilyFather.FirstName) && string.IsNullOrEmpty(f.FamilyFather.LastName))) { if (!f.FamilyFather.IsValidate()) { return; } } if (!(string.IsNullOrEmpty(f.FamilyMother.FirstName) && string.IsNullOrEmpty(f.FamilyMother.LastName))) { if (!f.FamilyMother.IsValidate()) { return; } } if (!string.IsNullOrEmpty(f.FamilyHouse.OldAddress) || !string.IsNullOrEmpty(f.FamilyHouse.Address)) { if (!f.FamilyHouse.IsValidate()) { return; } } foreach (var fp in cFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (!fp.IsValidate()) { return; } } if (DBMain.UpdateData(f)) { if (!(string.IsNullOrEmpty(f.FamilyFather.FirstName) && string.IsNullOrEmpty(f.FamilyFather.LastName))) { if (f.FamilyFather.ParentrID.HasValue) { DBMain.UpdateData(f.FamilyFather); } else { DBMain.InsertData(f.FamilyFather); } } else if (f.FamilyFather.ParentrID.HasValue) { DBMain.DeleteData(f.FamilyFather); } if (!(string.IsNullOrEmpty(f.FamilyMother.FirstName) && string.IsNullOrEmpty(f.FamilyMother.LastName))) { if (f.FamilyMother.ParentrID.HasValue) { DBMain.UpdateData(f.FamilyMother); } else { DBMain.InsertData(f.FamilyMother); } } else if (f.FamilyMother.ParentrID.HasValue) { DBMain.DeleteData(f.FamilyMother); } f.FamilyHouse.FamilyID = f.FamilyID; if (!string.IsNullOrEmpty(f.FamilyHouse.OldAddress) || !string.IsNullOrEmpty(f.FamilyHouse.HouseSection)) { if (f.FamilyHouse.HouseID == null) { DBMain.InsertData(f.FamilyHouse); } else { DBMain.UpdateData(f.FamilyHouse); } } foreach (var fp in cFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (!fp.FamilyPersonID.HasValue) { fp.FamilyID = f.FamilyID; DBMain.InsertData(fp); } else { DBMain.UpdateData(fp); } } f.UpdateFamilyPersonCount(); MyMessage.UpdateMessage(); } } }
private void btnExecute_Click(object sender, RoutedEventArgs e) { MoveFocus(new TraversalRequest(FocusNavigationDirection.Next)); var f = cFamily.DataContext as Family; if (f.IsValidate()) { if (!(string.IsNullOrEmpty(f.FamilyFather.FirstName) && string.IsNullOrEmpty(f.FamilyFather.LastName))) { if (!f.FamilyFather.IsValidate()) { return; } } if (!(string.IsNullOrEmpty(f.FamilyMother.FirstName) && string.IsNullOrEmpty(f.FamilyMother.LastName))) { if (!f.FamilyMother.IsValidate()) { return; } } if (!string.IsNullOrEmpty(f.FamilyHouse.OldAddress) || !string.IsNullOrEmpty(f.FamilyHouse.Address)) { if (!f.FamilyHouse.IsValidate()) { return; } } foreach (var fp in cFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (!fp.IsValidate()) { return; } } string a = (cFamily.cmboSector.SelectedItem as Sector).Code; string s = a + BaseDataBase._Scalar_StoredProcedure("sp_GetMaxFamilyCodeByChar", new SqlParameter("@char", a)); f.FamilyCode = s; if (DBMain.InsertData(f)) { var tih = this.Parent as TabItem; if (tih != null) { tih.Header = f.FamilyCode + " " + f.FamilyName; } if (tf != null) { tf.FamilyID = f.FamilyID; TempFamily.UpadteData(tf); } if (!(string.IsNullOrEmpty(f.FamilyFather.FirstName) && string.IsNullOrEmpty(f.FamilyFather.LastName))) { DBMain.InsertData(f.FamilyFather); } if (!(string.IsNullOrEmpty(f.FamilyMother.FirstName) && string.IsNullOrEmpty(f.FamilyMother.LastName))) { DBMain.InsertData(f.FamilyMother); } f.FamilyHouse.FamilyID = f.FamilyID; if (!string.IsNullOrEmpty(f.FamilyHouse.OldAddress) || !string.IsNullOrEmpty(f.FamilyHouse.HouseSection)) { DBMain.InsertData(f.FamilyHouse); } foreach (var fp in cFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (f.FamilyID.HasValue && !fp.FamilyPersonID.HasValue) { fp.FamilyID = f.FamilyID; DBMain.InsertData(fp); } } btnUpdate.Visibility = System.Windows.Visibility.Visible; btnExecute.Visibility = System.Windows.Visibility.Collapsed; cFamilyNeed.FamilyID = f.FamilyID; cExternalFamilySupport.FamilyID = f.FamilyID; cSpecialCard.FamilyID = f.FamilyID; cListerGroup.FamilyID = f.FamilyID; cAdminEvaluation.FamilyID = f.FamilyID; cOrders.FamilyID = f.FamilyID; f.UpdateFamilyPersonCount(); EnableTabs(); MyMessage.InsertMessage(); } } }