public static account getAccount(int accountID)
{
account account = new account() { };
using (var ctx = new accountingEntities())
{
account = ctx.accounts.Where(x => x.ID.Equals(accountID)).SingleOrDefault();
}
return account;
}
public Transaction(decimal amount , account acc)
{
using (var ctx = new accountingEntities())
{
TXN = new transaction
{
accountID = acc.ID,
amount = amount
};
ctx.transactions.AddObject(TXN);
ctx.SaveChanges();
}
}
public static account getAccount(int entityID, int catTypeID, int currencyID)
{
account account = new account() { };
using (var ctx = new accountingEntities())
{
account = ctx.accounts.Where(
x => x.catTypeID == catTypeID
&& x.ownerEntityID.Equals(entityID)
&& x.currencyID.Equals(currencyID))
.SingleOrDefault();
}
return account;
}
public account Create(int ownerEntityId,int currencyID,decimal balance=0)
{
using (var ctx = new accountingEntities())
{
var duplicate = ctx.accounts
.Where(x => x.ownerEntityID == ownerEntityId && x.currencyID == currencyID && x.catTypeID ==CATTYPE)
.SingleOrDefault();
if (duplicate != null)
ctx.DeleteObject(duplicate);
var newAccount = new account()
{
catTypeID=CATTYPE,
ownerEntityID=ownerEntityId,
currencyID=currencyID,
balance=balance
};
ctx.accounts.AddObject(newAccount);
ctx.SaveChanges();
return newAccount;
}
}
/// <summary>
/// Deprecated Method for adding a new object to the accounts EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToaccounts(account account)
{
base.AddObject("accounts", account);
}
/// <summary>
/// Create a new account object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
public static account Createaccount(global::System.Int32 id)
{
account account = new account();
account.ID = id;
return account;
}
