public static List<ResFile> GetAllFiles()
        {
            using (var dbManager = new DbManager("tmresource"))
            {
                var sql = new SqlQuery("res_files");

                return dbManager.ExecuteList(sql.SelectAll()).Select(r => new ResFile
                    {
                        FileID = (int)r[0],
                        ProjectName = (string)r[1],
                        ModuleName = (string)r[2],
                        FileName = (string)r[3]
                    }).ToList();
            }
        }