private void cmdFind_Click(object sender, EventArgs e)
{
try
{
lblCredit.Text = "";
lblDebit.Text = "";
cmdClose.Enabled = false;
selectedYear = 0;
credit = 0;
debit = 0;
decimal shiftAmountIncomes = 0;
decimal shiftAmountExpenses = 0;
int year = 0;
if (int.TryParse(txtYear.Text.Trim(), out year) && year > 0)
{
selectedYear = year;
ClosedPeriod closedPeriod = manager.My_db.ClosedPeriods.FirstOrDefault(x => x.year == year && x.fund_id == manager.Selected);
if (closedPeriod != null)
{
ErrorMessage.showErrorMessage(new Exception("This period has been already closed."));
return;
}
List <MovementsView> movements = manager.My_db.MovementsViews.Where(x => (x.TypeId == 3 || x.TypeId == 4) && x.Date.Year == year && x.FundId == manager.Selected).ToList();
if (movements.Count == 0)
{
ErrorMessage.showErrorMessage(new Exception("No found data in selected period."));
return;
}
foreach (MovementsView movement in movements)
{
if (movement.TypeId == 3)
{
shiftAmountIncomes += movement.Shift_Amount.Value;
}
else
{
shiftAmountExpenses += movement.Shift_Amount.Value;
}
string key = movement.account_id.ToString() + "_" +
(movement.SubAccountId.HasValue ? movement.SubAccountId.Value.ToString() : "x") + "_" +
(movement.detail_type.HasValue ? movement.detail_type.Value.ToString() : "x") + "_" +
(movement.detail_id.HasValue ? movement.detail_id.Value.ToString() : "x");
if (accountBalances.ContainsKey(key))
{
accountBalances[key] += movement.Shift_Amount.Value;
}
else
{
accountBalances.Add(key, movement.Shift_Amount.Value);
}
}
debitAdjustment = shiftAmountExpenses > shiftAmountIncomes ? shiftAmountExpenses - shiftAmountIncomes : 0;
creditAdjustment = shiftAmountIncomes > shiftAmountExpenses ? shiftAmountIncomes - shiftAmountExpenses : 0;
if (shiftAmountIncomes > 0 || shiftAmountIncomes > 0)
{
credit = shiftAmountExpenses;
debit = shiftAmountIncomes;
lblCredit.Text = String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("es-ES"), "{0:C2}", shiftAmountExpenses);
lblCreditAdjustment.Text = creditAdjustment > 0 ? "+ " + String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("es-ES"), "{0:C2}", creditAdjustment) : "";
lblDebit.Text = String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("es-ES"), "{0:C2}", shiftAmountIncomes);
lblDebitAdjustment.Text = debitAdjustment > 0 ? "+ " + String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("es-ES"), "{0:C2}", debitAdjustment) : "";
cmdClose.Enabled = true;
}
}
else
{
ErrorMessage.showErrorMessage(new Exception("Data format error."));
}
}
catch (Exception _ex)
{
ErrorMessage.showErrorMessage(_ex);
}
}
private void cmdClose_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Do you want close selected period?", "Warning", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
AccountingMovement _accountingMovement = new AccountingMovement();
Account account999 = manager.My_db.Accounts.FirstOrDefault(x => x.number == "999" && x.FK_Accounts_Funds == manager.Selected);
if (account999 != null)
{
_accountingMovement.FK_AccountingMovements_Funds = manager.Selected;
_accountingMovement.description = "Period Closure";
_accountingMovement.date = new DateTime(selectedYear, 12, 31, 23, 59, 59);
_accountingMovement.reference = _accountingMovement.contract = KeyDefinitions.NextAccountMovementReference(selectedYear);
_accountingMovement.FK_AccountingMovements_Currencies = 1;
_accountingMovement.original_reference = "";
manager.My_db.AccountingMovements.Add(_accountingMovement);
foreach (KeyValuePair <string, decimal> item in accountBalances)
{
string[] strKeys = item.Key.Split('_');
int accountId = int.Parse(strKeys[0]);
int?subaccountId = null;
int?detailType = null;
int?detailId = null;
if (strKeys[1] != "x")
{
subaccountId = int.Parse(strKeys[1]);
}
if (strKeys[2] != "x")
{
detailType = int.Parse(strKeys[2]);
}
if (strKeys[3] != "x")
{
detailId = int.Parse(strKeys[3]);
}
Account acct = manager.My_db.Accounts.FirstOrDefault(x => x.Id == accountId);
Movements_Accounts movement = new Movements_Accounts();
movement.AccountingMovement = _accountingMovement;
movement.FK_Movements_Accounts_Funds = manager.Selected;
movement.FK_Movements_Accounts_Accounts = accountId;
movement.FK_Movements_Accounts_Subaccounts = subaccountId;
movement.subaccount_type = detailType;
movement.subaccount = detailId;
movement.debit = acct.type == 3 ? Math.Round(item.Value, 2) : 0;
movement.credit = acct.type == 4 ? Math.Round(item.Value, 2) : 0;
manager.My_db.Movements_Accounts.Add(movement);
}
Movements_Accounts _maccount999 = new Movements_Accounts();
_maccount999.AccountingMovement = _accountingMovement;
_maccount999.FK_Movements_Accounts_Funds = manager.Selected;
_maccount999.FK_Movements_Accounts_Accounts = account999.Id;
_maccount999.debit = Math.Round(debitAdjustment, 2);
_maccount999.credit = Math.Round(creditAdjustment, 2);
manager.My_db.Movements_Accounts.Add(_maccount999);
txtYear.Text = "";
lblCredit.Text = "";
lblDebit.Text = "";
lblCreditAdjustment.Text = "";
lblDebitAdjustment.Text = "";
cmdClose.Enabled = false;
ClosedPeriod closure = new ClosedPeriod();
closure.year = selectedYear;
closure.closing_date = DateTime.Now;
closure.AccountingMovement = _accountingMovement;
closure.fund_id = manager.Selected;
manager.My_db.ClosedPeriods.Add(closure);
manager.My_db.SaveChanges();
MessageBox.Show("Period has been closed.");
}
else
{
ErrorMessage.showErrorMessage(new Exception("Missing account 999."));
}
}
}
catch (Exception _ex)
{
ErrorMessage.showErrorMessage(_ex);
}
}