/// <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); }