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