private async void BtnAdd_Click(object sender, RoutedEventArgs e) { if (!CheckEmpty()) { return; } var havalehId = 0; #region AddHavaleh try { var addHavaleh = new DHavaleh { DFactoryId = ((tblFactory)CboFactory.SelectedItem).Id, DCountyId = ((tblCounty)CboCounty.SelectedItem).Id, DBuyerId = ((tblBuyer)CboBuyer.SelectedItem).Id, DDriverId = ((tblDriver)CboDriver.SelectedItem).Id, DVehicleTypeId = ((tblVehicleType)CboVehicle.SelectedItem).Id, DDate = TxtDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtDate.Text), DNumber = TxtNumber.Text.Trim() == string.Empty ? null : TxtNumber.Text, DHavlehNumber = TxtHavlehNumber.Text.Trim() == string.Empty ? null : TxtHavlehNumber.Text, DHavlehDate = TxtHavlehDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtHavlehDate.Text), DHavalehEndDate = TxtHavalehEndDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtHavalehEndDate.Text) }; havalehId = Convert.ToInt32(await addHavaleh.Add()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در ثبت اطلاعات\n" + exception.Message); } foreach (var t in _createProduct) { try { var addSelectProduct = new DSelectProduct { DHavalehId = havalehId, DProductId = t.ProductId, DCapacityId = t.CapacityId, DCapacityNumber = t.Num }; await Task.Run(() => addSelectProduct.Add()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در ثبت اطلاعات\n" + exception.Message); } } Window_Loaded(null, null); Utility.Message("پیام", "اطلاعات با موفقیت ثبت گردید", "Correct.png"); #endregion }
private async void BtnDelete_Click(object sender, RoutedEventArgs e) { if (!CheckSelectDelete()) { return; } var selectItem = _havalehSearchData[DgdHavaleh.SelectedIndex]; Utility.MyMessageBox("هشدار", "آیا از حذف اطمینان دارید؟ ", "Warning.png", false); if (!Utility.YesNo) { return; } try { var deleteHavaleh = new DHavaleh { DId = selectItem.Id }; await Task.Run(() => deleteHavaleh.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); return; } try { var deleteSelectProduct = new DSelectProduct { DHavalehId = selectItem.Id }; await Task.Run(() => deleteSelectProduct.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); return; } Window_Loaded(null, null); Utility.Message("پیام", "اطلاعات با موفقیت حذف گردید", "Correct.png"); }
private async void DgdDoctor_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (DgdHavaleh.SelectedIndex == -1) { return; } BtnAdd.IsEnabled = false; DgdProduct.ItemsSource = null; _createProduct = null; _s1 = null; _s2 = null; _s3 = null; _s4 = null; _s5 = null; _createProduct = new List <CreateProduct>(); _s1 = new List <byte>(); _s2 = new List <byte>(); _s3 = new List <byte>(); _s4 = new List <string>(); _s5 = new List <string>(); var selectItem = _havalehSearchData[DgdHavaleh.SelectedIndex]; CboFactory.SelectedValue = selectItem.Factory_Id; CboProvince.SelectedValue = selectItem.Province_Id; CboCounty.SelectedValue = selectItem.County_Id; CboBuyer.SelectedValue = selectItem.Buyer_Id; CboDriver.SelectedValue = selectItem.Driver_Id; CboVehicle.SelectedValue = selectItem.VehicleType_Id; TxtNumber.Text = selectItem.Number; TxtDate.Text = selectItem.Date; TxtHavlehNumber.Text = selectItem.HavlehNumber; TxtHavlehDate.Text = selectItem.HavlehDate; TxtHavalehEndDate.Text = selectItem.HavalehEndDate; LblMobile.Content = selectItem.DriverMobile; LblPelak.Content = selectItem.NumberPlates; var selectProductData = await Task.Run(() => DSelectProduct.GetData(selectItem.Id)); foreach (var t in selectProductData) { if (t.Product_Id != null) { _s1.Add((byte)t.Product_Id); } if (t.Capacity_Id != null) { _s2.Add((byte)t.Capacity_Id); } if (t.CapacityNumber != null) { _s3.Add((byte)t.CapacityNumber); } _s4.Add(t.ProductName); _s5.Add(t.CapacityNumber + " " + t.CapacityName); } _createProduct = new List <CreateProduct>(); for (var i = 0; i < _s1.Count; i++) { _createProduct.Add(new CreateProduct(_s1[i], _s2[i], _s3[i], _s4[i], _s5[i])); } DgdProduct.ItemsSource = _createProduct; }
private async void BtnEdit_Click(object sender, RoutedEventArgs e) { if (!CheckSelectEdit() || !CheckEmpty()) { return; } var selectItem = _havalehSearchData[DgdHavaleh.SelectedIndex]; try { var editHavaleh = new DHavaleh { DId = selectItem.Id, DFactoryId = ((tblFactory)CboFactory.SelectedItem).Id, DCountyId = ((tblCounty)CboCounty.SelectedItem).Id, DBuyerId = ((tblBuyer)CboBuyer.SelectedItem).Id, DDriverId = ((tblDriver)CboDriver.SelectedItem).Id, DVehicleTypeId = ((tblVehicleType)CboVehicle.SelectedItem).Id, DDate = TxtDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtDate.Text), DNumber = TxtNumber.Text.Trim() == string.Empty ? null : TxtNumber.Text, DHavlehNumber = TxtHavlehNumber.Text.Trim() == string.Empty ? null : TxtHavlehNumber.Text, DHavlehDate = TxtHavlehDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtHavlehDate.Text), DHavalehEndDate = TxtHavalehEndDate.Text.Trim() == string.Empty ? null : Utility.CurrectDate(TxtHavalehEndDate.Text) }; await Task.Run(() => editHavaleh.Edit()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در ویرایش اطلاعات پزشک\n" + exception.Message); return; } try { var deleteSelectProduct = new DSelectProduct { DHavalehId = selectItem.Id }; await Task.Run(() => deleteSelectProduct.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); return; } foreach (var t in _createProduct) { try { var addSelectProduct = new DSelectProduct { DHavalehId = selectItem.Id, DProductId = t.ProductId, DCapacityId = t.CapacityId, DCapacityNumber = t.Num }; await Task.Run(() => addSelectProduct.Add()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در ثبت اطلاعات\n" + exception.Message); } } Window_Loaded(null, null); Utility.Message("پیام", "اطلاعات با موفقیت ویرایش گردید", "Correct.png"); }