/// <summary>
/// Add a new entry to one of the dropdown tables in the database.
/// </summary>
/// <param name="table">Table to add a new entry to.</param>
/// <param name="entry">
/// DropdownEntry containing the value and code,
/// if exists.
/// </param>
public void addEntry(Constants.DropdownTable table,
DropdownEntry entry)
{
switch (table) {
case Constants.DropdownTable.Keyword:
var kw = new Keyword {
KeywordValue = entry.value
};
_db.Keywords.InsertOnSubmit(kw);
break;
case Constants.DropdownTable.QuestionType:
var qType = new QuestionType {
Code = entry.code,
Value = entry.value
};
_db.QuestionTypes.InsertOnSubmit(qType);
break;
case Constants.DropdownTable.Region:
var region = new Region {
Code = entry.code,
Value = entry.value
};
_db.Regions.InsertOnSubmit(region);
break;
case Constants.DropdownTable.RequestorType:
var rType = new RequestorType {
Code = entry.code,
Value = entry.value
};
_db.RequestorTypes.InsertOnSubmit(rType);
break;
case Constants.DropdownTable.TumourGroup:
var tGroup = new TumourGroup {
Code = entry.code,
Value = entry.value
};
_db.TumourGroups.InsertOnSubmit(tGroup);
break;
case Constants.DropdownTable.UserGroup:
var uGroup = new UserGroup {
Code = entry.code,
Value = entry.value
};
_db.UserGroups.InsertOnSubmit(uGroup);
break;
}
_db.SubmitChanges();
}
public void tumourGroupAddLogicTest()
{
TumourGroup m = new TumourGroup();
m.Code = "TST";
m.FullName = "TumourGroupAddLogicTest";
m.Enabled = true;
ActionResult result = dDAdminController.Add(m, "TumourGroup");
Assert.AreEqual("System.Web.Mvc.RedirectToRouteResult", result.GetType().FullName);
TumourGroup justAdded = db.TumourGroups.ToArray().Last();
Assert.IsTrue(justAdded.Code.Equals("TST") && justAdded.FullName.Equals("TumourGroupAddLogicTest") && justAdded.Enabled);
}
public static IQueryable<TumourGroup> getSampleTumourGroups()
{
var tg0 = new TumourGroup {
TumourGroupID = 0,
Code = "BR",
Value = "Breast",
Active = true
};
var tg1 = new TumourGroup {
TumourGroupID = 1,
Code = "CNS",
Value = "Central Nervous System",
Active = false
};
var sampleTumourGroups = new List<TumourGroup> {
tg0,
tg1
};
return sampleTumourGroups.AsQueryable();
}
public void SelectATumourGroup(string tumourGroup)
{
TumourGroup.Click();
PageHelper.SelectValueFromDropList(TumourGroupResult, tumourGroup);
}
/// <summary>
/// Searches by tumour groups.
/// </summary>
public void SearchByTumourGroups()
{
TumourGroup.Click();
PageHelper.SelectValueFromDropList(TumourGroupResult, "Brain");
PageHelper.WaitForElement(Driver, SearchButton).Click();
}
public void TestFixtureSetUp()
{
_db = new CAIRSDataContext();
_rmc = new RequestManagementController();
var random = new Random();
_up = new UserProfile {
UserName = "******" + random.Next(1, 100000000)
};
_db.UserProfiles.InsertOnSubmit(_up);
_db.SubmitChanges();
_rType = new RequestorType {
Code = "TRMC" + random.Next(1, 100000),
Value =
"TestRequestManagementController" +
random.Next(1, 100000000),
Active = true
};
_db.RequestorTypes.InsertOnSubmit(_rType);
_db.SubmitChanges();
_region = new Region {
Code = "TRMC" + random.Next(1, 100000),
Value =
"TestRequestManagementController" +
random.Next(1, 100000000),
Active = true
};
_db.Regions.InsertOnSubmit(_region);
_db.SubmitChanges();
_tGroup = new TumourGroup {
Code = "TRMC" + random.Next(1, 100000),
Value =
"TestRequestManagementController" +
random.Next(1, 100000000),
Active = true
};
_db.TumourGroups.InsertOnSubmit(_tGroup);
_db.SubmitChanges();
_qType = new QuestionType {
Code = "TRMC" + random.Next(1, 100000),
Value =
"TestRequestManagementController" +
random.Next(1, 100000000),
Active = true
};
_db.QuestionTypes.InsertOnSubmit(_qType);
_db.SubmitChanges();
}
public void TestViewRequestWorking()
{
// Add some Dependencies
var rt = new RequestorType {
Code = _random.Next(1000000)
.ToString(CultureInfo.InvariantCulture),
Value = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
Active = true
};
_cdc.RequestorTypes.InsertOnSubmit(rt);
var qt = new QuestionType {
Code = _random.Next(1000000)
.ToString(CultureInfo.InvariantCulture),
Value = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
Active = true
};
_cdc.QuestionTypes.InsertOnSubmit(qt);
var tg = new TumourGroup {
Code = _random.Next(1000000)
.ToString(CultureInfo.InvariantCulture),
Value = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
Active = true
};
_cdc.TumourGroups.InsertOnSubmit(tg);
var r = new Region {
Code = _random.Next(1000000)
.ToString(CultureInfo.InvariantCulture),
Value = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
Active = true
};
_cdc.Regions.InsertOnSubmit(r);
var k = new Keyword {
KeywordValue = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
Active = true
};
_cdc.Keywords.InsertOnSubmit(k);
// Submit our changes so far.
_cdc.SubmitChanges();
// Create a test request in the DB
var rc = new RequestContent {
patientFName = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
patientLName = "VRInt-" +
_random.Next()
.ToString(CultureInfo.InvariantCulture),
patientAgencyID = _random.Next()
.ToString(CultureInfo.InvariantCulture),
patientGender = Constants.Gender.Female,
patientAge = 255,
requestorTypeID = rt.RequestorTypeID,
regionID = r.RegionID,
requestorFirstName = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture),
requestorLastName = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture),
requestorEmail = _random.Next()
.ToString(CultureInfo.InvariantCulture) +
"@example.com",
requestorPhoneNum = _random.Next()
.ToString(
CultureInfo.InvariantCulture),
requestorPhoneExt = _random.Next()
.ToString(
CultureInfo.InvariantCulture)
};
var refCont = new ReferenceContent {
referenceType = Constants.ReferenceType.Text,
referenceString = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture)
};
var qrc = new QuestionResponseContent {
question = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture),
response = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture),
specialNotes = "VRInt-" +
_random.Next()
.ToString(
CultureInfo.InvariantCulture),
consequence = Constants.Consequence.Certain,
severity = Constants.Severity.Major,
keywords = new List<string> {k.KeywordValue},
referenceList = new List<ReferenceContent> {refCont},
timeSpent = 255,
questionTypeID = qt.QuestionTypeID,
tumourGroupID = tg.TumourGroupID
};
rc.addQuestionResponse(qrc);
var rmc = new RequestManagementController();
long rid = rmc.create(rc);
var dmc = new DropdownManagementController();
// Attempt to go to the appropriate View Request Page Directly
_driver.Navigate().GoToUrl(CommonTestingMethods.getURL());
_driver.Navigate()
.GoToUrl(CommonTestingMethods.getURL() + "/Request/Details/" +
rid.ToString(CultureInfo.InvariantCulture));
// Assert that we're not redirected
StringAssert.Contains("/Request/Details", _driver.Url);
// Go through fields and check values
IWebElement element = _driver.FindElement(By.Id("status"));
StringAssert.AreEqualIgnoringCase(rc.requestStatus.ToString(),
element.Text);
element = _driver.FindElement(By.Id("total-time-spent"));
StringAssert.Contains(qrc.timeSpent.ToString(), element.Text);
element = _driver.FindElement(By.Id("requestor-name"));
StringAssert.Contains(rc.requestorFirstName, element.Text);
StringAssert.Contains(rc.requestorLastName, element.Text);
element = _driver.FindElement(By.Id("requestor-email"));
StringAssert.AreEqualIgnoringCase(rc.requestorEmail, element.Text);
element = _driver.FindElement(By.Id("requestor-phone"));
StringAssert.Contains(rc.requestorPhoneNum, element.Text);
StringAssert.Contains(rc.requestorPhoneExt, element.Text);
element = _driver.FindElement(By.Id("caller-type"));
StringAssert.Contains(rt.Code, element.Text);
StringAssert.Contains(rt.Value, element.Text);
element = _driver.FindElement(By.Id("region"));
StringAssert.Contains(r.Code, element.Text);
StringAssert.Contains(r.Value, element.Text);
element = _driver.FindElement(By.Id("patient-name"));
StringAssert.Contains(rc.patientFName, element.Text);
StringAssert.Contains(rc.patientLName, element.Text);
element = _driver.FindElement(By.Id("patient-gender"));
StringAssert.AreEqualIgnoringCase(rc.patientGender.ToString(),
element.Text);
element = _driver.FindElement(By.Id("patient-id"));
StringAssert.AreEqualIgnoringCase(rc.patientAgencyID, element.Text);
element = _driver.FindElement(By.Id("patient-age"));
StringAssert.AreEqualIgnoringCase(rc.patientAge.ToString(),
element.Text);
element = _driver.FindElement(By.ClassName("question"));
StringAssert.AreEqualIgnoringCase(qrc.question, element.Text);
element = _driver.FindElement(By.ClassName("response"));
StringAssert.AreEqualIgnoringCase(qrc.response, element.Text);
element = _driver.FindElement(By.ClassName("special-notes"));
StringAssert.AreEqualIgnoringCase(qrc.specialNotes, element.Text);
element = _driver.FindElement(By.ClassName("question-type"));
StringAssert.Contains(qt.Code, element.Text);
StringAssert.Contains(qt.Value, element.Text);
element = _driver.FindElement(By.ClassName("tumour-group"));
StringAssert.Contains(tg.Code, element.Text);
StringAssert.Contains(tg.Value, element.Text);
element = _driver.FindElement(By.ClassName("time-spent"));
StringAssert.Contains(qrc.timeSpent.ToString(), element.Text);
element = _driver.FindElement(By.ClassName("score"));
StringAssert.AreEqualIgnoringCase(
1.ToString(CultureInfo.InvariantCulture), element.Text);
element = _driver.FindElement(By.ClassName("impact-sev"));
StringAssert.AreEqualIgnoringCase(qrc.severity.ToString(),
element.Text);
element = _driver.FindElement(By.ClassName("impact-cons"));
StringAssert.AreEqualIgnoringCase(qrc.consequence.ToString(),
element.Text);
element = _driver.FindElement(By.ClassName("reference-string"));
StringAssert.AreEqualIgnoringCase(refCont.referenceString,
element.Text);
// Cleanup
var cdc2 = new CAIRSDataContext();
IQueryable<KeywordQuestion> kqs =
cdc2.KeywordQuestions.Where(kq => kq.RequestID == rid);
Assert.IsTrue(kqs.Any());
cdc2.KeywordQuestions.DeleteAllOnSubmit(kqs);
IQueryable<AuditLog> als =
cdc2.AuditLogs.Where(al => al.RequestID == rid);
Assert.IsTrue(als.Any());
cdc2.AuditLogs.DeleteAllOnSubmit(als);
IQueryable<QuestionResponse> qrs =
cdc2.QuestionResponses.Where(dbQr => dbQr.RequestID == rid);
Assert.IsTrue(qrs.Any());
cdc2.QuestionResponses.DeleteAllOnSubmit(qrs);
IQueryable<Request> rs =
cdc2.Requests.Where(rq => rq.RequestID == rid);
Assert.IsTrue(rs.Any());
cdc2.Requests.DeleteAllOnSubmit(rs);
IQueryable<Reference> refs =
cdc2.References.Where(rf => rf.RequestID == rid);
Assert.IsTrue(refs.Any());
cdc2.References.DeleteAllOnSubmit(refs);
IQueryable<RequestorType> rqts =
cdc2.RequestorTypes.Where(
rqt => rqt.RequestorTypeID == rt.RequestorTypeID);
Assert.IsTrue(rqts.Any());
cdc2.RequestorTypes.DeleteAllOnSubmit(rqts);
IQueryable<QuestionType> qts =
cdc2.QuestionTypes.Where(
dbQt => dbQt.Value == qt.Value);
Assert.IsTrue(qts.Any());
cdc2.QuestionTypes.DeleteAllOnSubmit(qts);
IQueryable<TumourGroup> tgs =
cdc2.TumourGroups.Where(
dbTg => dbTg.TumourGroupID == tg.TumourGroupID);
Assert.IsTrue(tgs.Any());
cdc2.TumourGroups.DeleteAllOnSubmit(tgs);
IQueryable<Region> regions =
cdc2.Regions.Where(dbRg => dbRg.RegionID == r.RegionID);
Assert.IsTrue(regions.Any());
cdc2.Regions.DeleteAllOnSubmit(regions);
IQueryable<Keyword> keywords =
cdc2.Keywords.Where(kw => kw.KeywordID == k.KeywordID);
Assert.IsTrue(keywords.Any());
cdc2.Keywords.DeleteAllOnSubmit(keywords);
IQueryable<Request> rqs =
cdc2.Requests.Where(dbRq => dbRq.RequestID == rid);
Assert.IsTrue(rqs.Any());
cdc2.Requests.DeleteAllOnSubmit(rqs);
cdc2.SubmitChanges();
}
private void SelectATumourGroup()
{
TumourGroup.Click();
PageHelper.PickRandomValueFromDropList(TumourGroupResult);
}
