public void TestSetup() { role_testObject = new Role(); busRole = new BRole(); DatabaseGateway.TA_SecurityRoleDataTable roleTable = new DatabaseGateway.TA_SecurityRoleDataTable(); roleTable = roleTA.GetRoot(); if (roleTable.Rows.Count == 0) { roleTA.Insert("TestLevel1", 0, true, "", "000-0"); roleTable = roleTA.GetRoot(); } ADORootRole.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); roleTA.Insert("TestRuleName1", ADORootRole.ID, true, "", "000-1"); roleTable = roleTA.GetDataByRoleName("TestRuleName1"); ADORole1.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); ADORole1.Name = Convert.ToString(roleTable.Rows[0]["role_name"]); ADORole1.CustomCode = Convert.ToString(roleTable.Rows[0]["role_customcode"]); roleTA.Insert("TestRuleName2", ADORole1.ID, true, "", "000-2"); roleTable = roleTA.GetDataByRoleName("TestRuleName2"); ADORole2.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); ADORole2.Name = Convert.ToString(roleTable.Rows[0]["role_name"]); ADORole2.CustomCode = Convert.ToString(roleTable.Rows[0]["role_customcode"]); DatabaseGateway.TA_SecurityResourceDataTable resourceTable = new DatabaseGateway.TA_SecurityResourceDataTable(); resourceTable = resourceTA.GetRoot(); if (resourceTable.Rows.Count == 0) { resourceTA.Insert("TestRootResource", 0, "", "", "", ""); resourceTable = resourceTA.GetRoot(); } ADORootResource.ID = Convert.ToInt32(resourceTable.Rows[0][0]); resourceTA.Insert("TestResource1", ADORootResource.ID, "", "", "", "," + ADORootResource.ID.ToString() + ","); resourceTable = resourceTA.GetDataByName("TestResource1"); ADORedource1.ID = Convert.ToInt32(resourceTable.Rows[0][0]); ADORedource1.ResourceID = Convert.ToString(resourceTable.Rows[0]["resource_ResourceID"]); resourceTA.Insert("TestResource2", ADORootResource.ID, "", "", "", "," + ADORootResource.ID.ToString() + ","); resourceTable = resourceTA.GetDataByName("TestResource2"); ADORedource2.ID = Convert.ToInt32(resourceTable.Rows[0][0]); ADORedource2.ResourceID = Convert.ToString(resourceTable.Rows[0]["resource_ResourceID"]); resourceTA.Insert("TestResource3", ADORedource1.ID, "", "", "", "," + ADORootResource.ID.ToString() + "," + ADORedource1.ID.ToString() + ","); resourceTable = resourceTA.GetDataByName("TestResource3"); ADORedource3.ID = Convert.ToInt32(resourceTable.Rows[0][0]); ADORedource3.ResourceID = Convert.ToString(resourceTable.Rows[0]["resource_ResourceID"]); //athorizeTA.Insert(ADORole1.ID, ADORootResource.ID,true); athorizeTA.Insert(ADORole1.ID, ADORedource1.ID, true); athorizeTA.Insert(ADORole1.ID, ADORedource2.ID, false); }
public void TestSetup() { puser_testObject = new UserProxy(); user_testObject = new User(); busUser = new BUser(); #region Roles DatabaseGateway.TA_SecurityRoleDataTable roleTable = new DatabaseGateway.TA_SecurityRoleDataTable(); roleTable = roleTA.GetRoot(); if (roleTable.Rows.Count == 0) { roleTA.Insert("TestLevel1", 0, true, "", "000-0"); roleTable = roleTA.GetRoot(); } ADORootRole.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); roleTA.Insert("TestRuleName1", ADORootRole.ID, true, "", "000-1"); roleTable = roleTA.GetDataByRoleName("TestRuleName1"); ADORole1.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); ADORole1.Name = Convert.ToString(roleTable.Rows[0]["role_name"]); ADORole1.CustomCode = Convert.ToString(roleTable.Rows[0]["role_customcode"]); roleTA.Insert("TestRuleName2", ADORole1.ID, true, "", "000-2"); roleTable = roleTA.GetDataByRoleName("TestRuleName2"); ADORole2.ID = Convert.ToInt32(roleTable.Rows[0]["role_ID"]); ADORole2.Name = Convert.ToString(roleTable.Rows[0]["role_name"]); ADORole2.CustomCode = Convert.ToString(roleTable.Rows[0]["role_customcode"]); #endregion #region user userTA.UpdateRoleById(ADORole1.ID, "123", ADOUser1.ID); userTA.UpdateRoleById(ADORole2.ID, "123", ADOUser1.ID); userSetTA.Insert(ADOUser2.ID, 2, null); #endregion }