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