/// <summary> /// Creates the <see cref="HaushaltsRechner.Data.Model.REASON"/>. /// </summary> /// <param name="text">The text.</param> /// <returns> /// The new <see cref="HaushaltsRechner.Data.Model.REASON"/>, /// or if Text already exists,the old <see cref="HaushaltsRechner.Data.Model.REASON"/> /// </returns> public static REASON CreateReason(string text) { using (var en = new HaushaltsrechnerEntities()) { var rOld = en.REASON.Where(r => r.TEXT == text); if (!rOld.Any()) { var r = new REASON { ID = Guid.NewGuid(), TEXT = text }; en.REASON.AddObject(r); en.SaveChanges(); return r; } return rOld.First(); } }
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> /// Erstellt ein neues REASON-Objekt. /// </summary> /// <param name="id">Anfangswert der Eigenschaft ID.</param> /// <param name="tEXT">Anfangswert der Eigenschaft TEXT.</param> public static REASON CreateREASON(global::System.Guid id, global::System.String tEXT) { REASON rEASON = new REASON(); rEASON.ID = id; rEASON.TEXT = tEXT; return rEASON; }
/// <summary> /// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'REASON'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'. /// </summary> public void AddToREASON(REASON rEASON) { base.AddObject("REASON", rEASON); }