public IHttpActionResult GetTideDataValueWithID([FromUri] int TideDataValueID, [FromUri] string lang = "en", [FromUri] string extra = "")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                TideDataValueService tideDataValueService = new TideDataValueService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                tideDataValueService.Query = tideDataValueService.FillQuery(typeof(TideDataValue), lang, 0, 1, "", "", extra);

                if (tideDataValueService.Query.Extra == "A")
                {
                    TideDataValueExtraA tideDataValueExtraA = new TideDataValueExtraA();
                    tideDataValueExtraA = tideDataValueService.GetTideDataValueExtraAWithTideDataValueID(TideDataValueID);

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

                    return(Ok(tideDataValueExtraA));
                }
                else if (tideDataValueService.Query.Extra == "B")
                {
                    TideDataValueExtraB tideDataValueExtraB = new TideDataValueExtraB();
                    tideDataValueExtraB = tideDataValueService.GetTideDataValueExtraBWithTideDataValueID(TideDataValueID);

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

                    return(Ok(tideDataValueExtraB));
                }
                else
                {
                    TideDataValue tideDataValue = new TideDataValue();
                    tideDataValue = tideDataValueService.GetTideDataValueWithTideDataValueID(TideDataValueID);

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

                    return(Ok(tideDataValue));
                }
            }
        }
 public TideDataValueTest()
 {
     tideDataValue       = new TideDataValue();
     tideDataValueExtraA = new TideDataValueExtraA();
     tideDataValueExtraB = new TideDataValueExtraB();
 }