// GET: VenueSchedules
public ActionResult Index()
{
VenueSchedule myModel = new VenueSchedule();
if (TempData["model"] != null)
{
myModel = (VenueSchedule)TempData["model"];
TempData.Remove("model");
}
return(View(myModel));
}
public ActionResult PageData(IDataTablesRequest request)
{
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
// Nothing important here. Just creates some mock data.
var data = VenueSchedule.GetData();
//This code is for joining if we want to show information of the Vehicle instead of the ID
var venues = db.Venues.ToList();
var buildings = db.Buildings.ToList();
var newData = (from s in data
join v in venues on s.VenueID equals v.VenueID
join b in buildings on s.BuildingID equals b.BuildingID
select new
{
ScheduleID = s.ScheduleID,
Date = s.DateAvailable,
StartTime = s.StartTime,
EndTime = s.EndTime,
Status = s.Status,
Name = v.Name,
BuildingName = b.Name,
}).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.Name.ToUpper().Contains(request.Search.Value.ToUpper()) ||
_item.BuildingName.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));
}
// GET: AddVenueSchedule
public ActionResult Index(string venueID)
{
var db = new CodeFirst.CodeFirst();
if (venueID != null)
{
VenueSchedule mySchedule = new VenueSchedule();
var intVenueID = Int32.Parse(venueID);
mySchedule.VenueID = int.Parse(venueID);
GlobalBuildingID = db.Venues.Where(d => d.VenueID == intVenueID).FirstOrDefault().BuildingID;
mySchedule.BuildingID = GlobalBuildingID;
return(View(mySchedule));
}
return(View());
}
