public void AddBudgetFromFile(String path,int UserId) { FileStream fs = new FileStream(path, FileMode.Open); StreamReader sr = new StreamReader(fs); String name = sr.ReadLine(); String StartDate = sr.ReadLine(); String endDate = sr.ReadLine(); String Income = sr.ReadLine(); String ExpCatagories = sr.ReadLine(); String ExpCatagoriesRanges = sr.ReadLine(); sr.Close(); fs.Close(); Budget b = new Budget(); b.Name = name; b.UID = UserId; b.StartDate = DateTime.ParseExact(StartDate, "dd/MM/yyyy", null); b.EndDate = DateTime.ParseExact(endDate, "dd/MM/yyyy", null); b.Income = Int32.Parse(Income); b.isCurrent = true; MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget AlreadySelectedBudget = null; foreach (Budget curr in db.Budgets) { if (curr.isCurrent == true) AlreadySelectedBudget = curr; } if (AlreadySelectedBudget != null) { AlreadySelectedBudget.isCurrent = false; db.SaveChanges(); } db.Budgets.Add(b); db.SaveChanges(); String [] catagories = ExpCatagories.Split(','); String[] catagoriesRanges = ExpCatagoriesRanges.Split(','); ExpenseCatagory Bcatagory = new ExpenseCatagory(); for (int i = 0; i < catagories.Length; i++ ) { Bcatagory.BID = b.BID; Bcatagory.CatName = catagories[i]; Bcatagory.CatRange = Int32.Parse(catagoriesRanges[i]); Bcatagory.Rangepercentage = ( (Bcatagory.CatRange / b.Income) * 100 ); Bcatagory.ExpensesSum = 0; db.ExpenseCatagories.Add(Bcatagory); db.SaveChanges(); } }
public ActionResult SaveBudget() { if (Session["key"] != null) { Budget b = new Budget(); b.Name = Request["Budget_name"].ToString(); b.Income = Int32.Parse(Request["income"]); b.UID = (int)Session["key"]; String catagories = Request["catagories"].ToString(); String ranges = Request["Ranges"].ToString(); String StartDate = Request["SDate"].ToString(); String EndDate = Request["EDate"].ToString(); b.StartDate = DateTime.ParseExact(StartDate, "MM/dd/yyyy", null); b.EndDate = DateTime.ParseExact(EndDate, "MM/dd/yyyy", null); budget.SaveBudget(b,catagories,ranges); return Redirect("/Budget/Index"); } else { return Redirect("/Account/Login"); } }
public void saveExpense(Expens exp,String catName,int UserID) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User u = db.Users.Find(UserID); Budget SelectedBudget = new Budget(); foreach (Budget b in u.Budgets) { if (b.isCurrent == true) { exp.BID = b.BID; SelectedBudget = b; } } foreach(ExpenseCatagory expCat in SelectedBudget.ExpenseCatagories) { if (expCat.CatName == catName) { exp.ExpCat = expCat.ExpCatId; } } db.Expenses.Add(exp); db.SaveChanges(); }
public void SaveBudget(Budget b, String catagories, String ranges) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); db.Budgets.Add(b); db.SaveChanges(); String[] catagoriesList = catagories.Split(','); String[] rangesList = ranges.Split(','); Budget currBudget = db.Budgets.Find(b.BID); for (int i = 0; i < catagoriesList.Length; i++) { ExpenseCatagory cat = new ExpenseCatagory(); cat.BID = b.BID; cat.CatName = catagoriesList[i]; cat.CatRange = Int32.Parse(rangesList[i]); cat.Rangepercentage = ((cat.CatRange / currBudget.Income) * 100); cat.ExpensesSum = 0; db.ExpenseCatagories.Add(cat); db.SaveChanges(); } }