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