private void btnSaveCity_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.Con);
Linq.DbDataContext subDb = new Linq.DbDataContext(flag.SubCon);
Linq.City city = new Linq.City();
Linq.City subcity = new Linq.City();
if (!isnew)
{
if (dgvCity.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
city = Db.Cities.SingleOrDefault(item => item.Exist == true && item.ID_City == Convert.ToInt32(DtCity.Rows[dgvCity.SelectedIndex].ItemArray[0]) && item.Brunsh == Properties.Settings.Default.Brunch);
subcity = subDb.Cities.SingleOrDefault(item => item.Exist == true && item.CityName == Convert.ToString(DtCity.Rows[dgvCity.SelectedIndex].ItemArray[1]) && item.Brunsh == Properties.Settings.Default.Brunch);
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
city.CityName = subcity.CityName = txtCity.Text;
city.PriceMen = subcity.PriceMen = Convert.ToDecimal(txtPriceMen.Text);
city.ID_Province = subcity.ID_Province = Convert.ToInt32(Dt.Rows[cmbProvince.SelectedIndex].ItemArray[0]);
city.Days = subcity.Days = txtDays.Text;
city.Exist = subcity.Exist = true;
city.Brunsh = subcity.Brunsh = Properties.Settings.Default.Brunch;
city.ProvinceName = subcity.ProvinceName = cmbProvince.Text;
if (isnew)
{
Db.Cities.InsertOnSubmit(city);
subDb.Cities.InsertOnSubmit(subcity);
}
Db.SubmitChanges();
subDb.SubmitChanges();
if (isnew)
{
MessageBox.Show("تم الحفظ");
}
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDeleteCity_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.SubCon);
Linq.City subcity = Db.Cities.SingleOrDefault(item => item.Exist == true && item.CityName == Convert.ToString(DtCity.Rows[dgvCity.SelectedIndex].ItemArray[1]) && item.Brunsh == Properties.Settings.Default.Brunch);
subcity.Exist = false;
Db.SubmitChanges();
flag.Dellete("Cities", "ID_City", DtCity, dgvCity);
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
