/// <summary>
/// Adds an <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/>.
/// </summary>
/// <param name="name">The new name.</param>
/// <returns><c>false</c>, if <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/> already exists</returns>
public static bool AddAccount(string name)
{
using (var en = new HaushaltsrechnerEntities())
{
var aOld = en.ACCOUNT.FirstOrDefault(r => r.NAME == name);
if (aOld == null)
{
var a = new ACCOUNT
{
ID = Guid.NewGuid(),
NAME = name
};
en.ACCOUNT.AddObject(a);
en.SaveChanges();
return true;
}
return false;
}
}
/// <summary>
/// Creates an <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/> with the specified name and one
/// <see cref="HaushaltsRechner.Data.Model.USER"/>
/// </summary>
/// <param name="name">Name of the new <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/></param>
/// <param name="userId">ID of the first <see cref="HaushaltsRechner.Data.Model.USER"/>
/// of the <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/></param>
/// <returns>
/// The created <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/>
/// or an old <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/>, if Name is already in DB
/// </returns>
public static ACCOUNT CreateAccount(string name, Guid userId)
{
using (var en = new HaushaltsrechnerEntities())
{
var user = en.USER.FirstOrDefault(u => u.ID == userId);
var aOld = en.ACCOUNT.First(r => r.NAME == name && r.USER.Any(u => u.ID == user.ID));
if (aOld == null)
{
var a = new ACCOUNT
{
ID = Guid.NewGuid(),
NAME = name
};
a.USER.Add(user);
en.ACCOUNT.AddObject(a);
en.SaveChanges();
return a;
}
return aOld;
}
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'ACCOUNT'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToACCOUNT(ACCOUNT aCCOUNT)
{
base.AddObject("ACCOUNT", aCCOUNT);
}
/// <summary>
/// Erstellt ein neues ACCOUNT-Objekt.
/// </summary>
/// <param name="id">Anfangswert der Eigenschaft ID.</param>
/// <param name="nAME">Anfangswert der Eigenschaft NAME.</param>
public static ACCOUNT CreateACCOUNT(global::System.Guid id, global::System.String nAME)
{
ACCOUNT aCCOUNT = new ACCOUNT();
aCCOUNT.ID = id;
aCCOUNT.NAME = nAME;
return aCCOUNT;
}
/// <summary>
/// Gets all <see cref="HaushaltsRechner.Data.Model.MOVEMENT"/> by <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/> id.
/// </summary>
/// <param name="ac">The <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/>.</param>
/// <returns>all <see cref="HaushaltsRechner.Data.Model.MOVEMENT"/> from <see cref="HaushaltsRechner.Data.Model.ACCOUNT"/></returns>
public static IQueryable<MOVEMENT> GetMovementsByAccount(ACCOUNT ac)
{
return GetMovementsByAccountId(ac.ID);
}
