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);
}
}
