public static string Tags(string tekst, RescueTekniq.BOL.PageContent item) { string res = ""; StringBuilder sb = new StringBuilder(); //UPDATE [vicjos1_Heart2Start].[vicjos1_sysadm].[Co2Db_HtmlPageContent] // SET [IsAktiv] = <IsAktiv, bit,> // ,[IsDeleted] = <IsDeleted, bit,> // ,[PageType] = <PageType, int,> // ,[LocalCultureID] = <LocalCultureID, int,> // ,[Alias] = <Alias, nvarchar(100),> // ,[Title] = <Title, nvarchar(100),> // ,[ShowTitle] = <ShowTitle, bit,> // ,[SubTitle] = <SubTitle, nvarchar(100),> // ,[Description] = <Description, nvarchar(250),> // ,[KeyWords] = <KeyWords, nvarchar(250),> // ,[Content] = <Content, nvarchar(max),> // ,[PublishDate] = <PublishDate, datetime,> // ,[ExpireDate] = <ExpireDate, datetime,> // ,[OprettetAF] = <OprettetAF, nvarchar(50),> // ,[OprettetDen] = <OprettetDen, datetime,> // ,[OprettetIP] = <OprettetIP, nvarchar(15),> // ,[RettetAF] = <RettetAF, nvarchar(50),> // ,[RettetDen] = <RettetDen, datetime,> // ,[RettetIP] = <RettetIP, nvarchar(15),> // WHERE <Search Conditions,,> sb.Append(tekst); //.Replace("[VARE.TYPE]", "PageContent") //.Replace("[PAGECONTENT.TYPE]", "[VARE.NAVN]") sb.Replace("[PAGECONTENT.PUBLISHDATE]", item.PublishDate.ToString("dd. MMM yyyy")); sb.Replace("[PAGECONTENT.PUBLISH.DATE]", item.PublishDate.ToString("dd. MMM yyyy")); sb.Replace("[PAGECONTENT.EXPIREDDATE]", item.ExpiredDate.ToString("dd MMMM yyyy")); sb.Replace("[PAGECONTENT.EXPIRED.DATE]", item.ExpiredDate.ToString("dd MMMM yyyy")); sb.Replace("[PAGECONTENT.LOCALCULTUREID]", item.LocalCultureID.ToString()); sb.Replace("[PAGECONTENT.ALIAS]", item.Alias.ToString()); sb.Replace("[PAGECONTENT.SHOWTITLE]", item.ShowTitle.ToString()); sb.Replace("[PAGECONTENT.TITLE]", item.Title.ToString()); sb.Replace("[PAGECONTENT.SUBTITLE]", item.SubTitle.ToString()); sb.Replace("[PAGECONTENT.DESCRIPTION]", item.Description.ToString()); sb.Replace("[PAGECONTENT.KEYWORDS]", item.KeyWords.ToString()); sb.Replace("[PAGECONTENT.CONTENT]", item.Content.ToString()); sb.Replace("[PAGECONTENT.GUID]", item.Guid.ToString()); res = sb.ToString(); return(res); }
public static int Delete(PageContent rec) { return(Delete(rec.ID)); }