public void AddReport_ApprovedBySupAndApprovedByAcc_GetReportStatus() { DateTime date = DateTime.Now.Date; string reportName = "REPORT"; string location = "Broadway"; string description = "food"; string strAmount = "100.1111"; double amount = Math.Round(100.1111, 2); double amount_aud = 148.16; string currency = "Euros"; byte[] receipt = new byte[] { 2, 3, 4, 2 }; int reportId = GetCurrentRowOfReportsTable() + 1; int expenseId = GetCurrentRowOfExpensesTable() + 1; Consultant consultant = new Consultant("con_he5"); Supervisor supervisor = new Supervisor("sup_he1"); AccountsStaff accountsStaff = new AccountsStaff("acc1"); // start transaction using (TransactionScope testTransaction = new TransactionScope()) { consultant.CreateExpense(date, location, description, strAmount, currency, receipt); consultant.AddExpenses(reportId); consultant.AddReport(reportName); supervisor.Approve(reportId); accountsStaff.Approve(reportId); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); foreach (Reports.ReportsRow report in reportsTable) { Assert.AreEqual(reportId, report.Id); Assert.AreEqual(reportName, report.Report_name); Assert.AreEqual(amount, report.Total_amount); Assert.AreEqual("APPROVED", report.Supervisor_approval); Assert.AreEqual("APPROVED", report.Accounts_approval); Assert.AreEqual(consultant.Department, report.Department); Assert.AreEqual(consultant.Username, report.Consultant_id); Assert.AreEqual("NONE", report.Supervisor_id); } testTransaction.Dispose(); // rollback } }
/* * This will determine that a specific report is already approved/rejected by accounts staff or not * approved/rejected = false * still processing = ture */ public bool IsProcessing(int reportId) { ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); Reports.ReportsRow row = (Reports.ReportsRow)reportsTable.Rows[0]; if (row.Accounts_approval.Equals("PROCESSING")) return true; else return false; }
public void AddReport_ApprovedBySupAndRejectedByAcc_GetReportStatus() { DateTime date = DateTime.Now.Date; string reportName = "REPORT"; string location = "Department Store"; string description = "computer"; string strAmount = "1000.567"; double amount = Math.Round(1000.567, 2); byte[] receipt = new byte[] { 2, 3, 4, 2 }; int reportId = GetCurrentRowOfReportsTable() + 1; int expenseId = GetCurrentRowOfExpensesTable() + 1; Consultant consultant = new Consultant("41651a9d-3122-4ea2-bfe0-dca38d7248d1"); Supervisor supervisor = new Supervisor("c252413a-1f6c-4086-b35f-1e430f7d7a14"); AccountsStaff accountsStaff = new AccountsStaff("f447b9f3-6733-42aa-b1c5-05a8b4451ca7"); // start transaction using (TransactionScope testTransaction = new TransactionScope()) { consultant.CreateExpense(date, location, description, strAmount, "AUD", receipt); consultant.AddExpenses(reportId); consultant.AddReport(reportName); supervisor.Approve(reportId); accountsStaff.Reject(reportId); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); foreach (Reports.ReportsRow report in reportsTable) { Assert.AreEqual(reportId, report.Id); Assert.AreEqual(reportName, report.Report_name); Assert.AreEqual(amount, report.Total_amount); Assert.AreEqual("APPROVED", report.Supervisor_approval); Assert.AreEqual("REJECTED", report.Accounts_approval); Assert.AreEqual(consultant.Department, report.Department); Assert.AreEqual(consultant.Username, report.Consultant_id); Assert.AreEqual("NONE", report.Supervisor_id); } testTransaction.Dispose(); // rollback } }
public void CalcaluateExpences_ExpensesNotChanged() { int reportId = GetCurrentRowOfReportsTable() + 1; Consultant con_s1 = new Consultant("ce65a8ac-728b-405e-a00d-4a14e6ad23dc"); Supervisor sup_s1 = new Supervisor("1b52538c-ee54-425b-a3bc-e1b5cab1fdd3"); AccountsStaff acc1 = new AccountsStaff("f447b9f3-6733-42aa-b1c5-05a8b4451ca7"); sup_s1.CalculateExpenses(); double currentExpenses = sup_s1.Expenses; double currentBudgetRemained = sup_s1.BudgetRemained; sup_s1.ResetBudget(); using (TransactionScope testTransaction = new TransactionScope()) { con_s1.CreateExpense(DateTime.Now.Date, "sd", "first", "1000", "AUD", null); con_s1.AddReport("new report"); con_s1.AddExpenses(reportId); ReportsTableAdapter adapter2 = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter2.FillById(reportsTable, reportId); sup_s1.CalculateExpenses(); Assert.AreEqual(currentExpenses, sup_s1.Expenses); sup_s1.ResetBudget(); testTransaction.Dispose(); // rollback } }
public void AddReport_HavingMultipleExpenses_AddsReportAndExpenseToDB() { string strAmount = "100.1111"; double amount_aud = 100.11; string strAmount2 = "50.222"; double amount_aud2 = 74.33; string strAmount3 = "99"; double amount_aud3 = 16.83; int reportId = GetCurrentRowOfReportsTable() + 1; int expenseId = GetCurrentRowOfExpensesTable() + 1; Consultant consultant = new Consultant("6cb4e17b-f8d9-469a-84a7-424ac788afac"); // start transaction using (TransactionScope testTransaction = new TransactionScope()) { consultant.CreateExpense(DateTime.Now, "", "", strAmount, "AUD", null); consultant.CreateExpense(DateTime.Now, "", "", strAmount2, "Euros", null); consultant.CreateExpense(DateTime.Now, "", "", strAmount3, "CNY", null); consultant.AddExpenses(reportId); consultant.AddReport(""); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); foreach (Reports.ReportsRow report in reportsTable) { Assert.AreEqual(amount_aud + amount_aud2 + amount_aud3, report.Total_amount); } testTransaction.Dispose(); // rollback } }
public void AddReport_GivenValidExpense_AddsReportAndExpenseToDB2() { DateTime date = DateTime.Now.Date; string reportName = "REPORT"; string location = "Broadway"; string description = "food"; string strAmount = "100.1111"; double amount = Math.Round(100.1111, 2); double amount_aud = 148.16; string currency = "Euros"; byte[] receipt = new byte[] { 2, 3, 4, 2 }; int reportId = GetCurrentRowOfReportsTable() + 1; int expenseId = GetCurrentRowOfExpensesTable() + 1; Consultant consultant = new Consultant("41651a9d-3122-4ea2-bfe0-dca38d7248d1"); // start transaction using (TransactionScope testTransaction = new TransactionScope()) { consultant.CreateExpense(date, location, description, strAmount, currency, receipt); consultant.AddExpenses(reportId); consultant.AddReport(reportName); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); foreach (Reports.ReportsRow report in reportsTable) { Assert.AreEqual(reportId, report.Id); Assert.AreEqual(reportName, report.Report_name); Assert.AreEqual(amount, report.Total_amount); Assert.AreEqual("PROCESSING", report.Supervisor_approval); Assert.AreEqual("PROCESSING", report.Accounts_approval); Assert.AreEqual(consultant.Department, report.Department); Assert.AreEqual(consultant.Username, report.Consultant_id); Assert.AreEqual("NONE", report.Supervisor_id); } ExpensesTableAdapter adapter2 = new ExpensesTableAdapter(); Reports.ExpensesDataTable expensesTable = new Reports.ExpensesDataTable(); adapter2.FillByReportId(expensesTable, reportId); foreach (Reports.ExpensesRow expense in expensesTable) { Assert.AreEqual(date, expense.Date); Assert.AreEqual(location, expense.Location); Assert.AreEqual(description, expense.Description); Assert.AreEqual(amount, expense.Amount); Assert.AreEqual(currency, expense.Currency); Assert.AreEqual(amount_aud, expense.Amount_aud); } testTransaction.Dispose(); // rollback } }
public void AddReport_GivenValidExpense_AddsReportAndExpenseToDB() { DateTime date = DateTime.Now.Date; string reportName = "report"; string location = "AA"; string description = "BB"; string strAmount = "100"; double amount = Math.Round(100.000, 2); string currency = "AUD"; byte[] receipt = new byte[] { 1, 2, 3, 4 }; int reportId = GetCurrentRowOfReportsTable() + 1; int expenseId = GetCurrentRowOfExpensesTable() + 1; Consultant consultant = new Consultant("ce65a8ac-728b-405e-a00d-4a14e6ad23dc"); // start transaction using (TransactionScope testTransaction = new TransactionScope()) { consultant.CreateExpense(date, location, description, strAmount, currency, receipt); consultant.AddExpenses(reportId); consultant.AddReport(reportName); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); foreach (Reports.ReportsRow report in reportsTable) { Assert.AreEqual(reportId, report.Id); Assert.AreEqual(reportName, report.Report_name); Assert.AreEqual(amount, report.Total_amount); Assert.AreEqual("PROCESSING", report.Supervisor_approval); Assert.AreEqual("PROCESSING", report.Accounts_approval); Assert.AreEqual(consultant.Department, report.Department); Assert.AreEqual("ce65a8ac-728b-405e-a00d-4a14e6ad23dc", report.Consultant_id); Assert.AreEqual("NONE", report.Supervisor_id); } ExpensesTableAdapter adapter2 = new ExpensesTableAdapter(); Reports.ExpensesDataTable expensesTable = new Reports.ExpensesDataTable(); adapter2.FillByReportId(expensesTable, reportId); foreach (Reports.ExpensesRow expense in expensesTable) { Assert.AreEqual(date, expense.Date); Assert.AreEqual(location, expense.Location); Assert.AreEqual(description, expense.Description); Assert.AreEqual(amount, expense.Amount); Assert.AreEqual(currency, expense.Currency); Assert.AreEqual(amount, expense.Amount_aud); } testTransaction.Dispose(); // rollback } }
/* * This will determine that expenses of a report will make company over budget or not * over budet = true, no = false */ public bool IsOverBudget(int reportId) { CalculateExpenses(); ReportsTableAdapter adapter = new ReportsTableAdapter(); Reports.ReportsDataTable reportsTable = new Reports.ReportsDataTable(); adapter.FillById(reportsTable, reportId); Reports.ReportsRow row = (Reports.ReportsRow)reportsTable.Rows[0]; if (row.Total_amount > BudgetRemained) { ResetBudget(); return true; } ResetBudget(); return false; }