public List <DisplayShiftVM> GetShiftsForWeek([FromBody] int week)
{
UserRepo uRepo = new UserRepo(context, service);
List <DisplayShiftVM> schedule = new List <DisplayShiftVM>();
var shifts = context.Schedule;
if (shifts.Count() != 0)
{
foreach (var shift in shifts)
{
if (shift.Week == week)
{
EmployeeVM employee = uRepo.GetEmployeeDetails(shift.EmpId);
DisplayShiftVM displayShift = new DisplayShiftVM
{
ShiftId = shift.ShiftId,
Firstname = employee.Firstname,
Lastname = employee.Lastname,
Week = shift.Week,
Day = shift.Day,
StartTime = shift.StartTime.ToString()
};
schedule.Add(displayShift);
}
}
}
return(schedule);
}
public List <DisplayShiftVM> GetDroppedShifts()
{
//var shifts = context.DroppedShifts.OrderBy(s => s.Week).ThenBy(s => s.Day);
var shifts = from s in context.DroppedShifts
from u in context.UserDetails
where s.EmpId == u.EmpId
orderby s.Week, s.Day
select new
{
ShiftId = s.ShiftId,
Firstname = u.Firstname,
Lastname = u.Lastname,
Day = s.Day,
Week = s.Week,
StartTime = s.StartTime
};
List <DisplayShiftVM> theShifts = new List <DisplayShiftVM>();
foreach (var shift in shifts)
{
DisplayShiftVM newShift = new DisplayShiftVM
{
ShiftId = shift.ShiftId,
Firstname = shift.Firstname,
Lastname = shift.Lastname,
Day = shift.Day,
Week = shift.Week,
StartTime = shift.StartTime.ToString()
};
theShifts.Add(newShift);
}
return(theShifts);
}
public List <DisplayShiftVM> GetShiftsPerEmployee(string email)
{
List <DisplayShiftVM> theShifts = new List <DisplayShiftVM>();
//var user = context.Users.Where(u => u.Email == email).FirstOrDefault();
//var shifts = context.Schedule.Where(s => s.EmpId == user.Email);
var query = from u in context.Users
from s in context.Schedule
from ud in context.UserDetails
where u.Email == email
where u.Id == s.EmpId
where ud.EmpId == u.Id
select new
{
s.ShiftId,
ud.Firstname,
ud.Lastname,
s.Day,
s.Week,
s.StartTime
};
foreach (var shift in query)
{
DisplayShiftVM addShift = new DisplayShiftVM
{
ShiftId = shift.ShiftId,
Firstname = shift.Firstname,
Lastname = shift.Lastname,
Day = shift.Day,
Week = shift.Week,
StartTime = shift.StartTime.ToString()
};
theShifts.Add(addShift);
}
return(theShifts);
}
