public ActionResult EditLesson(int id, string title, string text, string pdf, string inactive) { ViewBag.error = ""; if (id > 0) { Boolean inActive = false; inActive = (inactive == "on") ? true : false; // retrieve the lesson with the id try { B2BDataContext db = new B2BDataContext(); B2BLesson lesson = new B2BLesson(); lesson = db.B2BLessons.Where(x => x.id == id).FirstOrDefault<B2BLesson>(); lesson.title = title; lesson.Text = text; lesson.inactive = inActive; db.SubmitChanges(); B2BVideo videoObj = new B2BVideo(); videoObj = db.B2BVideos.Where(x => x.lessonID == lesson.id).FirstOrDefault<B2BVideo>(); db.SubmitChanges(); B2BResource pdfObj = new B2BResource(); pdfObj = db.B2BResources.Where(x => x.lessonID.Equals(lesson.id)).FirstOrDefault<B2BResource>(); pdfObj.file_path = pdf; db.SubmitChanges(); ViewBag.lesson = lesson; ViewBag.video = videoObj; ViewBag.pdf = pdfObj; ViewBag.msg = "The Lesson changes have been made."; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
public static void addLesson(int catID, string title, string text, string pdf, bool inActive) { try { B2BDataContext db = new B2BDataContext(); B2BLesson newLesson = new B2BLesson(); newLesson.catID = catID; newLesson.title = title; newLesson.Text = text; newLesson.date_added = DateTime.Now; newLesson.date_modified = DateTime.Now; newLesson.inactive = inActive; db.B2BLessons.InsertOnSubmit(newLesson); db.SubmitChanges(); B2BResource newPDF = new B2BResource(); newPDF.file_path = pdf; newPDF.date_added = DateTime.Now; newPDF.sort = 1; newPDF.lessonID = newLesson.id; newPDF.title = title + " PDF"; newPDF.image_path = "https://www.curtmfg.com/assets/f70444af-54b2-4242-8eca-13dacd6e715c.png"; db.B2BResources.InsertOnSubmit(newPDF); db.SubmitChanges(); } catch (Exception e) { throw new Exception("Could not add Lesson: " + e.Message); } }