public EnrollmentStatus PromoteStudents(PromoteStudentsRequest promoteStudentsRequest) { EnrollmentStatus registerStudentStatus = new EnrollmentStatus(); using (var client = new SqlConnection(SqlConn)) using (var command = new SqlCommand()) { command.Connection = client; client.Open(); try { command.CommandText = $"SELECT IdEnrollment FROM Enrollment WHERE Enrollment.Semester = @semester AND IdStudy = (SELECT IdStudy FROM Studies WHERE Studies.Name = @name);"; command.Parameters.AddWithValue("semester", promoteStudentsRequest.Semester); command.Parameters.AddWithValue("name", promoteStudentsRequest.Studies); var dataReader = command.ExecuteReader(); if (!dataReader.Read()) { registerStudentStatus.enrollment = null; registerStudentStatus.Status = 400; registerStudentStatus.Message = "Nie ma takiego semestru dla tych studiów"; return(registerStudentStatus); } dataReader.Close(); command.CommandText = "PromoteStudents"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Clear(); command.Parameters.AddWithValue("@Studies", promoteStudentsRequest.Studies); command.Parameters.AddWithValue("@Semester", promoteStudentsRequest.Semester); int rowAffected = command.ExecuteNonQuery(); command.CommandText = $"SELECT * FROM Enrollment WHERE Enrollment.Semester = @semester AND IdStudy = (SELECT IdStudy FROM Studies WHERE Studies.Name = @name);"; command.CommandType = CommandType.Text; command.Parameters.Clear(); command.Parameters.AddWithValue("@name", promoteStudentsRequest.Studies); command.Parameters.AddWithValue("@semester", promoteStudentsRequest.Semester + 1); dataReader = command.ExecuteReader(); if (!dataReader.Read()) { registerStudentStatus.enrollment = null; registerStudentStatus.Status = 400; registerStudentStatus.Message = "Błąd bazy!"; return(registerStudentStatus); } EnrollmentResponse enrollment = new EnrollmentResponse() { IdEnrollment = int.Parse((dataReader["IdEnrollment"]).ToString()), Semester = promoteStudentsRequest.Semester + 1, IdStudy = int.Parse((dataReader["IdStudy"]).ToString()), StartDate = DateTime.Parse(dataReader["StartDate"].ToString()), }; registerStudentStatus.enrollment = enrollment; registerStudentStatus.Status = 201; registerStudentStatus.Message = "Promowany"; } catch (SqlException exc) { registerStudentStatus.enrollment = null; registerStudentStatus.Status = 400; registerStudentStatus.Message = "Wyjątek bazy danych"; } return(registerStudentStatus); } }
public async Task <bool> verifyOwnerPetEnrollmentStatus(int ownerId, string petName, EnrollmentStatus status = EnrollmentStatus.Enrolled) { bool matchPet = false; ownerCollection = testDataManager.GetEnrolledOwnerCollection(ownerId); foreach (PetAndPolicy pet in ownerCollection.pets) { matchPet = pet.Pet.Name.ToLower().Equals(petName.ToLower()); if (matchPet) { matchPet = pet.PetPolicy.EnrollmentStatusId == (int?)status; Assert.IsTrue(matchPet, $"{petName} enrollment status {pet.PetPolicy.EnrollmentStatusId} is not match the expected {status}"); break; } } Assert.IsTrue(matchPet, $"pet {petName} not found in owner {ownerId}"); return(matchPet); }
/// <summary> /// Create the adaptive card submit action corresponding to the current status. /// </summary> /// <param name="userStatus">user status</param> /// <param name="teamName">Team name the status is for</param> /// <param name="extraData">TeamContext or ChooseUserAndTeamResult object</param> /// <returns>submit action</returns> public static AdaptiveSubmitAction CreateStatusSubmitAction(EnrollmentStatus userStatus, string teamName, object extraData) { var textAndMsg = GetButtonTextAndMsgIdForStatusButton(userStatus, teamName); return(CreateSubmitAction(textAndMsg.Item1, textAndMsg.Item2, extraData)); }
/// <summary> /// Returns a list of user actions that are invoked when an admin wishes to perform the action on behalf of someone else /// </summary> /// <param name="userAndTeam">user and team info</param> /// <param name="enrollmentStatus">enrollment status for the team</param> /// <returns>List of user actions</returns> public static List <AdaptiveAction> CreateUserActionsForAdmin(UserAndTeam userAndTeam, EnrollmentStatus enrollmentStatus) { return(CreateUserActions(enrollmentStatus, userAndTeam.Team.TeamName, userAndTeam)); }
/// <summary> /// Returns a list of user actions that a user can take /// </summary> /// <param name="teamContext">team context for the actions</param> /// <param name="enrollmentStatus">user status for the team</param> /// <returns>List of user actions</returns> public static List <AdaptiveAction> CreateUserActions(TeamContext teamContext, EnrollmentStatus enrollmentStatus) { return(CreateUserActions(enrollmentStatus, teamContext.TeamName, teamContext)); }
public EnrollmentStatus GetEnrollmentStatus(int userId) { var survey = _surveyService.GetSurvey(new SurveyRequest { SurveyName = Settings.SurveyNames.Enrollment, UserID = userId, IncludeResponse = true }); var enrollmentStatus = new EnrollmentStatus() { Pages = survey.Status.Pages, PercentComplete = survey.Status.PercentComplete, State = survey.Status.State }; var questionA = survey.GetQuestion("My Interests", "Acquisition"); var questionC = survey.GetQuestion("My Interests", "Continuity"); var questionS = survey.GetQuestion("My Interests", "Succession"); var questionF = survey.GetQuestion("My Interests", "NeedAcquisitionFunding"); // Business Acquisitions if (questionA != null && questionA.HasAnswer) { var answer = questionA.FindPossibleAnswer("I am interested in Business Acquisitions."); enrollmentStatus.BusinessAcquisition.Interested = answer != null && answer.IsSelected; enrollmentStatus.BusinessAcquisition.HasAnswer = true; } // Funding if (questionF != null && questionF.HasAnswer && enrollmentStatus.BusinessAcquisition.Interested) { var answer = questionF.FindPossibleAnswer("Yes, I need funding and want to learn more."); enrollmentStatus.BusinessAcquisitionFunding.Interested = answer != null && answer.IsSelected; enrollmentStatus.BusinessAcquisitionFunding.HasAnswer = true; } // Continuity if (questionC != null && questionC.HasAnswer) { var answer = questionC.FindPossibleAnswer("I have a written Continuity Plan and I am satisfied that my plan meets all my needs."); enrollmentStatus.ContinuityPlanning.Interested = answer != null && !answer.IsSelected; enrollmentStatus.ContinuityPlanning.HasAnswer = true; } // Succession if (questionS != null && questionS.HasAnswer) { var answer = questionS.FindPossibleAnswer("I have a written Succession Plan and I am satisfied that my plan meets all my needs."); enrollmentStatus.SuccessionPlanning.Interested = answer != null && !answer.IsSelected; enrollmentStatus.SuccessionPlanning.HasAnswer = true; } // Messages enrollmentStatus.ContinuityPlanning.Message = GetInterestMessage(questionC); enrollmentStatus.SuccessionPlanning.Message = GetInterestMessage(questionS); enrollmentStatus.BusinessAcquisition.Message = GetInterestMessage(questionA); enrollmentStatus.BusinessAcquisitionFunding.Message = GetInterestMessage(questionF); // Overwrite message if interested in both acquisition and funding if (enrollmentStatus.BusinessAcquisition.Interested) { enrollmentStatus.BusinessAcquisition.Message = enrollmentStatus.BusinessAcquisitionFunding.Interested ? "You are interested in acquiring a business and need funding and want to learn more." : "You are interested in acquiring a business and do not need funding."; } return(enrollmentStatus); }