/// <summary> /// 根据单词包id查找单词 /// </summary> /// <param name="cd"></param> /// <returns></returns> public List <CourseDetails> CourseDetail_Id(CourseDetails cd) { string sql = "select * from CourseDetails where C_ID=@id"; SqlParameter[] par = new SqlParameter[1] { new SqlParameter("@id", cd.C_ID) }; List <CourseDetails> list = new List <CourseDetails>(); SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, par); if (sdr.HasRows) { while (sdr.Read()) { cd.CD_ID = Convert.ToInt32(sdr["CD_ID"]); cd.CD_NAME = sdr["CD_NAME"].ToString(); cd.CD_YINBIAO = sdr["CD_YINBIAO"].ToString(); cd.CD_Mean = sdr["CD_Mean"].ToString(); cd.CD_RIGHT_PIC = (byte[])sdr["CD_RIGHT_PIC"]; cd.CD_WRONG_PIC1 = (byte[])sdr["CD_WRONG_PIC1"]; cd.CD_WRONG_PIC2 = (byte[])sdr["CD_WRONG_PIC2"]; cd.CD_WRONG_PIC3 = (byte[])sdr["CD_WRONG_PIC3"]; cd.CD_SENEng = sdr["CD_SENEng"].ToString(); cd.CD_SENChi = sdr["CD_SENChi"].ToString(); cd.CD_VIDEO = sdr["CD_VIDEO"].ToString(); list.Add(cd); } } sdr.Close(); return(list); }
/// <summary> /// 根据单词包返回第一条单词的记录 /// </summary> /// <param name="cid"></param> /// <returns></returns> public CourseDetails QueryCourseDetails1(int cid) { string sql = "select top 1 * from CourseDetails where c_id=@cid"; SqlParameter[] par = new SqlParameter[1] { new SqlParameter("@cid", cid) }; SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, par); CourseDetails cd = new CourseDetails(); while (sdr.Read()) { cd.C_ID = Convert.ToInt32(sdr["C_ID"]); cd.CD_ID = Convert.ToInt32(sdr["CD_ID"]); cd.CD_NAME = sdr["CD_NAME"].ToString(); cd.CD_YINBIAO = sdr["CD_YINBIAO"].ToString(); cd.CD_Mean = sdr["CD_Mean"].ToString(); cd.CD_RIGHT_PIC = (byte[])sdr["CD_RIGHT_PIC"]; cd.CD_WRONG_PIC1 = (byte[])sdr["CD_WRONG_PIC1"]; cd.CD_WRONG_PIC2 = (byte[])sdr["CD_WRONG_PIC2"]; cd.CD_WRONG_PIC3 = (byte[])sdr["CD_WRONG_PIC3"]; cd.CD_SENEng = sdr["CD_SENEng"].ToString(); cd.CD_SENChi = sdr["CD_SENChi"].ToString(); cd.CD_VIDEO = sdr["CD_VIDEO"].ToString(); } return(cd); }
public void ShowHideBackToResultsTest(bool referralUrlExists) { // Arrange var courseDetailsHtml = new _MVC_Views_CourseDetails_CourseDetails_cshtml(); var courseDetailsViewModel = new CourseDetailsViewModel(); var courseDetails = new CourseDetails(); if (referralUrlExists) { courseDetailsViewModel.ReferralPath = nameof(CourseDetailsViewModel.ReferralPath); } else { courseDetailsViewModel.ReferralPath = null; } // Act var htmlDocument = courseDetailsHtml.RenderAsHtml(courseDetailsViewModel); // Assert if (referralUrlExists) { htmlDocument.DocumentNode.Descendants("a") .Any(a => a.Attributes["class"].Value.Contains("govuk-back-link") && a.Attributes["href"].Value.Contains(courseDetailsViewModel.ReferralPath)).Should().BeTrue(); } else { htmlDocument.DocumentNode.Descendants("a") .Any(a => a.Attributes["class"].Value.Contains("govuk-back-link") && a.Attributes["href"].Value.Contains(courseDetailsViewModel.ReferralPath)).Should().BeFalse(); } }
public EditLearningPathwayDefaultsViewModel(CourseDetails courseDetails) { CustomisationId = courseDetails.CustomisationId; CompleteWithinMonths = courseDetails.CompleteWithinMonths.ToString(); ValidityMonths = courseDetails.ValidityMonths.ToString(); Mandatory = courseDetails.Mandatory; AutoRefresh = courseDetails.AutoRefresh; }
public CourseSummaryViewModel(CourseDetails courseDetails) { CurrentVersion = courseDetails.CurrentVersion; CreatedDate = courseDetails.CreatedDate.ToString(DateHelper.StandardDateFormat); LastAccessed = courseDetails.LastAccessed?.ToString(DateHelper.StandardDateFormat); Completions = courseDetails.CompletedCount; ActiveLearners = courseDetails.InProgressCount; }
public ActionResult DeleteConfirmed(int id) { CourseDetails courseDetails = db.CourseDetails.Find(id); db.CourseDetails.Remove(courseDetails); db.SaveChanges(); return(RedirectToAction("Index")); }
public CourseOptionsViewModel(CourseDetails courseDetails) { Active = courseDetails.Active; AllowSelfEnrolment = courseDetails.SelfRegister; DiagnosticObjectiveSelection = courseDetails.DiagObjSelect; HideInLearningPortal = courseDetails.HideInLearnerPortal; CustomisationId = courseDetails.CustomisationId; ShowDiagnosticObjectiveSelection = courseDetails.DiagAssess; }
public EditAutoRefreshOptionsViewModel( CourseDetails courseDetails, int customisationId, IEnumerable <SelectListItem> courseOptions ) : base(courseDetails) { CustomisationId = customisationId; CourseOptions = courseOptions; }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["xx"] != null) { xx = Convert.ToInt32(Request.QueryString["xx"]); } //进入页面后 首先加载出第一个单词的信息 if (xx < 2) { if (Session["ID"] != null) { if (Session["c_id"] == null) { Session["c_id"] = 1; } UserCollect_Bll uc_b = new UserCollect_Bll(); UserCollect uc = new UserCollect(); uc = uc_b.GetUserCollect(Convert.ToInt32(Session["ID"])); GetCourseID = uc.C_ID; CourseDetail_Bll cd_b = new CourseDetail_Bll(); CourseDetails cd = new CourseDetails(); cd = cd_b.QueryCourseDetails1(GetCourseID); Session["c_id"] = GetCourseID; Words_ID = cd.CD_ID; xx = Words_ID; Session["cd_id"] = Words_ID; Words_name = cd.CD_NAME; Learning_Words.Text = Words_name; Learning_Words_Sentence.Text = cd.CD_SENEng; Pic_1.ImageUrl = "getpic1.aspx?cd_id=" + Words_ID; Pic_2.ImageUrl = "getpic2.aspx?cd_id=" + Words_ID; Pic_3.ImageUrl = "getpic3.aspx?cd_id=" + Words_ID; Pic_4.ImageUrl = "getpic4.aspx?cd_id=" + Words_ID; } } else { UserCollect_Bll uc_b = new UserCollect_Bll(); UserCollect uc = new UserCollect(); uc = uc_b.GetUserCollect(Convert.ToInt32(Session["ID"])); GetCourseID = uc.C_ID; CourseDetail_Bll cd_b = new CourseDetail_Bll(); CourseDetails cd = new CourseDetails(); cd = cd_b.QueryCourseDetails1(GetCourseID, xx); Session["c_id"] = GetCourseID; Words_ID = cd.CD_ID; Session["cd_id"] = Words_ID; Words_name = cd.CD_NAME; Learning_Words.Text = Words_name; Learning_Words_Sentence.Text = cd.CD_SENEng; Pic_1.ImageUrl = "getpic1.aspx?cd_id=" + Words_ID; Pic_2.ImageUrl = "getpic2.aspx?cd_id=" + Words_ID; Pic_3.ImageUrl = "getpic3.aspx?cd_id=" + Words_ID; Pic_4.ImageUrl = "getpic4.aspx?cd_id=" + Words_ID; } }
public ManageCourseViewModel(CourseDetails courseDetails) { CustomisationId = courseDetails.CustomisationId; Active = courseDetails.Active; CourseName = courseDetails.CourseName; SummaryViewModel = new CourseSummaryViewModel(courseDetails); DetailsViewModel = new CourseDetailsViewModel(courseDetails); OptionsViewModel = new CourseOptionsViewModel(courseDetails); LearningPortalDefaultsViewModel = new LearningPathwayDefaultsViewModel(courseDetails); }
public IActionResult Create( [Bind("Description,CourseFee")] CourseDetails courseDetails) { if (ModelState.IsValid) { School.Addcourse(courseDetails.Description, courseDetails.CourseFee); return(RedirectToAction(nameof(Index))); } return(View(courseDetails)); }
public ActionResult Edit([Bind(Include = "detailID,courseName,courseDescription,instructorName")] CourseDetails courseDetails) { if (ModelState.IsValid) { db.Entry(courseDetails).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(courseDetails)); }
public ActionResult GetCourseDetails() { GetDepartment(); string query = "SELECT * FROM Course WHERE DepartmentId = '" + Request["selectedDepartment"] + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CourseDetails aCourseDetails = new CourseDetails(); // POPULATE THE LIST WITH BIRD DETAILS. while (reader.Read()) { if (!DBNull.Value.Equals(reader["AssignTo"])) { courseDetailses.Add(new CourseDetails { Name = reader["Name"].ToString(), Code = reader["Code"].ToString(), SemesterName = reader["SemesterId"].ToString(), AssignTo = reader["AssignTo"].ToString() }); } else { courseDetailses.Add(new CourseDetails { Name = reader["Name"].ToString(), Code = reader["Code"].ToString(), SemesterName = reader["SemesterId"].ToString(), AssignTo = "Not Assigned Yet" }); } } connection.Close(); foreach (var details in courseDetailses) { details.SemesterName = GetSemesterName(int.Parse(details.SemesterName)); if (details.AssignTo == "Not Assigned Yet") { details.AssignTo = "Not Assigned Yet"; } else { details.AssignTo = GetTeacherName(int.Parse(details.AssignTo)); } } // RETURN DETAILS TO THE PARENT VIEW. return(View("CourseWebGridView", courseDetailses)); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["rank"] != null) { rank = Convert.ToInt32(Request.QueryString["rank"]); } string cnstr = ConfigurationManager.ConnectionStrings["cnstr"].ToString(); SqlConnection cn = new SqlConnection(cnstr); cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; //cmd.CommandText = "select cd_Name,ud_State from UserDownload"; cmd.CommandText = " select top 1 * from CourseDetails where CD_ID in(select CD_ID from UserDownload where U_ID=@u_id and UD_CUT=0 and cd_id=@cd_id)"; cmd.Parameters.AddWithValue("@u_id", Convert.ToInt32(Session["ID"])); cmd.Parameters.AddWithValue("@cd_id", rank); SqlDataReader sdr = cmd.ExecuteReader(); CourseDetails cd = new CourseDetails(); if (sdr.HasRows) { while (sdr.Read()) { cd.CD_ID = Convert.ToInt32(sdr["CD_ID"]); cd.C_ID = Convert.ToInt32(sdr["C_ID"]); cd.CD_NAME = sdr["CD_NAME"].ToString(); cd.CD_YINBIAO = sdr["CD_YINBIAO"].ToString(); cd.CD_Mean = sdr["CD_Mean"].ToString(); cd.CD_RIGHT_PIC = (byte[])sdr["CD_RIGHT_PIC"]; cd.CD_WRONG_PIC1 = (byte[])sdr["CD_WRONG_PIC1"]; cd.CD_WRONG_PIC2 = (byte[])sdr["CD_WRONG_PIC2"]; cd.CD_WRONG_PIC3 = (byte[])sdr["CD_WRONG_PIC3"]; cd.CD_SENEng = sdr["CD_SENEng"].ToString(); cd.CD_SENChi = sdr["CD_SENChi"].ToString(); cd.CD_VIDEO = sdr["CD_VIDEO"].ToString(); } } else { Response.Redirect("../List/list.aspx"); Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('复习完毕.');</script>"); } sdr.Close(); cn.Close(); cdid = cd.CD_ID; Learning_Words.Text = cd.CD_NAME; Learning_Words_Sentence.Text = cd.CD_SENEng; Pic_1.ImageUrl = "getpic1.aspx?cd_id=" + cd.CD_ID; Pic_2.ImageUrl = "getpic2.aspx?cd_id=" + cd.CD_ID; Pic_3.ImageUrl = "getpic3.aspx?cd_id=" + cd.CD_ID; Pic_4.ImageUrl = "getpic4.aspx?cd_id=" + cd.CD_ID; }
public ApprenticeshipDetails( long employerAccountLegalEntityId, string employerName, long trainingProviderId, string trainingProviderName, CourseDetails courseDetails) { EmployerAccountLegalEntityId = employerAccountLegalEntityId; EmployerName = employerName; TrainingProviderId = trainingProviderId; TrainingProviderName = trainingProviderName; Course = courseDetails; }
public void GetAllFreeDecksTest() { // Arrange this.courseDetails = new CourseDetails(this.unitOfWork.Object); // Act // Assert Assert.Throws <NotImplementedException>( () => this.courseDetails.GetAllFreeDecks(DateTime.Now)); }
public List <CourseDetails> GetStudentCourseDetils(List <CourseDetails> cL) { List <CourseDetails> cdList = new List <CourseDetails>(); foreach (var c in cL) { CourseDetails cD = aStudentResultGateWay.GetStudentCourseDetils(c.CourseId); cdList.Add(cD); } return(cdList); }
public ActionResult Create([Bind(Include = "detailID,courseName,courseDescription,courseStartDate,instructorName")] CourseDetails courseDetails) { if (ModelState.IsValid) { db.CourseDetails.Add(courseDetails); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(courseDetails)); }
public CourseDetailsViewModel(CourseDetails courseDetails) { CustomisationId = courseDetails.CustomisationId; Password = courseDetails.Password; NotificationEmails = courseDetails.NotificationEmails; PostLearningAssessment = courseDetails.PostLearningAssessment; IsAssessed = courseDetails.IsAssessed; DiagAssess = courseDetails.DiagAssess; TutCompletionThreshold = courseDetails.TutCompletionThreshold; DiagCompletionThreshold = courseDetails.DiagCompletionThreshold; }
public Course(SerializationInfo info, StreamingContext context) { _courseName = info.GetString("Course Name"); _courseDescription = info.GetString("Course Description"); _coursePrefix = info.GetString("Course Prefix"); _courseID = info.GetInt32("Course ID"); _credits = info.GetInt32("Credits"); _validTerms = (HashSet <TermEnums>)info.GetValue("Valid Terms", typeof(HashSet <TermEnums>)); _dependencies = (HashSet <Course>)info.GetValue("Dependencies", typeof(HashSet <Course>)); _copendencies = (HashSet <Course>)info.GetValue("Copendencies", typeof(HashSet <Course>)); _courseDetails = (CourseDetails)info.GetValue("Course Details", typeof(CourseDetails)); }
public LearningPathwayDefaultsViewModel(CourseDetails courseDetails) { CustomisationId = courseDetails.CustomisationId; CompleteWithinMonths = DisplayStringHelper.ConvertNumberToMonthsString(courseDetails.CompleteWithinMonths); CompletionValidFor = DisplayStringHelper.ConvertNumberToMonthsString(courseDetails.ValidityMonths); Mandatory = courseDetails.Mandatory; AutoRefresh = courseDetails.AutoRefresh; RefreshToCustomisationId = courseDetails.RefreshToCustomisationId; RefreshToCourseName = courseDetails.RefreshToCourseName; AutoRefreshMonths = SetMonthDisplayString(courseDetails.AutoRefreshMonths) + " before expiry"; ApplyLpDefaultsToSelfEnrol = courseDetails.ApplyLpDefaultsToSelfEnrol; }
public async Task <IActionResult> Create([Bind("Id,Price,Description,CourseId")] CourseDetails courseDetails) { if (ModelState.IsValid) { _context.Add(courseDetails); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CourseId"] = new SelectList(_context.Course, "Id", "Name", courseDetails.CourseId); return(View(courseDetails)); }
public void CourseName_should_be_ApplicationName_and_CustomisationName_if_CustomisationName_not_null() { // When var courseDetails = new CourseDetails { ApplicationName = "Original course", CustomisationName = "name", }; // Then courseDetails.CourseName.Should().BeEquivalentTo("Original course - name"); }
public void InProgressCount_should_be_TotalDelegates_minus_CompletedCount() { // When var courseDetails = new CourseDetails { DelegateCount = 123, CompletedCount = 81 }; // Then courseDetails.InProgressCount.Should().Be(42); }
public HttpResponseMessage getCourseDetails() { try { CourseDetails response = _business.getCourseDetails(); return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "error")); } }
public ActionResult Edit([Bind(Include = "courseDetailsID,semesterDate,courseID,studentID")] CourseDetails courseDetails) { if (ModelState.IsValid) { db.Entry(courseDetails).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.courseID = new SelectList(db.Courses, "courseID", "courseAbbreviation", courseDetails.courseID); ViewBag.studentID = new SelectList(db.Students, "studentID", "studentFullName", courseDetails.studentID); return(View(courseDetails)); }
public void CourseName_should_be_ApplicationName_if_CustomisationName_is_blank() { // When var courseDetails = new CourseDetails { ApplicationName = "Original course", CustomisationName = string.Empty }; // Then courseDetails.CourseName.Should().BeEquivalentTo("Original course"); }
public void RefreshedToCourseName_should_be_Same_Course_if_RefreshToId_is_Zero() { // When var courseDetails = new CourseDetails { ApplicationName = "Original course", CustomisationName = "name", RefreshToCustomisationId = 0 }; // Then courseDetails.RefreshToCourseName.Should().BeEquivalentTo("Same course"); }
public CourseDetails getCourseDetails() { try { CourseDetails courses = _repository.getCourseDetails(); // CourseDetails[] Response = courses.ToArray(); return(courses); } catch (Exception ex) { throw; } }
public IActionResult Edit(int id, [Bind("CourseCode,CourseStartDate,Description,CourseFee,Grade")] CourseDetails courseDetails) { if (id != courseDetails.CourseCode) { return(NotFound()); } if (ModelState.IsValid) { School.UpdateCourse(courseDetails); return(RedirectToAction(nameof(Index))); } return(View(courseDetails)); }