public JsonResult GetOrders(JQDTParams param) { var orders = from x in db.Order select x; var nonfilteredcount = orders.Count(); //filter //------------------------------------------------------------------- //orders = orders.Where(x => x.Id.ToLower().Contains(param.search.value)); //result //------------------------------------------------------------------- var filteredCount = orders.Count(); orders = orders.OrderBy(o => o.DataEntregaDe).Skip(param.start).Take(param.length); var data = orders.Include(o => o.Cliente).Include(o => o.Produto).ToList().Select(o => new[] { o.Id, o.Cliente.Nome, o.Produto.Descricao, o.DataEntregaDe.ToShortDateString(), o.DataEntregaAte.ToShortTimeString(), o.Quantidade.ToString(), o.PrecoUnitario.ToString(), o.Tipo, o.ToleranciaMais.ToString(), o.ToleranciaMenos.ToString() }).ToList(); return(Json(new { draw = param.draw, recordsTotal = nonfilteredcount, recordsFiltered = filteredCount, data = data }, JsonRequestBehavior.AllowGet)); }
public ContentResult GetJsonForDataTable(JQDTParams param) { try { JqueryDataTable jsonData = null; var camelCaseFormatter = new JsonSerializerSettings(); camelCaseFormatter.ContractResolver = new CamelCasePropertyNamesContractResolver(); if ((param.draw % 2) == 1) { using (StreamReader r = new StreamReader("F:/MyProjects/02 PITS/MyDiary/src/01 Presentation/UI/Mvc/Controllers/Test/dataTable.json")) { string json = r.ReadToEnd(); jsonData = JsonConvert.DeserializeObject <JqueryDataTable>(json, camelCaseFormatter); if (param.length > 0) { jsonData.Data = jsonData.Data .ToList() .Skip(param.start) .Take(param.length) .ToList(); } //jsonData.RecordsFiltered = jsonData.Data.Count(); jsonData.Draw = param.draw; } } else { jsonData = new JqueryDataTable() { Data = new List <Employee>() }; } return(Content(JsonConvert.SerializeObject(jsonData), "application/json")); } catch (Exception ex) { throw; } }
public ActionResult GetAll(JQDTParams param) { var customers = customerService.GetAll().Include(c => c.User); //var customers = db.Customers.Include(c => c.User); //var customers.ToList() //using (var db = new MBOSSEntities()) //{ // var q = from x in db.VW_ARACMARKATIPI select x; // var nonfilteredcount = q.Count(); // //filter // //------------------------------------------------------------------- // foreach (var item in param.columns) // { // var filterText = item.search.value; // if (!String.IsNullOrEmpty(filterText)) // { // filterText = filterText.ToLower(); // switch (item.name) // { // case "MARKAADI": // q = q.Where( // x => // x.MARKAADI.ToLower().Contains(filterText) // ); // break; // case "TIPADI": // q = q.Where( // x => // x.TIPADI.ToLower().Contains(filterText) // ); // break; // } // } // } // //order // //------------------------------------------------------------------- // foreach (var item in param.order) // { // string orderingFunction = "MARKAADI"; // switch (item.column) // { // case 1: // orderingFunction = "MARKAADI"; // break; // case 2: // orderingFunction = "TIPADI"; // break; // } // q = OrderClass.OrderBy<VW_ARACMARKATIPI>(q, orderingFunction, item.dir.GetStringValue()); // } // //result // //------------------------------------------------------------------- // var filteredCount = q.Count(); // q = q.Skip(param.start).Take(param.length); // var data = q.ToList() // .Select(r => new[] { // r.ARACMARKAPK.ToString(), // r.MARKAADI, // r.TIPADI, // } // ); // return Json(new // { // draw = param.draw, // recordsTotal = nonfilteredcount, // recordsFiltered = filteredCount, // data = data // }, JsonRequestBehavior.AllowGet); //} //var model = new ModelZa(); //var fileContents = System.IO.File.ReadAllText(Server.MapPath(@"~/NewFolder1/Bookings.json")); //var movie1 = JsonConvert.DeserializeObject<ModelZa>(fileContents); var nonfilteredcount = customers.Count(); ////filter ////------------------------------------------------------------------- //foreach (var item in param.columns) //{ // var filterText = item.search.value; // if (!String.IsNullOrEmpty(filterText)) // { // filterText = filterText.ToLower(); // switch (item.name) // { // case "MARKAADI": // movie1.Bookings = movie1.Bookings.Where( // x => // x.MARKAADI.ToLower().Contains(filterText) // ); // break; // case "TIPADI": // movie1.Bookings = q.Where( // x => // x.TIPADI.ToLower().Contains(filterText) // ); // break; // } // } //} customers = customers.OrderBy(n => n.ContactName).Skip(param.start).Take(param.length); var data = customers.ToList().Select(r => new[] { r.CustomerId.ToString(), r.ContactName.ToString(), r.Address.ToString(), r.City.ToString(), r.Phone.ToString() }).ToArray(); // < td > @item.Id </ td > //< td > @item.Upd_Dat </ td > //< td > @item.Srv_Prc </ td > //< td > @item.Sta </ td > return(this.Json(new { draw = param.draw, recordsTotal = nonfilteredcount, recordsFiltered = nonfilteredcount, data = data }, JsonRequestBehavior.AllowGet)); }