public void LabSheet_Controller_GetLabSheetWithID_Test()
        {
            foreach (LanguageEnum LanguageRequest in AllowableLanguages)
            {
                foreach (int ContactID in new List <int>()
                {
                    AdminContactID
                })                                                             //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
                {
                    LabSheetController labSheetController = new LabSheetController(DatabaseTypeEnum.SqlServerTestDB);
                    Assert.IsNotNull(labSheetController);
                    Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetController.DatabaseType);

                    LabSheet labSheetFirst = new LabSheet();
                    using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
                    {
                        LabSheetService labSheetService = new LabSheetService(new Query(), db, ContactID);
                        labSheetFirst = (from c in db.LabSheets select c).FirstOrDefault();
                    }

                    // ok with LabSheet info
                    IHttpActionResult jsonRet = labSheetController.GetLabSheetWithID(labSheetFirst.LabSheetID);
                    Assert.IsNotNull(jsonRet);

                    OkNegotiatedContentResult <LabSheet> Ret = jsonRet as OkNegotiatedContentResult <LabSheet>;
                    LabSheet labSheetRet = Ret.Content;
                    Assert.AreEqual(labSheetFirst.LabSheetID, labSheetRet.LabSheetID);

                    BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
                    Assert.IsNull(badRequest);

                    // Not Found
                    IHttpActionResult jsonRet2 = labSheetController.GetLabSheetWithID(0);
                    Assert.IsNotNull(jsonRet2);

                    OkNegotiatedContentResult <LabSheet> labSheetRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheet>;
                    Assert.IsNull(labSheetRet2);

                    NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
                    Assert.IsNotNull(notFoundRequest);
                }
            }
        }