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>
/// 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 void SetReason(REASON reason)
{
this.PutByte((byte)reason, 4);
}
public ControllerInfoException(FileInfo controller, string message, REASON reason)
: base(message, reason)
{
this.controller = controller;
}
public ControllerException(string message, REASON r)
: base(message)
{
thisreason = r;
}
public FMathException(REASON reason)
{
this.reason = reason;
}
public void SetReason(REASON reason)
{
this.PutByte((byte)reason, 4);
}
