public ActionResult Delete(int id)
{
var db = new TimeCardContext();
var model = db.Employees.Find(id);
return(View(model));
}
public IEnumerable <TimeCardDTO> GetTimeCardsByDate(DateTime startDate)
{
using (var context = new TimeCardContext())
{
return(context.TimeCards.Where(tc => tc.StartDate.Equals(startDate)).Select(tc => tc.ToDTO(true)));
}
}
public ActionResult Index()
{
var db = new TimeCardContext();
var model = db.Employees;
return(View(model));
}
public ActionResult Delete(int id, FormCollection collection)
{
var db = new TimeCardContext();
var employee = db.Employees.Find(id);
db.Employees.Remove(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddEmployee(EmployeeDTO employee)
{
using (var context = new TimeCardContext())
{
context.Employees.Add(employee.ToDomain(true));
context.SaveChanges();
}
}
public void AddTimeCard(TimeCardDTO timeCard)
{
using (var context = new TimeCardContext())
{
context.TimeCards.Add(timeCard.ToDomain(true));
context.SaveChanges();
}
}
public void AddEntry(clsTimeEntry newEntry)
{
using (TimeCardContext context = new TimeCardContext())
{
newEntry.DateTimeLastMaint = DateTime.Now.Date;
context.TimeCardEntries.Add(newEntry);
context.SaveChanges();
}
}
public TimeCardDTO GetTimeCard(int id)
{
using (var context = new TimeCardContext())
{
var timeCard = context.TimeCards.Find(id);
return(timeCard != null?timeCard.ToDTO(true) : null);
}
}
public IEnumerable <TimeCardDTO> GetTimeCardsForEmployee(int employeeId)
{
using (var context = new TimeCardContext())
{
var employee = context.Employees.Find(employeeId);
return(employee != null?employee.TimeCards.Select(tc => tc.ToDTO(true)) : new List <TimeCardDTO>());
}
}
public EmployeeDTO GetEmployee(int id, bool includeTimeCards)
{
using (var context = new TimeCardContext())
{
var employee = context.Employees.Find(id);
return(employee != null?employee.ToDTO(includeTimeCards) : null);
}
}
public ActionResult Create(Employee newEmployee)
{
if (ModelState.IsValid)
{
var db = new TimeCardContext();
db.Employees.Add(newEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newEmployee));
}
public ActionResult Edit(Employee updatedEmployee)
{
if (ModelState.IsValid)
{
var db = new TimeCardContext();
db.Entry(updatedEmployee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(updatedEmployee));
}
public void DeleteEntry(clsTimeEntry entryToDelete)
{
using (TimeCardContext context = new TimeCardContext())
{
clsTimeEntry entry = context.TimeCardEntries.FirstOrDefault(e => e.EntryID == entryToDelete.EntryID);
if (entry == null)
{
throw new Exception(string.Format("Entry for EntryID \"{0}\" was not found.", entryToDelete));
}
context.TimeCardEntries.Remove(entry);
context.SaveChanges();
}
}
public void UpdateEntry(clsTimeEntry updatedEntry)
{
using (TimeCardContext context = new TimeCardContext())
{
DbEntityEntry <clsTimeEntry> entry = context.Entry(updatedEntry);
if (entry == null)
{
context.TimeCardEntries.Attach(updatedEntry);
entry = context.Entry(updatedEntry);
}
entry.State = EntityState.Modified;
context.SaveChanges();
}
}
public IEnumerable <EmployeeDTO> SearchEmployees(string firstName, string lastName, string title, bool includeTimeCards)
{
using (var context = new TimeCardContext())
{
var employees =
context.Employees.AsEnumerable().Where(
e =>
String.IsNullOrWhiteSpace(firstName) ||
e.FirstName.Equals(firstName, StringComparison.InvariantCultureIgnoreCase)).Where(
e =>
String.IsNullOrWhiteSpace(lastName) ||
e.LastName.Equals(lastName, StringComparison.InvariantCultureIgnoreCase)).Where(
e =>
String.IsNullOrWhiteSpace(title) ||
e.Title.Equals(title, StringComparison.InvariantCultureIgnoreCase));
return(employees.Select(e => e.ToDTO(includeTimeCards)).ToList());
}
}
public List <clsTimeEntry> GetAllEntries(DateTime beginDate, DateTime endDate)
{
using (TimeCardContext context = new TimeCardContext())
{
IQueryable <clsTimeEntry> query =
from entry in context.TimeCardEntries
where entry.DateWorked >= beginDate && entry.DateWorked <= endDate
orderby entry.EntryID
select entry;
int count = query.Count();
if (count > 500)
{
throw new clsTooManyRecordsException("More than 500 records found.");
}
return(query.ToList());
}
}
public TimeCardController(ILogger <TimeCardController> logger, TimeCardContext timeCardRepository)
{
_logger = logger;
_timeCardRepository = timeCardRepository;
}