public ActionResult <EmployeesTable> AddEmployees([FromBody] EmployeesTable incomingEmployees)
{
var db = new ScheduleQuikDbContext();
db.Employees.Add(incomingEmployees);
db.SaveChanges();
return(incomingEmployees);
}
public ActionResult <ShiftsTable> AddShifts([FromBody] ShiftsTable incomingShifts)
{
var db = new ScheduleQuikDbContext();
db.Shifts.Add(incomingShifts);
db.SaveChanges();
return(incomingShifts);
}
public ActionResult <PositionsTable> AddPositions([FromBody] PositionsTable incomingPositions)
{
var db = new ScheduleQuikDbContext();
db.Positions.Add(incomingPositions);
db.SaveChanges();
return(incomingPositions);
}
public ActionResult <IEnumerable <EmployeesTable> > GetAction()
{
// query my database
var db = new ScheduleQuikDbContext();
var employee = db.Employees.OrderBy(employees => employees.FirstName);
// return the results
return(employee.ToList());
}
public ActionResult <IEnumerable <PositionsTable> > GetAction()
{
// query my database
var db = new ScheduleQuikDbContext();
var position = db.Positions.OrderBy(positions => positions.PositionName);
// return the results
return(position.ToList());
}
public ActionResult <IEnumerable <ShiftsTable> > GetAction()
{
// query my database
var db = new ScheduleQuikDbContext();
var shift = db.Shifts.Include(i => i.Positions);
// includes positions
return(shift.ToList());
}
public ActionResult DeleteSchedule()
{
var db = new ScheduleQuikDbContext();
var shifts = db.Shifts.Where(shift => true);
db.Shifts.RemoveRange(shifts);
db.SaveChanges();
return(Ok());
}
public ActionResult DeleteGroupOfEmployees([FromBody] DeleteEmployeesViewModel vm)
{
var db = new ScheduleQuikDbContext();
var employeeIDsSelectedForDelete = db.Employees.Where(employee => vm.EmployeeIds.Contains(employee.Id));
if (employeeIDsSelectedForDelete != null)
{
db.Employees.RemoveRange(employeeIDsSelectedForDelete);
db.SaveChanges();
return(Ok());
}
else
{
return(Ok(vm));
}
}
public ActionResult <Object> DeleteEmployees([FromRoute] string firstname)
{
var db = new ScheduleQuikDbContext();
var employeesToDelete = db.Employees.FirstOrDefault(employees => employees.FirstName == firstname);
if (employeesToDelete != null)
{
db.Employees.Remove(employeesToDelete);
db.SaveChanges();
return(employeesToDelete);
}
else
{
return(new { message = "Employee not found" });
}
}
public ActionResult DeleteGroupOfPositions([FromBody] DeletePositionsViewModel vm)
{
var db = new ScheduleQuikDbContext();
var positionIDsSelectedForDelete = db.Positions.Where(position => vm.PositionIds.Contains(position.Id));
if (positionIDsSelectedForDelete != null)
{
db.Positions.RemoveRange(positionIDsSelectedForDelete);
db.SaveChanges();
return(Ok());
}
else
{
return(Ok(vm));
}
}
public ActionResult <Object> PositionsEmployees([FromRoute] int id)
{
var db = new ScheduleQuikDbContext();
var positionsToDelete = db.Positions.FirstOrDefault(positions => positions.Id == id);
if (positionsToDelete != null)
{
db.Positions.Remove(positionsToDelete);
db.SaveChanges();
return(positionsToDelete);
}
else
{
return(new { message = "Position not found" });
}
}
public ActionResult <Object> DeleteShifts([FromRoute] int id)
{
var db = new ScheduleQuikDbContext();
var shiftsToDelete = db.Shifts.FirstOrDefault(shifts => shifts.Id == id);
if (shiftsToDelete != null)
{
db.Shifts.Remove(shiftsToDelete);
db.SaveChanges();
return(shiftsToDelete);
}
else
{
return(new { message = "Shift not found" });
}
}
public ActionResult UpdatePositions([FromRoute] int id, [FromBody] PositionsTable newInformation)
{
var db = new ScheduleQuikDbContext();
// find the position
var positions = db.Positions.FirstOrDefault(f => f.Id == id);
if (positions != null)
{
positions.PositionName = newInformation.PositionName;
db.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok(positions));
}
public ActionResult UpdateShifts([FromRoute] int id, [FromBody] ShiftsTable updateInformation)
{
var db = new ScheduleQuikDbContext();
var shifts = db.Shifts.FirstOrDefault(shift => shift.Id == id);
if (shifts != null)
{
shifts.InTime = updateInformation.InTime;
shifts.OutTime = updateInformation.OutTime;
shifts.EmployeesTableId = updateInformation.EmployeesTableId;
shifts.PositionsTableId = updateInformation.PositionsTableId;
db.SaveChanges();
return(Ok(shifts));
}
else
{
return(NotFound(new { message = "Shift not found" }));
}
}
public ActionResult UpdateEmployees([FromRoute] int id, [FromBody] EmployeesTable newInformation)
{
var db = new ScheduleQuikDbContext();
// find the employee
var employees = db.Employees.FirstOrDefault(f => f.Id == id);
if (employees != null)
{
employees.FirstName = newInformation.FirstName;
employees.LastName = newInformation.LastName;
employees.PhoneNumber = newInformation.PhoneNumber;
employees.EmailAddress = newInformation.EmailAddress;
db.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok(employees));
}
