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 static void addAnswer(int questionID, string text, bool isCorrect, bool inActive) { try { B2BDataContext db = new B2BDataContext(); B2BAnswer newAnswer = new B2BAnswer(); newAnswer.questionID = questionID; newAnswer.text = text; newAnswer.isCorrect = isCorrect; newAnswer.date_added = DateTime.Now; newAnswer.date_modified = DateTime.Now; newAnswer.inactive = inActive; db.B2BAnswers.InsertOnSubmit(newAnswer); db.SubmitChanges(); } catch (Exception e) { throw new Exception("Could not add Answer: " + e.Message); } }
public static void addCat(int certID, string title, string text, string image_path, bool inActive) { try { B2BDataContext db = new B2BDataContext(); B2BCategory newCat = new B2BCategory(); newCat.certID = certID; newCat.title = title; newCat.text = text; newCat.image_path = image_path; newCat.date_added = DateTime.Now; newCat.date_modified = DateTime.Now; newCat.inactive = inActive; db.B2BCategories.InsertOnSubmit(newCat); db.SubmitChanges(); } catch (Exception e) { throw new Exception("Could not add category: " + e.Message); } }
//////////////////////== Create ==//////////////////////////// public static void addCert(string title, string text, int reqNum, string image_path, bool inActive) { try { B2BDataContext db = new B2BDataContext(); B2BCertificate newCertificate = new B2BCertificate(); newCertificate.title = title; newCertificate.text = text; newCertificate.requirementNum = reqNum; newCertificate.image_path = image_path; newCertificate.date_added = DateTime.Now; newCertificate.date_modified = DateTime.Now; newCertificate.inactive = inActive; db.B2BCertificates.InsertOnSubmit(newCertificate); db.SubmitChanges(); } catch (Exception e) { throw new Exception("Could not add certificate: " + e.Message); } }
public static B2BTest getTest(int testID) { try { B2BDataContext db = new B2BDataContext(); B2BTest test = new B2BTest(); test = db.B2BTests.Where(x => x.id == testID).Select(x => x).FirstOrDefault<B2BTest>(); return test; } catch (Exception e) { throw new Exception("Could not load the test: " + e.Message); } }
public static string DeleteTest(int id) { try { B2BDataContext db = new B2BDataContext(); B2BTest test = new B2BTest(); test = db.B2BTests.Where(x => x.id == id).FirstOrDefault<B2BTest>(); db.B2BTests.DeleteOnSubmit(test); db.SubmitChanges(); return ""; } catch (Exception) { return "Error while deleting"; } }
public ActionResult EditTest(int id, string title, string text, double minPassPercent, string inactive) { ViewBag.error = ""; if (id > 0) { Boolean inActive = false; inActive = (inactive == "on") ? true : false; // retrieve the test with the id try { B2BDataContext db = new B2BDataContext(); B2BTest test = new B2BTest(); test = db.B2BTests.Where(x => x.id == id).FirstOrDefault<B2BTest>(); test.title = title; test.text = text; test.min_pass_percent = minPassPercent; test.inactive = inActive; db.SubmitChanges(); ViewBag.test = test; ViewBag.msg = "The test changes have been made."; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
// get individual objects public static B2BAnswer getAnswer(int answerID) { try { B2BDataContext db = new B2BDataContext(); B2BAnswer answer = new B2BAnswer(); answer = db.B2BAnswers.Where(x => x.id == answerID).Select(x => x).FirstOrDefault<B2BAnswer>(); return answer; } catch (Exception e) { throw new Exception("could not retrieve the answer: " + e.Message); } }
///////////////////== AJAX == //////////////////////////////////// public static string SetPlaqueStatus(int certID, int userID) { try { B2BDataContext db = new B2BDataContext(); B2BCompletedCert compCert = new B2BCompletedCert(); B2BUser b2bUser = getB2BUser(userID); compCert = db.B2BCompletedCerts.Where(x => x.certID == certID && x.B2BUserID == b2bUser.id).FirstOrDefault<B2BCompletedCert>(); if (compCert.hasPlaque == false) { compCert.hasPlaque = true; } else { compCert.hasPlaque = false; } db.SubmitChanges(); return ""; } catch (Exception e) { return "Error setting plaque status"; } }
public static List<B2BVideoType> getVideoTypes() { try { List<B2BVideoType> listOfVideoTypes = new List<B2BVideoType>(); B2BDataContext db = new B2BDataContext(); listOfVideoTypes = db.B2BVideoTypes.ToList<B2BVideoType>(); return listOfVideoTypes; } catch (Exception e) { throw new Exception("Could not load B2B video types: " + e.Message); } }
public static List<B2BCategory> getCategories(int certID) { try { B2BDataContext db = new B2BDataContext(); List<B2BCategory> listOfCategories = new List<B2BCategory>(); listOfCategories = db.B2BCategories.Where(x => x.certID == certID).Select(x => x).ToList<B2BCategory>(); return listOfCategories; } catch (Exception e) { throw new Exception("Could not load categories: " + e.Message); } }
public static List<B2BFullUser> getB2BUsers(int custID = 0) { List<B2BUser> listOfB2BUsers = new List<B2BUser>(); B2BDataContext db = new B2BDataContext(); CurtDevDataContext cdb = new CurtDevDataContext(); if (custID == 0) { listOfB2BUsers = db.B2BUsers.ToList<B2BUser>(); } else { List<CustomerUser> listOfUsers = cdb.CustomerUsers.Where(x => x.cust_id == custID).ToList<CustomerUser>(); foreach (CustomerUser user in listOfUsers) { B2BUser b2bUser = db.B2BUsers.Where(x => x.customerUserEmail == user.email).FirstOrDefault<B2BUser>(); if (b2bUser != null) { listOfB2BUsers.Add(b2bUser); } } } List<B2BFullUser> listOfFullUsers = new List<B2BFullUser>(); foreach (B2BUser user in listOfB2BUsers) { listOfFullUsers.Add(B2BFullUser.castToFullUser(user)); // add the generated full user to the list of Full Users }// end foreach b2b user return listOfFullUsers; }
public static B2BUser getB2BUser(string customerUserEmail) { try { B2BUser b2bUser = new B2BUser(); B2BDataContext db = new B2BDataContext(); b2bUser = db.B2BUsers.Where(x => x.customerUserEmail == customerUserEmail).Select(x => x).FirstOrDefault<B2BUser>(); return b2bUser; } catch (Exception) { throw new Exception("Could not retrieve B2B user information."); } }
public static B2BUser getB2BUser(int b2bUserID) { try { // get b2b user with the id being passed in B2BDataContext db = new B2BDataContext(); B2BUser b2bUser = db.B2BUsers.Where(x => x.id == b2bUserID).Select(x => x).FirstOrDefault<B2BUser>(); return b2bUser; } catch (Exception e) { throw new Exception("Could not load B2B User Info: " + e.Message); } }
public static B2BFullUser getB2BFullUser(int b2bUserID) { try { // get b2b user with the id being passed in B2BDataContext db = new B2BDataContext(); B2BUser b2bUser = db.B2BUsers.Where(x => x.id == b2bUserID).Select(x => x).FirstOrDefault<B2BUser>(); // cast b2b user to full user and return it return B2BFullUser.castToFullUser(b2bUser); } catch (Exception e) { throw new Exception("Could get get B2B user: " + e.Message); } }
public static List<Customer> getB2BCustomers() { B2BDataContext b2bdb = new B2BDataContext(); CurtDevDataContext db = new CurtDevDataContext(); // get list of users emails. List<string> listofEmails = b2bdb.B2BUsers.Select(x => x.customerUserEmail).ToList<string>(); List<CustomerUser> users = new List<CustomerUser>(); // loop through the list of emails and get the users with those emails. foreach (string email in listofEmails) { users.Add(db.CustomerUsers.Where(x => x.email == email).FirstOrDefault<CustomerUser>()); } List<Customer> listOfCustomers = new List<Customer>(); // grab all the distinct customer records from that list of users. listOfCustomers = users.Select(x => x.Customer).Distinct().ToList<Customer>(); return listOfCustomers; }
public static List<B2BTest> getTests(int lessonID) { try { B2BDataContext db = new B2BDataContext(); List<B2BTest> listOfTests = new List<B2BTest>(); listOfTests = db.B2BTests.Where(x => x.lessonID == lessonID).Select(x => x).ToList<B2BTest>(); return listOfTests; } catch (Exception e) { throw new Exception("could not load tests: " + e.Message); } }
public static B2BCategory getCategory(int catID) { try { B2BDataContext db = new B2BDataContext(); B2BCategory cat = new B2BCategory(); cat = db.B2BCategories.Where(x => x.id == catID).Select(x => x).FirstOrDefault<B2BCategory>(); return cat; } catch (Exception e) { throw new Exception("Could not load category: " + e.Message); } }
public static B2BVideo getVideo(int videoID) { try { B2BDataContext db = new B2BDataContext(); B2BVideo video = new B2BVideo(); video = db.B2BVideos.Where(x => x.id == videoID).Select(x => x).FirstOrDefault<B2BVideo>(); return video; } catch (Exception e) { throw new Exception("Could not laod the video: " + e.Message); } }
public ActionResult EditAnswer(int id, string text, string isCorrect, string inactive) { ViewBag.error = ""; Boolean inActive = false; inActive = (inactive == "on") ? true : false; bool isCorrectAnswer = false; if (isCorrect == "on") { isCorrectAnswer = true; } else { isCorrectAnswer = false; } if (id > 0) { // retrieve the answer with the id try { B2BDataContext db = new B2BDataContext(); B2BAnswer answer = new B2BAnswer(); answer = db.B2BAnswers.Where(x => x.id == id).FirstOrDefault<B2BAnswer>(); answer.text = text; answer.isCorrect = isCorrectAnswer; answer.inactive = inActive; db.SubmitChanges(); ViewBag.answer = answer; ViewBag.msg = "The answer has been changed."; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
public static bool isCustomerUser(string custID) { B2BDataContext dbB2B = new B2BDataContext(); CurtDevDataContext db = new CurtDevDataContext(); CustomerUser customerUserCheck = db.CustomerUsers.Where(x => x.id.ToString() == custID.ToString()).Select(x => x).FirstOrDefault<CustomerUser>(); if (customerUserCheck == null) { // the b2bUser is a customer return false; } else { // the b2bUser is a customer User return true; } }
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 B2BCertificate getCertificate(int certID) { try { B2BDataContext db = new B2BDataContext(); B2BCertificate cert = new B2BCertificate(); cert = db.B2BCertificates.Where(x => x.id == certID).Select(x => x).FirstOrDefault<B2BCertificate>(); return cert; } catch (Exception e) { throw new Exception("Could not load certificate: " + e.Message); } }
public static string DeleteVideo(int id) { try { B2BDataContext db = new B2BDataContext(); B2BVideo video = new B2BVideo(); video = db.B2BVideos.Where(x => x.id == id).FirstOrDefault<B2BVideo>(); db.B2BVideos.DeleteOnSubmit(video); db.SubmitChanges(); return ""; } catch (Exception) { return "Error while deleting"; } }
public ActionResult EditCert(int id, string title, string text, int reqNum, string logo, string inactive) { ViewBag.error = ""; if (id > 0) { Boolean inActive = false; inActive = (inactive == "on") ? true : false; // retrieve the cert with the id try { B2BDataContext db = new B2BDataContext(); B2BCertificate cert = new B2BCertificate(); cert = db.B2BCertificates.Where(x => x.id == id).FirstOrDefault<B2BCertificate>(); cert.title = title; cert.text = text; cert.requirementNum = reqNum; cert.image_path = logo; cert.inactive = inActive; db.SubmitChanges(); ViewBag.cert = cert; ViewBag.msg = "The certificate changes have been made."; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
//////////////////////== Read ==///////////////////////////// public static List<B2BCertificate> getCertificates() { try { B2BDataContext db = new B2BDataContext(); List<B2BCertificate> listOfCertificates = new List<B2BCertificate>(); listOfCertificates = db.B2BCertificates.Select(x => x).ToList<B2BCertificate>(); return listOfCertificates; } catch (Exception e) { throw new Exception("Could not load certificates: " + e.Message); } }
public ActionResult EditQuestion(int id, string text, string inactive) { ViewBag.error = ""; if (id > 0) { Boolean inActive = false; inActive = (inactive == "on") ? true : false; // retrieve the question with the id try { B2BDataContext db = new B2BDataContext(); B2BQuestion question = new B2BQuestion(); question = db.B2BQuestions.Where(x => x.id == id).FirstOrDefault<B2BQuestion>(); question.text = text; question.inactive = inActive; db.SubmitChanges(); ViewBag.question = question; ViewBag.msg = "The question has been changed."; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
public static List<B2BLesson> getLessons(int catID) { try { B2BDataContext db = new B2BDataContext(); List<B2BLesson> listOfLessons = new List<B2BLesson>(); listOfLessons = db.B2BLessons.Where(x => x.catID == catID).Select(x => x).ToList<B2BLesson>(); return listOfLessons; } catch (Exception e) { throw new Exception("Could not load lessons: " + e.Message); } }
public ActionResult EditVideo(int id, string title, string mp4, string ogg, string webm, string inactive) { ViewBag.error = ""; Boolean inActive = false; inActive = (inactive == "on") ? true : false; bool isCorrectAnswer = false; if (id > 0 && title != "") { // retrieve the video with the id try { B2BDataContext db = new B2BDataContext(); B2BVideo video = db.B2BVideos.Where(x => x.id == id).FirstOrDefault<B2BVideo>(); video.title = title; video.inactive = inActive; db.SubmitChanges(); if (mp4.Length > 0) { B2BVideoSource mp4videoSrc = new B2BVideoSource(); mp4videoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "mp4").Select(x => x).FirstOrDefault<B2BVideoSource>(); if (mp4videoSrc != null) { mp4videoSrc.filePath = mp4; db.SubmitChanges(); } else { B2BVideoSource newMp4Source = new B2BVideoSource(); newMp4Source.filePath = mp4; newMp4Source.videoID = id; B2BVideoType videoType = B2B.getVideoTypes().Where(x => x.type == "mp4").FirstOrDefault(); newMp4Source.typeID = videoType.id; db.B2BVideoSources.InsertOnSubmit(newMp4Source); db.SubmitChanges(); } } if (ogg.Length > 0) { B2BVideoSource oggvideoSrc = new B2BVideoSource(); oggvideoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "ogg").Select(x => x).FirstOrDefault<B2BVideoSource>(); if (oggvideoSrc != null) { oggvideoSrc.filePath = ogg; db.SubmitChanges(); } else { B2BVideoSource newoggSource = new B2BVideoSource(); newoggSource.filePath = ogg; newoggSource.videoID = id; B2BVideoType videoType = B2B.getVideoTypes().Where(x => x.type == "ogg").FirstOrDefault(); newoggSource.typeID = videoType.id; db.B2BVideoSources.InsertOnSubmit(newoggSource); db.SubmitChanges(); } } if (webm.Length > 0) { B2BVideoSource webmvideoSrc = new B2BVideoSource(); webmvideoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "webm").Select(x => x).FirstOrDefault<B2BVideoSource>(); if (webmvideoSrc != null) { webmvideoSrc.filePath = webm; db.SubmitChanges(); } else { B2BVideoSource newwebmSource = new B2BVideoSource(); newwebmSource.filePath = webm; newwebmSource.videoID = id; B2BVideoType videoType = B2B.getVideoTypes().Where(x => x.type == "webm").FirstOrDefault(); newwebmSource.typeID = videoType.id; db.B2BVideoSources.InsertOnSubmit(newwebmSource); db.SubmitChanges(); } } ViewBag.msg = "The video has been changed."; ViewBag.video = video; ViewBag.lesson = B2B.getLesson(video.lessonID); B2BVideoSource videoSrc = new B2BVideoSource(); videoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "mp4").Select(x => x).FirstOrDefault<B2BVideoSource>(); ViewBag.mp4 = videoSrc.filePath; videoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "ogg").Select(x => x).FirstOrDefault<B2BVideoSource>(); ViewBag.ogg = videoSrc.filePath; videoSrc = video.B2BVideoSources.Where(x => x.VideoTypes.type == "webm").Select(x => x).FirstOrDefault<B2BVideoSource>(); ViewBag.webm = videoSrc.filePath; } catch (Exception e) { ViewBag.error = e.Message; } } else { return RedirectToAction("Index"); } return View(); }
public static B2BQuestion getQuestion(int questionID) { try { B2BDataContext db = new B2BDataContext(); B2BQuestion question = new B2BQuestion(); question = db.B2BQuestions.Where(x => x.id == questionID).Select(x => x).FirstOrDefault<B2BQuestion>(); return question; } catch (Exception e) { throw new Exception("Could not load the question: " + e.Message); } }