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