/// <summary>
/// Erstellt ein neues MOVEMENT-Objekt.
/// </summary>
/// <param name="id">Anfangswert der Eigenschaft ID.</param>
/// <param name="aMOUNT">Anfangswert der Eigenschaft AMOUNT.</param>
/// <param name="dATE_ADDED">Anfangswert der Eigenschaft DATE_ADDED.</param>
/// <param name="aCCOUNT_ID">Anfangswert der Eigenschaft ACCOUNT_ID.</param>
/// <param name="cATEGORY_ID">Anfangswert der Eigenschaft CATEGORY_ID.</param>
/// <param name="uSER_ID">Anfangswert der Eigenschaft USER_ID.</param>
/// <param name="rEASON_ID">Anfangswert der Eigenschaft REASON_ID.</param>
public static MOVEMENT CreateMOVEMENT(global::System.Guid id, global::System.Decimal aMOUNT, global::System.DateTime dATE_ADDED, global::System.Guid aCCOUNT_ID, global::System.Guid cATEGORY_ID, global::System.Guid uSER_ID, global::System.Guid rEASON_ID)
{
MOVEMENT mOVEMENT = new MOVEMENT();
mOVEMENT.ID = id;
mOVEMENT.AMOUNT = aMOUNT;
mOVEMENT.DATE_ADDED = dATE_ADDED;
mOVEMENT.ACCOUNT_ID = aCCOUNT_ID;
mOVEMENT.CATEGORY_ID = cATEGORY_ID;
mOVEMENT.USER_ID = uSER_ID;
mOVEMENT.REASON_ID = rEASON_ID;
return mOVEMENT;
}
public string AddMovement(string data)
{
try
{
var movement = JsonConvert.DeserializeObject<NewMovement>(data);
var en = new HaushaltsrechnerEntities();
var acc = en.ACCOUNT.FirstOrDefault(a=>a.ID == movement.AccountID);
var cat = en.CATEGORY.FirstOrDefault(c=>c.ID == movement.CategoryID);
var user = en.USER.FirstOrDefault(u => u.ID == SessionManager.CurrentUser.ID);
var rea = en.REASON.Where(r => r.TEXT == movement.Reason);
REASON reason;
if (rea.Any())
{
reason = rea.First();
}
else
{
reason = new REASON
{
ID = Guid.NewGuid(),
TEXT = movement.Reason
};
en.REASON.AddObject(reason);
}
var m = new MOVEMENT
{
ID = movement.ID,
DATE_ADDED = movement.DateAdded,
DATE_EDIT = DateTime.Now,
AMOUNT = Decimal.Parse(movement.Amount.Replace("€",string.Empty)),
MESSAGE = movement.Message,
USER = user,
ACCOUNT = acc,
CATEGORY = cat,
REASON = reason
};
en.MOVEMENT.AddObject(m);
en.SaveChanges();
return bool.TrueString;
}
catch
{
return bool.FalseString;
}
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'MOVEMENT'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToMOVEMENT(MOVEMENT mOVEMENT)
{
base.AddObject("MOVEMENT", mOVEMENT);
}
