/// <summary>
///
/// </summary>
/// <param name="databaseHelper"></param>
/// <param name="Username"></param>
/// <param name="Password"></param>
/// <param name="UserRole"></param>
public void CreateUser(DAODatabaseHelper databaseHelper, string Username, string Password, string UserRole)
{
this.BeginTransaction();
System.Data.Common.DbCommand TempCommand_2 = databaseHelper.CreateCommand();
TempCommand_2.CommandText = "sp_addnewuser";
TempCommand_2.CommandType = System.Data.CommandType.StoredProcedure;
TempCommand_2.Transaction = TransactionManager.GetTransaction(databaseHelper.Connection);
DbCommand command = TempCommand_2;
ADORecordSetHelper.commandParameterBinding(command, "Username").Value = Username;
ADORecordSetHelper.commandParameterBinding(command, "Password").Value = Password;
ADORecordSetHelper.commandParameterBinding(command, "UserRole").Value = UserRole;
command.ExecuteNonQuery();
this.CommitTransaction();
}