// GET= DefaultFunctionalities
public ActionResult Template()
{
QueryBuilderRules rule = new QueryBuilderRules()
{
Condition = "and",
Rules = new List <QueryBuilderRules>()
{
new QueryBuilderRules {
Label = "Category", Field = "Category", Type = "string", Operator = "equal", Value = new string[] { "Clothing" }
},
new QueryBuilderRules {
Condition = "or", Rules = new List <QueryBuilderRules>()
{
new QueryBuilderRules {
Label = "Transaction Type", Field = "TransactionType", Type = "boolean", Operator = "equal", Value = "Income"
},
new QueryBuilderRules {
Label = "Payment Mode", Field = "PaymentMode", Type = "string", Operator = "equal", Value = "Cash"
}
}
},
new QueryBuilderRules {
Label = "Amount", Field = "Amount", Type = "number", Operator = "equal", Value = 10
}
}
};
List <object> paymentOperator = new List <object> {
new { key = "Equal", value = "equal" },
new { key = "Not Equal", value = "notequal" }
};
List <object> transactionOperator = new List <object> {
new { key = "Equal", value = "equal" },
new { key = "Not Equal", value = "notequal" }
};
List <object> amountOperator = new List <object> {
new { key = "Equal", value = "equal" },
new { key = "Greater than", value = "greaterthan" },
new { key = "Less than", value = "lessthan" },
new { key = "Less than or equal", value = "lessthanorequal" },
new { key = "Greater than or equal", value = "greaterthanorequal" },
new { key = "Not equal", value = "notequal" }
};
ViewBag.rule = rule;
ViewBag.paymentOperator = paymentOperator;
ViewBag.transactionOperator = transactionOperator;
ViewBag.amountOperator = amountOperator;
ViewBag.dataSource = QueryBuilderData.expenseData;
return(View());
}
// GET= DefaultFunctionalities
public ActionResult Grid()
{
QueryBuilderRules rule = new QueryBuilderRules()
{
Condition = "or",
Rules = new List <QueryBuilderRules>()
{
new QueryBuilderRules {
Label = "Category", Field = "Category", Type = "string", Operator = "equal", Value = "Laptop"
}
}
};
ViewBag.rule = rule;
ViewBag.dataSource = QueryBuilderData.hardwareData;
return(View());
}
// GET= DefaultFunctionalities
public ActionResult DefaultFunctionalities()
{
QueryBuilderRules rule = new QueryBuilderRules()
{
Condition = "and",
Rules = new List <QueryBuilderRules>()
{
new QueryBuilderRules {
Label = "Employee ID", Field = "EmployeeID", Type = "number", Operator = "equal", Value = 1
},
new QueryBuilderRules {
Label = "Title", Field = "Title", Type = "string", Operator = "equal", Value = "Sales Manager"
}
}
};
ViewBag.rule = rule;
ViewBag.dataSource = EmployeeView.GetAllRecords();
return(View());
}
