public void DeleteEntries_string_contains_condition()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set
where s.CharacterField.Contains(TestCharacterFieldValueChinese + "%") && s.IntegerField == 3
select s.RequestID;
Assert.AreEqual(2, q.Count());
proxy.DeleteEntryList("'Character Field' LIKE \"" + TestCharacterFieldValueChinese + "%\" AND 'Integer Field' = 3");
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
public void DeleteEntries_single_condition()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set
where s.CharacterField == TestCharacterFieldValue
select s.RequestID;
Assert.AreEqual(7, q.Count());
proxy.DeleteEntryList(m => m.CharacterField == TestCharacterFieldValue);
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally {
if (context != null)
{
context.Dispose();
}
}
}
public static void DeleteEntryList <TModel>(this ARProxy <TModel> proxy, Expression <Func <TModel, bool> > expression)
where TModel : ARBaseForm
{
if (expression == null)
{
throw new ArgumentNullException("expression must not null. If want to delete all entries, try to use m => true");
}
ConditionExpressionVisitor visitor = new ConditionExpressionVisitor();
var expEvaled = Evaluator.PartialEval(expression);
ConditionResult tr = visitor.Translate(expEvaled);
string qu = tr.Qulification == null ? null : tr.Qulification.ToString();
proxy.DeleteEntryList(qu);
}
public void DeleteEntries_constant_condition_true()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy <NRemedy_Test_Regular_Form> proxy = new ARProxy <NRemedy_Test_Regular_Form>(context);
NRemedy_Test_Regular_Form newentry = new NRemedy_Test_Regular_Form();
newentry.CharacterField = TestCharacterFieldValue;
newentry.Radio_Button_Field = null;
newentry.IntegerField = 1;
for (int i = 0; i < 7; i++)
{
proxy.CreateEntry(newentry);
}
newentry.CharacterField = TestCharacterFieldValueChinese;
newentry.IntegerField = 2;
for (int i = 0; i < 9; i++)
{
proxy.CreateEntry(newentry);
}
ARSet <NRemedy_Test_Regular_Form> set = new ARSet <NRemedy_Test_Regular_Form>(context);
var q = from s in set
select s.RequestID;
int count = q.Count();
Assert.IsTrue(count > 0);
proxy.DeleteEntryList(null);
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
public void DeleteEntries_constant_condition_true()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy<NRemedy_Test_Regular_Form> proxy = new ARProxy<NRemedy_Test_Regular_Form>(context);
NRemedy_Test_Regular_Form newentry = new NRemedy_Test_Regular_Form();
newentry.CharacterField = TestCharacterFieldValue;
newentry.Radio_Button_Field = null;
newentry.IntegerField = 1;
for (int i = 0; i < 7; i++)
{
proxy.CreateEntry(newentry);
}
newentry.CharacterField = TestCharacterFieldValueChinese;
newentry.IntegerField = 2;
for (int i = 0; i < 9; i++)
{
proxy.CreateEntry(newentry);
}
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set
select s.RequestID;
int count = q.Count();
Assert.IsTrue(count > 0);
proxy.DeleteEntryList(null);
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally
{
if (context != null)
context.Dispose();
}
}
public void DeleteEntries_string_contains_condition()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy<NRemedy_Test_Regular_Form> proxy = new ARProxy<NRemedy_Test_Regular_Form>(context);
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set
where s.CharacterField.Contains(TestCharacterFieldValueChinese + "%") && s.IntegerField == 3
select s.RequestID;
Assert.AreEqual(2, q.Count());
proxy.DeleteEntryList("'Character Field' LIKE \"" + TestCharacterFieldValueChinese + "%\" AND 'Integer Field' = 3");
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally
{
if (context != null)
context.Dispose();
}
}
public void DeleteEntries_single_condition()
{
ARLoginContext context = null;
try
{
context = new ARLoginContext(TestServer, TestAdmin, TestAdminPwd);
ARProxy<NRemedy_Test_Regular_Form> proxy = new ARProxy<NRemedy_Test_Regular_Form>(context);
ARSet<NRemedy_Test_Regular_Form> set = new ARSet<NRemedy_Test_Regular_Form>(context);
var q = from s in set
where s.CharacterField == TestCharacterFieldValue
select s.RequestID;
Assert.AreEqual(7, q.Count());
proxy.DeleteEntryList(m => m.CharacterField == TestCharacterFieldValue);
//after delete the count should be 0
Assert.AreEqual(0, q.Count());
}
finally {
if (context != null)
context.Dispose();
}
}