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