コード例 #1
0
        // GET: Expenses/Report/5
        public async Task<ActionResult> ViewReport(int? id)
        {
            var employee = await this.GetEmployee();
            var employeeId = employee.Item1;
            ViewBag.UserName = employee.Item2;

            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            DbExpenseReport dbReport = await db.Reports.FindAsync(id);
            if (dbReport == null)
            {
                return HttpNotFound();
            }

            var associatedCharges = await db.Charges
                .Where(c => c.EmployeeId == employeeId && c.ExpenseReportId.HasValue && c.ExpenseReportId.Value == id)
                .ToListAsync();

            var outstandingCharges = await db.Charges
                .Where(c => c.EmployeeId == employeeId && !c.ExpenseReportId.HasValue)
                .ToListAsync();

            var report = new ExpenseReportModel(dbReport);
            report.EmployeeId = employeeId;
            report.AssociatedCharges = associatedCharges.Select(c => new ChargeModel(c)).ToList();
            report.OutstandingCharges = outstandingCharges.Select(c => new ChargeModel(c)).ToList();

            return View(report);
        }
コード例 #2
0
        public async Task<ActionResult> NewReport(
            ExpenseReportModel expenseReportModel,
            string associatedChargesIds,
            string outstandingChargesIds,
            int? addCharge,
            int? removeCharge)
        {
            var employee = await db.Employees.FirstOrDefaultAsync(e => e.Alias == ExpensesDemoData.DefaultEmployeeAlias);
            var employeeId = employee.EmployeeId;
            ViewBag.UserName = employee.Name;

            expenseReportModel.AssociatedCharges = await GetChargesFromSerializedIdList(associatedChargesIds, employeeId);
            expenseReportModel.OutstandingCharges = await GetChargesFromSerializedIdList(outstandingChargesIds, employeeId);

            if (addCharge.HasValue)
            {
                // the request was to add a charge to the report
                ReplaceChargeObjectBetweenLists(addCharge.Value, expenseReportModel.OutstandingCharges, expenseReportModel.AssociatedCharges);
            }
            else if (removeCharge.HasValue)
            {
                // the request was to remove a charge from the report
                ReplaceChargeObjectBetweenLists(removeCharge.Value, expenseReportModel.AssociatedCharges, expenseReportModel.OutstandingCharges);
            }
            else
            {
                // Submit request
                if (ModelState.IsValid)
                {
                    expenseReportModel.EmployeeId = employeeId;
                    var dbExpenseReport = new DbExpenseReport()
                        {
                            Amount = expenseReportModel.Amount,
                            Approver = expenseReportModel.Approver,
                            Charges = expenseReportModel.AssociatedCharges.Select(c => c.ConvertToDbCharge(employeeId)).ToList(),
                            CostCenter = expenseReportModel.CostCenter,
                            DateResolved = expenseReportModel.DateResolved,
                            DateSubmitted = expenseReportModel.DateSubmitted,
                            Employee = employee,
                            EmployeeId = expenseReportModel.EmployeeId,
                            ExpenseReportId = expenseReportModel.Id,
                            Notes = expenseReportModel.Notes,
                            Status = (DbExpenseReportStatus)expenseReportModel.Status,
                        };
                    db.Reports.Add(dbExpenseReport);
                    await db.SaveChangesAsync();

                    // add charges to report
                    foreach (var c in expenseReportModel.AssociatedCharges)
                    {
                        var dbCharge = await db.Charges.FindAsync(c.Id);
                        dbCharge.ExpenseReportId = dbExpenseReport.ExpenseReportId;
                        db.Entry(dbCharge).State = EntityState.Modified;
                    }

                    await db.SaveChangesAsync();

                    return RedirectToAction("Report", new { id = dbExpenseReport.ExpenseReportId });
                }
            }

            // This is required to update hidden fields in the view.
            ModelState.Clear();

            // Recalculate the total expense amount, since we have added or removed some charges.
            expenseReportModel.Amount = expenseReportModel.AssociatedCharges.Sum(c => c.BilledAmount);

            return View(expenseReportModel);
        }
コード例 #3
0
        public async Task<ActionResult> Report(
            ExpenseReportModel expenseReportModel,
            string associatedChargesIds,
            string outstandingChargesIds,
            string command,
            int? addCharge,
            int? removeCharge)
        {
            var employee = await db.Employees.FirstOrDefaultAsync(e => e.Alias == ExpensesDemoData.DefaultEmployeeAlias);
            var employeeId = employee.EmployeeId;
            ViewBag.UserName = employee.Name;

            expenseReportModel.AssociatedCharges = await GetChargesFromSerializedIdList(associatedChargesIds, employeeId);
            expenseReportModel.OutstandingCharges = await GetChargesFromSerializedIdList(outstandingChargesIds, employeeId);

            if (addCharge.HasValue)
            {
                // the request was to add a charge to the report
                ReplaceChargeObjectBetweenLists(addCharge.Value, expenseReportModel.OutstandingCharges, expenseReportModel.AssociatedCharges);
                expenseReportModel.HasUnsavedChanges = true;
            }
            else if (removeCharge.HasValue)
            {
                // the request was to remove a charge from the report
                ReplaceChargeObjectBetweenLists(removeCharge.Value, expenseReportModel.AssociatedCharges, expenseReportModel.OutstandingCharges);
                expenseReportModel.HasUnsavedChanges = true;
            }
            else if (!String.IsNullOrEmpty(command) && command == "Save")
            {
                // Submit request
                if (ModelState.IsValid)
                {
                    var dbExpenseReport = await db.Reports.FindAsync(expenseReportModel.Id);
                    dbExpenseReport.Amount = expenseReportModel.Amount;
                    dbExpenseReport.Notes = expenseReportModel.Notes;
                    db.Entry(dbExpenseReport).State = EntityState.Modified;

                    // add charges to report
                    foreach (var c in expenseReportModel.AssociatedCharges)
                    {
                        var dbCharge = await db.Charges.FindAsync(c.Id);
                        dbCharge.ExpenseReportId = dbExpenseReport.ExpenseReportId;
                        db.Entry(dbCharge).State = EntityState.Modified;
                    }

                    // remove charges from report
                    foreach (var c in expenseReportModel.OutstandingCharges)
                    {
                        var dbCharge = await db.Charges.FindAsync(c.Id);
                        dbCharge.ExpenseReportId = null;
                        db.Entry(dbCharge).State = EntityState.Modified;
                    }

                    await db.SaveChangesAsync();

                    expenseReportModel.HasUnsavedChanges = false;
                }
            }
            else if (!String.IsNullOrEmpty(command) && command == "SubmitForApproval")
            {
                // Submit request
                if (ModelState.IsValid)
                {
                    var dbExpenseReport = await db.Reports.FindAsync(expenseReportModel.Id);

                    if (dbExpenseReport.Status != DbExpenseReportStatus.Saved)
                    {
                        return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                    }

                    dbExpenseReport.Amount = expenseReportModel.Amount;
                    dbExpenseReport.Notes = expenseReportModel.Notes;
                    dbExpenseReport.Status = DbExpenseReportStatus.Submitted;
                    dbExpenseReport.DateSubmitted = DateTime.Today;
                    db.Entry(dbExpenseReport).State = EntityState.Modified;

                    await db.SaveChangesAsync();

                    expenseReportModel.DateSubmitted = DateTime.Today;
                    expenseReportModel.Status = ExpenseReportStatus.Submitted;
                    expenseReportModel.HasUnsavedChanges = false;
                }
            }
            else if (!String.IsNullOrEmpty(command) && command == "Cancel")
            {
                return RedirectToAction("Reports");
            }

            // This is required to update hidden fields in the view.
            ModelState.Clear();

            // Recalculate the total expense amount, since we have added or removed some charges.
            expenseReportModel.Amount = expenseReportModel.AssociatedCharges.Sum(c => c.BilledAmount);

            return View(expenseReportModel);
        }
コード例 #4
0
        // GET: Expenses/NewReport
        public async Task<ActionResult> NewReport()
        {
            var employee = await db.Employees.FirstOrDefaultAsync(e => e.Alias == ExpensesDemoData.DefaultEmployeeAlias);
            var employeeId = employee.EmployeeId;
            var manager = employee.Manager;
            ViewBag.UserName = employee.Name;

            var outstandingCharges = await db.Charges
                .Where(c => c.EmployeeId == employeeId && !c.ExpenseReportId.HasValue)
                .ToListAsync();

            var newReport = new ExpenseReportModel()
            {
                Approver = manager,
                CostCenter = 1055,
                EmployeeId = employeeId,
                OutstandingCharges = outstandingCharges.Select(c => new ChargeModel(c)).ToList(),
            };

            return View(newReport);
        }