public MetaSprocSqlDependencyManager(DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings,
string sprocName)
{
_smoObjectsAndSettings = databaseSmoObjectsAndSettings;
AddDependecyStoredProcedures();
SetMetaDataList(sprocName);
SetRecursiveSprocDependencyDictionary();
}
public void TestGetCities()
{
ConnectionStringHelper.GetConnectionStrings();
CountryCityProvinceService.CountryCityProvinceService serviceInstance =
new CountryCityProvinceService.CountryCityProvinceService();
DatabaseSmoObjectsAndSettings settings =
serviceInstance.CountryCityProvinceManager_Property.SmoSettings[CountryCityProvinceManager.CONNECTION_STRING_NAME];
List <City> returnedValue = serviceInstance.GetCities(1);
}
public MetaSprocSqlDependencyManager(DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings,
List <StoredProcedure> sprocs)
{
_smoObjectsAndSettings = databaseSmoObjectsAndSettings;
AddDependecyStoredProcedures();
foreach (StoredProcedure sproc in sprocs)
{
SetMetaDataList(sproc.Name);
}
SetRecursiveSprocDependencyDictionary();
}
public static DatabaseSmoObjectsAndSettings BuildDatabaseSmoObjectsAndSettings(string databaseName,
string dataSource,
string initialCatalog,
string userId,
string password,
bool trustedConnection)
{
DatabaseSmoObjectsAndSettings smoObjectsAndSettings =
new DatabaseSmoObjectsAndSettings(databaseName, dataSource, initialCatalog,
userId, password, trustedConnection);
return(smoObjectsAndSettings);
}
public static bool IsIdentityColumn(string tableName,
string columnName,
DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings)
{
bool isIdentity = false;
CommonLibrary.Base.Database.BaseDatabase baseDatabase =
new CommonLibrary.Base.Database.BaseDatabase();
SqlParameter paramTableName = new SqlParameter("@TableName", SqlDbType.NVarChar, 255);
paramTableName.Value = tableName;
SqlParameter paramColumnName = new SqlParameter("@ColumnName", SqlDbType.NVarChar, 255);
paramColumnName.Value = columnName;
SqlParameter outIsIdentity = new SqlParameter("@IsIdentity", SqlDbType.Bit);
outIsIdentity.Direction = ParameterDirection.Output;
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = paramTableName;
parameters[1] = paramColumnName;
parameters[2] = outIsIdentity;
using (SqlConnection sqlConnection = new SqlConnection(databaseSmoObjectsAndSettings.ConnectionString))
{
sqlConnection.ConnectionString = databaseSmoObjectsAndSettings.ConnectionString;
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("IsIdentity", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter sqlParameter in parameters)
{
sqlCommand.Parameters.Add(sqlParameter);
}
sqlCommand.ExecuteNonQuery();
isIdentity = (bool)sqlCommand.Parameters["@IsIdentity"].Value;
sqlCommand.Dispose();
}
return(isIdentity);
}
public void TestLoginUser()
{
ConnectionStringHelper.GetConnectionStrings();
AccountService.AccountService serviceInstance = new AccountService.AccountService();
DatabaseSmoObjectsAndSettings settings = serviceInstance.AccountManager_Property.SmoSettings[AccountManager.CONNECTION_STRING_NAME];
string username = "******";
string password = "******";
//check if user exists
//bool exists = serviceInstance.DoesUsernameExist(username);
//if exists delete user
//if (exists)
//{
// serviceInstance.AccountDeleteByCriteria(new Account(settings) { AccountUsername = username });
//}
//create user
//exists = serviceInstance.DoesUsernameExist(username);
//Assert.IsFalse(exists);
//serviceInstance.AccountCreate(new Account(settings) { AccountUsername = username, AccountPassword = password });
////login user
//exists = serviceInstance.DoesUsernameExist(username);
//Assert.IsTrue(exists);
bool login = serviceInstance.LoginUser(username, password);
Assert.IsTrue(login);
////delete user
//bool deleted = serviceInstance.AccountDeleteByCriteria(new Account(settings) { AccountUsername = username });
//Assert.IsTrue(deleted);
}
public CustomerManager(DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings)
{
_databaseSmoObjectsAndSettings = databaseSmoObjectsAndSettings;
}
//GridUIRepresentation _gridUIRepresentation = new _gridUIRepresentation();
public CustomerController(DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings)
{
_databaseSmoObjectsAndSettings = databaseSmoObjectsAndSettings;
_customerManager = new CustomerManager(databaseSmoObjectsAndSettings);
//_gridUIRepresentation.LoadGrid(_customerManager);
}
public void TestRegisterUser()
{
RegistrationService.RegistrationService registrationInstance = new RegistrationService.RegistrationService();
DatabaseSmoObjectsAndSettings settings = registrationInstance.RegistrationManager_Property.SmoSettings[RegistrationManager.CONNECTION_STRING_NAME];
bool didItExist = false;
//first Delete everything then create a new registration for testing
//For this test i need to make sure that an existing registration for this username does not exist
bool deletedSuccess = registrationInstance.DeleteRegistration("testusername-registration", out didItExist);
Assert.AreEqual <bool>(deletedSuccess, didItExist);
Account account =
new Account(settings)
{
AccountID = Guid.NewGuid(),
AccountUsername = "******",
AccountPassword = "******",
AccountCode = "REGISTRATION"
};
Person person =
new Person(settings)
{
PersonID = Guid.NewGuid(),
PersonFirstName = "Register",
PersonMiddleInitials = "RG",
PersonLastName = "User"
};
Address address =
new Address(settings)
{
AddressID = Guid.NewGuid(),
AddressStreet = "1234 anytown",
AddressCity = "Bellingham",
AddressZipCode = "98229",
AddressCountry = "USA",
AddressTypeID = new Guid("74EE21B4-29F0-4EA9-B1C0-40CCD2D5BE00")
};
PhoneNumber phoneNumber =
new PhoneNumber(settings)
{
PhoneNumberTypeID = new Guid("B7CC6F6C-F435-4EF1-BFD8-92BCAFB2C4C3"),
PhoneNumber_Property = "555-123-4567"
};
EmailAddress emailAddress =
new EmailAddress(settings)
{
EmailAddressID = Guid.NewGuid(),
EmailAddress_Property = "*****@*****.**"
};
ProfileType profileType =
new ProfileType(settings)
{
ProfileTypeID = new Guid("4CCBD7AB-8725-41C8-93EA-CC5A14718A1D"),
ProfileName = "Administrator"
};
bool success = registrationInstance.Register(account,
person,
address,
phoneNumber,
emailAddress,
profileType);
Assert.IsTrue(success);
}
public CustomerDAOController(DatabaseSmoObjectsAndSettings databaseSmoObjectsAndSettings)
{
_databaseSmoObjectsAndSettings = databaseSmoObjectsAndSettings;
}
public BaseBusiness(DatabaseSmoObjectsAndSettings smoSettings)
{
_databaseSmoObjectsAndSettings = smoSettings;
}
