// GET: api/Home_Expenses/5
public Home_Expenses Get(int id)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
return(entities.Home_Expenses.FirstOrDefault(e => e.ID_Home_Expense == id));
}
}
// GET: api/Home_Expenses
public IEnumerable <Home_Expenses> Get()
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
return(entities.Home_Expenses.ToList());
}
}
// GET: api/Expense_Detail/5
public Expense_Detail Get(int id)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
return(entities.Expense_Detail.FirstOrDefault(e => e.ID_Expense_Detail == id));
}
}
// GET: api/Expense_Detail
public IEnumerable <Expense_Detail> Get()
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
return(entities.Expense_Detail.ToList());
}
}
// POST: api/Home_Expenses
public void Post([FromBody] Home_Expenses value)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
entities.Home_Expenses.Add(value);
entities.SaveChanges();
}
}
// POST: api/Expense_Detail
public void Post([FromBody] Expense_Detail value)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
entities.Expense_Detail.Add(value);
entities.SaveChanges();
}
}
// PUT: api/Home_Expenses/5
public void Put(int id, [FromBody] Home_Expenses value)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
if (value.ID_Home_Expense == id)
{
entities.Entry(value).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}
}
// DELETE: api/Home_Expenses/5
public void Delete(int id)
{
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
var temp = entities.Home_Expenses.FirstOrDefault(e => e.ID_Home_Expense == id);
if (temp.ID_Home_Expense == id)
{
entities.Home_Expenses.Remove(temp);
entities.SaveChanges();
}
}
}
public decimal GetMax()
{
decimal total = 0;
using (FinancesChallengeDBEntities entities = new FinancesChallengeDBEntities())
{
foreach (var e in entities.Expense_Detail.ToList())
{
total += e.Spent_Money;
}
}
return(total);
}
