public async Task <IActionResult> DisplayTrackTimeDetails(string startDate, string endDate)
{
if (TempData.Peek("userName") == null)
{
return(UserNotAllowedAccess());
}
//get the track time details for the newly created records
var getTrackTimeInput = new GetTrackTimeDatabaseInput(TempData.Peek("userGuid").ToString(), startDate, endDate);
var trackTimeDetails = await _ITrackTimeDomain.GetTrackTime(getTrackTimeInput);
//Set the UserTrackTimeList property of the ViewModel
TrackTimeList trackTimeDetailsList = new TrackTimeList {
UserTrackTimeList = trackTimeDetails
};
trackTimeDetailsList.IsCurrentRecord = true;
if (!_ITrackTimeDomain.IsCurrentRecord(startDate, endDate))
{
TempData.Add("ReadonlyTrackTime", "This is record is for a previous week's Track Time.");
trackTimeDetailsList.IsCurrentRecord = false;
//return RedirectTo("TrackTime", "DisplayReadonlyTrackTime");
}
//return the View and pass in the user's track time details list
return(View(trackTimeDetailsList));
}
public async Task GetTrackTime_Success()
{
//Arrange
var userGuid = new GetTrackTimeDatabaseInput("67d537cb-123d-424b-a6d1-2cc5b2920430",
"11/11/18", "11/17/18");
IEnumerable <GetTrackTimeDatabaseOutput> tracktTimeList;
//Act
tracktTimeList = await _trackTimeRepo.GetTrackTime(userGuid);
//Assert
Assert.NotNull(tracktTimeList);
}
public async Task CreateNewTrackTimeRecord()
{
//Arrange
var createNewRecordInput = new CreateNewTrackTimeRecordDatabaseInput("ca0e7040-b42c-4cf3-9b4e-4a9a06129cec", "ProjectPaper", "11/11/18", "11/17/18");
var getTrackTimeInput = new GetTrackTimeDatabaseInput("ca0e7040-b42c-4cf3-9b4e-4a9a06129cec", "11/11/18", "11/17/18");
var trackTimeList = new List <GetTrackTimeDatabaseOutput>();
//Act
await _trackTimeRepo.CreateNewTrackTimeRecord(createNewRecordInput);
trackTimeList = await _trackTimeRepo.GetTrackTime(getTrackTimeInput);
//Assert
Assert.NotNull(trackTimeList);
}
/// <summary>
/// Given a userGuid return TrackTime data
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <List <GetTrackTimeDatabaseOutput> > GetTrackTime(GetTrackTimeDatabaseInput input)
{
var p = new DynamicParameters();
p.Add("@p_UserGuid", input.UserGuid);
p.Add("@p_StartDate", input.StartDate);
p.Add("@p_EndDate", input.EndDate);
IEnumerable <GetTrackTimeDatabaseOutput> trackTime;
using (IDbConnection connection = new SqlConnection(_connectionString))
{
trackTime = await connection.QueryAsync <GetTrackTimeDatabaseOutput>("sp_GetTrackTime", p, commandType : CommandType.StoredProcedure);
}
var trackTimeList = trackTime.ToList();
//Incase the comment is null make it a string
trackTimeList.ForEach(x => x.Comments = x.Comments ?? "");
return(trackTimeList);
}
/// <summary>
/// Get the TrackTime Details
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <List <GetTrackTimeDatabaseOutput> > GetTrackTime(GetTrackTimeDatabaseInput input)
{
return(await _ITrackTimeRepo.GetTrackTime(input));
}
