public static IEnumerable <Budget> GetBudgetList()
{
using (var db = new BIMFall4Context())
{
return(db.Budgets.ToList());
}
}
static public IEnumerable <User> SearchByFirstName(string firstName)
{
using (var db = new BIMFall4Context())
{
return(db.Users.Where(user => user.FirstName == firstName));
}
}
public static IEnumerable <Income> GetIncomeList()
{
using (var db = new BIMFall4Context())
{
return(db.Incomes.ToList());
}
}
public static IEnumerable <SavingGoal> GetSavingGoalList()
{
using (var db = new BIMFall4Context())
{
return(db.SavingGoals.ToList());
}
}
public static IEnumerable <Expense> GetExpenseList()
{
using (var db = new BIMFall4Context())
{
return(db.Expenses.ToList());
}
}
static public User GetUserByEmail(string email)
{
using (var db = new BIMFall4Context())
{
return(GetUserByEmail(email, db));
}
}
public static IEnumerable <Income> GetIncomeById(int id)
{
using (var db = new BIMFall4Context())
{
var income = db.Incomes.Where(x => x.UserID == id).ToList();
return(income);
}
}
public static void CreateIncome(Income income)
{
using (BIMFall4Context db = new BIMFall4Context())
{
db.Incomes.Add(income);
db.SaveChanges();
}
}
static public void CreateUser(User user)
{
using (var db = new BIMFall4Context())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public static void CreateExpense(Expense expense)
{
using (var db = new BIMFall4Context())
{
db.Expenses.Add(expense);
db.SaveChanges();
}
}
public static IEnumerable <SavingGoal> getSavingGoalById(int id)
{
using (var db = new BIMFall4Context())
{
var saving = db.SavingGoals.Where(x => x.UserID == id).ToList();
return(saving);
}
}
public static void CreateSavingGoal(SavingGoal savingGoal)
{
using (var db = new BIMFall4Context())
{
db.SavingGoals.Add(savingGoal);
db.SaveChanges();
}
}
public static IEnumerable <Expense> GetExpensesById(int id)
{
using (var db = new BIMFall4Context())
{
var expense = db.Expenses.Where(x => x.UserID == id).ToList();
return(expense);
}
}
public static IEnumerable <Budget> GetBudgetById(int id)
{
using (var db = new BIMFall4Context())
{
var budget = db.Budgets.Where(x => x.UserID == id).ToList();
return(budget);
}
}
public static void CreateBudget(Budget budget)
{
using (var db = new BIMFall4Context())
{
db.Budgets.Add(budget);
db.SaveChanges();
}
}
static public User GetSafeUserByID(int id)
{
using (var db = new BIMFall4Context())
{
var SafeUser = db.Users.Find(id);
//SafeUser.Password = "";
return(SafeUser);
}
}
public static void DeleteSavingGoal(int id)
{
using (var db = new BIMFall4Context())
{
if (db.SavingGoals.Find(id) != null)
{
db.SavingGoals.Remove(db.SavingGoals.Find(id));
db.SaveChanges();
}
}
}
public static void DeleteIncome(int id)
{
using (BIMFall4Context db = new BIMFall4Context())
{
if (db.Incomes.Find(id) != null)
{
db.Incomes.Remove(db.Incomes.Find(id));
db.SaveChanges();
}
}
}
static public void RemoveUser(int id)
{
using (var db = new BIMFall4Context())
{
if (db.Users.Find(id) != null)
{
db.Users.Remove(db.Users.Find(id));
db.SaveChanges();
}
}
}
static public UserDTO GetUserById(int id)
{
using (var db = new BIMFall4Context())
{
var user = db.Users.FirstOrDefault(x => x.ID == id);
//var user = db.Users.Where(s => s.ID == id).Include(u => u.Pendings).FirstOrDefault()
var userdto = new UserDTO
{
ID = user.ID,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
};
return(userdto);
}
}
static public Response GetLoginResponse(User value)
{
using (var db = new BIMFall4Context())
{
var user = db.Users.Where(x => x.Email.Equals(value.Email) && x.Password.Equals(value.Password)).FirstOrDefault();
if (user == null)
{
return new Response {
Status = "Invalid", Message = "Invalid User."
}
}
;
else
{
return new Response {
Status = "Success", Message = "Login Successfully", UserID = user.ID
}
};
}
}
}
public static IEnumerable <BudgetDTO> GetBudgetDtoById(int id)
{
using (var db = new BIMFall4Context())
{
var bud = db.Budgets.Where(x => x.UserID == id).ToList();
var budgetlist = new List <BudgetDTO>();
foreach (var item in bud)
{
budgetlist.Add(new BudgetDTO
{
ID = item.ID,
Category = item.Category,
Amount = item.Amount,
Date = item.Date
});
}
return(budgetlist);
}
}
public static IEnumerable <IncomeDTO> GetIncomeDtoById(int id)
{
using (var db = new BIMFall4Context())
{
var inc = db.Incomes.Where(x => x.UserID == id).ToList();
var incomelist = new List <IncomeDTO>();
foreach (var item in inc)
{
incomelist.Add(new IncomeDTO
{
ID = item.ID,
Amount = item.Amount,
Name = item.Name,
Date = item.Date
});
}
return(incomelist);
}
}
public static IEnumerable <SavingGoalDTO> GetSavingGoalDtoById(int id)
{
using (var db = new BIMFall4Context())
{
var goal = db.SavingGoals.Where(x => x.UserID == id).ToList();
var goallist = new List <SavingGoalDTO>();
foreach (var item in goal)
{
goallist.Add(new SavingGoalDTO
{
ID = item.ID,
ReachDate = item.ReachDate,
StartDate = item.StartDate,
Amount = item.Amount,
Name = item.Name
});
}
return(goallist);
}
}
public static IEnumerable <ExpenseDTO> GetExpenseDtoById(int id)
{
using (var db = new BIMFall4Context())
{
var exp = db.Expenses.Where(x => x.UserID == id).ToList();
var expenselist = new List <ExpenseDTO>();
foreach (var item in exp)
{
expenselist.Add(new ExpenseDTO
{
ID = item.ID,
Name = item.Name,
Category = item.Category,
Date = item.Date,
Amount = item.Amount
});
}
return(expenselist);
}
}
static public User GetUserByEmail(string email, BIMFall4Context db)
{
return(db.Users.Where(user => user.Email == email).FirstOrDefault());
}
