public List <ExpenseEntity> QueryAll() { List <ExpenseEntity> expenses; using (ISession session = _inHibernateSession.OpenSession()) { expenses = session.Query <ExpenseEntity>().ToList(); } return(expenses); }
public IActionResult Create([FromBody] ExpenseInputModel expenseInputModels) { try { var expenseEntity = new ExpenseEntity(); expenseEntity.Account = expenseInputModels.Account; expenseEntity.Amount = expenseInputModels.Amount; expenseEntity.Category = expenseInputModels.Category; expenseEntity.ColorCode = expenseInputModels.ColorCode; expenseEntity.Date = expenseInputModels.Date; expenseEntity.Impulse = expenseInputModels.Impulse; expenseEntity.Memo = expenseInputModels.Memo; expenseEntity.Payee = expenseInputModels.Payee; expenseEntity.Repeat = expenseInputModels.Repeat; using (ISession session = _inHibernateSession.OpenSession()) { using (ITransaction transaction = session.BeginTransaction()) { session.Save(expenseEntity); transaction.Commit(); } } return(new JsonResult(expenseEntity)); } catch (Exception e) { return(new JsonResult(e)); } }
//ViewBag Message goes here public ActionResult Index() { IList <Expense> expenses; using (ISession session = _nHibernateSession.OpenSession()) { expenses = session.Query <Expense>().ToList(); } return(View(expenses)); }
public void Drop(int id) { using (ISession session = _inHibernateSession.OpenSession()) { var expense = session.Query <ExpenseEntity>(). Where(b => b.Id == id).FirstOrDefault(); if (expense == null) { throw new NotFoundException(); } else { using (ITransaction transaction = session.BeginTransaction()) { session.Delete(expense); transaction.Commit(); } } } }
public ExpenseEntity Modify(int id, [FromBody] ExpenseInputModel expenseInputModel) { using (ISession session = _inHibernateSession.OpenSession()) { var expenseEntity = session.Query <ExpenseEntity>().Where(b => b.Id == id).FirstOrDefault(); expenseEntity.Account = expenseInputModel.Account; expenseEntity.Category = expenseInputModel.Category; expenseEntity.ColorCode = expenseInputModel.ColorCode; expenseEntity.Memo = expenseInputModel.Memo; expenseEntity.Payee = expenseInputModel.Payee; expenseEntity.Amount = expenseInputModel.Amount; expenseEntity.Date = expenseInputModel.Date; expenseEntity.Impulse = expenseInputModel.Impulse; expenseEntity.Repeat = expenseInputModel.Repeat; expenseEntity.Repeat = expenseEntity.Repeat; using (ITransaction transaction = session.BeginTransaction()) { session.SaveOrUpdate(expenseEntity); transaction.Commit(); return(expenseEntity); } } }
public UoW(INHibernateSession nHibernateSession) { _session = nHibernateSession.OpenSession(); }