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()); }