public void Set()
{
using (SqlCmd cmd = new SqlCmd("UPDATE Article SET Title = @Title, SubHeading = @SubHeading, ShortDescription = @ShortDescription, Content = @Content, PublishDate = @PublishDate, UrlLabel = @UrlLabel WHERE Id = @Id", false))
{
cmd.AddIInt("@Id", Id);
cmd.AddIString("@Title", 300, Title);
cmd.AddIString("@SubHeading", 300, SubHeading);
cmd.AddIString("@ShortDescription", 1000, ShortDescription);
cmd.AddIString("@Content", -1, Content);
cmd.AddIDateTime("@PublishDate", PublishDate);
cmd.AddIString("@UrlLabel", 300, CreateUrl());
cmd.Execute();
}
}
public void Add()
{
using (SqlCmd cmd = new SqlCmd("INSERT INTO Article VALUES (@UserId, @Title, @SubHeading, @ShortDescription, @Content, @PublishDate, @UrlLabel); SET @Id = SCOPE_IDENTITY();", false))
{
cmd.AddIInt("@UserId", Author.Id);
cmd.AddIString("@Title", 300, Title);
cmd.AddIString("@SubHeading", 300, SubHeading);
cmd.AddIString("@ShortDescription", 1000, ShortDescription);
cmd.AddIString("@Content", -1, Content);
cmd.AddIDateTime("@PublishDate", PublishDate);
cmd.AddIString("@UrlLabel", 300, CreateUrl());
cmd.AddOInt("@Id");
cmd.Execute();
Id = cmd.GetInt("@Id");
}
}
private bool UrlExists()
{
DataRow r;
using (SqlCmd cmd = new SqlCmd("SELECT Id FROM Article WHERE UrlLabel = @UrlLabel AND MONTH(PublishDate) = MONTH(@Date) AND YEAR(PublishDate) = YEAR(@Date)", false))
{
cmd.AddIString("@UrlLabel", 300, UrlLabel);
cmd.AddIDateTime("@Date", PublishDate);
r = cmd.ExecuteSingleRowOrNull();
}
if (r == null)
{
return(false);
}
return((int)r["Id"] != Id);
}
