public IHttpActionResult GetTideLocationWithID([FromUri] int TideLocationID, [FromUri] string lang = "en", [FromUri] string extra = "")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                TideLocationService tideLocationService = new TideLocationService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                tideLocationService.Query = tideLocationService.FillQuery(typeof(TideLocation), lang, 0, 1, "", "", extra);

                if (tideLocationService.Query.Extra == "A")
                {
                    TideLocationExtraA tideLocationExtraA = new TideLocationExtraA();
                    tideLocationExtraA = tideLocationService.GetTideLocationExtraAWithTideLocationID(TideLocationID);

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

                    return(Ok(tideLocationExtraA));
                }
                else if (tideLocationService.Query.Extra == "B")
                {
                    TideLocationExtraB tideLocationExtraB = new TideLocationExtraB();
                    tideLocationExtraB = tideLocationService.GetTideLocationExtraBWithTideLocationID(TideLocationID);

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

                    return(Ok(tideLocationExtraB));
                }
                else
                {
                    TideLocation tideLocation = new TideLocation();
                    tideLocation = tideLocationService.GetTideLocationWithTideLocationID(TideLocationID);

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

                    return(Ok(tideLocation));
                }
            }
        }
        public void GetTideLocationWithTideLocationID__tideLocation_TideLocationID__Test()
        {
            foreach (CultureInfo culture in AllowableCulture)
            {
                ChangeCulture(culture);

                using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
                {
                    TideLocationService tideLocationService = new TideLocationService(new Query()
                    {
                        Lang = culture.TwoLetterISOLanguageName
                    }, dbTestDB, ContactID);
                    TideLocation tideLocation = (from c in dbTestDB.TideLocations select c).FirstOrDefault();
                    Assert.IsNotNull(tideLocation);

                    foreach (string extra in new List <string>()
                    {
                        null, "A", "B", "C", "D", "E"
                    })
                    {
                        tideLocationService.Query.Extra = extra;

                        if (string.IsNullOrWhiteSpace(extra))
                        {
                            TideLocation tideLocationRet = tideLocationService.GetTideLocationWithTideLocationID(tideLocation.TideLocationID);
                            CheckTideLocationFields(new List <TideLocation>()
                            {
                                tideLocationRet
                            });
                            Assert.AreEqual(tideLocation.TideLocationID, tideLocationRet.TideLocationID);
                        }
                        else
                        {
                            //Assert.AreEqual(true, false);
                        }
                    }
                }
            }
        }