private async void BtnAdd_Click(object sender, RoutedEventArgs e)
{
if (!CheckEmpty())
{
return;
}
try
{
var addIncome = new DIncome
{
DPaymentTypeId = (byte)CboPayType.SelectedIndex,
DIncomeCategoryId = IncomeCategoryId,
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(() => addIncome.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 = _incomeSearchData[DgdIncome.SelectedIndex];
Utility.MyMessageBox("هشدار", "آیا از حذف اطمینان دارید؟ ", "Warning.png", false);
if (!Utility.YesNo)
{
return;
}
try
{
var deleteIncome = new DIncome
{
DId = selectItem.Id
};
await Task.Run(() => deleteIncome.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
{
_incomeData = await DIncome.GetData();
}
catch (Exception exception)
{
Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در دریافت اطلاعات\n" + exception.Message);
Close();
return;
}
_incomeSearchData = _incomeData;
DgdIncome.ItemsSource = _incomeSearchData;
BtnNew_Click(null, null);
}
private async void BtnDelete_Click(object sender, RoutedEventArgs e)
{
if (!CheckSelectGroup() || !CheckSelectCategory())
{
return;
}
var selectCategory = _incomeCategory[DgdCategory.SelectedIndex];
try
{
_incomeData = await DIncome.GetIncomeCategoryData(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 deleteIncomeCategory = new DIncomeCategory
{
DId = selectCategory.Id
};
await Task.Run(() => deleteIncomeCategory.Delete());
}
catch (Exception exception)
{
Utility.MyMessageBox("خطا در بانک اطلاعاتی", "خطا در حذف اطلاعات\n" + exception.Message);
}
Utility.Message("پیام", "اطلاعات مورد نظر با موفقیت حذف گردید", "Correct.png");
Window_Loaded(null, null);
}
