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; }