/// <summary>
/// Loads all comments into the list.
/// </summary>
private void LoadComments()
{
Database db = new Database();
try
{
comments = new List<RemoteFileComment>();
db.CreateCommand("SELECT * FROM files_comments WHERE files_id = :id");
db.AddParameter("id", Id);
db.OpenConnection();
db.ExecuteCommand();
OracleDataReader dr = db.DataReader;
while (dr.Read())
{
User user = ftp_db_poc.User.GetById(dr.GetValueByColumn<int>("users_id"));
DateTime dateTime = dr.GetValueByColumn<DateTime>("created");
string text = dr.GetValueByColumn<string>("text");
RemoteFileComment comment = new RemoteFileComment(dr.GetValueByColumn<int>("id"), text, user, dateTime);
comments.Add(comment);
}
}
finally
{
db.CloseConnection();
}
}
/// <summary>
/// Removes the comment from the database and from the list.
/// </summary>
/// <param name="comment"></param>
public void RemoveComment(RemoteFileComment comment)
{
Database db = new Database();
try
{
db.CreateCommand("DELETE files_comments WHERE id = :id");
db.AddParameter("id", comment.Id);
db.OpenConnection();
db.ExecuteCommand();
comments.Remove(comment);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
db.CloseConnection();
}
}
