private void InitTestModel() { Model = new CsvModel(); List <ItemMasterModel> Models; using (var entities = new ApplicationDbContext()) { Models = entities.ItemMasters.Select(X => X).ToList(); foreach (var model in Models) { var cell = new Cell(Model.ColumnNames); cell.SetCellInfo(Model.ColumnNames[0], model.PartNumber); cell.SetCellInfo(Model.ColumnNames[1], model.Specification); cell.SetCellInfo(Model.ColumnNames[2], model.Description); cell.SetCellInfo(Model.ColumnNames[3], model.CreatedDate.ToString()); Model.AddCell(cell); } } }
public ActionResult LoadDataIndex() { var For = Request.Form; //var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]); //var isAddressSortable = Convert.ToBoolean(Request["bSortable_2"]); //var isTownSortable = Convert.ToBoolean(Request["bSortable_3"]); var Draw = Request.Form.GetValues("draw").FirstOrDefault(); var Start = Request.Form.GetValues("start").FirstOrDefault(); var Length = Request.Form.GetValues("length").FirstOrDefault(); var SortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); var SortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); // SEARCH INPUTS var SearchInput = new String[Model.GetSize() + 1]; for (int i = 0; i < Model.GetSize() - 1; i++) { SearchInput[i] = Request.Form.GetValues("columns[" + i.ToString() + "][search][value]").FirstOrDefault(); } SearchInput[Model.GetSize()] = Request.Form.GetValues("search[value]").FirstOrDefault(); /* * var PartNo = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault(); * var Spec = Request.Form.GetValues("columns[1][search][value]").FirstOrDefault(); * var Desc = Request.Form.GetValues("columns[2][search][value]").FirstOrDefault(); * //var Date = Request.Form.GetValues("columns[3][search][value]").FirstOrDefault(); * var Global = Request.Form.GetValues("search[value]").FirstOrDefault(); */ int PageSize = Length != null?Convert.ToInt32(Length) : 0; int Skip = Start != null?Convert.ToInt32(Start) : 0; int TotalRecords = 4; //Model.Data.Count(); List <ItemMasterModel> Models; using (var entities = new ApplicationDbContext()) { Models = entities.ItemMasters.Select(X => X).ToList(); foreach (var model in Models) { var cell = new Cell(Model.ColumnNames); cell.SetCellInfo(Model.ColumnNames[0], model.PartNumber); cell.SetCellInfo(Model.ColumnNames[1], model.Specification); cell.SetCellInfo(Model.ColumnNames[2], model.Description); Model.AddCell(cell); } } /* * var Items = (from a in Models * .Where(x => * (x.Description.ToLower().Contains(Desc.ToLower()) && x.Specification.ToLower().Contains(Spec.ToLower()) && * x.PartNumber.ToLower().Contains(PartNo.ToLower()) && ContainsTime(x.CreatedDate, "")) && //Date * * (x.Description.ToLower().Contains(Global.ToLower()) || x.Specification.ToLower().Contains(Global.ToLower()) || * x.PartNumber.ToLower().Contains(Global.ToLower()))) * * * .Take(4000) * select new ItemMasterModel * { * PartNumber = a.PartNumber.Trim(), * Specification = a.Specification.Trim(), * Description = a.Description.Trim(), * CreatedDate = a.CreatedDate * }); * * * * * * * * if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir))) * { //Items = Items.OrderBy(SortColumn + " " + SortColumnDir); * * switch (SortColumn) * { * case "PartNumber": * if (SortColumnDir != "asc") { Items = Items.OrderByDescending(m => m.PartNumber);} * else { Items = Items.OrderBy(m => m.PartNumber); } * break; * case "Specification": * if (SortColumnDir != "asc") { Items = Items.OrderByDescending(m => m.Specification); } * else { Items = Items.OrderBy(m => m.Specification); } * break; * case "Description": * if (SortColumnDir != "asc") { Items = Items.OrderByDescending(m => m.Description); } * else { Items = Items.OrderBy(m => m.Description); } * break; * case "CreatedDate": * if (SortColumnDir != "asc") { Items = Items.OrderByDescending(m => m.CreatedDate); } * else { Items = Items.OrderBy(m => m.CreatedDate); } * break; * default: * Items = Items.OrderBy(m => m.PartNumber); * break; * } * * } * * TotalRecords = Items.ToList().Count(); * var NewItems = Items.Skip(Skip).Take(PageSize).ToList(); */ //List<Cell> NewItems = Model.Data; return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = Model.Data }, JsonRequestBehavior.AllowGet)); }