/// <summary>
/// Обновление блокнота
/// </summary>
/// <param name="structureNotepad">Модель блокнота</param>
/// <returns></returns>
public static bool UpdateNotepad(StructureNotepad structureNotepad)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE [Data] " +
"SET " +
"content = @content " +
"WHERE Id = @Id;";
cmd.Parameters.AddWithValue("@content", structureNotepad.Content);
cmd.Parameters.AddWithValue("@Id", structureNotepad.Id);
try
{
cmd.ExecuteNonQuery(); // синхронно
return(true);
}
catch (Exception e)
{
return(false);
// TODO сделать лог
}
}
}
}
/// <summary>
/// Создать новый блокнот
/// </summary>
/// <param name="name">Название блокнота</param>
/// <returns></returns>
public static bool AddNotepad(string name)
{
if (Database.LoadNotepads().Any(notepad => notepad.Name == name))
{
return(false);
}
StructureNotepad sn = new StructureNotepad();
sn.Name = name;
return(Database.AddNotepad(name));
}
/// <summary>
/// Получить данные о всех блокнотах
/// </summary>
/// <returns></returns>
public static List <StructureNotepad> LoadNotepads()
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * " +
"FROM [Data] ";
using (var reader = cmd.ExecuteReader())
{
List <StructureNotepad> structureNotepads = new List <StructureNotepad>();
while (reader.Read())
{
int id;
try
{
id = Convert.ToInt32(reader["Id"]);
}
catch (Exception)
{
id = 0;
}
StructureNotepad structure = new StructureNotepad();
structure.Id = id;
structure.Name = reader["name"].ToString();
structure.Content = reader["content"].ToString();
structureNotepads.Add(structure);
}
return(structureNotepads);
}
}
}
return(null);
}