private Employee GetEmployee(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.Employees.FirstOrDefault(item => item.EmployeeId == employeeId));
}
}
public ExpenseReport GetExpenseReport(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.ExpenseReports.FirstOrDefault(item => item.ExpenseReportId == expenseReportId));
}
}
public List <ExpenseReport> GetExpenseReportsForApproval(string employeeAlias)
{
using (DbDataContext db = new DbDataContext())
{
return(db.ExpenseReports.Where(item => ((item.Approver == employeeAlias) && (item.Status == (int)ExpenseReportStatus.Pending))).ToList());
}
}
public List <Charge> GetOutstandingCharges(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.Charges.Where(item => ((item.EmployeeId == employeeId) && (item.ExpenseReportId == null))).ToList());
}
}
public List <ExpenseReport> GetExpenseReportsByStatus(int employeeId, ExpenseReportStatus status)
{
using (DbDataContext db = new DbDataContext())
{
return(db.ExpenseReports.Where(item => ((item.EmployeeId == employeeId) && (item.Status == (int)status))).ToList());
}
}
public Charge GetCharge(int chargeId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.Charges.FirstOrDefault(item => item.ChargeId == chargeId));
}
}
public List <Charge> GetCharges(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.Charges.Where(item => item.ExpenseReportId == expenseReportId).ToList());
}
}
public int SaveCharge(Charge charge)
{
using (DbDataContext db = new DbDataContext())
{
Charge dbCharge;
if (charge.ChargeId == 0)
{
dbCharge = charge;
db.Charges.InsertOnSubmit(dbCharge);
}
else
{
dbCharge = db.Charges.Single(item => item.ChargeId == charge.ChargeId);
dbCharge.AccountNumber = charge.AccountNumber;
dbCharge.BilledAmount = charge.BilledAmount;
dbCharge.Category = charge.Category;
dbCharge.Description = charge.Description;
dbCharge.EmployeeId = charge.EmployeeId;
dbCharge.ExpenseDate = charge.ExpenseDate;
dbCharge.ExpenseReportId = charge.ExpenseReportId;
dbCharge.ExpenseType = charge.ExpenseType;
dbCharge.Location = charge.Location;
dbCharge.Merchant = charge.Merchant;
dbCharge.Notes = charge.Notes;
dbCharge.ReceiptRequired = charge.ReceiptRequired;
dbCharge.TransactionAmount = charge.TransactionAmount;
}
db.SubmitChanges();
return(dbCharge.ChargeId);
}
}
public int SaveExpenseReport(ExpenseReport expenseReport)
{
using (DbDataContext db = new DbDataContext())
{
ExpenseReport dbExpenseReport;
if (expenseReport.ExpenseReportId == 0)
{
dbExpenseReport = expenseReport;
db.ExpenseReports.InsertOnSubmit(dbExpenseReport);
}
else
{
dbExpenseReport = db.ExpenseReports.Single(item => item.ExpenseReportId == expenseReport.ExpenseReportId);
dbExpenseReport.Amount = expenseReport.Amount;
dbExpenseReport.Approver = expenseReport.Approver;
dbExpenseReport.CostCenter = expenseReport.CostCenter;
dbExpenseReport.DateResolved = expenseReport.DateResolved;
dbExpenseReport.DateSaved = expenseReport.DateSaved;
dbExpenseReport.DateSubmitted = expenseReport.DateSubmitted;
dbExpenseReport.EmployeeId = expenseReport.EmployeeId;
dbExpenseReport.Notes = expenseReport.Notes;
dbExpenseReport.OwedToCreditCard = expenseReport.OwedToCreditCard;
dbExpenseReport.OwedToEmployee = expenseReport.OwedToEmployee;
dbExpenseReport.Purpose = expenseReport.Purpose;
dbExpenseReport.Status = expenseReport.Status;
}
db.SubmitChanges();
return(dbExpenseReport.ExpenseReportId);
}
}
public List <ExpenseReport> GetExpenseReports(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return(db.ExpenseReports.Where(item => item.EmployeeId == employeeId).ToList());
}
}
public void DeleteCharge(int chargeId)
{
using (DbDataContext db = new DbDataContext())
{
db.Charges.DeleteAllOnSubmit(db.Charges.Where(item => item.ChargeId == chargeId));
db.SubmitChanges();
}
}
public void DeleteExpenseReport(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
db.ExpenseReports.DeleteAllOnSubmit(db.ExpenseReports.Where(item => item.ExpenseReportId == expenseReportId));
db.SubmitChanges();
}
}
public void ResetData()
{
using (DbDataContext db = new DbDataContext())
{
db.Charges.DeleteAllOnSubmit(db.Charges);
db.ExpenseReports.DeleteAllOnSubmit(db.ExpenseReports);
db.Employees.DeleteAllOnSubmit(db.Employees);
db.SubmitChanges();
}
}
public Employee GetEmployee(string employeeAlias)
{
using (DbDataContext db = new DbDataContext())
{
Employee employee = db.Employees.FirstOrDefault(item => item.Alias == employeeAlias);
// This is a hack to create fresh data for a new employee.
if (employee == null)
{
employee = this.CreateNewEmployee(employeeAlias);
}
return employee;
}
}
public Employee GetEmployee(string employeeAlias)
{
using (DbDataContext db = new DbDataContext())
{
Employee employee = db.Employees.FirstOrDefault(item => item.Alias == employeeAlias);
// This is a hack to create fresh data for a new employee.
if (employee == null)
{
employee = this.CreateNewEmployee(employeeAlias);
}
return(employee);
}
}
public int SaveEmployee(Employee employee)
{
using (DbDataContext db = new DbDataContext())
{
Employee dbEmployee;
if (employee.EmployeeId == 0)
{
dbEmployee = employee;
db.Employees.InsertOnSubmit(dbEmployee);
}
else
{
dbEmployee = db.Employees.Single(item => item.EmployeeId == employee.EmployeeId);
dbEmployee.Alias = employee.Alias;
dbEmployee.Manager = employee.Manager;
dbEmployee.Name = employee.Name;
}
db.SubmitChanges();
return(dbEmployee.EmployeeId);
}
}
public int SaveEmployee(Employee employee)
{
using (DbDataContext db = new DbDataContext())
{
Employee dbEmployee;
if (employee.EmployeeId == 0)
{
dbEmployee = employee;
db.Employees.InsertOnSubmit(dbEmployee);
}
else
{
dbEmployee = db.Employees.Single(item => item.EmployeeId == employee.EmployeeId);
dbEmployee.Alias = employee.Alias;
dbEmployee.Manager = employee.Manager;
dbEmployee.Name = employee.Name;
}
db.SubmitChanges();
return dbEmployee.EmployeeId;
}
}
public List<Charge> GetCharges(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
return db.Charges.Where(item => item.ExpenseReportId == expenseReportId).ToList();
}
}
public List<ExpenseReport> GetExpenseReportsByStatus(int employeeId, ExpenseReportStatus status)
{
using (DbDataContext db = new DbDataContext())
{
return db.ExpenseReports.Where(item => ((item.EmployeeId == employeeId) && (item.Status == (int)status))).ToList();
}
}
public int SaveCharge(Charge charge)
{
using (DbDataContext db = new DbDataContext())
{
Charge dbCharge;
if (charge.ChargeId == 0)
{
dbCharge = charge;
db.Charges.InsertOnSubmit(dbCharge);
}
else
{
dbCharge = db.Charges.Single(item => item.ChargeId == charge.ChargeId);
dbCharge.AccountNumber = charge.AccountNumber;
dbCharge.BilledAmount = charge.BilledAmount;
dbCharge.Category = charge.Category;
dbCharge.Description = charge.Description;
dbCharge.EmployeeId = charge.EmployeeId;
dbCharge.ExpenseDate = charge.ExpenseDate;
dbCharge.ExpenseReportId = charge.ExpenseReportId;
dbCharge.ExpenseType = charge.ExpenseType;
dbCharge.Location = charge.Location;
dbCharge.Merchant = charge.Merchant;
dbCharge.Notes = charge.Notes;
dbCharge.ReceiptRequired = charge.ReceiptRequired;
dbCharge.TransactionAmount = charge.TransactionAmount;
}
db.SubmitChanges();
return dbCharge.ChargeId;
}
}
public Charge GetCharge(int chargeId)
{
using (DbDataContext db = new DbDataContext())
{
return db.Charges.FirstOrDefault(item => item.ChargeId == chargeId);
}
}
public int SaveExpenseReport(ExpenseReport expenseReport)
{
using (DbDataContext db = new DbDataContext())
{
ExpenseReport dbExpenseReport;
if (expenseReport.ExpenseReportId == 0)
{
dbExpenseReport = expenseReport;
db.ExpenseReports.InsertOnSubmit(dbExpenseReport);
}
else
{
dbExpenseReport = db.ExpenseReports.Single(item => item.ExpenseReportId == expenseReport.ExpenseReportId);
dbExpenseReport.Amount = expenseReport.Amount;
dbExpenseReport.Approver = expenseReport.Approver;
dbExpenseReport.CostCenter = expenseReport.CostCenter;
dbExpenseReport.DateResolved = expenseReport.DateResolved;
dbExpenseReport.DateSaved = expenseReport.DateSaved;
dbExpenseReport.DateSubmitted = expenseReport.DateSubmitted;
dbExpenseReport.EmployeeId = expenseReport.EmployeeId;
dbExpenseReport.Notes = expenseReport.Notes;
dbExpenseReport.OwedToCreditCard = expenseReport.OwedToCreditCard;
dbExpenseReport.OwedToEmployee = expenseReport.OwedToEmployee;
dbExpenseReport.Purpose = expenseReport.Purpose;
dbExpenseReport.Status = expenseReport.Status;
}
db.SubmitChanges();
return dbExpenseReport.ExpenseReportId;
}
}
public void DeleteCharge(int chargeId)
{
using (DbDataContext db = new DbDataContext())
{
db.Charges.DeleteAllOnSubmit(db.Charges.Where(item => item.ChargeId == chargeId));
db.SubmitChanges();
}
}
public void ResetData()
{
using (DbDataContext db = new DbDataContext())
{
db.Charges.DeleteAllOnSubmit(db.Charges);
db.ExpenseReports.DeleteAllOnSubmit(db.ExpenseReports);
db.Employees.DeleteAllOnSubmit(db.Employees);
db.SubmitChanges();
}
}
public void DeleteExpenseReport(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
db.ExpenseReports.DeleteAllOnSubmit(db.ExpenseReports.Where(item => item.ExpenseReportId == expenseReportId));
db.SubmitChanges();
}
}
private Employee GetEmployee(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return db.Employees.FirstOrDefault(item => item.EmployeeId == employeeId);
}
}
public List<ExpenseReport> GetExpenseReportsForApproval(string employeeAlias)
{
using (DbDataContext db = new DbDataContext())
{
return db.ExpenseReports.Where(item => ((item.Approver == employeeAlias) && (item.Status == (int)ExpenseReportStatus.Pending))).ToList();
}
}
private Employee CreateNewEmployee(string alias)
{
string managerAlias = "manager";
if (string.Compare(alias, "rogreen", true) != 0)
{
managerAlias = "rogreen";
}
Employee employee =
new Employee()
{
Alias = alias,
Charges = new EntitySet<Charge>(),
ExpenseReports = new EntitySet<ExpenseReport>(),
Manager = managerAlias,
Name = "New Employee",
};
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 200M,
Category = (int)CategoryType.Hotel,
Description = "REF# 27438948",
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Northwind Inn",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 200M,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 40,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "REF# 77384751",
ExpenseDate = DateTime.Today.AddDays(-20),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 40,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 67,
Category = (int)CategoryType.TEMeals,
Description = "REF# 33748563",
ExpenseDate = DateTime.Today.AddDays(-8),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Fourth Coffee",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 12,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 17,
Category = (int)CategoryType.TEMeals,
Description = "REF# 33748876",
ExpenseDate = DateTime.Today.AddDays(-4),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Fourth Coffee",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 15,
});
ExpenseReport expenseReport =
new ExpenseReport()
{
Amount = 640M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(-7),
Notes = (managerAlias == "rogreen") ? "Kim Akers" : "Visit to Blue Yonder Airlines",
OwedToCreditCard = 450M,
OwedToEmployee = 0M,
Purpose = "Visit to Blue Yonder Airlines",
Status = (int)ExpenseReportStatus.Pending,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport =
new ExpenseReport()
{
Amount = 450M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(-7),
Notes = (managerAlias == "rogreen") ? "Kim Akers" : "Visit to Tailspin Toys",
OwedToCreditCard = 450M,
OwedToEmployee = 0M,
Purpose = "Visit to Tailspin Toys",
Status = (int)ExpenseReportStatus.Pending,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 350M,
Category = (int)CategoryType.AirFare,
Description = "Airfare to San Francisco",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-60),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Blue Yonder Airlines",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 350M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab from airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab to airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50,
});
// Add a year of every other month customer visits
int x = -75;
for (int i = 1; i <= 6; i++)
{
expenseReport =
new ExpenseReport()
{
Amount = 850M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(x - 5),
DateResolved = DateTime.Today.AddDays(x),
Notes = "Visit to Tailspin Toys",
OwedToCreditCard = 850M,
OwedToEmployee = 0M,
Purpose = "Customer visit",
Status = (int)ExpenseReportStatus.Approved,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 350M,
Category = (int)CategoryType.AirFare,
Description = "Airfare to Chicago",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 15),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Blue Yonder Airlines",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 350M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab from airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 5),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab to airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 3),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 400M,
Category = (int)CategoryType.Hotel,
Description = "2 nights hotel",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 3),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Northwind Inn",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 400M,
});
x -= 60;
}
// Add 18 months of cell phone charges
x = -30;
for (int i = 1; i <= 18; i++)
{
expenseReport =
new ExpenseReport()
{
Amount = 850M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(x - 5),
DateResolved = DateTime.Today.AddDays(x),
Notes = "",
OwedToCreditCard = 0,
OwedToEmployee = 50M,
Purpose = "Last month's cell phone",
Status = (int)ExpenseReportStatus.Approved,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 742000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cell phone bill",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 10),
ExpenseType = (int)ChargeType.Personal,
Location = "Seattle, WA",
Merchant = "The Phone Company",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 50M,
});
x -= 30;
}
using (DbDataContext db = new DbDataContext())
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
this.GetEmployee("kimakers");
return employee;
}
public List<Charge> GetOutstandingCharges(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return db.Charges.Where(item => ((item.EmployeeId == employeeId) && (item.ExpenseReportId == null))).ToList();
}
}
public List<ExpenseReport> GetExpenseReports(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
return db.ExpenseReports.Where(item => item.EmployeeId == employeeId).ToList();
}
}
private Employee CreateNewEmployee(string alias)
{
string managerAlias = "manager";
if (string.Compare(alias, "rogreen", true) != 0)
{
managerAlias = "rogreen";
}
Employee employee =
new Employee()
{
Alias = alias,
Charges = new EntitySet <Charge>(),
ExpenseReports = new EntitySet <ExpenseReport>(),
Manager = managerAlias,
Name = "New Employee",
};
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 200M,
Category = (int)CategoryType.Hotel,
Description = "REF# 27438948",
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Northwind Inn",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 200M,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 40,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "REF# 77384751",
ExpenseDate = DateTime.Today.AddDays(-20),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 40,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 67,
Category = (int)CategoryType.TEMeals,
Description = "REF# 33748563",
ExpenseDate = DateTime.Today.AddDays(-8),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Fourth Coffee",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 12,
});
employee.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 17,
Category = (int)CategoryType.TEMeals,
Description = "REF# 33748876",
ExpenseDate = DateTime.Today.AddDays(-4),
ExpenseType = (int)ChargeType.Business,
Location = "Seattle, WA",
Merchant = "Fourth Coffee",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 15,
});
ExpenseReport expenseReport =
new ExpenseReport()
{
Amount = 640M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(-7),
Notes = (managerAlias == "rogreen") ? "Kim Akers" : "Visit to Blue Yonder Airlines",
OwedToCreditCard = 450M,
OwedToEmployee = 0M,
Purpose = "Visit to Blue Yonder Airlines",
Status = (int)ExpenseReportStatus.Pending,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport =
new ExpenseReport()
{
Amount = 450M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(-7),
Notes = (managerAlias == "rogreen") ? "Kim Akers" : "Visit to Tailspin Toys",
OwedToCreditCard = 450M,
OwedToEmployee = 0M,
Purpose = "Visit to Tailspin Toys",
Status = (int)ExpenseReportStatus.Pending,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 350M,
Category = (int)CategoryType.AirFare,
Description = "Airfare to San Francisco",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-60),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Blue Yonder Airlines",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 350M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab from airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab to airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(-45),
ExpenseType = (int)ChargeType.Business,
Location = "San Francisco, CA",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50,
});
// Add a year of every other month customer visits
int x = -75;
for (int i = 1; i <= 6; i++)
{
expenseReport =
new ExpenseReport()
{
Amount = 850M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(x - 5),
DateResolved = DateTime.Today.AddDays(x),
Notes = "Visit to Tailspin Toys",
OwedToCreditCard = 850M,
OwedToEmployee = 0M,
Purpose = "Customer visit",
Status = (int)ExpenseReportStatus.Approved,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 350M,
Category = (int)CategoryType.AirFare,
Description = "Airfare to Chicago",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 15),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Blue Yonder Airlines",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 350M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab from airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 5),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cab to airport",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 3),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Contoso Taxi",
Notes = string.Empty,
ReceiptRequired = false,
TransactionAmount = 50M,
});
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 723000,
BilledAmount = 400M,
Category = (int)CategoryType.Hotel,
Description = "2 nights hotel",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 3),
ExpenseType = (int)ChargeType.Business,
Location = "Chicago, IL",
Merchant = "Northwind Inn",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 400M,
});
x -= 60;
}
// Add 18 months of cell phone charges
x = -30;
for (int i = 1; i <= 18; i++)
{
expenseReport =
new ExpenseReport()
{
Amount = 850M,
Approver = managerAlias,
CostCenter = 50992,
DateSubmitted = DateTime.Today.AddDays(x - 5),
DateResolved = DateTime.Today.AddDays(x),
Notes = "",
OwedToCreditCard = 0,
OwedToEmployee = 50M,
Purpose = "Last month's cell phone",
Status = (int)ExpenseReportStatus.Approved,
};
employee.ExpenseReports.Add(expenseReport);
expenseReport.Charges.Add(
new Charge()
{
AccountNumber = 742000,
BilledAmount = 50M,
Category = (int)CategoryType.OtherTravelAndLodging,
Description = "Cell phone bill",
Employee = employee,
ExpenseDate = DateTime.Today.AddDays(x - 10),
ExpenseType = (int)ChargeType.Personal,
Location = "Seattle, WA",
Merchant = "The Phone Company",
Notes = string.Empty,
ReceiptRequired = true,
TransactionAmount = 50M,
});
x -= 30;
}
using (DbDataContext db = new DbDataContext())
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
this.GetEmployee("kimakers");
return(employee);
}
public List<SummaryItem> GetSummaryItems(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
Employee employee = db.Employees.FirstOrDefault(item => item.EmployeeId == employeeId);
if (employee == null)
{
throw new ArgumentException("Employee not found");
}
List<SummaryItem> summaryItems = new List<SummaryItem>();
summaryItems.AddRange(
this.GetOutstandingCharges(employeeId).Select(
item =>
new SummaryItem()
{
Amount = item.TransactionAmount,
Date = item.ExpenseDate,
Description = (!string.IsNullOrWhiteSpace(item.Location)) ? string.Format("{0} ({1})", item.Merchant, item.Location) : item.Merchant,
Id = item.ChargeId,
ItemType = ItemType.Charge,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Saved).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSaved,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.SavedReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Pending).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSubmitted,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.PendingReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Approved).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSaved,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.ApprovedReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsForApproval(employee.Alias).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSubmitted,
Description = string.Format("{0} ({1})", item.Purpose, this.GetEmployee(item.EmployeeId).Name),
Id = item.ExpenseReportId,
ItemType = ItemType.UnresolvedReport,
Submitter = employee.Name,
}));
return summaryItems;
}
}
public List <SummaryItem> GetSummaryItems(int employeeId)
{
using (DbDataContext db = new DbDataContext())
{
Employee employee = db.Employees.FirstOrDefault(item => item.EmployeeId == employeeId);
if (employee == null)
{
throw new ArgumentException("Employee not found");
}
List <SummaryItem> summaryItems = new List <SummaryItem>();
summaryItems.AddRange(
this.GetOutstandingCharges(employeeId).Select(
item =>
new SummaryItem()
{
Amount = item.TransactionAmount,
Date = item.ExpenseDate,
Description = (!string.IsNullOrWhiteSpace(item.Location)) ? string.Format("{0} ({1})", item.Merchant, item.Location) : item.Merchant,
Id = item.ChargeId,
ItemType = ItemType.Charge,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Saved).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSaved,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.SavedReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Pending).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSubmitted,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.PendingReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsByStatus(employeeId, ExpenseReportStatus.Approved).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSaved,
Description = item.Purpose,
Id = item.ExpenseReportId,
ItemType = ItemType.ApprovedReport,
Submitter = employee.Name,
}));
summaryItems.AddRange(
this.GetExpenseReportsForApproval(employee.Alias).Select(
item =>
new SummaryItem()
{
Amount = item.Amount,
Date = item.DateSubmitted,
Description = string.Format("{0} ({1})", item.Purpose, this.GetEmployee(item.EmployeeId).Name),
Id = item.ExpenseReportId,
ItemType = ItemType.UnresolvedReport,
Submitter = employee.Name,
}));
return(summaryItems);
}
}
public ExpenseReport GetExpenseReport(int expenseReportId)
{
using (DbDataContext db = new DbDataContext())
{
return db.ExpenseReports.FirstOrDefault(item => item.ExpenseReportId == expenseReportId);
}
}