/// <summary> /// Sets the caption and builds the message that will be presented to the user whenever /// a <see cref="iClickerQuizPts.AppExceptions.InvalidWshListObjPairException"/> is thrown. /// </summary> /// <param name="pr">The <see langword="struc"/> which is missing either or both the name of the list object and /// the name of the parent worksheet.</param> public static void SetInvalidWshListObjPairMsg(WshListobjPair pr) { // Plug in a "Missing Value" value where appropriate... string wshNm = pr.WshNm; string tblNm = pr.ListObjName; if (string.IsNullOrEmpty(pr.WshNm)) { wshNm = MSG_VAL; } if (string.IsNullOrEmpty(pr.ListObjName)) { tblNm = MSG_VAL; } _caption = "Code Missing a Value"; // Build msg... const string S1 = "There is a problem with this application's code."; const string S2 = "The code requires a value for both the name of an Excel ListObject (i.e., Table) and of its parent worksheet. "; const string S3 = "However, at least one of these values is missing."; _msg = string.Format($"{S1}\n\n{S2}{S3}\n\n\tWsh name:\t{wshNm}\n\n\tTable name:\t{tblNm}\n\n{CANNOT_CONTINUE}"); }
/// <summary> /// Sets the caption and builds the message that will be presented to the user whenever /// a <see cref="iClickerQuizPts.AppExceptions.MissingWorksheetException"/> is thrown. /// </summary> /// <param name="pr">The <see langword="struc"/> which contains the name of the missisng /// worksheet.</param> public static void SetMissingWshMsg(WshListobjPair pr) { _caption = "This Workbook Has Been Altered"; // Build msg... const string S1 = "We cannot find at least one of the Worksheets originally built into this workbook. "; _msg = string.Format($"{S1}\n\n\tMissing worksheet:\n\t\t{pr.WshNm}\n\n{CANNOT_CONTINUE}"); }
/// <summary> /// Sets the caption and builds the message that will be presented to the user whenever /// a <see cref="iClickerQuizPts.AppExceptions.MissingListObjectException"/> is thrown. /// </summary> /// <param name="pr">The <see langword="struc"/> which contains the name of the missisng /// list object and the name of the parent worksheet.</param> public static void SetMissingListObjMsg(WshListobjPair pr) { _caption = "This Workbook Has Been Altered"; // Build msg... const string S1 = "We cannot find at least one of the ListObjects (Tables) required to run this application. "; _msg = string.Format($"{S1}\n\n\tMissing ListObject(Table):\n\t\t{pr.ListObjName}"); _msg = string.Format($"{_msg}\n\n\tWorksheet:\n\t\t{pr.WshNm}\n\n{CANNOT_CONTINUE}"); }
/// <summary> /// Instantiates the (currently) 2 fields of List Object wrapper classes. /// </summary> public virtual void InstantiateListObjWrapperClasses() { // Define the wsh-ListObj pairs... WshListobjPair quizDataLOInfo = new WshListobjPair("tblClkrQuizGrades", Globals.Sheet1.Name); WshListobjPair dblDpprsLOInfo = new WshListobjPair("tblDblDippers", Globals.Sheet2.Name); // Instantiate quiz data class... try { _qdLOWrppr = new QuizDataLOWrapper(quizDataLOInfo); } catch (ApplicationException ex) { throw ex; } try { _qdLOWrppr.SetListObjAndParentWshPpts(); } catch (ApplicationException ex) { throw ex; } // Instantiate double dippers class... try { _ddsLOWrppr = new DblDippersLOWrapper(dblDpprsLOInfo); } catch (ApplicationException ex) { throw ex; } try { _ddsLOWrppr.SetListObjAndParentWshPpts(); } catch (ApplicationException ex) { throw ex; } }