// GET: EquipmentSchedule
public ActionResult Index()
{
EquipmentSchedule myModel = new EquipmentSchedule();
if (TempData["model"] != null)
{
myModel = (EquipmentSchedule)TempData["model"];
TempData.Remove("model");
}
return(View(myModel));
}
// GET: AddEquipmentSchedule
public ActionResult Index(string equipmentID)
{
if (equipmentID != null)
{
EquipmentSchedule mySchedule = new EquipmentSchedule();
mySchedule.EquipmentID = int.Parse(equipmentID);
return(View(mySchedule));
}
return(View());
}
public ActionResult PageData(IDataTablesRequest request)
{
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
// Nothing important here. Just creates some mock data.
var data = EquipmentSchedule.GetData();
//This code is for joining if we want to show information of the Vehicle instead of the ID
var Equipments = db.Equipments.ToList();
var newData = (from s in data
join e in Equipments on s.EquipmentID equals e.EquipmentID
select new
{
ScheduleID = s.LineID,
Date = s.Date,
StartTime = s.TimeStart,
EndTime = s.TimeEnd,
Status = s.Status,
ManufacturerName = e.ManufacturerName,
Model = e.ModelNumber
}).ToList();
// Global filtering.
// Filter is being manually applied due to in-memmory (IEnumerable) data.
// If you want something rather easier, check IEnumerableExtensions Sample.
var filteredData = newData.Where(_item =>
_item.ScheduleID.ToString().Contains(request.Search.Value) ||
_item.Date.ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.StartTime.ToString().ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.EndTime.ToString().ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.Status.ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.ManufacturerName.ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.Model.ToUpper().Contains(request.Search.Value.ToUpper())
);
// Paging filtered data.
// Paging is rather manual due to in-memmory (IEnumerable) data.
var dataPage = filteredData.Skip(request.Start).Take(request.Length);
// Response creation. To create your response you need to reference your request, to avoid
// request/response tampering and to ensure response will be correctly created.
var response = DataTablesResponse.Create(request, data.Count(), filteredData.Count(), dataPage);
// Easier way is to return a new 'DataTablesJsonResult', which will automatically convert your
// response to a json-compatible content, so DataTables can read it when received.
return(new DataTablesJsonResult(response, JsonRequestBehavior.AllowGet));
}
