public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DeviceData _model = db.DeviceDatas.Find(id); var _viewModel = DeviceDataViewModel.GetViewModelDatas(_model); if (_model == null) { return(HttpNotFound()); } ViewBag.DeviceID = new SelectList(db.Devices, "DeviceID", "InventoryNumber", _model.DeviceID); return(View(_viewModel)); }
// GET: DeviceDatas public ActionResult Index(string searchString, int?page) { #region Default Code //var deviceDatas = db.DeviceDatas.Include(d => d.Device); //return View(deviceDatas.ToList()); #endregion End of Default Code #region List //var _model = db.DeviceDatas.Include(d => d.Device); //var _viewModel = new List<DeviceDataViewModel>(); //foreach (var item in _model) //{ // _viewModel.Add(DeviceDataViewModel.GetViewModelDatas(item)); //} //return View(_viewModel); #endregion // end of List #region LINQ Expression //var qData = from q in db.Devices.Include(d => d.DeviceDocument) select q; var qData = (from q in db.DeviceDatas.Include(d => d.Device) select q).OrderBy(s => s.DeviceID).Skip(0); if (!string.IsNullOrEmpty(searchString)) { qData = qData.Where(s => s.Device.InventoryNumber.Contains(searchString)); } int pageSize = 8; int pageNumber = (page ?? 1); var _viewModel = new List <DeviceDataViewModel>(); foreach (var item in qData) { _viewModel.Add(DeviceDataViewModel.GetViewModelDatas(item)); } return(View("Index", _viewModel.ToPagedList(pageNumber, pageSize))); //return View(_listViewModel.ToPagedList(pageNumber, pageSize)); #endregion // end of LINQ Expression }