public async Task <IActionResult> PutCourseDetail(int id, CourseDetail courseDetail)
{
if (id != courseDetail.CId)
{
return(BadRequest());
}
_context.Entry(courseDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CourseDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IActionResult UpdateCourse(int id, CourseDetail course)
{
if (id != course.CourseDetailId)
{
return(BadRequest());
}
_context.Entry(course).State = EntityState.Modified;
_context.subjects.UpdateRange(course.subjects);
try
{
_context.SaveChanges();
var courses = _context.courseDetails.Include(s => s.subjects).FirstOrDefault(i => i.CourseDetailId == id);
return(Ok(course));
}
catch (DbUpdateConcurrencyException)
{
if (!CourseDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
//获取课程详细信息
public static CourseDetail getCourseDetail(string course_id, string inst_id)
{
CourseDetail course = new CourseDetail();
OracleConnection conn = new OracleConnection(connectionString);
try
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from instructor";
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
}
}
catch (Exception e)
{
Console.Write(e.Message);
}
finally
{
conn.Close();
}
return(course);
}
protected void Page_Load(object sender, EventArgs e)
{
//Application specific authentication, or other logic, goes here
//Grab course id from request
String courseId = Request["courseid"];
//Get properties editor url from ScormCloud client lib
CourseDetail courseDetail = ScormCloud.CourseService.GetCourseDetail(courseId);
StringBuilder ct = new StringBuilder();
ct.AppendLine("<table class=\"coursesTable\">");
ct.AppendLine("<tr>");
ct.AppendLine("<td>Title</td><td>" + courseDetail.Title + "</td>");
ct.AppendLine("</tr><tr>");
ct.AppendLine("<td>CourseId</td><td>" + courseDetail.CourseId + "</td>");
ct.AppendLine("</tr><tr>");
ct.AppendLine("<td>Number of Versions</td><td>" + courseDetail.NumberOfVersions + "</td>");
ct.AppendLine("</tr><tr>");
ct.AppendLine("<td>Number of Registrations</td><td>" + courseDetail.NumberOfRegistrations + "</td>");
ct.AppendLine("</tr><tr>");
ct.AppendLine("<td>Learning Standard</td><td>" + courseDetail.LearningStandard + "</td>");
ct.AppendLine("</tr><tr>");
ct.AppendLine("<td>Tin Can / xAPI Activity ID</td><td>" + courseDetail.TincanActivityId + "</td>");
ct.AppendLine("</tr>");
ct.AppendLine("</table>");
courseDetailDiv.InnerHtml = ct.ToString();
}
/// <summary>
/// 下载PPT和源码
/// </summary>
/// <param name="id"></param>
/// <param name="categoryName"></param>
private void DownloadPowerPointAndCode(string id, string categoryName)
{
try
{
string directoryName = BaseDir + categoryName;
if (!Directory.Exists(directoryName))
{
Directory.CreateDirectory(directoryName);
}
using (var wc = new WebClient())
{
Console.WriteLine("\n" + id + "开始下载...");
string jsonString = wc.DownloadString(string.Format(DetailUrl, id));
CourseDetail detail = JsonConvert.DeserializeObject <CourseDetail>(jsonString);
if (!string.IsNullOrWhiteSpace(detail.sourceCodeDownloadURL))
{
var name = "\\" + Path.GetFileName("http://www.jinxuliang.com" + detail.sourceCodeDownloadURL);
wc.DownloadFile("http://www.jinxuliang.com" + detail.sourceCodeDownloadURL, directoryName + name);
}
if (!string.IsNullOrWhiteSpace(detail.originalFileDownloadURL))
{
var name = "\\" + Path.GetFileName("http://www.jinxuliang.com" + detail.originalFileDownloadURL);
wc.DownloadFile("http://www.jinxuliang.com" + detail.originalFileDownloadURL, directoryName + name);
}
}
}
catch (Exception ex)
{
Console.WriteLine("下载PPT和源码发生错误，原因：" + ex.Message);
}
}
public ActionResult AddMember(CourseDetailDTO cd)
{
var User = (TaiKhoan)Session["User"];
if (User == null)
{
return(RedirectToAction("Login", "Login"));
}
var us = ClassService.GetUserInfo((long)cd.UserID);
var course = ClassService.GetClassByID((long)cd.CourseID);
if (course.Capacity == course.NumOfPeo)
{
//Lớp đã đầy
return(Json(2, JsonRequestBehavior.AllowGet));
}
if (us == null || course == null)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
CourseDetail data = new CourseDetail();
data.UserID = us.ID;
data.CourseID = course.ID;
var checkJoin = ClassService.CheckJoinStatus(course.ID, us.ID);
if (checkJoin == false)
{
return(Json(ClassService.AddMember(data), JsonRequestBehavior.AllowGet));
}
return(Json(-1, JsonRequestBehavior.AllowGet));
}
public static CourseDetails ToCourseDetail(this CourseDetail courseDetail)
{
int id = int.TryParse(courseDetail.CourseID, out id) ? id : 0;
return(new CourseDetails(id,
courseDetail.CourseTitle,
courseDetail.CourseSummary,
courseDetail.AwardingBody,
courseDetail.EntryRequirements,
courseDetail.AssessmentMethod,
courseDetail.EquipmentRequired,
courseDetail.URL,
courseDetail.BookingURL,
courseDetail.TariffRequired,
courseDetail.LADID,
courseDetail.QualificationReferenceAuthority,
courseDetail.QualificationReference,
courseDetail.QualificationLevel.ToQualificationLevel(),
courseDetail.QualificationTitle,
courseDetail.Level2EntitlementCategoryDesc,
courseDetail.Level3EntitlementCategoryDesc,
courseDetail.SectorLeadBodyDesc,
courseDetail.AccreditationStartDate,
courseDetail.AccreditationEndDate,
courseDetail.CertificationEndDate,
courseDetail.CreditValue,
courseDetail.QCAGuidedLearningHours,
courseDetail.SkillsForLifeTypeDesc
));
}
public async Task <IActionResult> Create(BackEndProject.Areas.Admin.ViewModels.CourseCreateVM courseVM)
{
if (!ModelState.IsValid)
{
return(View());
}
if (!courseVM.Photo.isImage())
{
ModelState.AddModelError(string.Empty, "Choose photo type");
return(View());
}
CourseFeature feature = courseVM.CourseFeature;
CourseDetail detail = new CourseDetail
{
AboutCourse = courseVM.AboutCourse,
HowToApply = courseVM.HowToApply,
Certification = courseVM.Certification,
Content = courseVM.Content
};
Course course = new Course
{
Name = courseVM.Name,
CourseDetail = detail,
CourseFeature = feature,
Image = await courseVM.Photo.SaveImg(_env.WebRootPath, "img/course")
};
_db.Courses.Add(course);
await _db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
// GET: CourseDetails/Edit/5
public ActionResult Edit(int?courseID, int?holeNumber)
{
if (courseID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// Get the CourseDetailID from CourseID and Hole Number
var HoleDetails = from hd in db.CourseDetails
where hd.CourseID == courseID && hd.HoleNumber == holeNumber
select hd;
int courseDetailID = 0;
foreach (var item in HoleDetails)
{
courseDetailID = item.CourseDetailID;
}
CourseDetail courseDetail = db.CourseDetails.Find(courseDetailID);
if (courseDetail == null)
{
return(HttpNotFound());
}
return(View(courseDetail));
}
public async Task <ActionResult <CourseDetail> > PostCourseDetail(CourseDetail courseDetail)
{
_context.CourseDetails.Add(courseDetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCourseDetail", new { id = courseDetail.CId }, courseDetail));
}
public ActionResult DeleteConfirmed(int id)
{
CourseDetail courseDetail = db.CourseDetails.Find(id);
db.CourseDetails.Remove(courseDetail);
db.SaveChanges();
return RedirectToAction("Index");
}
public string delete(string id)
{
CourseDetail c = new CourseDetail();
c.id = int.Parse(id);
r.delete(c);
return("");
}
public ActionResult Edit([Bind(Include = "CourseDetailID,CourseID,HoleNumber,WhiteYrds,YellowYrds,MensPar,MensSI,RedYrds,LadiesPar,LadiesSI")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "CourseMains", new { id = courseDetail.CourseID }));
}
return(View(courseDetail));
}
public ActionResult Edit([Bind(Include = "CourseId,CourseName,Domain,Type,Duration,Fee,TrainerName,IsEnabled,CreatedOn,CreatedBy")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(courseDetail));
}
public ActionResult DeleteConfirmed(Guid id)
{
CourseDetail courseDetail = db.CourseDetails.Find(id);
courseDetail.IsDeleted = true;
courseDetail.DeletionDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public RedirectToRouteResult SaveCourseDetail(CourseDetail courseDetail)
{
courseDetail.CreatedBy = USER_ID;
courseDetail.CreatedOn = UTILITY.SINGAPORETIME;
courseDetail.ModifiedBy = USER_ID;
courseDetail.ModifiedOn = UTILITY.SINGAPORETIME;
var result = new CourseDetailBO().SaveCouseDetail(courseDetail);
return(RedirectToAction("List"));
}
public ActionResult Edit([Bind(Include = "courseDetailId,seatsAvalible,courseId")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseId = new SelectList(db.Courses, "courseId", "description", courseDetail.courseId);
return(View(courseDetail));
}
public ActionResult Edit([Bind(Include = "courseDetailID,courseName,grade,courseID,studentID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.studentID = new SelectList(db.Students, "studentID", "firstName", courseDetail.studentID);
return(View(courseDetail));
}
public ActionResult Create([Bind(Include = "CourseDetailID,CourseID,HoleNumber,WhiteYrds,YellowYrds,MensPar,MensSI,RedYrds,LadiesPar,LadiesSI")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.CourseDetails.Add(courseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(courseDetail));
}
public ActionResult Edit([Bind(Include = "coursedetailID,courseDescription,textbookPrice,courseID,studentID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "description", courseDetail.courseID);
ViewBag.studentID = new SelectList(db.Students, "studentID", "fullName", courseDetail.studentID);
return(View(courseDetail));
}
public ActionResult Create([Bind(Include = "courseDetailID,description,courseID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.CourseDetails.Add(courseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "courseName", courseDetail.courseID);
return(View(courseDetail));
}
public ActionResult Edit([Bind(Include = "Id,PresentDate,Teachers,CourseId,IsActive,CreationDate,CreateUserId,LastModifiedDate,IsDeleted,DeletionDate,DeleteUserId,Description")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
courseDetail.IsDeleted = false;
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "Id", "Title", courseDetail.CourseId);
return(View(courseDetail));
}
public ActionResult Edit([Bind(Include = "coursedetailID,price,courseID,instructorID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.Entry(courseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "description", courseDetail.courseID);
ViewBag.instructorID = new SelectList(db.Instructors, "instructorID", "firstName", courseDetail.instructorID);
return(View(courseDetail));
}
public ActionResult Create([Bind(Include = "coursedetailID,startDate,endDate,location,courseID,studentID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.CourseDetails.Add(courseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "courseName", courseDetail.courseID);
ViewBag.studentID = new SelectList(db.Students, "studentID", "fullName", courseDetail.studentID);
return(View(courseDetail));
}
public ActionResult Create([Bind(Include = "courseDetailID,qtyInstructor,courseID,instructorID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.CourseDetails.Add(courseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "name", courseDetail.courseID);
ViewBag.instructorID = new SelectList(db.Instructors, "instructorID", "firstName", courseDetail.instructorID);
return(View(courseDetail));
}
public IActionResult AddCourse([FromBody] CourseDetail course)
{
try
{
_context.courseDetails.Add(course);
_context.SaveChanges();
return(CreatedAtAction("GetCourses", course));
}
catch
{
return(BadRequest());
}
}
// GET: CourseDetails/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
CourseDetail courseDetail = db.CourseDetails.Find(id);
if (courseDetail == null)
{
return HttpNotFound();
}
return View(courseDetail);
}
public ActionResult Create([Bind(Include = "courseDetailID,grade,courseID,studentID")] CourseDetail courseDetail)
{
if (ModelState.IsValid)
{
db.CourseDetails.Add(courseDetail);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.courseID = new SelectList(db.Courses, "courseID", "courseDescription", courseDetail.courseID);
ViewBag.studentID = new SelectList(db.Students, "studentID", "firstName", courseDetail.studentID);
return View(courseDetail);
}
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseDetail courseDetail = db.CourseDetails.Find(id);
if (courseDetail == null)
{
return(HttpNotFound());
}
return(View(courseDetail));
}
private CourseDb ConvertToCourseDb(CourseDetail courseDetail)
{
CourseDb course = new CourseDb()
{
Name = courseDetail.Name,
PrerequisiteKnowledge = courseDetail.PrerequisiteKnowledge,
CommenceDate = courseDetail.CommenceDate,
StartAppliedDate = courseDetail.StartAppliedDate,
CompleteDate = courseDetail.CompleteDate,
Tuition = courseDetail.Tuition,
Published = false
};
return(course);
}
public CourseDetail GetCourseDetail(string makh)
{
CourseDetail Su = new CourseDetail();
DataTable dt = new DataTable();
dt = Db.TruyVan_TraVe_DataTable(@"Select KhoaHoc.TenKH, KhoaHoc.Manganh, CTKH.batdau, CTKH.ketthuc, CTKH.Chitiet, CTKH.Hocphi, Nguoidang.Ten, Nguoidang.DT
from KhoaHoc, CTKH, Nguoidang
where KhoaHoc.MaKH=CTKH.Makh and CTKH.Manguoidang=Nguoidang.Ma and KhoaHoc.MaKH='"+makh+"'");
Su.Tenkh = dt.Columns[0].ToString();
Su.Manganh = dt.Columns[1].ToString();
Su.Batdau = dt.Columns[2].ToString();
Su.Ketthuc = dt.Columns[3].ToString();
Su.Chitiet = dt.Columns[4].ToString();
Su.Hocphi = Int32.Parse(dt.Columns[1].ToString());
Su.Ten = dt.Columns[5].ToString();
Su.Dt = dt.Columns[6].ToString();
return Su;
}
