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);
}
}
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 ActionResult EditLesson(int id)
{
ViewBag.error = "";
if (id > 0) {
B2BLesson lesson = new B2BLesson();
lesson = B2B.getLesson(id);
ViewBag.lesson = lesson;
ViewBag.video = lesson.B2BVideos.FirstOrDefault<B2BVideo>();
ViewBag.pdf = lesson.B2BResources.FirstOrDefault<B2BResource>();
} else {
return RedirectToAction("Index");
}
return View();
}
public static B2BLesson getLesson(int lessonID)
{
try {
B2BDataContext db = new B2BDataContext();
B2BLesson lesson = new B2BLesson();
lesson = db.B2BLessons.Where(x => x.id == lessonID).Select(x => x).FirstOrDefault<B2BLesson>();
return lesson;
} catch (Exception e) {
throw new Exception("Could not load the lesson: " + e.Message);
}
}
public static string DeleteLesson(int id)
{
try {
B2BDataContext db = new B2BDataContext();
B2BLesson lesson = new B2BLesson();
lesson = db.B2BLessons.Where(x => x.id == id).FirstOrDefault<B2BLesson>();
db.B2BLessons.DeleteOnSubmit(lesson);
db.SubmitChanges();
return "";
} catch (Exception) {
return "Error while deleting";
}
}
