public void GetBaseScheduleLinesByBaseScheduleID()
{
IBaseScheduleManager baseScheduleManager = new BaseScheduleManager(_baseScheduleAccessor);
BaseScheduleLine baseScheduleLine = new BaseScheduleLine()
{
BaseScheduleID = 1000000,
DepartmentID = "Management",
ERoleID = "Manager",
ShiftTimeID = 1000000,
Count = 1
};
List <BaseScheduleLine> others = baseScheduleManager.GetBaseScheduleLinesByBaseScheduleID(1000000);
bool success = false;
if (others.Count == 2)
{
foreach (BaseScheduleLine line in others)
{
if (line.DepartmentID.Equals(baseScheduleLine.DepartmentID) &&
line.ERoleID.Equals(baseScheduleLine.ERoleID) &&
line.ShiftTimeID == baseScheduleLine.ShiftTimeID &&
line.BaseScheduleID == baseScheduleLine.BaseScheduleID &&
line.Count == baseScheduleLine.Count)
{
success = true;
}
}
}
Assert.AreEqual(true, success);
}
/// <summary>
/// Creator: Jordan Lindo
/// Created: 4/1/2020
/// Approver: Chase Schulte
///
/// This displays the edit canvas with appropriate informaion.
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
///
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEditCount_Click(object sender, RoutedEventArgs e)
{
if (dgBaseSchedule.SelectedIndex != -1)
{
BaseScheduleLine line = (BaseScheduleLine)dgBaseSchedule.SelectedItem;
lblDepartmentName.Content = line.DepartmentID;
lblRoleName.Content = line.ERoleID;
fillCount();
cboCount.SelectedIndex = line.Count;
canBaseSchedule.Visibility = Visibility.Hidden;
canEditBaseSchedule.Visibility = Visibility.Visible;
}
}
/// <summary>
/// Creator: Jordan Lindo
/// Created: 4/1/2020
/// Approver: Chase Schulte
///
/// This saves the changes made to a temporary list.
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
///
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, RoutedEventArgs e)
{
BaseScheduleLine selected = (BaseScheduleLine)dgBaseSchedule.SelectedItem;
bool done = false;
for (int i = 0; i < _newLines.Count && !done; i++)
{
if (_newLines.ElementAt(i).ShiftTimeID.Equals(selected.ShiftTimeID) && _newLines.ElementAt(i).ERoleID.Equals(selected.ERoleID))
{
_newLines.ElementAt(i).Count = cboCount.SelectedIndex;
done = true;
}
}
WPFErrorHandler.SuccessMessage(selected.ERoleID + " count set to " + cboCount.SelectedIndex);
setDataGird();
canEditBaseSchedule.Visibility = Visibility.Hidden;
canBaseSchedule.Visibility = Visibility.Visible;
}
/// <summary>
/// Creator: Jordan Lindo
/// Created: 4/14/2020
/// Approver: Chase Schulte
///
/// Retruns a list of available employees.
/// </summary>
/// <remarks>
/// Updater: NA
/// Updated: NA
/// Update: NA
///
/// </remarks>
/// <param name="date"></param>
/// <param name="line"></param>
/// <returns></returns>
public List <PUUserVMAvailability> GetListOfAvailableEmployees(DateTime date, BaseScheduleLine line)
{
List <PUUserVMAvailability> users = new List <PUUserVMAvailability>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_available_users_new_schedule", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DayOfWeek", date.ToString("dddd"));
cmd.Parameters.AddWithValue("@ADate", date);
cmd.Parameters.AddWithValue("@ERoleID", line.ERoleID);
cmd.Parameters.AddWithValue("@ShiftTimeID", line.ShiftTimeID);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
users.Add(new PUUserVMAvailability
{
PUUserID = reader.GetInt32(0),
FirstName = reader.GetString(1),
LastName = reader.GetString(2),
Email = reader.GetString(3),
Availability = new EmployeeAvailability
{
StartTime = reader.GetString(4),
EndTime = reader.GetString(5),
DayOfWeek = date.ToString("dddd")
}
});
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(users);
}
/// <summary>
/// Creator: Jordan Lindo
/// Created: 4/14/2020
/// Approver: Chase Schulte
///
/// Method for getting a list of employees available to be added to a schedule.
/// </summary>
/// <remarks>
/// Updater: NA
/// Updated: NA
/// Update: NA
///
/// </remarks>
/// <param name="date"></param>
/// <param name="line"></param>
/// <returns></returns>
public List <PUUserVMAvailability> GetListOfAvailableEmployees(DateTime date, BaseScheduleLine line)
{
List <PUUserVMAvailability> employees = _employees;
return(employees);
}
