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