private void btnEdit_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.Con);
Linq.Order order = new Linq.Order();
for (int i = 0; i < Dt.Rows.Count; i++)
{
order = Db.Orders.SingleOrDefault(item => item.Exist == true & item.Barcode == Dt.Rows[i].ItemArray[0].ToString());
if (cmbState.Text != string.Empty)
{
order.State = cmbState.Text;
}
if (txtDelegate.Text != string.Empty)
{
order.Delegate = txtDelegate.Text;
}
order.DateState = (DateTime)txtDate.SelectedDate;
}
Db.SubmitChanges();
Movement.frm.grdEdit.Children.Clear();
MessageBox.Show("تم التعديل");
Movement usc = new Movement();
MainWindow.GetMainForm.grdUSC.Children.Clear();
MainWindow.GetMainForm.grdUSC.Children.Add(usc);
this.Visibility = Visibility.Collapsed;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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 btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.SubCon);
Linq.Delegate @delegate = new Linq.Delegate();
if (!isnew)
{
if (dgvDelegate.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
@delegate = Db.Delegates.SingleOrDefault(item => item.Exist == true && item.ID_Delegate == Convert.ToInt32(Dt.Rows[dgvDelegate.SelectedIndex].ItemArray[0]));
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
@delegate.Name = txtName.Text;
@delegate.Phone1 = txtPhone1.Text;
@delegate.Phone2 = txtPhone2.Text;
if (txtSalary.Text != string.Empty)
{
@delegate.Salary = Convert.ToDecimal(txtSalary.Text);
}
else
{
@delegate.Salary = Convert.ToDecimal(0);
}
@delegate.Note = txtNote.Text;
@delegate.Exist = true;
if (isnew)
{
Db.Delegates.InsertOnSubmit(@delegate);
}
Db.SubmitChanges();
if (isnew)
{
MessageBox.Show("تم الحفظ");
}
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.SubCon);
Linq.User users = new Linq.User();
if (!isnew)
{
if (dgvUsers.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
users = Db.Users.SingleOrDefault(item => item.Exist == true && item.ID_User == Convert.ToInt32(Dt.Rows[dgvUsers.SelectedIndex].ItemArray[0]));
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
users.Name = txt_Name.Text;
users.pass = txt_pass.Text;
users.OrderPrm = cbxOrder.IsChecked;
users.MovementPrm = cbxMovement.IsChecked;
users.CitieAndProvincePrm = cbxCitieAndProvince.IsChecked;
users.DelegatePrm = cbxDelegate.IsChecked;
users.CustomerPrm = cbxCustomer.IsChecked;
users.AddMovementNewPrm = cbxAddMovementNewPrm.IsChecked;
users.BtnDelete = cbxBtnDelete.IsChecked;
users.UsersPrm = cbxUsers.IsChecked;
users.SittingsPrm = cbxSettings.IsChecked;
users.Exist = true;
if (isnew)
{
Db.Users.InsertOnSubmit(users);
}
Db.SubmitChanges();
if (isnew)
{
MessageBox.Show("تم الحفظ");
}
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(Connection);
Linq.AspNetUser customer = new Linq.AspNetUser();
Linq.DbDataContext CodeDb = new Linq.DbDataContext(flag.SubCon);
Linq.Code code = CodeDb.Codes.FirstOrDefault();
if (!isnew)
{
if (dgvCustomer.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
customer = Db.AspNetUsers.SingleOrDefault(item => item.Exist == true && item.Id == Convert.ToString(Dt.Rows[dgvCustomer.SelectedIndex].ItemArray[0]));
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
customer.Name = txtName.Text;
customer.Code = txtCode.Text;
customer.Phone1 = txtPhone1.Text;
customer.Phone2 = txtPhone2.Text;
customer.Address = txtAddress.Text;
//customer.Note = txtNote.Text;
customer.Exist = true;
if (isnew)
{
Db.AspNetUsers.InsertOnSubmit(customer);
code.CustomerCode = customer.Code;
}
Db.SubmitChanges();
CodeDb.SubmitChanges();
if (isnew)
{
MessageBox.Show("تم الحفظ");
}
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
Db = new Linq.DbDataContext(flag.Con);
Linq.Province province = new Linq.Province();
if (!isnew)
{
if (dgvProvince.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
province = Db.Provinces.SingleOrDefault(item => item.Exist == true && item.ID_Province == Convert.ToInt32(Dt.Rows[dgvProvince.SelectedIndex].ItemArray[0]));
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
province.ProvinceName = txtProvince.Text;
province.Exist = true;
if (isnew)
{
Db.Provinces.InsertOnSubmit(province);
}
Db.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);
}
}
private void cmbProvince_PreviewTextInput(object sender, TextCompositionEventArgs e)
{
try
{
cmbProvince.IsDropDownOpen = true;
Db = new Linq.DbDataContext();
//cmbProvince.Items.Clear();
Dtsearch = flag.Fill_DataGrid_join("SELECT ProvinceName FROM [dbo].[Cities] inner join Provinces on Provinces.ID_Province = Cities.ID_Province where Cities.Exist = 'true'and ProvinceName like '%'+ '" + cmbProvince.Text + "' +'%'");
string[] st = new string[Dtsearch.Rows.Count];
//Dtsearch.Rows.CopyTo(st,0);
Dtsearch.Columns.CopyTo(st, 0);
cmbProvince.ItemsSource = st;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
string note = txtNote.Text;
if (MainWindow.frm.offline)
{
Db = new Linq.DbDataContext(flag.SubCon);
note += " لم يتم الرفع";
}
else
{
Db = new Linq.DbDataContext(flag.Con);
}
Linq.Order order = new Linq.Order();
Linq.DbDataContext CodeDb = new Linq.DbDataContext(flag.SubCon);
Linq.Code code = CodeDb.Codes.FirstOrDefault();
if (!isnew)
{
if (dgvOrder.SelectedIndex != -1)
{
if (MessageBox.Show("هل تريد حفظ التعديلات؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
order = Db.Orders.SingleOrDefault(item => item.Exist == true && item.ID_Order == Convert.ToInt32(Dt.Rows[dgvOrder.SelectedIndex].ItemArray[0]));
}
else
{
MessageBox.Show("الرجاء اختيار عنصر من القائمة");
return;
}
}
order.Barcode = txtBarcode.Text;
order.Customer = txtCustomer.Text;
order.CustomerPhone = txtCustomerPhone.Text;
order.Recipient = txtRecipient.Text;
order.RecipientPhone1 = txtRecipientPhone1.Text;
order.RecipientPhone2 = txtRecipientPhone2.Text;
order.Address = txtAddress.Text;
order.City = txtCity.Text;
order.PackagePrice = Convert.ToDecimal(txtPackagePrice.Text);
order.PackageNumber = Convert.ToInt32(txtPackageNumber.Text);
order.DeliveryPrice = Convert.ToDecimal(txtDeliveryPrice.Text);
order.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text);
order.Delegate = txtDelegate.Text;
order.State = cmbState.Text;
order.Date = Convert.ToDateTime(txtDate.Text);
order.DateState = Convert.ToDateTime(txtDate.Text);
order.Note = note;
order.Exist = true;
order.User = MainWindow.frm.user;
if (selectindx == true)
{
order.Province = provine;
selectindx = false;
}
if (isnew)
{
Db.Orders.InsertOnSubmit(order);
code.Barcode = order.Barcode;
}
Db.SubmitChanges();
CodeDb.SubmitChanges();
if (isnew)
{
MessageBox.Show("تم الحفظ");
}
usc_Initialize();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
