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 Delete(int id) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User u = db.Users.Find(id); db.Users.Add(u); db.SaveChanges(); }
public void unSlect(int Bid, int uid) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget b = db.Budgets.Find(Bid); b.isCurrent = false; db.SaveChanges(); }
public void SaveEditProfile(User u,int loggedInUserId) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User loggedInUser = db.Users.Find(loggedInUserId); if (u.Name != null) loggedInUser.Name = u.Name; if (u.Email != null) loggedInUser.Email = u.Email; if (u.password != null) loggedInUser.password = u.password; db.SaveChanges(); }
public void Slect(int Bid, int uid) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget AlreadySelectedBudget = null; User u = db.Users.Find(uid); foreach (Budget curr in u.Budgets) { if (curr.isCurrent == true) { AlreadySelectedBudget = curr; } } if (AlreadySelectedBudget != null) { AlreadySelectedBudget.isCurrent = false; db.SaveChanges(); } Budget B = db.Budgets.Find(Bid); B.isCurrent = true; 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 DeleteBudget(int id) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget b = db.Budgets.Find(id); List<ExpenseCatagory> catagories = new List<ExpenseCatagory>(); foreach (ExpenseCatagory c in b.ExpenseCatagories) { catagories.Add(c); } foreach (ExpenseCatagory c in catagories) { db.ExpenseCatagories.Remove(c); } db.Budgets.Remove(b); db.SaveChanges(); }
public void DeleteBudget(int id) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget b = db.Budgets.Find(id); List <ExpenseCatagory> catagories = new List <ExpenseCatagory>(); foreach (ExpenseCatagory c in b.ExpenseCatagories) { catagories.Add(c); } foreach (ExpenseCatagory c in catagories) { db.ExpenseCatagories.Remove(c); } db.Budgets.Remove(b); db.SaveChanges(); }
public bool SaveUser(User u) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User Authentic_user = null; bool isExist = IsAlreadyExist(u.Email); //This means user not already exist in database if (isExist == false) { Authentic_user = u; } if (Authentic_user != null && u != null) { db.Users.Add(u); db.SaveChanges(); return true; } return false; }
public void SaveEditProfile(User u, int loggedInUserId) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User loggedInUser = db.Users.Find(loggedInUserId); if (u.Name != null) { loggedInUser.Name = u.Name; } if (u.Email != null) { loggedInUser.Email = u.Email; } if (u.password != null) { loggedInUser.password = u.password; } db.SaveChanges(); }
public bool SaveUser(User u) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User Authentic_user = null; bool isExist = IsAlreadyExist(u.Email); //This means user not already exist in database if (isExist == false) { Authentic_user = u; } if (Authentic_user != null && u != null) { db.Users.Add(u); db.SaveChanges(); return(true); } return(false); }
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 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 unSlect(int Bid,int uid) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget b = db.Budgets.Find(Bid); b.isCurrent = false; db.SaveChanges(); }
public void Slect(int Bid,int uid) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); Budget AlreadySelectedBudget = null; User u = db.Users.Find(uid); foreach (Budget curr in u.Budgets) { if (curr.isCurrent == true) AlreadySelectedBudget = curr; } if (AlreadySelectedBudget != null) { AlreadySelectedBudget.isCurrent = false; db.SaveChanges(); } Budget B = db.Budgets.Find(Bid); B.isCurrent = true; db.SaveChanges(); }