public int AddSubTheme(SubTheme subtheme) { using (ThemesDAO.Connection = ConnectionSettings.CreateDBConnection()) { return ThemesDAO.AddSubTheme(subtheme); } }
public int AddSubTheme(SubTheme subtheme) { return DbTemplateHelper<int>.GetValueByProcedure( Connection, "config.insertsubtheme", new DbParameterHelper[] { new DbParameterHelper(DbType.String, "p_name", subtheme.Name), new DbParameterHelper(DbType.String, "p_nameAbbr", subtheme.NameAbbr), new DbParameterHelper(DbType.Int32, "p_themeid", subtheme.ThemeID), new DbParameterHelper(DbType.Int32, "p_providerid", subtheme.ProviderID) }); }
public void GetProviderSubThemesTest() { ThemesDAO target = new ThemesDAO(connnetion); int providerId = 1; int themeId = 1; SubTheme expected = new SubTheme { ID = 1, Name = "Ordenamento do território", NameAbbr = "Ordenamento do território", ProviderID = 1, ThemeID = 1 }; IEnumerable<SubTheme> actual; actual = target.GetProviderSubThemes(providerId, themeId); Assert.AreEqual(1, actual.Count()); Assert.AreEqual(expected, actual.ElementAt(0)); }