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