protected override void assignValuesToEntity() // send textboxes info to entity
{
Accountancy Accountancy = (Accountancy)mainEntity;
Accountancy.ExpenseID = expenseSelected.Id;
Accountancy.Cost = Convert.ToDecimal(tbCost.Text);
Accountancy.AccountDate = Convert.ToDateTime(tbDate.Text);
}
public IActionResult Delete(Income income)
{
_incomeRepository.DeleteIncome(income);
Accountancy accountancy = new Accountancy();
_accountancyRepository.CreateOrEditIncome(accountancy);
return(RedirectToAction(nameof(Index)));
}
public IActionResult DeleteConfirmed(int Id)
{
var expense = _expenseRepository.GetExpense(Id);
_expenseRepository.DeleteExpense(expense);
Accountancy accountancy = new Accountancy();
_accountancyRepository.CreateOrEditExpense(accountancy);
return(RedirectToAction(nameof(Index)));
}
public IActionResult Create(Income income)
{
if (ModelState.IsValid)
{
_incomeRepository.CreateIncome(income);
Accountancy accountancy = new Accountancy();
_accountancyRepository.CreateOrEditIncome(accountancy);
}
return(RedirectToAction(nameof(Index)));
}
public IActionResult Create(Expense expense)
{
if (ModelState.IsValid)
{
_expenseRepository.CreateExpense(expense);
Accountancy accountancy = new Accountancy();
_accountancyRepository.CreateOrEditExpense(accountancy);
}
return(RedirectToAction(nameof(Index)));
}
private void listData()
{
Double TotalExpenses = 0; // accountancy variables
Double TotalPayments = 0;
Double Total = 0;
this.listView1.Items.Clear();
foreach (var item in controllerBase.getAllData()) // get data from accountancy entity and insert rows on listview
{
Accountancy accountancy = (Accountancy)item;
ListViewItem newList = new ListViewItem(accountancy.Id.ToString());
newList.SubItems.Add(accountancy.AccountDate.ToString());
newList.SubItems.Add(accountancy.OrderID.ToString());
if (accountancy.Expense != null)
{
newList.SubItems.Add(accountancy.Expense.Name);
}
else
{
newList.SubItems.Add("");
}
newList.SubItems.Add(accountancy.Cost.ToString());
newList.ForeColor = Color.White;
if (accountancy.Expense != null)
{
newList.BackColor = Color.Red; // label color
TotalExpenses = TotalExpenses + Convert.ToDouble(accountancy.Expense.Cost);
}
else
{
if (accountancy.Orders != null)
{
newList.BackColor = Color.Green; // label color
TotalPayments = TotalPayments + Convert.ToDouble(accountancy.Orders.Cost);
}
}
this.listView1.Items.Add(newList);
}
lbExpenses.Text = TotalExpenses.ToString(); // show expenses in label
lbPayment.Text = TotalPayments.ToString(); // show paymment in label
Total = TotalPayments - TotalExpenses; // show total balance in label
lbTotal.Text = Total.ToString();
}
public void finishOrder(int id)
{
Orders order = (from p in db.Orders
where p.Id == id
select p).FirstOrDefault(); //search at database with query ID
order.Finished = 1;
order.DeliveryDate = DateTime.Now; //set date
Accountancy accountancy = new Accountancy();
accountancy.CompanyID = getDefaultCompany().Id;
accountancy.OrderID = order.Id;
accountancy.Cost = order.Cost;
accountancy.AccountDate = DateTime.Now;
db.Accountancy.Add(accountancy);
db.SaveChanges();
}
public IActionResult Pay(Expense expense, int Id)
{
var regular = _regularRepository.GetRegular(Id);
if (regular.Status == false)
{
expense.ShoppingDate = expense.Payment.ToShortDateString();
expense.Id = 0;
_expenseRepository.CreateExpense(expense);
_regularRepository.ChangeStatus(regular);
Accountancy accountancy = new Accountancy();
_accountancyRepository.CreateOrEditExpense(accountancy);
return(RedirectToAction(nameof(Index)));
}
else
{
return(RedirectToAction(nameof(Payed)));
}
}
public override void add()
{
try
{
Accountancy accountancy = new Accountancy();
accountancy.CompanyID = getDefaultCompany().Id; // get default ID from table
AddExpenseToAccountancyForm addExpenseForm = new AddExpenseToAccountancyForm();
addExpenseForm.mainEntity = accountancy;
addExpenseForm.controller = this;
if (addExpenseForm.ShowDialog() == System.Windows.Forms.DialogResult.OK) // Save input at expense
{
db.Accountancy.Add(accountancy);
db.SaveChanges();
}
}
catch (System.InvalidOperationException ex)
{
MessageBox.Show(ex.Message);
}
}
