private void btnChild_Click(object sender, RoutedEventArgs e) { var tf = this.DataContext as TempFamily; var tc = grdChild.DataContext as TempChild; if (tc == null) { return; } if (radDel.IsChecked == true) { if (MyMessageBox.Show("هل تريد تأكيد الحذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (!tc.ChildID.HasValue || TempChild.DeleteData(tc)) { tf.TempChilds.Remove(tc); dgChild.Items.Refresh(); MyMessage.DeleteMessage(); radAdd.IsChecked = true; } } } else { if (tc.IsValidate()) { if (radAdd.IsChecked == true) { tc.TempFamilyID = tf.ID; if (!tf.ID.HasValue || TempChild.InsertData(tc)) { tf.TempChilds.Add(tc); dgChild.Items.Refresh(); grdChild.DataContext = new TempChild(); Keyboard.Focus(txtChildName); if (tf.ID.HasValue) { MyMessage.InsertMessage(); } } } else { tc.TempFamilyID = tf.ID; if (!tf.ID.HasValue || TempChild.UpdateData(tc)) { dgChild.Items.Refresh(); if (tf.ID.HasValue) { MyMessage.UpdateMessage(); } } } } } }
public static bool InsertData(TempFamily t) { t.Creator = BaseDataBase.CurrentUser.Name; t.ID = BaseDataBase._StoredProcedureReturnable("sp_Add2TempFamily" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@FamilyName", t.FamilyName) , new SqlParameter("@FamilyCode", t.FamilyCode) , new SqlParameter("@ApplyDate", t.ApplyDate) , new SqlParameter("@Notes", t.Notes) , new SqlParameter("@FamilyType", t.FamilyType) , new SqlParameter("@FamilyIdentityID", t.FamilyIdentityID) , new SqlParameter("@FatherFirstName", t.FatherFirstName) , new SqlParameter("@FatherFatherName", t.FatherFatherName) , new SqlParameter("@FatherLastName", t.FatherLastName) , new SqlParameter("@FatherBornPlace", t.FatherBornPlace) , new SqlParameter("@FatherPID", t.FatherPID) , new SqlParameter("@FatherDOB", t.FatherDOB) , new SqlParameter("@MotherFirstName", t.MotherFirstName) , new SqlParameter("@MotherFatherName", t.MotherFatherName) , new SqlParameter("@MotherLastName", t.MotherLastName) , new SqlParameter("@MotherBornPlace", t.MotherBornPlace) , new SqlParameter("@MotherPID", t.MotherPID) , new SqlParameter("@MotherDOB", t.MotherDOB) , new SqlParameter("@Phone", t.Phone) , new SqlParameter("@Mobile1", t.Mobile1) , new SqlParameter("@Mobile2", t.Mobile2) , new SqlParameter("@IsPrinted", t.IsPrinted) , new SqlParameter("@Printer", t.Printer) , new SqlParameter("@HouseSection", t.HouseSection) , new SqlParameter("@HouseStreet", t.HouseStreet) , new SqlParameter("@HouseBuildingNumber", t.HouseBuildingNumber) , new SqlParameter("@HouseFloor", t.HouseFloor) , new SqlParameter("@HouseAddress", t.HouseAddress) , new SqlParameter("@HouseOldAddress", t.HouseOldAddress) , new SqlParameter("@Creator", t.Creator) , new SqlParameter("@IsCancelled", t.IsCancelled) , new SqlParameter("@FamilyPersonCount", t.FamilyPersonCount) , new SqlParameter("@CancelReason", t.CancelReason) , new SqlParameter("@FamilyID", t.FamilyID) ); t.FamilyCode = BaseDataBase._Scalar("select FamilyCode from TempFamily where Id = " + t.ID); foreach (var tc in t.TempChilds) { tc.TempFamilyID = t.ID; TempChild.InsertData(tc); } return(t.ID.HasValue); }