/// <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));
}
}
