public static ExpenseResponse GetAllExpenses(GetExpensesRequest request) //Get all Expense Information regarding that User
{
ExpenseResponse response = new ExpenseResponse();
using (var entities = new ExpenseProjectDBEntities())
{
response.ExpenseList = (from e in entities.Expenses
join u in entities.Users on e.Created_User equals u.ID
join s in entities.ExpenseStatuses on e.StatusId equals s.ID
where ((e.Created_User == request.UserID && request.RoleID == 1) ||
(e.StatusId == 2 && request.RoleID == 2) ||
(e.StatusId == 3 && request.RoleID == 3))
select new ExpenseDomain
{
ID = e.ID,
TotalAmount = e.TotalAmount,
CreatedDate = e.CreatedDate,
CreatedUserID = e.Created_User,
CreatedUserName = u.Name,
CreatedUserSurname = u.Surname,
StatusID = e.StatusId,
StatusName = s.StatusDescription,
ModifiedByID = e.ModifiedBy,
ModifiedDate = e.ModifiedDate,
RejectDescription = e.RejectDescription
}
).ToList();
List <ExpenseDomain> expenses = new List <ExpenseDomain>();
return(response);
}
}
public async Task <IActionResult> GetAllExpenses([FromQuery] GetExpensesRequest request)
{
var response = await this.mediator.Send(request);
return(this.Ok(response));
}
public ExpenseResponse GetExpensesByUserID(GetExpensesRequest request)
{
return(ExpenseHandler.GetAllExpenses(request));
}
