public bool saveUpdatedPageFilesItemData(PageFilesItemData updatedFileItem) { if (updatedFileItem.Id < 0) { return(false); } string sql = "update pagefileitem set "; sql += "Filename = '" + dbEncode(updatedFileItem.Filename) + "', "; sql += "Title = '" + dbEncode(updatedFileItem.Title) + "', "; sql += "Author = '" + dbEncode(updatedFileItem.Author) + "', "; sql += "Abstract = '" + dbEncode(updatedFileItem.Abstract) + "', "; sql += "FileSize = " + updatedFileItem.FileSize.ToString() + ", "; sql += "LastModified = " + dbEncode(updatedFileItem.lastModified) + ", "; sql += "CreatorUsername = '******' "; sql += " where PageFileItemId = " + updatedFileItem.Id.ToString() + "; "; int NumModified = this.RunUpdateQuery(sql); if (NumModified >= 0) { return(true); } return(false); } // saveUpdatedPageFilesItemData
} // ItemDataFromDataRow /// <summary> /// deletes the pageFileItemToDelete. Note: the calling pageFileItemToDelete.Filename is modified with this function. /// </summary> /// <param name="pageFileItemToDelete"></param> /// <param name="page"></param> /// <param name="identifier"></param> /// <returns>TRUE if successful, false if not</returns> public bool deletePageFilesItemData(PageFilesItemData pageFileItemToDelete, CmsPage page, int identifier, CmsLanguage language) { if (pageFileItemToDelete.Id >= 0) { string renamedFilename = "Deleted." + DateTime.Now.ToString("yyyyMMdd.HH.mm.ss.") + pageFileItemToDelete.Filename; string currentFilenameOnDisk = pageFileItemToDelete.getFilenameOnDisk(page, identifier, language); pageFileItemToDelete.Filename = renamedFilename; string renamedFilenameOnDisk = pageFileItemToDelete.getFilenameOnDisk(page, identifier, language); if (System.IO.File.Exists(currentFilenameOnDisk)) { try { System.IO.File.Move(currentFilenameOnDisk, renamedFilenameOnDisk); } catch (Exception e) { Console.Write(e.Message); return(false); } } string sql = "update pagefileitem set Deleted = NOW(), Filename = '" + dbEncode(renamedFilename) + "' where PageFileItemId = " + pageFileItemToDelete.Id.ToString(); int numAffected = this.RunUpdateQuery(sql); if (numAffected > 0) { return(page.setLastUpdatedDateTimeToNow()); } } // if return(false); }
} // getPageFilesItemDatas public bool saveNewPageFilesItemData(PageFilesItemData newItem, CmsPage page, int indentifier, CmsLanguage pageLanguage) { string sql = "insert into pagefileitem (PageId, Identifier, langShortCode, Filename, Title, Author, Abstract, FileSize, LastModified, CreatorUsername) VALUES ("; sql += "" + page.ID.ToString() + ", "; sql += "" + indentifier.ToString() + ", "; sql += "'" + dbEncode(pageLanguage.shortCode) + "', "; sql += "'" + dbEncode(newItem.Filename) + "', "; sql += "'" + dbEncode(newItem.Title) + "', "; sql += "'" + dbEncode(newItem.Author) + "', "; sql += "'" + dbEncode(newItem.Abstract) + "', "; sql += "" + newItem.FileSize.ToString() + ", "; sql += "" + dbEncode(newItem.lastModified) + ", "; sql += "'" + dbEncode(newItem.CreatorUsername) + "' "; sql += ")"; int newId = this.RunInsertQuery(sql); if (newId >= 0) { newItem.Id = newId; return(true); } return(false); }
public static FileAggItem FromPageFilesItemData(PageFilesItemData sourceDetails, CmsUrlFormat pageLinkUrlFormat, CmsUrlFormat fileLinkUrlFormat) { CmsPage detailsPage = CmsContext.getPageById(sourceDetails.DetailsPageId); Dictionary <string, string> pageUrlParams = new Dictionary <string, string>(); pageUrlParams.Add(PageFiles.CurrentFileIdFormName, sourceDetails.Id.ToString()); string PageDisplayURL = detailsPage.getUrl(pageUrlParams, sourceDetails.Lang, pageLinkUrlFormat); string FileDownloadURL = sourceDetails.getDownloadUrl(fileLinkUrlFormat); string Title = sourceDetails.Title; string Description = sourceDetails.Abstract; string CategoryName = detailsPage.getTitle(sourceDetails.Lang); // use the page title as the category DateTime lastModified = sourceDetails.lastModified; return(new FileAggItem(PageDisplayURL, FileDownloadURL, Title, Description, CategoryName, lastModified)); }
} // saveUpdatedPageFilesData private PageFilesItemData getItemDataFromDataRow(DataRow dr) { PageFilesItemData item = new PageFilesItemData(); item.Id = Convert.ToInt32(dr["PageFileItemId"]); item.Filename = dr["Filename"].ToString(); item.Title = dr["Title"].ToString(); item.Author = dr["Author"].ToString(); item.Abstract = dr["Abstract"].ToString(); item.FileSize = Convert.ToInt64(dr["FileSize"]); item.lastModified = Convert.ToDateTime(dr["LastModified"]); item.CreatorUsername = dr["CreatorUsername"].ToString(); item.DetailsPageId = Convert.ToInt32(dr["PageId"]); item.Identifier = Convert.ToInt32(dr["Identifier"]); string langCode = dr["langShortCode"].ToString(); item.Lang = CmsLanguage.GetFromHaystack(langCode, CmsConfig.Languages); return(item); } // ItemDataFromDataRow