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