Obtaining the size of the MDF file

SELECT size*8192 as FileSize
FROM master..sysaltfiles
WHERE fileid=1
AND dbid=DB_ID('')