public ImageGalleryData getImageGallery(CmsPage page, int identifier, bool createNewIfDoesNotExist)
{
if (page.Id < 0 || identifier < 0)
{
return(new ImageGalleryData());
}
string sql = "";
sql = "select g.ImageGalleryId, g.subDir, g.thumbSize, g.largeSize, g.numThumbsPerRow, i.ImageGalleryImageId, i.Caption, I.Filename from imagegallery g left join imagegalleryimages i on i.ImageGalleryId = g.ImageGalleryId";
sql += " where g.pageid = " + page.Id.ToString() + " and g.identifier = " + identifier.ToString() + " and g.deleted is null;";
DataSet ds = this.RunSelectQuery(sql);
if (this.hasRows(ds))
{
ImageGalleryData data = new ImageGalleryData();
DataRow dr = ds.Tables[0].Rows[0];
data.ImageGalleryId = Convert.ToInt32(dr["ImageGalleryId"]);
data.subDir = (dr["subDir"].ToString().Trim());
data.thumbSize = Convert.ToInt32(dr["thumbSize"]);
data.largeSize = Convert.ToInt32(dr["largeSize"]);
data.numThumbsPerRow = Convert.ToInt32(dr["numThumbsPerRow"]);
foreach (DataRow r in ds.Tables[0].Rows)
{
if (r["ImageGalleryImageId"] != System.DBNull.Value && r["ImageGalleryImageId"] != null)
{
ImageGalleryImageData img = new ImageGalleryImageData();
img.Filename = r["Filename"].ToString();
img.Caption = r["Caption"].ToString();
img.ImageGalleryImageId = Convert.ToInt32(r["ImageGalleryImageId"]);
data.addImage(img);
}
}
return(data);
}
else
{
if (createNewIfDoesNotExist)
{
ImageGalleryData data = new ImageGalleryData();
bool b = createNewImageGallery(page, identifier, data);
if (!b)
{
throw new Exception("getImageGallery database error: Error creating new placeholder");
}
else
{
return(data);
}
}
else
{
throw new Exception("getImageGallery database error: placeholder does not exist");
}
}
} // getImageGallery
public override void RenderInEditMode(HtmlTextWriter writer, CmsPage page, int identifier, CmsLanguage langToRenderFor, string[] paramList)
{
ImageGalleryDb db = new ImageGalleryDb();
ImageGalleryData data = new ImageGalleryData();
data.subDir = "";
data.thumbSize = 200;
data.largeSize = 500;
data.numThumbsPerRow = 3;
data = db.getImageGallery(page, identifier, true);
string ImageGalleryId = "ImageGallery_" + page.Id.ToString() + "_" + identifier.ToString();
// ------- CHECK THE FORM FOR ACTIONS
string action = Hatfield.Web.Portal.PageUtils.getFromForm(ImageGalleryId + "_Action", "");
if (action.Trim().ToLower() == "update")
{
data.ImageGalleryId = PageUtils.getFromForm(ImageGalleryId + "_DataId", -1);
data.subDir = PageUtils.getFromForm("subDir_" + ImageGalleryId, "");
data.thumbSize = PageUtils.getFromForm("thumbSize_" + ImageGalleryId, data.thumbSize);
data.largeSize = PageUtils.getFromForm("largeSize_" + ImageGalleryId, data.largeSize);
data.numThumbsPerRow = PageUtils.getFromForm("numThumbsPerRow_" + ImageGalleryId, data.numThumbsPerRow);
string[] captionIds = PageUtils.getFromForm(ImageGalleryId + "_captions");
foreach (string captionId in captionIds)
{
// captionId is in the form
// "imgCaption"+ImageGalleryId+"_"+imgFilenameUnderAppPath;
if (captionId != "")
{
string capId = System.Web.HttpUtility.UrlDecode(captionId);
if (capId.StartsWith("imgCaption" + ImageGalleryId + "_"))
{
string imgFilenameUnderAppPath = capId.Substring(("imgCaption" + ImageGalleryId + "_").Length);
string caption = PageUtils.getFromForm(System.Web.HttpUtility.UrlEncode(capId), "");
ImageGalleryImageData img = data.getImageData(imgFilenameUnderAppPath);
img.Caption = caption;
img.Filename = imgFilenameUnderAppPath;
if (img.ImageGalleryImageId < 0)
{
data.addImage(img);
}
}
}
}
db.saveUpdatedImageGallery(page, identifier, data);
}
// ------- START RENDERING
// note: no need to put in the <form></form> tags.
StringBuilder html = new StringBuilder();
html.Append("<strong>Image Gallery Settings:</strong><br>");
html.Append("<table>");
string[] subDirs = getAllAvailableSubDirs();
string s = PageUtils.getDropDownHtml("subDir_" + ImageGalleryId, "subDir_" + ImageGalleryId, subDirs, data.subDir);
html.Append("<tr><td>Image SubDirectory:</td>");
html.Append("<td>" + s + "</td></tr>");
s = PageUtils.getInputTextHtml("numThumbsPerRow_" + ImageGalleryId, "numThumbsPerRow_" + ImageGalleryId, data.numThumbsPerRow.ToString(), 3, 5);
html.Append("<tr><td>Number of Thumbnails per row:</td>");
html.Append("<td>" + s + "</td></tr>");
s = PageUtils.getInputTextHtml("thumbSize_" + ImageGalleryId, "thumbSize_" + ImageGalleryId, data.thumbSize.ToString(), 3, 5);
html.Append("<tr><td>Thumbnail Size:</td>");
html.Append("<td>" + s + "</td></tr>");
s = PageUtils.getInputTextHtml("largeSize_" + ImageGalleryId, "largeSize_" + ImageGalleryId, data.largeSize.ToString(), 3, 5);
html.Append("<tr><td>Full-Sized Image size:</td>");
html.Append("<td>" + s + "</td></tr>");
html.Append("</table>");
string thumbViewHtml = getHtmlForThumbView(page, data, ImageGalleryId, true);
writer.WriteLine(thumbViewHtml);
html.Append("<input type=\"hidden\" name=\"" + ImageGalleryId + "_Action\" value=\"update\">");
html.Append("<input type=\"hidden\" name=\"" + ImageGalleryId + "_DataId\" value=\"" + data.ImageGalleryId.ToString() + "\">");
writer.WriteLine(html.ToString());
} // RenderEdit