public IActionResult DefaultFunctionalities()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
Condition = "and",
Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "Employee ID", Field = "EmployeeID", Type = "number", Operator = "equal", Value = 1
},
new QueryBuilderRule {
Label = "Title", Field = "Title", Type = "string", Operator = "equal", Value = "Sales Manager"
}
}
};
List <string> values = new List <string> {
"Mr.", "Mrs."
};
ViewBag.rule = rule;
ViewBag.values = values;
ViewBag.dataSource = EmployeeView.GetAllRecords();
return(View());
}
public IActionResult ComplexDatabinding()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
Condition = "and",
Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "ID", Field = "Employee.ID", Type = "number", Operator = "equal", Value = 1001
},
new QueryBuilderRule {
Label = "First Name", Field = "Name.FirstName", Type = "string", Operator = "equal", Value = "Mark"
},
new QueryBuilderRule {
Condition = "or", Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "State", Field = "Country.State", Type = "string", Operator = "equal", Value = "Jersey"
},
new QueryBuilderRule {
Label = "Date of birth", Field = "Employee.DOB", Type = "date", Operator = "equal", Value = "7/7/96"
}
}
}
}
};
ViewBag.rule = rule;
return(View());
}
// GET= DefaultFunctionalities
public ActionResult Template()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
Condition = "and",
Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "Category", Field = "Category", Type = "string", Operator = "equal", Value = new string[] { "Clothing" }
},
new QueryBuilderRule {
Condition = "or", Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "Transaction Type", Field = "TransactionType", Type = "boolean", Operator = "equal", Value = "Income"
},
new QueryBuilderRule {
Label = "Payment Mode", Field = "PaymentMode", Type = "string", Operator = "equal", Value = "Cash"
}
}
},
new QueryBuilderRule {
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()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
Condition = "or",
Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "Category", Field = "Category", Type = "string", Operator = "equal", Value = "Laptop"
}
}
};
ViewBag.rule = rule;
ViewBag.dataSource = QueryBuilderData.hardwareData;
return(View());
}
public ActionResult RuleTemplate()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
Condition = "and",
Rules = new List <QueryBuilderRule>()
{
new QueryBuilderRule {
Label = "First Name", Field = "FirstName", Type = "string", Operator = "equal", Value = "Nancy"
},
new QueryBuilderRule {
Label = "Country", Field = "Country", Type = "string", Operator = "equal", Value = "USA"
}
}
};
ViewBag.rule = rule;
return(View());
}
public IActionResult Template()
{
QueryBuilderRule rule = new QueryBuilderRule()
{
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> template = new List <object>()
{
new { create = "categoryCreate", destroy = "categoryDestroy", write = "categoryWrite" },
new { create = "paymentCreate", destroy = "paymentDestroy", write = "paymentWrite" },
new { create = "transactionCreate", destroy = "transactionDestroy", write = "transactionWrite" },
new { create = "amountCreate", destroy = "amountDestroy", write = "amountWrite" }
};
List <object> paymentOperator = new List <object> {
new { key = "Equal", value = "equal" },
new { key = "Not Equal", value = "notequal" },
new { key = "In", value = "in" },
new { key = "Not In", value = "notin" }
};
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.template = template;
return(View());
}
