public Department GetDepartmentProfile(int departmentId) { Department department = new Department(); string query = String.Format("SELECT * FROM Department WHERE DepartmentId ={0}", departmentId); daFunctions.Command.CommandText = query; try { daFunctions.Connection.Open(); SqlDataReader rdr = daFunctions.Command.ExecuteReader(); while (rdr.Read()) { department.DepartmentId = rdr["DepartmentId"] as int? ?? default(int); department.DepartmentName = (string)rdr["DepartmentName"]; department.MonthlyBudget = rdr["MonthlyBudget"] as decimal? ?? default(decimal); } daFunctions.Connection.Close(); } catch (Exception ex) { throw new Exception("Unable to load department profile: " + ex.Message); } return department; }
public ExpenseReport() { CreatedBy = new Employee(); ApprovedBy = new Employee(); ProcessedBy = new Employee(); ExpenseToDept = new Department(); ExpenseItems = new List<ExpenseItem>(); }
public Employee() { UserId = new Guid(); FirstName = ""; Surname = ""; Role = ""; AmountApproved = 0; ExpenseApproved = 0; Dept = new Department(); }
/// <summary> /// Highlight the footer of expense report if the amount will result in the department budget being exceeded /// </summary> /// <param name="amount">Total amount of the expense report</param> /// <param name="dept">Department expensed to</param> /// <returns>background styling</returns> protected string HighlightOverBudget(decimal amount, Department dept) { BudgetTracker deptBudget = new BudgetTracker(); deptBudget.DepartmentBudget(dept.MonthlyBudget, dept.DepartmentId); if (deptBudget.IsBudgetExceededAccounts(amount)) return "background-color:#f2dede; color:red"; else return "background-color:#dff0d8"; }