//удаление
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();
}
