private void dgCual_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (dgCual.SelectedIndex != -1) { Linq.Caule caul = (Linq.Caule)dgCual.SelectedItem; CaulID = caul.ID_Caule; txtNameCual.IsEnabled = true; txtPhoneCual.IsEnabled = true; btnSaveCual.IsEnabled = false; btnNewCual.IsEnabled = true; btnEditCual.IsEnabled = true; btnDeletCual.IsEnabled = true; txtNameCual.Text = caul.CauleName; txtPhoneCual.Text = caul.Phone.ToString(); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnEditCual_Click(object sender, RoutedEventArgs e) { try { if (CaulID != 0) { if (MessageBox.Show("هل تريد تعديل العنصر المحدد؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Caule caul = PharmaLinq.Caules.Single(item => item.Exist == true && item.ID_Caule == CaulID); txtPhoneCual.Focus(); txtPhoneCual.SelectAll(); try { if (txtPhoneCual.Text == "") { } else { caul.Phone = Convert.ToInt32(txtPhoneCual.Text); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show("يجب ملء هذا العنصر برقم صحيح"); return; } caul.CauleName = txtNameCual.Text; caul.Exist = true; MessageBox.Show("تم التعديل"); PharmaLinq.SubmitChanges(); flag.Fill_DataGrid(dgCual, PharmaLinq.Caules.Where(item => item.Exist == true)); ReInitialize(); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnSaveCual_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Caule caul = new Linq.Caule(); txtPhoneCual.Focus(); txtPhoneCual.SelectAll(); try { if (txtPhoneCual.Text == "") { } else { caul.Phone = Convert.ToInt32(txtPhoneCual.Text); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show("يجب ملء هذا العنصر برقم صحيح"); return; } caul.CauleName = txtNameCual.Text; caul.Exist = true; PharmaLinq.Caules.InsertOnSubmit(caul); PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحفظ"); flag.Fill_DataGrid(dgCual, PharmaLinq.Caules.Where(item => item.Exist == true)); ReInitialize(); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnDeletCual_Click(object sender, RoutedEventArgs e) { try { if (dgCual.SelectedIndex == 0) { MessageBox.Show("لايمكن حذف هذا العنصر"); return; } if (CaulID != 0) { if (MessageBox.Show("هل تريد حذف العنصر المحدد؟", "حذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Caule caul = PharmaLinq.Caules.Single(item => item.Exist == true && item.ID_Caule == CaulID); caul.Exist = false; PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحذف"); flag.Fill_DataGrid(dgCual, PharmaLinq.Caules.Where(item => item.Exist == true)); txtNameCual.Clear(); txtPhoneCual.Clear(); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }