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 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 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(); } }
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(); } }