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