//get filter data from jquery
public JsonResult GetTblOrderWithParameter(string prefix)
{
List <tblOrder> allOrder = new List <tblOrder>();
//Here MyOrderModel is DB context, which is created at the time of model creation
using (Models.OrderModels.MyOrderModel db = new Models.OrderModels.MyOrderModel())
{
allOrder = db.tblOrder.Where(a => a.OrderTrackingNumber.Contains(prefix)).ToList();
}
return(new JsonResult {
Data = allOrder, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//get ALL order data
public JsonResult GetTblOrder()
{
List <tblOrder> allOrder = new List <tblOrder>();
//Here MyOrderModel is DB context, which is created at the time of model creation
using (Models.OrderModels.MyOrderModel db = new Models.OrderModels.MyOrderModel()) {
//select data from MyOrderModel
allOrder = db.tblOrder.ToList();
}
return(new JsonResult {
Data = allOrder, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}