public IActionResult InsertExpense([FromBody] ExpenseInsertViewModel newExpense)
{
using (var context = new EntityContext())
{
if (!Request.Headers.ContainsKey("email") && !Request.Headers.ContainsKey("email"))
{
return(Unauthorized());
}
if (!(CheckUser(Request.Headers["email"], Request.Headers["password"])))
{
return(Unauthorized());
}
//The line below clears and resets the databse.
//context.Database.EnsureDeleted();
// Create the database if it does not exist
context.Database.EnsureCreated();
User loggedUser = getLoggedUser(Request.Headers["email"], Request.Headers["password"]);
// Add some video games.
//Note that the Id field is autoincremented by default
var expense = new Expense();
expense.expense_name = newExpense.expense_name;
expense.expense_amount_TL = newExpense.expense_amount_TL;
expense.expense_amount_dollar = newExpense.expense_amount_dollar;
expense.expense_date = newExpense.expense_date;
expense.expense_explaination = newExpense.expense_explaination;
expense.whose_expense_name = newExpense.whose_expense_name;
expense.record_created_date = DateTime.Now;
expense.record_created_by_id = loggedUser.user_id;
//throw new Exception("Test Hatası");
context.Expense.Add(expense);
context.SaveChanges();
return(Json(expense));
}
}
public IActionResult ListExpense()
{
using (var context = new EntityContext())
{
/*if (!Request.Headers.ContainsKey("email")&&!Request.Headers.ContainsKey("email"))
* {
* return Unauthorized();
* }
* if (!(CheckUser(Request.Headers["email"], Request.Headers["password"])))
* {
* return Unauthorized();
* } */
var expenseViewModel = new ExpenseInsertViewModel();
/* var recordCreatedUser = (from a in context.Expense
* join b in context.Users on a.record_created_by_id equals b.user_id
* select new { a, b.user_name, b.user_surname });
*/
return(Json(context.Expense.OrderByDescending(x => x.expense_date).ToList()));
}
}
