public static ExpenseDetailsResponse GetExpenseDetails(ExpenseDetailsRequest request) //Get Details for a specific Expense { int ExpenseID = request.ExpenseID; var response = new ExpenseDetailsResponse(); var expense = new ExpenseDomain(); using (var entities = new ExpenseProjectDBEntities()) { expense = (from e in entities.Expenses where (e.ID == ExpenseID) select new ExpenseDomain { ID = e.ID, TotalAmount = e.TotalAmount, CreatedDate = e.CreatedDate, CreatedUserID = e.Created_User, StatusID = e.StatusId, ModifiedByID = e.ModifiedBy, ModifiedDate = e.ModifiedDate, RejectDescription = e.RejectDescription } ).FirstOrDefault(); response.ExpenseInformation = expense; response.ExpenseItemList = GetExpenseItems(request); return(response); } }
public IHttpActionResult GetExpensesByExpenseID(ExpenseDetailsRequest request) { if (!ModelState.IsValid) { return(BadRequest()); } var response = ExpenseHandler.GetExpenseDetails(request); return(Ok(response)); }
public static List <ExpenseItemDomain> GetExpenseItems(ExpenseDetailsRequest request) //Get all Expense Items of one Expense { int ExpenseID = request.ExpenseID; List <ExpenseItemDomain> response = new List <ExpenseItemDomain>(); using (var entities = new ExpenseProjectDBEntities()) { response = (from e in entities.ExpenseItems where (e.ExpenseId == ExpenseID) select new ExpenseItemDomain { ExpenseItemID = e.ID, ExpenseItemDescription = e.ExpenseDescription, ExpenseItemAmount = e.ExpenseAmount, ExpenseItemDate = e.ExpenseDate } ).ToList(); return(response); } }