public IHttpActionResult GetTVFileWithID([FromUri] int TVFileID, [FromUri] string lang = "en", [FromUri] string extra = "")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                TVFileService tvFileService = new TVFileService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                tvFileService.Query = tvFileService.FillQuery(typeof(TVFile), lang, 0, 1, "", "", extra);

                if (tvFileService.Query.Extra == "A")
                {
                    TVFileExtraA tvFileExtraA = new TVFileExtraA();
                    tvFileExtraA = tvFileService.GetTVFileExtraAWithTVFileID(TVFileID);

                    if (tvFileExtraA == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(tvFileExtraA));
                }
                else if (tvFileService.Query.Extra == "B")
                {
                    TVFileExtraB tvFileExtraB = new TVFileExtraB();
                    tvFileExtraB = tvFileService.GetTVFileExtraBWithTVFileID(TVFileID);

                    if (tvFileExtraB == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(tvFileExtraB));
                }
                else
                {
                    TVFile tvFile = new TVFile();
                    tvFile = tvFileService.GetTVFileWithTVFileID(TVFileID);

                    if (tvFile == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(tvFile));
                }
            }
        }
 public TVFileTest()
 {
     tVFile       = new TVFile();
     tVFileExtraA = new TVFileExtraA();
     tVFileExtraB = new TVFileExtraB();
 }