/// <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); }