public ActionResult Create([Bind(Include = "Id,Description,Amount,PaymentType,Date")] Transaction transaction)
{
transaction.Date = DateTime.Now;
if (ModelState.IsValid)
{
db.Transactions.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(transaction));
}
public IHttpActionResult PutCategory(int id, CategoryDetailsDto category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != category.ID)
{
return(BadRequest());
}
Category currentCategory = new Category
{
ID = category.ID,
Name = category.Name,
Description = category.Description,
PurchaseItems = category.PurchaseItems.Select(x => new PurchaseItem
{
ID = x.ID,
Amount = x.Amount,
Date = x.Date,
Comment = x.Comment,
CategoryID = x.CategoryID,
PurchaseLogID = x.PurchaseLogID
}).ToList()
};
db.Entry(currentCategory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public long?Save(TransferDto transfer)
{
if (transfer != null)
{
using (var context = new CashFlowContext())
{
if (transfer.Id.HasValue)
{
context.Transfer.Update(TransferMapper.Map(transfer));
}
else
{
Transfer transferMapped = TransferMapper.Map(transfer);
context.Transfer.Add(transferMapped);
transfer.Id = transferMapped.Id;
}
context.SaveChanges();
}
return(transfer.Id);
}
else
{
return(null);
}
}
public long?Save(TransferDto transfer)
{
if (transfer != null)
{
using (var context = new CashFlowContext())
{
if (transfer.Id.HasValue)
{
TransferSchema transferSchema = context.TransferSchema.SingleOrDefault(t => t.Id == transfer.Id);
if (transferSchema != null)
{
Transfer transferMapped = TransferPendingMapper.Map(transfer);
context.Transfer.Add(transferMapped);
transfer.Id = transferMapped.Id;
transferSchema.LastTransferDate = transferMapped.TransferDate;
context.TransferSchema.Update(transferSchema);
}
}
context.SaveChanges();
}
return(transfer.Id);
}
else
{
return(null);
}
}
public long?Save(AccountDto account)
{
if (account != null)
{
using (var context = new CashFlowContext())
{
if (account.Id.HasValue)
{
context.Account.Update(AccountMapper.Map(account));
}
else
{
Account accountMapped = AccountMapper.Map(account);
context.Account.Add(accountMapped);
account.Id = accountMapped.Id;
AccountBalance accountBalance = new AccountBalance();
accountBalance.AccountId = account.Id.Value;
accountBalance.Balance = 0;
accountBalance.StartDate = DateTime.Now;
context.AccountBalance.Add(accountBalance);
}
context.SaveChanges();
}
return(account.Id);
}
else
{
return(null);
}
}
public IHttpActionResult PutBudget(int id, [FromBody] BudgetDetailsDto budget)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!BudgetExists(id))
{
return(BadRequest());
}
Budget currentBudget = db.Budgets.Find(id);
if (id != currentBudget.ID)
{
return(BadRequest());
}
db.Entry(currentBudget).State = EntityState.Modified;
currentBudget = new Budget
{
ID = budget.ID,
Balance = budget.Balance,
PurchaseLogID = budget.PurchaseLogID
};
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BudgetExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutPurchaseItem(int id, PurchaseItemDetailsDto purchaseItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchaseItem.ID)
{
return(BadRequest());
}
PurchaseItem currentPurchaseItem = new PurchaseItem
{
ID = purchaseItem.ID,
Amount = purchaseItem.Amount,
Date = purchaseItem.Date,
Comment = purchaseItem.Comment,
CategoryID = purchaseItem.CategoryID,
PurchaseLogID = purchaseItem.PurchaseLogID
};
db.Entry(currentPurchaseItem).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutSaving(int id, SavingDetailsDto saving)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != saving.ID)
{
return(BadRequest());
}
Saving currentSaving = new Saving
{
ID = saving.ID,
Balance = saving.Balance,
GoalBalance = saving.GoalBalance,
Deadline = saving.Deadline,
Description = saving.Description,
PurchaseLogID = saving.PurchaseLogID
};
db.Entry(currentSaving).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SavingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Delete(long id)
{
using (var context = new CashFlowContext())
{
var transfer = context.Transfer.FirstOrDefault(t => t.Id == id);
if (transfer != null)
{
context.Remove(transfer);
context.SaveChanges();
}
}
}
public void Delete(long id)
{
using (var context = new CashFlowContext())
{
var Account = context.Account.FirstOrDefault(t => t.Id == id);
if (Account != null)
{
context.Remove(Account);
context.SaveChanges();
}
}
}
public IHttpActionResult PutPurchaseLog(int id, PurchaseLogDetailsDto purchaseLog)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchaseLog.ID)
{
return(BadRequest());
}
PurchaseLog currentPurchaseLog = new PurchaseLog
{
ID = purchaseLog.ID,
Name = purchaseLog.Name,
Budgets = purchaseLog.Budgets.Select(x => new Budget
{
ID = x.ID,
Balance = x.Balance,
PurchaseLogID = x.PurchaseLogID
}).ToList(),
Savings = purchaseLog.Savings.Select(x => new Saving
{
ID = x.ID,
Balance = x.Balance,
GoalBalance = x.GoalBalance,
Deadline = x.Deadline,
Description = x.Description,
PurchaseLogID = x.PurchaseLogID
}).ToList(),
PurchaseItems = purchaseLog.PurchaseItems.Select(x => new PurchaseItem
{
ID = x.ID,
Amount = x.Amount,
Date = x.Date,
Comment = x.Comment,
CategoryID = x.CategoryID,
PurchaseLogID = x.PurchaseLogID
}).ToList()
};
db.Entry(purchaseLog).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseLogExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
