//удаление public static void Delete(int id) { String query = "DELETE FROM Citation WHERE Id = @id"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("Id", id) }; CitationsDB.Execute(query, parameters); CitationsDB.CloseConnection(); }
//создание цитаты public static void Create(Citation citation) { String query = "INSERT INTO Citation(Text, Author, IdCategory, Date) VALUES(@text, @author, @idCategory, @date)"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("text", citation.Text), new SqlParameter("author", citation.Author), new SqlParameter("date", citation.Date) }; if (citation.Category.Id == 0) { parameters.Add(new SqlParameter("idCategory", DBNull.Value)); } else { parameters.Add(new SqlParameter("idCategory", citation.Category.Id)); } CitationsDB.Execute(query, parameters); CitationsDB.CloseConnection(); }
//изменение цитаты public static void Update(Citation citation) { String query = "UPDATE Citation SET Text = @text, Author = @author, IdCategory = @idCategory, Date = @date WHERE Id = @id"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("id", citation.Id), new SqlParameter("text", citation.Text), new SqlParameter("author", citation.Author), new SqlParameter("date", citation.Date) }; if (citation.Category.Id == 0) { parameters.Add(new SqlParameter("idCategory", DBNull.Value)); } else { parameters.Add(new SqlParameter("idCategory", citation.Category.Id)); } CitationsDB.Execute(query, parameters); CitationsDB.CloseConnection(); }