private async void BtnAdd_Click(object sender, RoutedEventArgs e)
{
if (!CheckEmpty())
{
return;
}
try
{
var addBankAccount = new DBankAccount
{
DBankName = TxtBankName.Text.Trim() == string.Empty ? null : TxtBankName.Text,
DBranchName = TxtBranchName.Text.Trim() == string.Empty ? null : TxtBranchName.Text,
DAccountNum = TxtAccountNum.Text.Trim() == string.Empty ? null : TxtAccountNum.Text,
DCardNum = TxtCardNum.Text.Trim() == string.Empty ? null : TxtCardNum.Text,
DInitialBalance = long.Parse(Regex.Replace(TxtInitialBalance.Text, "[\\W]", "")),
DDescription = TxtDescription.Text.Trim() == string.Empty ? null : TxtDescription.Text,
};
await Task.Run(() => addBankAccount.Add());
}
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)
{
Id = 1;
BankName = "حساب شخصی";
try
{
_bankAccountData = await DBankAccount.GetData();
_bankAccountData.RemoveAt(0);
}
catch (Exception exception)
{
Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message);
return;
}
DgdBankAccount.ItemsSource = _bankAccountData;
}
