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)); }