public static void ClockOutExcessUsers()
{
using (CCSContext context = new CCSContext())
{
foreach (var item in _users)
{
context.HoursWorkeds.Add(new HoursWorked()
{
hrsWrkdIDType = item.HoursWorkedType,
hrsWrkdTimeIn = item.ClockIn,
hrsWrkdQty = item.HoursWorkedQuantity,
hrsWrkdTimeOut = item.ClockOut,
hrsWrkedSchedDate = item.HoursWorkedDate,
userAcctID = item.UserAccount,
modifiedOn = item.ModifiedOn,
volunteerID = item.UserId,
volunteerGroupID = item.GroupId,
volunteer = context.Volunteers.Find(item.UserId),
positionLocationID = item.PositionLocationId
});
context.SaveChanges();
}
}
_users.RemoveRange(0, _users.Count());
}
public static void InsertVolunteerInDatabase(User user)
{
using (CCSContext context = new CCSContext())
{
HoursWorked hoursWorked = new HoursWorked()
{
hrsWrkdIDType = user.HoursWorkedType,
hrsWrkdTimeIn = user.ClockIn,
hrsWrkdQty = user.HoursWorkedQuantity,
hrsWrkdTimeOut = user.ClockOut,
hrsWrkedSchedDate = user.HoursWorkedDate,
userAcctID = user.UserAccount,
modifiedOn = user.ModifiedOn,
volunteerID = user.UserId,
volunteerGroupID = user.GroupId,
volunteer = context.Volunteers.Find(user.UserId),
positionLocation = context.PositionLocations.Find(user.PositionKey),
positionLocationID = user.PositionLocationId
};
context.HoursWorkeds.Add(hoursWorked);
context.SaveChanges();
}
}
public CCSController(CCSContext context)
{
_context = context;
}
public ValuesController(IHostingEnvironment _hostingEnvironm, CCSContext dbConn)
{
_hostingEnvironment = _hostingEnvironm;
cCSContext = dbConn;
}
