public IEnumerable <string> GetIncomeCategories()
{
using (var context = new ExpenseEntities())
{
var result = context.Incomecategory.Select(x => x.CategoryName).ToList();
return(result);
}
}
public bool UserExists(string name)
{
using (var context = new ExpenseEntities())
{
var result = context.Users.Any(x => x.Name == name);
return(result);
}
}
public int GetUserID(string name)
{
using (var context = new ExpenseEntities())
{
var result = context.Users.Where(x => x.Name == name).Select(x => x.Id).FirstOrDefault();
return(Convert.ToInt32(result));
}
}
public bool ValidateUser(string name, string password)
{
using (var context = new ExpenseEntities())
{
var result = context.Users.Any(x => x.Name == name && x.Password == password);
return(result);
}
}
public List <ExpenseBO> GetAllExpenses()
{
using (var context = new ExpenseEntities())
{
var result = context.Expenses.Select(x => new ExpenseBO {
Category = x.Category.CategoryName, Desc = x.Description, Date = x.Date, Price = x.Price
}).ToList();
return(result);
}
}
public void CreateNewCategory(string name)
{
using (var context = new ExpenseEntities())
{
ExpenseCategory category = new ExpenseCategory()
{
CategoryName = name
};
context.ExpenseCategory.Add(category);
context.SaveChanges();
}
}
public void CreateNewUser(string name, string password)
{
using (var context = new ExpenseEntities())
{
Users user = new Users()
{
Name = name, Password = password
};
context.Users.Add(user);
context.SaveChanges();
}
}
public List <ExpenseBO> SumMonthlyExpanses()
{
using (var context = new ExpenseEntities())
{
var result = context.Expenses
.GroupBy(g => new { g.Date.Month, g.Date.Year })
.Select(g => new ExpenseBO {
Month = g.Key.Month, Price = g.Sum(x => x.Price)
}).ToList();
return(result);
}
}
public void CreateNewExpense(string description, DateTime date, string category, decimal price)
{
using (var context = new ExpenseEntities())
{
ExpenseCategory cat = context.ExpenseCategory.Where(x => x.CategoryName == category).FirstOrDefault();
Expenses expense = new Expenses()
{
Description = description, Date = date, Price = price, Category = cat, Users_ID = Global.UserID
};
context.Expenses.Add(expense);
context.SaveChanges();
}
}