/// <summary>
/// Procura um determinado ficheiro na base dados se para ver o seu tempo de vida
/// </summary>
/// <param name="filename"></param>
/// <returns></returns>
public Filettl GetFile(string filename)
{
NpgsqlConnection conn = new NpgsqlConnection(connString);
var sqlStatement = string.Format("SELECT * FROM filettl WHERE f_name = '{0}'", filename);
var sqlCommand = new NpgsqlCommand(sqlStatement, conn);
conn.Open();
Filettl result = null;
using (var dataReader = sqlCommand.ExecuteReader())
{
while (dataReader.Read())
{
result = new Filettl(dataReader.GetInt32(0), dataReader.GetString(1), DateTime.Parse(dataReader.GetString(2)));
}
}
conn.Close();
return(result);
}
/// <summary>
/// Retorna todos os ficheiros que têm tempo de vida da base de dados para uma lista
/// </summary>
/// <returns></returns>
public List <Filettl> GetFiles()
{
NpgsqlConnection conn = new NpgsqlConnection(connString);
var sqlStatement = string.Format("SELECT * FROM filettl");
var sqlCommand = new NpgsqlCommand(sqlStatement, conn);
conn.Open();
List <Filettl> result = new List <Filettl>();
using (var dataReader = sqlCommand.ExecuteReader())
{
while (dataReader.Read())
{
Filettl values = new Filettl(dataReader.GetInt32(0), dataReader.GetString(1), DateTime.Parse(dataReader.GetString(2)));
result.Add(values);
}
}
conn.Close();
return(result);
}
