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