public IHttpActionResult GetLabSheetWithID([FromUri] int LabSheetID, [FromUri] string lang = "en", [FromUri] string extra = "")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                LabSheetService labSheetService = new LabSheetService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                labSheetService.Query = labSheetService.FillQuery(typeof(LabSheet), lang, 0, 1, "", "", extra);

                if (labSheetService.Query.Extra == "A")
                {
                    LabSheetExtraA labSheetExtraA = new LabSheetExtraA();
                    labSheetExtraA = labSheetService.GetLabSheetExtraAWithLabSheetID(LabSheetID);

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

                    return(Ok(labSheetExtraA));
                }
                else if (labSheetService.Query.Extra == "B")
                {
                    LabSheetExtraB labSheetExtraB = new LabSheetExtraB();
                    labSheetExtraB = labSheetService.GetLabSheetExtraBWithLabSheetID(LabSheetID);

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

                    return(Ok(labSheetExtraB));
                }
                else
                {
                    LabSheet labSheet = new LabSheet();
                    labSheet = labSheetService.GetLabSheetWithLabSheetID(LabSheetID);

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

                    return(Ok(labSheet));
                }
            }
        }
 public LabSheetTest()
 {
     labSheet       = new LabSheet();
     labSheetExtraA = new LabSheetExtraA();
     labSheetExtraB = new LabSheetExtraB();
 }