internal bool IsValidate() { bool isValid = true; this.ClearAllErrors(); if (string.IsNullOrEmpty(FamilyCode)) { isValid = false; this.SetError("FamilyCode", "يجب إدخال رمز للعائلة"); } else { if (BaseDataBase._StoredProcedureReturnableBool("sp_IsFamilyCodeExists", new SqlParameter("@R", System.Data.SqlDbType.Bit), new SqlParameter("@FamilyID", FamilyID), new SqlParameter("@FamilyCode", FamilyCode))) { isValid = false; this.SetError("FamilyCode", "رمز العائلة موجود في قاعدة البيانات"); } } if (string.IsNullOrEmpty(FamilyIdentityID)) { isValid = false; this.SetError("FamilyIdentityID", "يجب إدخال رقم دفتر العائلة"); } else if (FamilyIdentityID != "لايوجد دفتر عائلة") { var num = FamilyIdentityID.Split(' '); if (!BaseDataBase.IsStringNumber(num[0])) { isValid = false; this.SetError("FamilyIdentityID", "رقم دفتر العائلة يجب أن يحوي أرقاما"); } if (num.Length > 3) { isValid = false; this.SetError("FamilyIdentityID", "رقم دفتر العائلة يحوي أكثر من فراغين"); } else if (num.Length > 1) { if (num[1].Length != 1) { isValid = false; this.SetError("FamilyIdentityID", "حرف دفتر العائلة يجب أن يكون خانة واحدة"); } else if (!char.IsLetter(char.Parse(num[1]))) { isValid = false; this.SetError("FamilyIdentityID", "حرف دفتر العائلة يجب أن يحوي حرف واحد فقط (أ، ب، ت، ث، ج)"); } if (num.Length == 3 && !BaseDataBase.IsStringNumber(num[2])) { isValid = false; this.SetError("FamilyIdentityID", "الرقم الأسري يجب أن يحوي أرقاما"); } } if (isValid) { string ExistedFamilyCode = BaseDataBase._Scalar_StoredProcedure("sp_GetFamilyCodeByFamilyIDentityID", new SqlParameter("@FamilyID", FamilyID), new SqlParameter("@FamilyIdentityID", FamilyIdentityID)); if (!string.IsNullOrEmpty(ExistedFamilyCode)) { isValid = false; this.SetError("FamilyIdentityID", "رقم دفتر العائلة موجود في قاعدة البيانات برقم " + ExistedFamilyCode); } } } if (string.IsNullOrEmpty(FamilyName)) { isValid = false; this.SetError("FamilyName", "يجب إدخال اسم العائلة"); } if (ApplyDate == null) { isValid = false; this.SetError("ApplyDate", "يجب إدخال تاريخ التسجيل"); } if (string.IsNullOrEmpty(FamilyType)) { isValid = false; this.SetError("FamilyType", "يجب إدخال نوع العائلة"); } if (!isValid) { string s = ""; foreach (var item in errors) { s += item.Value + "\n"; } MyMessageBox.Show(s); } return(isValid); }
private void btnSave_Click(object sender, RoutedEventArgs e) { MoveFocus(new TraversalRequest(FocusNavigationDirection.Next)); var f = cOrphanFamily.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.OrphanGuardian.FirstName) && string.IsNullOrEmpty(f.OrphanGuardian.LastName))) { if (!f.OrphanGuardian.IsValidate()) { return; } } if (!(string.IsNullOrEmpty(f.OrphanNursemaid.FirstName) && string.IsNullOrEmpty(f.OrphanNursemaid.LastName))) { if (!f.OrphanNursemaid.IsValidate()) { return; } } if (!string.IsNullOrEmpty(f.FamilyHouse.OldAddress) || !string.IsNullOrEmpty(f.FamilyHouse.Address)) { if (!f.FamilyHouse.IsValidate()) { return; } } foreach (var fp in cOrphanFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (!fp.IsValidate()) { return; } } if (cOrphanFamily.Orphans == null || cOrphanFamily.Orphans.Count == 0) { MyMessageBox.Show("يجب ادخال بيانات الايتام"); return; } if (!f.FamilyID.HasValue) { string a = (cOrphanFamily.cmboSector.SelectedItem as Sector).Code; string s = a + BaseDataBase._Scalar_StoredProcedure("sp_GetMaxFamilyCodeByChar", new SqlParameter("@char", a)); f.FamilyCode = s; if (!DBMain.InsertData(f)) { return; } else { MyMessage.InsertMessage(); var tih = this.Parent as TabItem; if (tih != null) { tih.Header = f.FamilyCode + " " + f.FamilyName; } } } else if (!DBMain.UpdateData(f)) { return; } else { MyMessage.UpdateMessage(); } //Father 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); } //Mother 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); } //Guardian if (!(string.IsNullOrEmpty(f.OrphanGuardian.FirstName) && string.IsNullOrEmpty(f.OrphanGuardian.LastName))) { f.OrphanGuardian.FamilyID = f.FamilyID; if (f.OrphanGuardian.GuardianID.HasValue) { Guardian.UpdateData(f.OrphanGuardian); } else { Guardian.InsertData(f.OrphanGuardian); } } else if (f.OrphanGuardian.GuardianID.HasValue) { Guardian.DeleteData(f.OrphanGuardian); } //Nursemaid if (!(string.IsNullOrEmpty(f.OrphanNursemaid.FirstName) && string.IsNullOrEmpty(f.OrphanNursemaid.LastName))) { f.OrphanNursemaid.FamilyID = f.FamilyID; if (f.OrphanNursemaid.GuardianID.HasValue) { Guardian.UpdateData(f.OrphanNursemaid); } else { Guardian.InsertData(f.OrphanNursemaid); } } else if (f.OrphanNursemaid.GuardianID.HasValue) { Guardian.DeleteData(f.OrphanNursemaid); } 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 cOrphanFamily.dgChild.ItemsSource as List <FamilyPerson> ) { if (fp.FamilyPersonID.HasValue) { DBMain.UpdateData(fp); } else if (f.FamilyID.HasValue) { fp.FamilyID = f.FamilyID; DBMain.InsertData(fp); } } foreach (var o in cOrphanFamily.Orphans) { if (o.OrphanID.HasValue) { Orphan.UpdateData(o); } else if (f.FamilyID.HasValue) { if (Orphan.InsertData(o)) { o.Account = new Account(); o.Account.Name = o.FirstName + " " + o.LastName; o.Account.Type = o.Type == "يتيم" ? Account.AccountType.Orphan : o.Type == "يتيم طالب علم" ? Account.AccountType.OrphanStudent : Account.AccountType.Student; o.Account.CurrentBalance = 0; o.Account.CreateDate = BaseDataBase.DateNow; o.Account.OwnerID = o.OrphanID; o.Account.Status = "مفعل"; o.Account.IsDebit = true; Account.InsertData(o.Account); } } } cFamilyNeed.FamilyID = f.FamilyID; cExternalFamilySupport.FamilyID = f.FamilyID; cSpecialCard.FamilyID = f.FamilyID; cListerGroup.FamilyID = f.FamilyID; cOrders.FamilyID = f.FamilyID; f.UpdateFamilyPersonCount(); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { var order = this.DataContext as Order; if (order.IsValidateMainOrderData() && order.IsValidateOrderItemsData()) { try { // foreach (var item in x.FamilyNeeds) // if (!item.IsEnsured) // if (MyMessageBox.Show("لم يتم تأمين كامل احتياجات العائلة .. هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes) // return; // break; if (!order.Id.HasValue) { //check if there is any other order from other device int CurrentMaxOrderID_temp = 0; if (order.FamilyID.HasValue) { int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where FamilyID=" + order.FamilyID), out CurrentMaxOrderID_temp); } else { int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where SpecialFamilyID=" + order.SpecialFamilyID), out CurrentMaxOrderID_temp); } if (CurrentMaxOrderID_temp != 0 && CurrentMaxOrderID_temp != CurrentMaxOrderID) { MyMessageBox.Show("لقد تمت اضافة اعانة جديدة من جهاز اخر\nبجب اغلاق النافذة وتحديث البيانات للتحقق\nلايمكن الاضافة"); return; } if (Properties.Settings.Default.ActiveFingerPrint && o == null && MyMessageBox.Show("لم يتم اضافة البصمة الالكترونية هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes) { return; } if (Order.InsertData(order)) { SendFingerPrint(order); } } else if (Order.UpdateData(order)) { MyMessage.UpdateMessage(); } Task.Run(() => InsertOrderItems(order)); //PrintOrder(order); DialogResult = true; } catch (Exception ex) { MyMessageBox.Show(ex.Message); } } }
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(); } } }