/// <summary>
///
/// </summary>
/// <param name="t">Represent an Transaction</param>
public void AddToBalance(Transaction t)
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
balanceDb.AddToTransactions(t);
}
}
public MainWindow()
{
InitializeComponent();
db = new BalanceEntities();
LoadAll();
Init();
}
/// <summary>
/// Method used to retrive the details of a certein transaction
/// </summary>
/// <param name="ofTransaction">Value that represent the Id of the transaction</param>
/// <returns>An IEnumerable of objects with the Detail,Bills and Bill's values</returns>
public IEnumerable <object> GetDetails(int ofTransaction)
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
var qDetail = balanceDb.Details.Where(d => d.Transaction.transactionId == ofTransaction);
var _Details = balanceDb.MoneyDetails.Join(
qDetail, money => money.detailId, detail => detail.detailId, (money, detail) => new
{
Description = detail.description,
Bills = money.billQuantity,
Value = money.Bill.value
});
return(_Details);
}
}
/// <summary>
/// Method used to retrive all the transactions
/// </summary>
/// <returns>An IEnumerable of Transaction type</returns>
public IList <Transaction> AllTransactions()
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
try
{
var _transactions = balanceDb.Transactions.Distinct();
return(_transactions.ToList());
}
catch (Exception e)
{
throw e;
}
}
}
/// <summary>
/// Method used to retrive the transactions of a certein type
/// </summary>
/// <param name="ofType">A byte value that represent the type of the transaction</param>
/// <returns>An IEnumerable of Transaction type </returns>
public IEnumerable <Transaction> GetTransactions(byte ofType)
{
try
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
var qTransactions =
balanceDb.Transactions.Where(t => t.typeId == ofType);
return(qTransactions.ToList());
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Creates a dictionary with the types o the bills
/// </summary>
/// <returns>A Collection with the types of bills</returns>
public Dictionary <byte, string> GetBills()
{
try
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
Dictionary <byte, string> dBills =
balanceDb.Bills.ToDictionary(b => b.billId, b => b.value);
return(dBills);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Creates a dictionary with the types of the transactions
/// </summary>
/// <returns>A Collection with the type of transactions</returns>
public Dictionary <byte, string> GetTypes()
{
try
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
Dictionary <byte, string> dTypes =
balanceDb.Types.ToDictionary(t => t.typeId, t => t.name);
return(dTypes);
}
}
catch (Exception e)
{
throw e;
}
}
static void Main(string[] args)
{
using (BalanceEntities db = new BalanceEntities())
{
var Devices = db.Devices.Take(10);
foreach (Device d in Devices)
{
Console.WriteLine("{0}", d.SerialNumber);
}
}
Console.WriteLine("");
Console.WriteLine("ALL!!");
Console.ReadLine();
}
/// <summary>
/// Saves the money detail for a transaction to the data source.
/// </summary>
/// <param name="billId">Value that represents the type of bill.</param>
/// <param name="quantity">Value that represents how many bills will be saved.</param>
public void AddToBalance(byte billId, short quantity)
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
try
{
MoneyDetail money = new MoneyDetail();
money.Bill = balanceDb.Bills.Single(b => b.billId == billId);
money.billQuantity = quantity;
money.detailId = _detail.detailId;
balanceDb.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
/// <summary>
/// Saves the textual detail for a transaction to the data source.
/// </summary>
/// <param name="description">A text that explain the transaction.</param>
public void AddToBalance(string description)
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
try
{
balanceDb.Details.AddObject(_detail =
new Detail {
description = description, transactionId = _transaction.transactionId
});
balanceDb.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
/// <summary>
/// Saves a transaction to the data source.
/// </summary>
/// <param name="type">Value that represents the type of the transaction.</param>
/// <param name="amount">The total value of the transaction.</param>
/// <param name="date">The date when the transaction was made.</param>
public void AddToBalance(byte type, decimal amount, DateTime date)
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
try
{
_transaction = new Transaction();
_transaction.Type = balanceDb.Types.Single(t => t.typeId == type);
_transaction.amount = amount;
_transaction.date = date;
balanceDb.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
/// <summary>
/// Method used to calculate the total amount of the savings
/// </summary>
/// <returns>A decimal value that represents the Total of savings</returns>
public decimal GetTotal()
{
using (BalanceEntities balanceDb = new BalanceEntities())
{
try
{
decimal _savings = balanceDb.Transactions.Where(t => t.typeId == 1).Sum(t => t.amount);
decimal _withdraws = balanceDb.Transactions.Where(t => t.typeId == 2).Sum(t => t.amount);
decimal _loans = balanceDb.Transactions.Where(t => t.typeId == 3).Sum(t => t.amount);
decimal _charges = balanceDb.Transactions.Where(t => t.typeId == 4).Sum(t => t.amount);
return(_savings - (_withdraws + _loans + _charges));
}
catch (Exception e)
{
throw e;
}
}
}
