private void save_Click(object sender, RoutedEventArgs e) { if (lstData.SelectedItems.Count <= 0) { MyMessageBox.Show("لم يتم اختيار أي قيمة للتعديل"); return; } if (txtUpdatedValue.Text.Trim() == "") { MyMessageBox.Show("يجب ادخال القيمة الجديدة"); return; } if (MyMessageBox.Show("هل تريد تأكيد تعديل البيانات", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { string query = "Update " + (column == "Job" || column == "HealthStatus" ? "Parent" : "House") + " set " + column + " = '" + txtUpdatedValue.Text.Replace("\'", "").Trim() + "' where " + column + " in ("; foreach (string item in lstData.SelectedItems) { query += "'" + item.Replace("\'", "") + "',"; } query = query.Remove(query.Length - 1) + ")"; MyMessageBox.Show("تم تعديل " + BaseDataBase._NonQuery(query) + " قيمة في قاعدة البيانات"); lstData.ItemsSource = column == "" ? null : BaseDataBase.GetAllStrings("Select Distinct " + column + " from " + (column == "Job" || column == "HealthStatus" ? "Parent" : "House") + " order by " + column); } }
private void Rad1_Checked(object sender, RoutedEventArgs e) { if (radBasePlace.IsChecked == true) { column = "OldAddress"; } else if (radAddress.IsChecked == true) { column = "HouseSection"; } else if (radStreet.IsChecked == true) { column = "HouseStreet"; } else if (radPoint.IsChecked == true) { column = "Address"; } else if (radJob.IsChecked == true) { column = "Job"; } else if (radHealth.IsChecked == true) { column = "HealthStatus"; } else { column = ""; } lstData.ItemsSource = column == "" ? null : BaseDataBase.GetAllStrings("Select Distinct " + column + " from " + (column == "Job" || column == "HealthStatus" ? "Parent" : "House") + " order by " + column); }
public OrphanHealthControl() { InitializeComponent(); cmbo.ItemsSource = BaseDataBase.GetAllStrings("select Distinct HealthSituation from OrphanHealth"); }
public QualificationContainerWindow(Qualification.QualificationPersonType PersonType) { InitializeComponent(); this.PersonType = PersonType; cmbo.ItemsSource = BaseDataBase.GetAllStrings("select Distinct QualificationName from PersonQualification"); }
void UpdateCombo() { cmbo.ItemsSource = BaseDataBase.GetAllStrings("select Distinct NeedType from FamilyNeed order by NeedType"); }
public InventoryItemSta() { InitializeComponent(); cmboItem.ItemsSource = BaseDataBase.GetAllStrings("select Name from Item order by Name"); }
void UpdateCombo() { cmbo.ItemsSource = BaseDataBase.GetAllStrings("select Distinct SupportType from ExternalFamilySupport order by SupportType"); }
void UpdateCombo() { cmbo.ItemsSource = BaseDataBase.GetAllStrings("select Distinct PropertyType from FamilyProperty order by PropertyType"); }