/// <summary>
/// Initializes a new instance of the <see cref="SiteCreationEngine"/> class.
/// </summary>
public SiteCreationEngine(SPList list)
{
_list = list;
_category = list.ID.ToString("B");
_properties = new SPSKeyValueList();
GetDataFromConfigurationManager();
}
/// <summary>
/// Reads the data base.
/// </summary>
/// <param name="filterValues">The filter values.</param>
public void ReadDataBase(SPSKeyValueList filterValues)
{
// Read
if (DataBaseOperation == ActionDataBaseOperation.Read)
{
Debug.WriteLine("** READ_DATABASE **");
// Try read
_actionDataBase.InitializeDataSet();
if (_actionDataBase.SelectRecord(filterValues, false) == 0)
{
// Record not found
FormMode = ActionEditorFormMode.Blank;
}
else
{
// Record found
if (FormMode == ActionEditorFormMode.Blank)
{
FormMode = ActionEditorFormMode.View;
}
}
}
// Retain filter values
FilterValues = filterValues;
// If skip-read put read
if (DataBaseOperation == ActionDataBaseOperation.NextTimeRead)
{
DataBaseOperation = ActionDataBaseOperation.Read;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SPSXsltExtension"/> class.
/// </summary>
/// <param name="control">The control.</param>
/// <param name="page">The page.</param>
/// <param name="keyValues">The key values.</param>
public SPSXsltExtension(Control control, Page page, SPSKeyValueList keyValues)
{
_control = control;
_page = page;
_keyValues = keyValues;
Initialize();
}
/// <summary>
/// Initializes a new instance of the <see cref="SPSXsltExtension"/> class.
/// </summary>
/// <param name="control">The control.</param>
/// <param name="page">The page.</param>
/// <param name="keyValues">The key values.</param>
public SPSXsltExtension(Control control, Page page, SPSKeyValueList keyValues)
{
if (control is ISPSViewCommandParameters)
{
_control = control;
}
else
{
foreach (Control subControl in control.Controls)
{
if (subControl is ISPSViewCommandParameters)
{
_control = subControl;
break;
}
}
if (_control == null)
{
throw new ArgumentException("Almost one ISPSViewCommandParameters is required", "control");
}
}
_page = page;
_keyValues = keyValues;
Initialize();
}
/// <summary>
/// Tries the get last added record.
/// </summary>
/// <param name="fieldValues">The field values.</param>
/// <param name="filterValues">The filter values.</param>
private void TryGetLastAddedRecord(IDictionary <string, string> fieldValues, SPSKeyValueList filterValues)
{
try
{
// Try to get identity
SqlCommand command = new SqlCommand("SELECT @@IDENTITY", _connection);
_adapter = new SqlDataAdapter(command);
string key = command.ExecuteScalar().ToString();
// If there is a key
if (!string.IsNullOrEmpty(key))
{
// Replace the key in the current filter
filterValues.ReplaceValue(_config.DataBase.Table.IdentityColumnCollection[0].Name, key);
}
else
{
// Set the new filter vales
SetNewFilterValues(fieldValues, filterValues);
}
// Select the added record using the new filter
if (filterValues != null)
{
SelectRecord(filterValues, false);
}
}
catch (SqlException ex)
{
DumpException("TryGetLastAddedRecord", ex);
}
}
public void Transform()
{
SPSKeyValueList list = new SPSKeyValueList();
list.Add("key0", "value0");
list.Add("key1", "value1");
list.Add("key2", "value2");
Mock <Page> mockPage = MockManager.MockObject <Page>(Constructor.Mocked);
Mock <Control> mockControl = MockManager.MockObject <Control>(Constructor.Mocked);
mockControl.MockedInstance.ID = "TestID";
Mock <SPSXsltControl> xsltMockControl = MockManager.MockObject <SPSXsltControl>(Constructor.Mocked);
xsltMockControl.ExpectGet("Page", mockPage.MockedInstance);
xsltMockControl.ExpectGet("Parent", mockControl.MockedInstance);
SPSXsltControl xsltControl = xsltMockControl.MockedInstance;
Assert.IsNotNull(xsltControl);
xsltControl.XmlData = TestData.GetResource("TestData.xml");
xsltControl.Xsl = TestData.GetResource("Test.xslt");
StringWriter transform = xsltControl.Transform();
string output = transform.ToString();
Debug.WriteLine(output);
Assert.IsTrue(output.Contains("TEST"));
Assert.IsTrue(output.Contains("1"));
Assert.IsTrue(output.Contains("2"));
MockManager.Verify();
}
///// <summary>
///// Handle the postback from form, get values from form fields
///// </summary>
///// <param name="postCollection">The post collection.</param>
//private void HandlePostData(NameValueCollection postCollection)
//{
// return;
// // Dictionary to store field values
// _fieldValues = new SPSKeyValueList();
// // Get field values from postCollection
// foreach (Field field in _config.Fields)
// {
// try
// {
// string value = GetPostDataValues(field, postCollection);
// Debug.WriteLine(string.Format("Load Field [{0,-20}] -> [{1}]", field.Name, value));
// _fieldValues.Add(field.Name, value);
// }
// catch (Exception ex) // ArgumentOutOfRangeException
// {
// SendError(ex);
// }
// }
//}
///// <summary>
///// Gets the form value for an espcified field.
///// </summary>
///// <param name="field">The field.</param>
///// <param name="postCollection">The post collection.</param>
///// <returns>The post data value of field</returns>
//private string GetPostDataValues(Field field, NameValueCollection postCollection)
//{
// string value;
// string baseId = UniqueID + IdSeparator + "ctl01$c" + field.Name;
// //Debug.WriteLine(baseId);
// switch (field.Control)
// {
// case ActionEditorControlsType.Lookup:
// if (field.Lookup.ControlEditor == ActionEditorLookupControl.PickerDataBase)
// {
// value = postCollection[baseId + IdSeparator + "hiddenSpanData"];
// }
// else
// {
// value = postCollection[baseId];
// }
// break;
// case ActionEditorControlsType.Date:
// value = postCollection[baseId + IdSeparator + "c" + field.Name + "Date"];
// break;
// case ActionEditorControlsType.DateTime:
// value = postCollection[baseId + IdSeparator + "c" + field.Name + "Date"] + " " +
// postCollection[baseId + IdSeparator + "c" + field.Name + "DateHours"] +
// postCollection[baseId + IdSeparator + "c" + field.Name + "DateMinutes"];
// break;
// case ActionEditorControlsType.Memo:
// if (field.Memo.RichText == "No" || field.Memo.RichText == "false")
// {
// value = postCollection[baseId];
// }
// else
// {
// value = postCollection[baseId + "_spSave"];
// }
// break;
// default:
// value = postCollection[baseId];
// break;
// }
// return value;
//}
public void SetFilterValues(SPSKeyValueList filterValues)
{
if (filterValues != null)
{
_filterValues = filterValues;
//FilterValues = filterValues;
}
}
public void Add()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
keyValues.Add("Key", "Value");
Assert.IsTrue(keyValues.Count == 1);
Assert.IsTrue(keyValues[0].Key == "Key");
Assert.IsTrue(keyValues[0].Value == "Value");
}
public void Index()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
keyValues.Add(new SPSKeyValuePair("Key1", "Value1"));
Assert.IsTrue(keyValues["Key"] == "Value");
Assert.IsTrue(keyValues["Key1"] == "Value1");
}
public void Contains()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
Assert.IsTrue(keyValues.Contains("Key"));
Assert.IsFalse(keyValues.Contains("OtherKey"));
}
protected override void OnPreRender(EventArgs e)
{
Debug.WriteLine("RollUp: OnPreRender " + Title);
// Crawl
InternalCrawl(false);
// Save last filter
LastFilter = _camlPreprocessor.VariablesValues;
}
public ActionEditorTest()
{
Debug.WriteLine("TEST Contructor");
_parameterValues = new SPSKeyValueList();
SPSInit("DD434B08-2854-4f29-81A7-44FC86E56886",
"ActionDataBase.1.0",
"WebParts ActionDataBase",
"http://www.spsprofessional.com");
EditorParts.Add(new ActionEditorTestEditorPart());
}
public void ReplaceAllValues()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
keyValues.ReplaceAllValues("Key", "NewValue");
Assert.IsTrue(keyValues[0].Value == "NewValue");
Assert.IsTrue(keyValues[1].Value == "NewValue");
}
/// <summary>
/// Creates the record.
/// </summary>
/// <param name="fieldValues">The field values.</param>
/// <param name="filterValues">The filter values.</param>
/// <returns>New record identity</returns>
internal int CreateRecord(IDictionary <string, string> fieldValues, SPSKeyValueList filterValues)
{
Debug.WriteLine("CreateRecord");
int createdRows = 0;
try
{
InitializeDataSet();
PrepareSchema();
_adapter.MissingSchemaAction = MissingSchemaAction.Ignore;
_builder = new SqlCommandBuilder(_adapter)
{
ConflictOption = ConflictOption.OverwriteChanges
};
SqlCommand command = new SqlCommand(_builder.GetInsertCommand(true).CommandText,
_connection);
Debug.WriteLine(command.CommandText);
AddDataParameters(command, fieldValues);
_connection.Open();
createdRows = command.ExecuteNonQuery();
if (createdRows > 0)
{
// Try to get the last added record
TryGetLastAddedRecord(fieldValues, filterValues);
}
}
catch (Exception ex)
{
if (OnError != null)
{
OnError(this, new SPSErrorArgs(SPSSubSystemName, "Error creating new record.", ex));
}
DumpException("CreateRecord", ex);
}
finally
{
_connection.Close();
}
Debug.WriteLine("CreateRecord End");
return(createdRows);
}
/// <summary>
/// Initializes a new instance of the <see cref="CamlPreprocessor"/> class.
/// </summary>
/// <param name="camlQuery">The caml query.</param>
public CamlPreprocessor(string camlQuery)
{
_regex = new Regex(CAMLVariableRegex,
RegexOptions.Multiline
| RegexOptions.IgnoreCase
| RegexOptions.CultureInvariant
| RegexOptions.IgnorePatternWhitespace
| RegexOptions.Compiled);
_camlQuery = camlQuery;
_variableValues = new SPSKeyValueList();
_variableFunctions = new SPSKeyValueList();
GetParameters();
}
protected override void OnPreRender(EventArgs e)
{
Debug.WriteLine("RollUp: OnPreRender " + Title);
// Crawl
InternalCrawl(false);
// Save last filter
// LastFilter = _camlPreprocessor.VariablesValues;
if (LastFilter == null)
{
LastFilter = new SPSKeyValueList();
}
_camlPreprocessor.CopyVariableValues(LastFilter);
}
public SPSXsltExtension_Test()
{
SPSKeyValueList list = new SPSKeyValueList();
list.Add("key0", "value0");
list.Add("key1", "value1");
list.Add("key2", "value2");
Mock <Page> mockPage = MockManager.MockObject <Page>(Constructor.Mocked);
Mock <Control> mockControl = MockManager.MockObject <Control>(Constructor.Mocked);
mockControl.MockedInstance.ID = "TestID";
_extension = new SPSXsltExtension(mockControl.MockedInstance, mockPage.MockedInstance, list);
MockManager.Verify();
}
public void ReplaceValue()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
keyValues.Add(new SPSKeyValuePair("Key", "Value"));
Assert.IsTrue(keyValues.Count == 2);
keyValues.ReplaceValue("Key", "Value1");
Assert.IsTrue(keyValues[0].Key == "Key");
Assert.IsTrue(keyValues[0].Value == "Value1");
Assert.IsTrue(keyValues[1].Key == "Key");
Assert.IsTrue(keyValues[1].Value == "Value");
}
/// <summary>
/// Gets the row data.
/// </summary>
/// <returns>Contains the schema if no data, otherwise data and schema</returns>
public SPSKeyValueList GetDataValues()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
// Generate Data
if (SelectedRow != null && HasResults)
{
DataRowView rowView = Data.Tables[0].DefaultView[SelectedRow.Value];
foreach (DataColumn column in Data.Tables[0].Columns)
{
keyValues.Add(column.ColumnName, rowView[column.ColumnName].ToString());
}
return(keyValues);
}
return(null);
}
/// <summary>
/// Gets the row data.
/// </summary>
/// <returns>Contains the schema if no data, otherwise data and schema</returns>
public SPSKeyValueList GetRowValues(int?selectedRow)
{
SPSKeyValueList keyValues = new SPSKeyValueList();
// Generate Data
if (selectedRow != null && HasResults)
{
DataRowView rowView = _dataTable.DefaultView[selectedRow.Value];
foreach (DataColumn column in _dataTable.Columns)
{
keyValues.Add(column.ColumnName, rowView[column.ColumnName].ToString());
}
}
return(keyValues);
}
/// <summary>
/// Updates the record.
/// </summary>
/// <param name="fieldValues">The field values.</param>
/// <param name="filterValues">The filter values.</param>
/// <returns>Rows affected</returns>
internal int UpdateRecord(IDictionary <string, string> fieldValues, SPSKeyValueList filterValues)
{
Debug.WriteLine("UpdateRecord");
int countRecords = 0;
try
{
InitializeDataSet();
SelectRecord(filterValues, true);
_adapter.MissingSchemaAction = MissingSchemaAction.Ignore;
_builder = new SqlCommandBuilder(_adapter)
{
ConflictOption = ConflictOption.OverwriteChanges
};
SqlCommand command = new SqlCommand(_builder.GetUpdateCommand(true).CommandText,
_connection);
Debug.WriteLine(command.CommandText);
AddDataParameters(command, fieldValues);
AddFilterParameters(command, filterValues, true);
_connection.Open();
countRecords = command.ExecuteNonQuery();
}
catch (Exception ex)
{
if (OnError != null)
{
OnError(this, new SPSErrorArgs(SPSSubSystemName, "Error updating record.", ex));
}
DumpException("UpdateRecord", ex);
}
finally
{
_connection.Close();
}
Debug.WriteLine("UpdateRecord End");
return(countRecords);
}
public SPSXsltExtension_Test()
{
SPSKeyValueList list = new SPSKeyValueList();
list.Add("key0", "value0");
list.Add("key1", "value1");
list.Add("key2", "value2");
Mock <Page> mockPage = MockManager.MockObject <Page>(Constructor.Mocked);
SPSXsltCommandControl xsltCommandControl = new SPSXsltCommandControl
{
ID = "TestID"
};
_extension = new SPSXsltExtension(xsltCommandControl, mockPage.MockedInstance, list);
MockManager.Verify();
}
/// <summary>
/// Selects the record.
/// </summary>
/// <param name="filterValues">The filter values.</param>
/// <param name="addError">if set to <c>true</c> add the error to error subsystem.</param>
internal int SelectRecord(SPSKeyValueList filterValues, bool addError)
{
Debug.WriteLine("SelectRecord");
int recordCount = 0;
try
{
SqlCommand sqlCommand = new SqlCommand(PrepareSelectFields() +
PrepareSelectForFilter(),
_connection);
AddFilterParameters(sqlCommand, filterValues, false);
Debug.WriteLine(sqlCommand.CommandText);
_adapter = new SqlDataAdapter(sqlCommand);
// Read
recordCount = _adapter.Fill(_dataSet, _tableName);
// The current data
if (recordCount > 0)
{
_dataRow = _dataSet.Tables[0].Rows[0];
}
}
catch (Exception ex)
{
if (OnError != null && addError)
{
OnError(this, new SPSErrorArgs(SPSSubSystemName, "Error selecting record.", ex));
}
DumpException("SelectRecord", ex);
}
finally
{
_connection.Close();
}
Debug.WriteLine("SelectRecord End");
return(recordCount);
}
public void SerializeDeserialize()
{
SPSKeyValueList keyValuesBefore = new SPSKeyValueList();
SPSKeyValuePair keyValue0 = new SPSKeyValuePair("KeyA", "Value1");
SPSKeyValuePair keyValue1 = new SPSKeyValuePair("KeyB", "Value2");
keyValuesBefore.Add(keyValue0);
keyValuesBefore.Add(keyValue1);
string serialized = SPSKeyValueList.Serialize(keyValuesBefore);
SPSKeyValueList keyValuesAfter = SPSKeyValueList.Deserialize(serialized);
Assert.IsTrue(keyValuesAfter.Count == keyValuesBefore.Count);
Assert.IsTrue(keyValuesAfter.Count == keyValuesBefore.Count);
Assert.IsTrue(keyValuesAfter.Contains("KeyA"));
Assert.IsTrue(keyValuesAfter.Contains("KeyB"));
Assert.IsTrue(keyValuesAfter[0].Value == "Value1");
Assert.IsTrue(keyValuesAfter[1].Value == "Value2");
}
/// <summary>
/// Initializes the variable values.
/// </summary>
/// <param name="keyValueList">The key value list.</param>
public void InitializeVariableValues(SPSKeyValueList keyValueList)
{
ClearVariableValues();
keyValueList.ForEach(pair => _variableValues.Add(pair));
}
/// <summary>
/// Copies the variable values.
/// </summary>
/// <param name="keyValueList">The key value list.</param>
public void CopyVariableValues(SPSKeyValueList keyValueList)
{
keyValueList.Clear();
_variableValues.ForEach(pair => keyValueList.Add(pair));
}
/// <summary>
/// Initializes a new instance of the <see cref="SiteCreationEngine"/> class.
/// </summary>
/// <param name="listId">The list id.</param>
public SiteCreationEngine(Guid listId)
{
_category = listId.ToString("B");
_properties = new SPSKeyValueList();
GetDataFromConfigurationManager();
}
public void Constructor()
{
SPSKeyValueList keyValues = new SPSKeyValueList();
Assert.IsTrue(keyValues.Count == 0);
}
