/// <summary> /// Create the entity object by reading the updated values from html form. /// </summary> /// <param name="langArray"></param> /// <param name="controlId"></param> /// <param name="id"></param> /// <returns></returns> protected FileLibraryCategoryData[] createUpdateRecord(CmsLanguage[] langArray, string controlId, int id) { int step = langArray.Length; FileLibraryCategoryData[] data = new FileLibraryCategoryData[step]; for (int x = 0; x < step; x++) { string l = langArray[x].shortCode; data[x] = new FileLibraryCategoryData(); data[x].CategoryId = id; data[x].Lang = langArray[x]; data[x].EventRequired = PageUtils.getFromForm(controlId + "eventRequired", false); data[x].CategoryName = PageUtils.getFromForm(controlId + "name_" + l, ""); data[x].SortOrdinal = PageUtils.getFromForm(controlId + "sortOrdinal", 0); } return(data); }
/// <summary> /// Create table body to show the Event Calendar Category records. /// </summary> /// <param name="langArray"></param> /// <param name="controlId"></param> /// <returns></returns> protected string generateContent(CmsLanguage[] langArray, string controlId) { FileLibraryDb db = new FileLibraryDb(); List <FileLibraryCategoryData> list = db.fetchCategoryList(); int step = langArray.Length; StringBuilder html = new StringBuilder(); for (int x = 0; x < list.Count; x = x + step) { html.Append("<tr>" + EOL); FileLibraryCategoryData data1 = list[x]; html.Append("<td>" + EOL); html.Append("<input class=\"" + controlId + "chgButton\" type=\"button\" value=\"Edit\" title=\"" + data1.CategoryId + "\" />" + EOL); html.Append("<input class=\"" + controlId + "delButton\" type=\"button\" value=\"Delete\" title=\"" + data1.CategoryId + "\" />" + EOL); html.Append("<input class=\"" + controlId + "chgSaveButton\" type=\"button\" value=\"Save\" title=\"" + data1.CategoryId + "\" />" + EOL); html.Append("<input class=\"" + controlId + "chgCancelButton\" type=\"button\" value=\"Cancel\" title=\"" + data1.CategoryId + "\" />" + EOL); html.Append("</td>" + EOL); html.Append("<td>" + EOL); html.Append("<select title=\"" + data1.EventRequired.ToString().ToLower() + "\" class=\"" + controlId + "chg\" disabled=\"disabled\" id=\"" + controlId + "eventRequired_" + data1.CategoryId + "\" name=\"" + controlId + "eventRequired\">" + EOL); html.Append(generateEventRequiredOption(data1.EventRequired.ToString().ToLower())); html.Append("</select>" + EOL); html.Append("</td>" + EOL); html.Append("<td>" + EOL); html.Append("<div id=\"" + controlId + "sortOrdinal_" + data1.CategoryId.ToString() + "\">" + data1.SortOrdinal.ToString() + "</td>" + EOL); html.Append("</td>" + EOL); for (int y = 0; y < step; y++) { string l = langArray[y].shortCode; FileLibraryCategoryData data2 = list[y + x]; string catName = data2.CategoryName; html.Append("<td><div id=\"" + controlId + "name_" + l + "_" + data1.CategoryId + "\">" + catName + "</div></td>" + EOL); } html.Append("</tr>" + EOL); } return(html.ToString()); }
/// <summary> /// Create the entity object by reading the new values from html form. /// </summary> /// <param name="langArray"></param> /// <param name="controlId"></param> /// <returns></returns> protected FileLibraryCategoryData[] createAddRecord(CmsLanguage[] langArray, string controlId) { int step = langArray.Length; FileLibraryCategoryData[] data = new FileLibraryCategoryData[step]; FileLibraryDb db = new FileLibraryDb(); int newId = db.fetchNextCategoryId(); for (int x = 0; x < step; x++) { string l = langArray[x].shortCode; data[x] = new FileLibraryCategoryData(); data[x].CategoryId = newId; data[x].Lang = langArray[x]; data[x].EventRequired = PageUtils.getFromForm(controlId + "addEventRequired", false); data[x].CategoryName = PageUtils.getFromForm(controlId + "addName_" + l, ""); data[x].SortOrdinal = PageUtils.getFromForm(controlId + "addSortOrdinal", 0); } return(data); }
/// <summary> /// Delete record from category table /// </summary> /// <param name="d"></param> /// <returns></returns> protected string handleDelete(FileLibraryCategoryData d) { try { FileLibraryDb db = new FileLibraryDb(); if (db.fetchCountByCategory(d) > 0) { return(formatErrorMsg("Some files under this category, cannot delete category record.")); } else if (db.deleteCategoryData(d) == false) { return(formatErrorMsg("Error deleting record.")); } else { return(""); } } catch (Exception ex) { return(formatErrorMsg("Error deleting record. " + ex.Message)); } }