public void ObjectDataSource_InsertParametersCaseSensitive ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.InsertMethod = "Insert";
Parameter p1, p2, p3;
p1 = new Parameter ("id", TypeCode.String, "1001");
p2 = new Parameter ("fname", TypeCode.String, "Mahesh");
p3 = new Parameter ("lname", TypeCode.String, "chand");
view.InsertParameters.Add (p1);
view.InsertParameters.Add (p2);
view.InsertParameters.Add (p3);
//This hashtable ovveride
Hashtable value = new Hashtable ();
value.Add ("t", "test_id");
//Merge parameters
view.ExecuteInsert (value);
Assert.AreEqual (true, MyTableObject.InsertWithMergedParameters, "InsertParametersCaseSensitive");
}
public void ObjectDataSource_UpdateExecute_2 ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.UpdateMethod = "TryUpdate";
Parameter p1, p2, p3;
p1 = new Parameter ("ID", TypeCode.String, "1001");
p2 = new Parameter ("FName", TypeCode.String, "Mahesh");
p3 = new Parameter ("LName", TypeCode.String, "chand");
view.UpdateParameters.Add (p1);
view.UpdateParameters.Add (p2);
view.UpdateParameters.Add (p3);
view.OldValuesParameterFormatString = "oldvalue_{0}";
Hashtable value = new Hashtable ();
value.Add ("P", "1001");
view.ExecuteUpdate (null, value, null);
Assert.AreEqual (true, MyTableObject.UpdateWithMergedCollection, "UpdateExecute#2");
}
public void ObjectDataSource_DeleteExecuteDataTypeCompareAllValues ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.DataObjectTypeName = typeof (NewData).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.DeleteMethod = "Delete";
view.ConflictDetection = ConflictOptions.CompareAllValues;
Hashtable keys;
Hashtable old_value;
Hashtable new_value;
InitializeView (view, out keys, out old_value, out new_value);
view.ExecuteDelete (keys, old_value);
Assert.AreEqual (true, MyTableObject.DeleteWithDataObjectTypeName, "DeleteExecuteDataTypeCompareAllValues");
Assert.AreEqual ("ov_1001, ov_Mahesh, ov_chand", MyTableObject.UpdatePassedValues, "DeleteExecuteDataTypeCompareAllValues Values");
}
public void ObjectDataSource_InsertExecute_1 ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.InsertMethod = "Insert";
//This hashtable ovveride
Hashtable value = new Hashtable ();
value.Add ("ID", "test_id");
view.ExecuteInsert (value);
Assert.AreEqual (true, MyTableObject.InsertWithParameters, "InsertExecute#1");
}
public void ObjectDataSource_SelectExecuteCaseSensitive ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.SelectMethod = "GetMyData";
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectParameters.Add (new Parameter ("fname", TypeCode.String, "TestSelect"));
ArrayList ls = (ArrayList) view.ExecuteSelect (new DataSourceSelectArguments (""));
Assert.AreEqual ("TestSelect", ls[0], "SelectExecuteCaseSensitive");
}
public void ObjectDataSource_DeleteExecuteMethodCaseSensitive ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.DeleteMethod = "delete";
Parameter p1, p2, p3;
p1 = new Parameter ("ID", TypeCode.String, "1001");
p2 = new Parameter ("FName", TypeCode.String, "Mahesh");
p3 = new Parameter ("LName", TypeCode.String, "chand");
view.DeleteParameters.Add (p1);
view.DeleteParameters.Add (p2);
view.DeleteParameters.Add (p3);
view.OldValuesParameterFormatString = "oldvalue_{0}";
Hashtable value = new Hashtable ();
value.Add ("ID", "test_id");
view.ExecuteDelete (value, null);
Assert.AreEqual (true, MyTableObject.DeleteWithParamsAndKeys, "DeleteExecuteMethodCaseSensitive");
}
public void ObjectDataSource_DeleteExecuteMethodParameterException()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.DeleteMethod = "delete";
Parameter p1, p2, p3;
p1 = new Parameter ("ID", TypeCode.String, "1001");
view.DeleteParameters.Add (p1);
view.OldValuesParameterFormatString = "oldvalue_{0}";
Hashtable value = new Hashtable ();
value.Add ("ID", "test_id");
view.ExecuteDelete (value, null);
}
public void ObjectDataSource_SelectExecuteException_2 ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.SelectMethod = "Fake";
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectParameters.Add (new Parameter ("Fname", TypeCode.String, "TestSelect"));
IEnumerable res = view.ExecuteSelect (new DataSourceSelectArguments (""));
}
public void ObjectDataSource_UpdateExecute_CompareAllValues_Exception ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.UpdateMethod = "TryUpdate_1";
Parameter p1, p2, p3;
p1 = new Parameter ("ID", TypeCode.String, "1001");
p2 = new Parameter ("FName", TypeCode.String, "Mahesh");
p3 = new Parameter ("LName", TypeCode.String, "chand");
view.UpdateParameters.Add (p1);
view.UpdateParameters.Add (p2);
view.UpdateParameters.Add (p3);
view.OldValuesParameterFormatString = "oldvalue_{0}";
view.ConflictDetection = ConflictOptions.CompareAllValues;
view.ExecuteUpdate (null, null, null);
}
public void ObjectDataSource_UpdateExecute_DataObjectTypeName2 ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.DataObjectTypeName = typeof (NewData).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.UpdateMethod = "Update";
view.OldValuesParameterFormatString = "oldvalue_{0}";
view.ConflictDetection = ConflictOptions.OverwriteChanges;
Hashtable keys;
Hashtable old_value;
Hashtable new_value;
InitializeView (view, out keys, out old_value, out new_value);
view.ExecuteUpdate (keys, new_value, old_value);
Assert.AreEqual (true, MyTableObject.UpdateWithDataObjectTypeName, "UpdateExecute_DataObjectTypeName2");
Assert.AreEqual ("n_1001, n_Mahesh, n_chand", MyTableObject.UpdatePassedValues, "UpdateExecute_DataObjectTypeName Values");
}
public void ObjectDataSource_UpdateExecute_DataObjectTypeName ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.DataObjectTypeName = typeof (NewData).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.UpdateMethod = "Update";
view.OldValuesParameterFormatString = "oldvalue_{0}";
view.ExecuteUpdate (null, null, null);
Assert.AreEqual (true, MyTableObject.UpdateWithDataObjectTypeName, "UpdateExecute_DataObjectTypeName");
Assert.AreEqual (", , ", MyTableObject.UpdatePassedValues, "UpdateExecute_DataObjectTypeName Values");
}
public void ObjectDataSource_UpdateExecute_OverwriteChanges ()
{
ObjectDataSourcePoker ods = new ObjectDataSourcePoker ();
InitObjectDataSource (ods, "");
CustomObjectDataSourceView view = new CustomObjectDataSourceView (ods, "CustomView", null);
view.TypeName = typeof (MyTableObject).AssemblyQualifiedName;
view.SelectMethod = "GetMyData";
view.UpdateMethod = "UpdateOverwriteChanges";
view.ConflictDetection = ConflictOptions.OverwriteChanges;
Hashtable keys;
Hashtable old_value;
Hashtable new_value;
InitializeView (view, out keys, out old_value, out new_value);
view.ExecuteUpdate (keys, new_value, old_value);
Assert.AreEqual (true, MyTableObject.UpdateOverwriteChangesCalled, "OverwriteChanges");
Assert.AreEqual ("n_1001, n_Mahesh, n_chand, k_1001", MyTableObject.UpdatePassedValues, "OverwriteChanges Values");
}
private static void InitializeView (CustomObjectDataSourceView view, out Hashtable keys, out Hashtable old_value, out Hashtable new_value)
{
Parameter p1, p2, p3, p4;
p1 = new Parameter ("oldvalue_ID", TypeCode.String, "p_1001");
p2 = new Parameter ("FName", TypeCode.String, "p_Mahesh");
p3 = new Parameter ("LName", TypeCode.String, "p_chand");
view.UpdateParameters.Add (p1);
view.UpdateParameters.Add (p2);
view.UpdateParameters.Add (p3);
p4 = new Parameter ("oldvalue_ID", TypeCode.String, "p_1001");
view.DeleteParameters.Add (p4);
view.OldValuesParameterFormatString = "oldvalue_{0}";
keys = new Hashtable ();
keys.Add ("ID", "k_1001");
old_value = new Hashtable ();
old_value.Add ("ID", "ov_1001");
old_value.Add ("FName", "ov_Mahesh");
old_value.Add ("LName", "ov_chand");
new_value = new Hashtable ();
new_value.Add ("ID", "n_1001");
new_value.Add ("FName", "n_Mahesh");
new_value.Add ("LName", "n_chand");
}
