/** * TODO: Refactor */ public ActionResult AddFile(HttpPostedFileBase file) { // Get the current resource root file string resourceFileLocation = ConfigurationManager.BaseLocation + ConfigurationManager.FileName; TransactionAdapterType type = ConfigurationManager.FileType; // Push some data to the view ViewData["ResourceFolder"] = resourceFileLocation; ViewData["ResourceType"] = type.ToString(); ViewData["NumRecords"] = RecordRetriever.GetAllBankRecords().Count(); ViewData["NumLines"] = System.IO.File.ReadLines(resourceFileLocation).Count(); // Save the uploaded file to the /Uploaded/ dir string path = System.IO.Path.Combine(ConfigurationManager.BaseLocation, "Uploaded/" + DateTime.Now.Ticks + "_" + System.IO.Path.GetFileName(file.FileName)); file.SaveAs(path); // Some more data on the new file ViewData["NewFileNumLines"] = System.IO.File.ReadLines(path).Count(); ViewData["NewFileNumRecords"] = RecordRetriever.GetBankRecordsByUploadPerUser(path, User.Identity.Name); // Merge uploaded file with the root file (which will make an automatic back-up as well) CSVMerger.MergeFiles(resourceFileLocation, path); // And some more data on the merged files ViewData["CombinedFileNumLines"] = System.IO.File.ReadLines(resourceFileLocation).Count(); ViewData["CombinedFileNumRecords"] = RecordRetriever.GetBankRecordsByUser(User.Identity.Name); return(View()); }
public ActionResult Index() { string resourceFileLocation = ConfigurationManager.BaseLocation + ConfigurationManager.FileName; ViewData["ResourceFolder"] = resourceFileLocation; ViewData["ResourceType"] = ConfigurationManager.FileType; ViewData["NumRecords"] = RecordRetriever.GetAllBankRecords().Count(); ViewData["NumLines"] = System.IO.File.ReadLines(resourceFileLocation).Count(); ViewData["LastUpdate"] = System.IO.File.GetLastWriteTime(resourceFileLocation); // Get all file names in the root file directory // TODO Use Path or something to properly extract the filename ViewData["RootFiles"] = System.IO.Directory.EnumerateFiles(ConfigurationManager.BaseLocation).Select(r => r.Substring(r.LastIndexOf('/') + 1)); return(View()); }
public ActionResult Charts() { IEnumerable <BankRecord> selection = RecordRetriever.GetAllBankRecords(); IOrderedEnumerable <IGrouping <string, BankRecord> > monthly = selection.GroupBy(r => new TimePeriodGroup(r.RequestDate).ToString()).OrderBy(r => r.Key); ChartDataSummary cds = new ChartDataSummary() { AllTransactions = ChartData.GetAllTransactionData(selection), MonthlySpending = ChartData.GetMonthlySpending(monthly), MonthlySpendingCumulative = ChartData.GetMonthlySpendingCumulative(monthly), MonthlySpending2011 = ChartData.GetAnnualSpending(selection.Where(r => r.RequestDate.Year.Equals(2011))), MonthlySpending2012 = ChartData.GetAnnualSpending(selection.Where(r => r.RequestDate.Year.Equals(2012))) }; return(View(cds)); }
public ActionResult Types() { IOrderedEnumerable <IGrouping <string, BankRecord> > selection = RecordRetriever.GetAllBankRecords().GroupBy(r => r.Category.ToString()).OrderByDescending(g => g.Sum(r => r.Amount)); return(View(selection)); }
public ActionResult Recent() { IEnumerable <BankRecord> rec = RecordRetriever.GetAllBankRecords(); return(View(rec.Where(r => r.RequestDate.AddDays(7).CompareTo(rec.OrderByDescending(a => a.RequestDate).First().RequestDate) > 0))); }
public ActionResult PoS() { IEnumerable <BankRecord> selection = RecordRetriever.GetAllBankRecords().Where(r => r.Description.Contains("Betaalautomaat")); return(View(selection)); }
public ActionResult Monthly() { IOrderedEnumerable <IGrouping <string, BankRecord> > selection = RecordRetriever.GetAllBankRecords().GroupBy(r => new TimePeriodGroup(r.RequestDate).ToString()).OrderByDescending(r => r.Key); return(View(selection)); }
public ActionResult Details(string name) { IEnumerable <BankRecord> selection = RecordRetriever.GetAllBankRecords().Where(r => r.Name.ToLower().Contains(name.ToLower())); return(View(selection)); }
public ActionResult All() { IEnumerable <BankRecord> selection = RecordRetriever.GetAllBankRecords(); return(View(selection)); }