public ActionResult DeleteConfirmed(int id)
{
UploadedTransaction uploadedTransaction = db.UploadedTransactions.Find(id);
db.UploadedTransactions.Remove(uploadedTransaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Description,Amount,Created,Saved,UploadDateTime,BankAccountId,IncomeExpenseId")] UploadedTransaction uploadedTransaction)
{
if (ModelState.IsValid)
{
db.Entry(uploadedTransaction).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BankAccountId = new SelectList(db.BankAccounts, "Id", "Name", uploadedTransaction.BankAccountId);
ViewBag.IncomeExpenseId = new SelectList(db.IncomeExpenses, "Id", "Type", uploadedTransaction.IncomeExpenseId);
return(View(uploadedTransaction));
}
// GET: UploadedTransactions/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UploadedTransaction uploadedTransaction = db.UploadedTransactions.Find(id);
if (uploadedTransaction == null)
{
return(HttpNotFound());
}
return(View(uploadedTransaction));
}
// GET: UploadedTransactions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UploadedTransaction uploadedTransaction = db.UploadedTransactions.Find(id);
if (uploadedTransaction == null)
{
return(HttpNotFound());
}
ViewBag.BankAccountId = new SelectList(db.BankAccounts, "Id", "Name", uploadedTransaction.BankAccountId);
ViewBag.IncomeExpenseId = new SelectList(db.IncomeExpenses, "Id", "Type", uploadedTransaction.IncomeExpenseId);
return(View(uploadedTransaction));
}
public ActionResult UploadTransactions(HttpPostedFileBase uploadedFile, int BankAccountId)
{
var filePath = csvHelper.UploadCsv(uploadedFile);
if (filePath == "")
{
return(View("Error", "Shared"));
}
var csvFile = csvHelper.ReadCsv(filePath);
//var csvFile = csvHelper.ReadNotSaveCsv(uploadedFile);
var nowDateTime = DateTimeOffset.Now;
TempData["NowDateTime"] = nowDateTime;
var expId = db.IncomeExpenses.FirstOrDefault(ie => ie.Type == "Expense").Id;
var incId = db.IncomeExpenses.FirstOrDefault(ie => ie.Type == "Income").Id;
UploadedTransaction upTran;
foreach (var line in csvFile)
{
var alreadySaved = db.UploadedTransactions.AsNoTracking().FirstOrDefault(up => up.Created == line.Date && up.Description == line.Description && up.Amount == line.Amount);
if (alreadySaved == null)
{
upTran = new UploadedTransaction();
upTran.Amount = line.Amount;
upTran.Description = line.Description;
upTran.Created = line.Date;
upTran.BankAccountId = BankAccountId;
upTran.UploadDateTime = nowDateTime;
upTran.Saved = false;
if (upTran.Amount < 0)
{
upTran.IncomeExpenseId = expId;
}
else
{
upTran.IncomeExpenseId = incId;
}
db.UploadedTransactions.Add(upTran);
db.SaveChanges();
}
}
TempData["CsvData"] = csvFile.OrderByDescending(x => x.Date).ToList();
csvHelper.DeleteCsv(filePath);
//User and household validation stuff
//Populate Viewbag data
if (!userHelper.UserHasEverything())
{
TempData["Error"] = "You must have a household, budget, and bank account(s) first!";
return(RedirectToAction("ErrorPage", "Home"));
}
var user = db.Users.Find(User.Identity.GetUserId());
var budget = new Budget();
var ExpenseId = db.IncomeExpenses.FirstOrDefault(i => i.Type == "Expense").Id;
if (user != null && user.HouseholdId != null)
{
ViewBag.hId = user.HouseholdId;
budget = db.Budgets.FirstOrDefault(b => b.HouseholdId == user.HouseholdId);
ViewBag.BankAccountId = new SelectList(db.BankAccounts.Where(a => a.HouseholdId == user.HouseholdId).ToList(), "Id", "Name");
if (budget != null)
{
var budgetItemList = budget.BudgetItems.ToList();
var item = budgetItemList[0];
ViewBag.BudgetItemList = new SelectList(budgetItemList, "Id", "Name");
}
}
ViewBag.BankAccountId = new SelectList(db.BankAccounts, "Id", "Name", BankAccountId);
ViewBag.SelectedBankAccountId = BankAccountId;
ViewBag.BankAccountName = db.BankAccounts.FirstOrDefault(ba => ba.Id == BankAccountId).Name;
ViewBag.IncomeExpenseId = new SelectList(db.IncomeExpenses, "Id", "Type", ExpenseId);
//return RedirectToAction("ReadCSV", new { CsvFile = filePath });
var transList = db.UploadedTransactions.Where(t => !t.Saved).OrderByDescending(x => x.Created).ToList();
return(View(transList));
}
