private async void BtnAdd_Click(object sender, RoutedEventArgs e) { if (!CheckEmpty()) { return; } try { var addFee = new DFee { DPaymentTypeId = (byte)CboPayType.SelectedIndex, DFeeCategoryId = FeeCategoryId, DBankAccontId = AccountId, DDate = Utility.CurrectDate(TxtDate.Text), DTime = Utility.CurrectTime(TxtTime.Text), DAmount = long.Parse(Regex.Replace(TxtAmount.Text, "[\\W]", "")), DReceiptNumber = TxtReceiptNumber.Text.Trim() == string.Empty ? null : TxtReceiptNumber.Text, DDescription = TxtDescription.Text.Trim() == string.Empty ? null : TxtDescription.Text }; await Task.Run(() => addFee.Add()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در ثبت اطلاعات\n" + exception.Message); return; } Window_Loaded(null, null); Utility.Message("پیام", "اطلاعات با موفقیت ویرایش گردید", "Correct.png"); }
private async void BtnDelete_Click(object sender, RoutedEventArgs e) { if (!CheckSelectDelete()) { return; } var selectItem = _feeSearchData[DgdFee.SelectedIndex]; Utility.MyMessageBox("هشدار", "آیا از حذف اطمینان دارید؟ ", "Warning.png", false); if (!Utility.YesNo) { return; } try { var deleteFee = new DFee { DId = selectItem.Id }; await Task.Run(() => deleteFee.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); return; } Window_Loaded(null, null); Utility.Message("پیام", "اطلاعات با موفقیت حذف گردید", "Correct.png"); }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { _incomeData = DIncome.GetIncomeData(); _feeData = DFee.GetFeeData(); _incomeInfo = DIncome.GetDataNoAsync(); _feeInfo = DFee.GetDataNoAsync(); _bankData = DBankAccount.GetDataNoAsync(); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message); } var today = PersianDateTime.Now.Date.ToString("yyyy/MM/dd"); var firstDayOfWeek = PersianDateTime.Now.FirstDayOfWeek.ToString("yyyy/MM/dd"); var lastDayOfWeek = PersianDateTime.Now.LastDayOfWeek.ToString("yyyy/MM/dd"); var firstDayOfMonth = PersianDateTime.Now.FirstDayOfMonth.ToString("yyyy/MM/dd"); var lastDayOfMonth = PersianDateTime.Now.LastDayOfMonth.ToString("yyyy/MM/dd"); var firstDayOfYear = PersianDateTime.Now.FirstDayOfYear.ToString("yyyy/MM/dd"); var lastDayOfYear = PersianDateTime.Now.LastDayOfYear.ToString("yyyy/MM/dd"); var totalIncome = Convert.ToInt64(_incomeData.Sum(y => y.Amount)); var totalFee = Convert.ToInt64(_feeData.Sum(y => y.Amount)); var totalAccount = Convert.ToInt64(_bankData.Sum(y => y.InitialBalance)); var total = totalIncome - totalFee + totalAccount; LblTotalIncome.Content = totalIncome.ToString("N0", CultureInfo.InvariantCulture); LblIncomeToday.Content = Convert.ToInt64(_incomeData.Where(x => x.IncomeDate == today).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblIncomeWeek.Content = Convert.ToInt64(_incomeData.Where(x => string.CompareOrdinal(x.IncomeDate, firstDayOfWeek) >= 0 && string.CompareOrdinal(x.IncomeDate, lastDayOfWeek) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblIncomeMonth.Content = Convert.ToInt64(_incomeData.Where(x => string.CompareOrdinal(x.IncomeDate, firstDayOfMonth) >= 0 && string.CompareOrdinal(x.IncomeDate, lastDayOfMonth) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblIncomeYear.Content = Convert.ToInt64(_incomeData.Where(x => string.CompareOrdinal(x.IncomeDate, firstDayOfYear) >= 0 && string.CompareOrdinal(x.IncomeDate, lastDayOfYear) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblTotalFee.Content = totalFee.ToString("N0", CultureInfo.InvariantCulture); LblFeeToday.Content = Convert.ToInt64(_feeData.Where(x => x.FeeDate == today).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblFeeWeek.Content = Convert.ToInt64(_feeData.Where(x => string.CompareOrdinal(x.FeeDate, firstDayOfWeek) >= 0 && string.CompareOrdinal(x.FeeDate, lastDayOfWeek) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblFeeMonth.Content = Convert.ToInt64(_feeData.Where(x => string.CompareOrdinal(x.FeeDate, firstDayOfMonth) >= 0 && string.CompareOrdinal(x.FeeDate, lastDayOfMonth) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblFeeYear.Content = Convert.ToInt64(_feeData.Where(x => string.CompareOrdinal(x.FeeDate, firstDayOfYear) >= 0 && string.CompareOrdinal(x.FeeDate, lastDayOfYear) <= 0).Sum(y => y.Amount)).ToString("N0", CultureInfo.InvariantCulture); LblTotalAccount.Content = totalAccount.ToString("N0", CultureInfo.InvariantCulture); LblTotal.Content = total.ToString("N0", CultureInfo.InvariantCulture); LblTotal.Foreground = total > 0 ? Brushes.Green : Brushes.Red; var myValuePairs = new List <KeyValuePair <string, long?> >(); foreach (var variable in _bankData) { var accountAmount = Convert.ToInt64(_incomeInfo.Where(x => x.BankAccont_Id == variable.Id).Sum(y => y.Amount)) - Convert.ToInt64(_feeInfo.Where(x => x.BankAccont_Id == variable.Id).Sum(y => y.Amount)) + variable.InitialBalance; myValuePairs.Add(new KeyValuePair <string, long?>(variable.BankName, accountAmount)); } CChart.DataContext = myValuePairs; }
private async void BtnDelete_Click(object sender, RoutedEventArgs e) { if (!CheckSelect()) { return; } var selectItem = _bankAccountData[DgdBankAccount.SelectedIndex]; try { _incomeData = await DIncome.GetIncomeBankData(selectItem.Id); _feeData = await DFee.GetFeeBankData(selectItem.Id); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message); return; } if (!CheckCanDelete()) { return; } Utility.MyMessageBox("هشدار", "آیا از حذف این حساب بانکی اطمینان دارید؟", "Warning.png", false); if (!Utility.YesNo) { return; } try { var deleteBankAccount = new DBankAccount { DId = selectItem.Id }; await Task.Run(() => deleteBankAccount.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); } Utility.Message("پیام", "اطلاعات حساب بانکی مورد نظر با موفقیت حذف گردید", "Correct.png"); Window_Loaded(null, null); }
private async void Window_Loaded(object sender, RoutedEventArgs e) { try { _feeData = await DFee.GetData(); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message); Close(); return; } _feeSearchData = _feeData; DgdFee.ItemsSource = _feeSearchData; BtnNew_Click(null, null); }
private async void BtnDelete_Click(object sender, RoutedEventArgs e) { if (!CheckSelectGroup() || !CheckSelectCategory()) { return; } var selectCategory = _feeCategory[DgdCategory.SelectedIndex]; try { _feeData = await DFee.GetFeeCategoryData(selectCategory.Id); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message); return; } if (!CheckCanDelete()) { return; } Utility.MyMessageBox("هشدار", "آیا از حذف این دسته بندی اطمینان دارید؟", "Warning.png", false); if (!Utility.YesNo) { return; } try { var deleteFeeCategory = new DFeeCategory { DId = selectCategory.Id }; await Task.Run(() => deleteFeeCategory.Delete()); } catch (Exception exception) { Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message); } Utility.Message("پیام", "اطلاعات مورد نظر با موفقیت حذف گردید", "Correct.png"); Window_Loaded(null, null); }