public IHttpActionResult updateTransaction([FromUri] bool UpdateTransaction, [FromBody] TransactionUpload data)
{
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().type_id = data.category;
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().source = data.source;
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().date = DateTime.Parse(data.date);
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().amount = data.amount;
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().description = data.description;
_db.transaction_log.Where(i => i.transaction_id == data.transactionID).FirstOrDefault().user_id = data.spender;
_db.SaveChanges();
return(Ok(data.transactionID));
}
public IHttpActionResult addTransaction([FromUri] bool addTransaction, [FromBody] TransactionUpload data)
{
var transaction = new transaction_log();
transaction.user_id = data.spender;
transaction.source = data.source;
transaction.amount = data.amount;
transaction.type_id = data.category;
transaction.date = DateTime.Parse(data.date);
transaction.description = data.description;
transaction.reoccuring = data.reoccur;
_db.transaction_log.Add(transaction);
_db.SaveChanges();
return(Created(transaction.description, transaction.transaction_id));
}
public IHttpActionResult GetTransaction([FromUri] bool getTransaction, [FromUri] int Id)
{
var Transaction = (from p in _db.transaction_log
join t in _db.types on p.type_id equals t.typeID
join u in _db.users on p.user_id equals u.userID
where p.transaction_id == Id
select new SingleTransaction
{
transactionID = p.transaction_id,
spender = u.userID,
source = p.source,
amount = p.amount,
category = t.typeID,
date = p.date,
description = p.description,
reoccur = p.reoccuring
}).FirstOrDefault();
var DateModified = Transaction.date.ToString("MM-dd-yyyy");
var TransactionModified = new TransactionUpload()
{
transactionID = Transaction.transactionID,
spender = Transaction.spender,
source = Transaction.source,
amount = Transaction.amount,
category = Transaction.category,
date = DateModified,
description = Transaction.description,
reoccur = Transaction.reoccur
};
if (TransactionModified != null)
{
return(Ok(TransactionModified));
}
else
{
return(InternalServerError());
}
}
