public static double DepositMoney(long accountNumber, double amoun)
{
var dep = EntitiesContainer.Deposits.FirstOrDefault(d => d.InvestorID == accountNumber);
if(dep != null)
{
dep.balance = dep.balance + amoun;
dep.date = DateTime.Now;
EntitiesContainer.SaveChanges();
}
else
{
dep = new Deposits();
dep.balance = amoun;
dep.InvestorID = accountNumber;
dep.date = DateTime.Now;
EntitiesContainer.Deposits.AddObject(dep);
EntitiesContainer.SaveChanges();
}
return dep.balance;
}
/// <summary>
/// Deprecated Method for adding a new object to the Deposits EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToDeposits(Deposits deposits)
{
base.AddObject("Deposits", deposits);
}
/// <summary>
/// Create a new Deposits object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="amount">Initial value of the amount property.</param>
/// <param name="date">Initial value of the date property.</param>
/// <param name="balance">Initial value of the balance property.</param>
/// <param name="investorID">Initial value of the InvestorID property.</param>
public static Deposits CreateDeposits(global::System.Int64 id, global::System.Double amount, global::System.DateTime date, global::System.Double balance, global::System.Int64 investorID)
{
Deposits deposits = new Deposits();
deposits.id = id;
deposits.amount = amount;
deposits.date = date;
deposits.balance = balance;
deposits.InvestorID = investorID;
return deposits;
}
