public ActionResult Search(HousekeepingBookModel model, string currentFilter) { var sessionData = HttpContextExtensionsAndHide.GetSessionData(); sessionData.SearchFilter = currentFilter; sessionData.SearchCategory = model.CategoryId; HttpContextExtensionsAndHide.SetSessionData(sessionData); return(RedirectToAction("Index")); }
public ActionResult SaveItem(HousekeepingBookModel model, string itemValue, string rowIndex) { var sessionData = HttpContextExtensionsAndHide.GetSessionData(); sessionData.MutationsList.Add(new Mutation4Item() { ItenNr = int.Parse(rowIndex) - 1, ItemValue = int.Parse(itemValue) }); HttpContextExtensionsAndHide.SetSessionData(sessionData); return(RedirectToAction("Index")); }
public ActionResult DisplayTable(int?Year) { var sessionData = HttpContextExtensionsAndHide.GetSessionData(); var initial = new SessionData { TransactionsFile = "NL97INGB0006166407_01-01-2018_31-12-2018.csv", SearchFilter = "", SearchCategory = -1, MutationsList = new List <Mutation4Item>() }; // string yearStr = Year.ToString(); // initial.TransactionsFile = initial.TransactionsFile.Replace("2018", yearStr); // sessionData.TransactionsFile = initial.TransactionsFile; // sessionData.SearchFilter = initial.SearchFilter; // sessionData.SearchCategory = initial.SearchCategory; // HttpContextExtensionsAndHide.SetSessionData(sessionData); HousekeepingBookModel model = new HousekeepingBookModel(); model.transactionsFile = ""; model.transactionList = new List <Transaction>(); model.sumList = (new List <TabelRow>()).ToPagedList(1, 3); model.itemList = new List <Item>(); model.errorList = new List <string>(); model.categoryList = new List <Category>(); model.unknownList = new List <Transaction>(); model.data = new List <int> { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 }; model.labels = new List <string> { "jan", "feb", "maart", "april", "mei", "juni", "juli", "aug", "sep", "okt", "nov", "dec" }; model.categorySelectList = new List <SelectListItem>(); return(PartialView("DisplayTable", model)); }
public ActionResult Authorise(HousekeepingBookModel model) { List <User> allowedUsers = new List <User> { new User { UserID = 1, UserName = "******", Password = "******" }, new User { UserID = 2, UserName = "******", Password = "******" }, new User { UserID = 3, UserName = "******", Password = "******" } }; //var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(allowedUsers, Newtonsoft.Json.Formatting.Indented); //System.IO.File.WriteAllText(Path.Combine(Server.MapPath("~/App_data"), "users.json"), jsonString); if (System.IO.File.Exists(Path.Combine(Server.MapPath("~/App_data"), "users.json"))) { var jsonString2 = System.IO.File.ReadAllText(Path.Combine(Server.MapPath("~/App_data"), "users.json")); allowedUsers = (List <User>)Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString2, typeof(List <User>)); } var userDetail = allowedUsers.Where(x => x.UserName == model.UserName && x.Password == Encrypt.EncryptString(model.Password, "Altran")).FirstOrDefault(); if (userDetail == null) { model.LoginErrorMsg = "Invalid UserName or Password"; return(View("Index", model)); } else { Session["userID"] = userDetail.UserID; Session["userName"] = userDetail.UserName; return(RedirectToAction("Index", "Home")); } }
public ViewResult Index(int?page1, int?page2, int?page3) { var sessionData = HttpContextExtensionsAndHide.GetSessionData(); if (sessionData == null) { HttpContextExtensionsAndHide.SetSessionData(new SessionData { TransactionsFile = "NL97INGB0006166407_01-01-2018_31-12-2018.csv", SearchFilter = "", SearchCategory = -1, MutationsList = new List <Mutation4Item>() }); } sessionData = HttpContextExtensionsAndHide.GetSessionData(); var dataModel = new DataModel(Server.MapPath("~/App_Data/uploads"), sessionData.TransactionsFile); dataModel.ProcessMutations(sessionData.MutationsList); dataModel.SetItem4Transactions(); dataModel.SetCategory4Transactions(); var maand_uit = dataModel.MaandUitgaven(); // --- var transactionsList = dataModel.TransactionsFilteredList; var itemsList = dataModel.ItemsList; string currentFilter = sessionData.SearchFilter; List <Transaction> processedTransactionList = new List <Transaction>(); processedTransactionList = transactionsList.Where(t => t.Naam_Omschrijving.Contains(currentFilter)).ToList(); int currentCategory = sessionData.SearchCategory; if ((currentCategory != -1) && (currentCategory != 0)) { processedTransactionList = processedTransactionList.Where(t => t.Item.CategoryId == currentCategory).ToList(); } // salaris niet steeds zichtbaar processedTransactionList = processedTransactionList.OrderByDescending(o => o.Bedrag).ToList(); List <Transaction> unknownTransactionList = new List <Transaction>(); unknownTransactionList = processedTransactionList.Where(t => t.Item.CategoryId == 1).OrderByDescending(o => o.Bedrag).ToList(); CultureInfo provider = new CultureInfo("nl-NL"); var transactionSumBij = transactionsList.Where(x => x.Af_Bij == "Bij").ToList().Sum(y => float.Parse(y.Bedrag, provider)); var transactionSumAf = transactionsList.Where(x => x.Af_Bij == "Af").ToList().Sum(y => float.Parse(y.Bedrag, provider)); var transactionSumSalaris = transactionsList.Where(x => (x.Af_Bij == "Bij" && (x.Naam_Omschrijving.Contains("TASS") || x.Naam_Omschrijving.Contains("Altran Netherlands") || x.Naam_Omschrijving.Contains("Altran BV") || x.Naam_Omschrijving.Contains("Nspyre B.V.")))).ToList().Sum(y => float.Parse(y.Bedrag, provider)); var transactionSumSavingBij = transactionsList.Where(t => t.Af_Bij == "Bij" && t.Category.CategoryStr == "sparen").ToList().Sum(y => float.Parse(y.Bedrag, provider)); var transactionSumSavingAf = transactionsList.Where(t => t.Af_Bij == "Af" && t.Category.CategoryStr == "sparen").ToList().Sum(y => float.Parse(y.Bedrag, provider)); List <TabelRow> sum = new List <TabelRow>(); sum.Add(new TabelRow { Column1 = "Bij", Column2 = transactionSumBij.ToString() }); sum.Add(new TabelRow { Column1 = "Af", Column2 = transactionSumAf.ToString() }); sum.Add(new TabelRow { Column1 = "Salary", Column2 = transactionSumSalaris.ToString() }); sum.Add(new TabelRow { Column1 = "Sparen", Column2 = (transactionSumSavingBij - transactionSumSavingAf).ToString() }); List <Item> processedItemList = new List <Item>(); processedItemList = itemsList; if ((currentCategory != -1) && (currentCategory != 0)) { processedItemList = processedItemList.Where(i => i.CategoryId == currentCategory).ToList(); } dataModel.Process4Totals(); HousekeepingBookModel model = new HousekeepingBookModel(); int pagenr1 = (page1 ?? 1); int pagenr2 = (page2 ?? 1); int pagenr3 = (page3 ?? 1); model.transactionsFile = Path.GetFileName(sessionData.TransactionsFile); model.transactionList = processedTransactionList; model.sumList = sum.ToPagedList(pagenr2, 3); model.itemList = processedItemList; model.errorList = dataModel.ErrorsList; model.categoryList = dataModel.CategoriesList; model.unknownList = unknownTransactionList; model.data = maand_uit; model.labels = new List <string> { "jan", "feb", "maart", "april", "mei", "juni", "juli", "aug", "sep", "okt", "nov", "dec" }; model.categorySelectList = new List <SelectListItem>(); foreach (var o in dataModel.CategoriesList) { SelectListItem sli = new SelectListItem { Text = o.CategoryStr, Value = o.CategoryId.ToString(), Selected = false }; model.categorySelectList = model.categorySelectList.Concat(new [] { sli }); } model.CategoryId = sessionData.SearchCategory; return(View(model)); }