internal void ProcessDataObjectsAll(UserDataContext udc)
{
FilterEngine.InitFilterAdWords();
blnCancel = false;
Dictionary <string, FilterObject> adWordFilterObjects = FilterEngine.GetAdWordFilterObjects();
foreach (KeyValuePair <string, FilterObject> adWordFilterObject in adWordFilterObjects)
{
if (blnCancel)
{
break;
}
int counter = 0;
Console.WriteLine("Loading " + adWordFilterObject.Value.TypeName);
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_DataObject_LoadIdsByType";
sqlConnection.Command.Parameters.Add(new SqlParameter("@ObjectTypeId", SqlDbType.Int));
sqlConnection.Command.Parameters["@ObjectTypeId"].Value = adWordFilterObject.Value.ObjectTypeId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
DateTime startTime = DateTime.Now;
while (sqlDataReader.Read())
{
if (blnCancel)
{
break;
}
FilterObjectAdWords(udc, adWordFilterObject.Value.TypeName, adWordFilterObject.Value.ObjectTypeId, sqlDataReader["OBJ_ID"].ToString().ToGuid());
counter++;
}
sqlDataReader.Close();
DateTime endTime = DateTime.Now;
TimeSpan duration = endTime - startTime;
Console.WriteLine(counter + " items took " + duration + " secs");
}
catch (Exception e)
{
Console.WriteLine("*** Error: " + e);
}
finally
{
sqlConnection.Close();
}
}
}
internal void ProcessDataObjectsForUser(UserDataContext udc, Guid userId)
{
FilterEngine.InitFilterAdWords();
Dictionary <string, FilterObject> adWordFilterObjects = FilterEngine.GetAdWordFilterObjects();
Dictionary <int, string> typeNameMapping = new Dictionary <int, string>();
foreach (KeyValuePair <string, FilterObject> adWordFilterObject in adWordFilterObjects)
{
typeNameMapping.Add(adWordFilterObject.Value.ObjectTypeId, adWordFilterObject.Value.TypeName);
}
int counter = 0;
Console.WriteLine("Loading " + userId);
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_DataObject_LoadIdsByUserId";
sqlConnection.Command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.UniqueIdentifier));
sqlConnection.Command.Parameters["@UserId"].Value = userId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
DateTime startTime = DateTime.Now;
while (sqlDataReader.Read())
{
if (typeNameMapping.ContainsKey((int)sqlDataReader["OBJ_Type"]))
{
FilterObjectAdWords(udc, typeNameMapping[(int)sqlDataReader["OBJ_Type"]], (int)sqlDataReader["OBJ_Type"], sqlDataReader["OBJ_ID"].ToString().ToGuid());
counter++;
}
}
sqlDataReader.Close();
DateTime endTime = DateTime.Now;
TimeSpan duration = endTime - startTime;
Console.WriteLine(counter + " items took " + duration + " secs");
}
catch (Exception e)
{
Console.WriteLine("*** Error: " + e);
}
finally
{
sqlConnection.Close();
}
}