/// <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 TestAddUserGroupEntity()
{
_table = Constants.DropdownTable.UserGroup;
_de = new DropdownEntry(_testCode, _testValue);
_ddc.addEntry(_table, _de);
UserGroup toCheck = (from ugs in _dc.UserGroups
where ugs.Value == _testValue
select ugs).FirstOrDefault();
Assert.NotNull(toCheck);
Assert.AreEqual(toCheck.Value.Trim(), _testValue);
Assert.AreEqual(toCheck.Code.Trim(), _testCode);
Assert.False(toCheck.Active);
}
public void TestAddRequestorTypeEntity()
{
_table = Constants.DropdownTable.RequestorType;
_de = new DropdownEntry(_testCode, _testValue);
_ddc.addEntry(_table, _de);
RequestorType toCheck = (from rts in _dc.RequestorTypes
where rts.Value == _testValue
select rts).FirstOrDefault();
Assert.NotNull(toCheck);
Assert.AreEqual(toCheck.Value.Trim(), _testValue);
Assert.AreEqual(toCheck.Code.Trim(), _testCode);
Assert.False(toCheck.Active);
}
public void TestAddKeywordEntity()
{
_table = Constants.DropdownTable.Keyword;
_de = new DropdownEntry(_testCode, _testValue);
_ddc.addEntry(_table, _de);
Keyword toCheck = (from keys in _dc.Keywords
where keys.KeywordValue == _testValue
select keys).FirstOrDefault();
Assert.NotNull(toCheck);
Assert.AreEqual(toCheck.KeywordValue.Trim(), _testValue);
Assert.False(toCheck.Active);
}
