// 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));
}
public List <ExpenseReportModel> MapExpenseReport(DataTable dt)
{
List <ExpenseReportModel> result = new List <ExpenseReportModel>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var obj = new ExpenseReportModel();
obj.ExpenseId = Convert.ToInt32(dr["ExpenseId"]);
obj.IsProjectExpense = Convert.ToBoolean(dr["IsProjectExpense"]);
obj.ProjectName = dr["ProjectName"].ToString();
obj.ExpenseDate = Convert.ToDateTime(dr["ExpenseDate"]).ToString("MM/dd/yyyy");
obj.ExpenseName = dr["ExpenseName"].ToString();
obj.Amount = Convert.ToInt32(dr["Amount"]);
obj.CategoryName = dr["CategoryName"].ToString();
obj.PhaseName = dr["PhaseName"].ToString();
obj.TotalCount = Convert.ToInt32(dr["TotalCount"]);
obj.TotalExpense = Convert.ToInt32(dr["TotalExpense"]);
obj.Comments = dr["Comments"].ToString();
result.Add(obj);
}
}
return(result);
}
public void UpdateExpense(ExpenseReportModel expense)
{
try
{
dbContext.Entry(expense).State = EntityState.Modified;
dbContext.SaveChanges();
}
catch
{
throw;
}
}
public void AddExpense(ExpenseReportModel expense)
{
try
{
dbContext.ExpenseReports.Add(expense);
dbContext.SaveChanges();
}
catch
{
throw;
}
}
public void DeleteExpense(int expenseId)
{
try
{
ExpenseReportModel emp = dbContext.ExpenseReports.Find(expenseId);
dbContext.ExpenseReports.Remove(emp);
dbContext.SaveChanges();
}
catch
{
throw;
}
}
public ActionResult ManageExpense(int expenseId = 0)
{
ExpenseReportModel expense = new ExpenseReportModel();
if (expenseId > 0)
{
expense = _expenseReportService.GetExpenseById(expenseId);
expense.Category = _categoryService.GetCategoryById(expense.CategoryId);
expense.PaymentType = _paymentTypeService.GetPaymentTypeById(expense.PaymentTypeId);
}
expense.ListOfCategories = _categoryService.GetAllCategories();
expense.ListOfPaymentTypes = _paymentTypeService.GetAllPaymentTypes();
return(PartialView("_ExpenseManageForm", expense));
}
public ActionResult ManageExpense(ExpenseReportModel expense)
{
expense.ExpenseBy = userManager.GetUserId(User);
if (expense != null)
{
if (expense.ExpenseId > 0)
{
_expenseReportService.UpdateExpense(expense);
}
else
{
_expenseReportService.AddExpense(expense);
}
return(RedirectToAction("Index", "Expense"));
}
return(PartialView("_ExpenseManageForm", expense));
}
// 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));
}
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));
}
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));
}
