예제 #1
0
        // GET: /Device/
        public ActionResult Index(string err = null)
        {
            ViewBag.Error = err;
            ViewBag.Functions = new SelectList(new SelectListItem[] {
                    new SelectListItem() { Text = "Prepare Tasker File", Value = funcPrepareTaskerFile.ToString() },
                    new SelectListItem() { Text = "Coming soon", Value = "2" }
            }, "Value", "Text");

            var model = new DeviceSelectionViewModel();
            var items =
                from d in db.Devices
                //join r in db.Requests on d.ID equals r.DeviceID into dr
                //join l in db.DeviceLogs on d.ID equals l.DeviceID into dl
                select new SelectDeviceEditorViewModel
                {
                    ID = d.ID,
                    AndriodVer = d.AndriodVer,
                    CreationDate = d.CreationDate,
                    CustomerID = d.CustomerID,
                    ModelNo = d.ModelNo,
                    DeviceCode = d.DeviceCode,
                    DeviceType = d.DeviceType,
                    TaskerVersion = d.TaskerVersion,
                    TodayNetworkConnectivity = d.TodayNetworkConnectivity,
                    Last30DaysNetworkConnectivity = d.Last30DaysNetworkConnectivity,
                    LastRequestID = d.LastRequestId,
                    LastRequestDate = d.LastRequestTime,
                    LastLogID = d.LastLogId,
                    LastLogDate = d.LastLogTime,
                    LastRunMinute = d.LastRunMinute,
                    TodayShowRate = d.TodayShowRate,
                    LastRunIndex = d.LastRunIndex,
                    LastCommandIssued = d.LastCommandIssued,
                    LastCommandIssueTime = d.LastCommandIssueTime,
                    LastCommandExecuted = d.LastCommandExecuted,
                    LastCommandExecuteTime = d.LastCommandExecuteTime,
                    //Status = (Device.DeviceStatus)d.Status, // d.GetStatus(), //.HasValue? (Device.DeviceStatus)d.Status.Value: Device.DeviceStatus.Unknown,

                    Selected = true
                    //LastRequest = dr.OrderByDescending(r => r.ID).Take(1).FirstOrDefault(),
                    //LastLog = dl.OrderByDescending(r => r.ID).Take(1).FirstOrDefault()
                };

            foreach(var item in items)
                model.Devices.Add(item);

            ////var items = db.Devices
            ////    .Join(db.DeviceLogs, d => d.ID, l => l.DeviceID, (d, l) => new {device = d, log = l}) //.OrderBy(d => d.device.ID).ThenByDescending(d => d.log.ID)
            ////    .Join(db.Requests, d => d.device.ID, r => r.DeviceID, (d, r) => new {device = d.device, log = d.log, req = r})
            ////    .OrderBy(d => d.device.ID)
            ////    .ThenByDescending(d => d.req.ID)
            ////    .ThenByDescending(d => d.log.ID);
            ////var devices =
            ////    from d in db.Devices
            ////    join r in db.Requests on d.ID equals r.DeviceID into dr
            ////    join l in db.DeviceLogs on d.ID equals l.DeviceID into dl
            ////    orderby d.ID
            ////    orderby r. descending
            ////    select new { Devices = d, Requests = dr, Logs = dl};
            ////foreach (var device in db.Devices.Include(d => d.Requests.OrderByDescending(o => o.ID).Take(10)).Include(d => d.DeviceLogs.OrderByDescending(l => l.ID).Take(10)))
            //foreach (var item in items) // (var device in db.Devices.Include(d => d.Requests.Where(dw => DateTime.Now.Subtract(dw.RequestDate).TotalDays ).Include(d => d.DeviceLogs))
            //{
            //    var editorViewModel = new SelectDeviceEditorViewModel()
            //    {
            //        ID = item.Device.ID,
            //        AndriodVer = item.Device.AndriodVer,
            //        CreationDate = item.Device.CreationDate,
            //        CustomerID = item.Device.CustomerID,
            //        DeviceID = item.Device.DeviceID,
            //        DeviceType = item.Device.DeviceType,
            //        ModelNo = item.Device.ModelNo,
            //        LastRequestDate = item.LastRequest == null? (DateTime?)null: item.LastRequest.RequestDate,
            //        LastRequestID = item.LastRequest == null ? (long?)null : item.LastRequest.ID,
            //        LastLogDate = item.LastLog == null ? (DateTime?)null : item.LastLog.CreationDate,
            //        LastLogID = item.LastLog == null ? (long?)null : item.LastLog.ID,

            //        //ID = device.ID,
            //        //AndriodVer = device.AndriodVer,
            //        //CreationDate = device.CreationDate,
            //        //CustomerID = device.CustomerID,
            //        //DeviceID = device.DeviceID,
            //        //DeviceType = device.DeviceType,
            //        //ModelNo = device.ModelNo,
            //        Selected = true
            //    };
            //    //if (device.Requests != null && device.Requests.Count > 0)
            //    //{
            //    //    var lastReq = device.Requests.OrderByDescending(o => o.ID).First();
            //    //    editorViewModel.LastRequestDate = lastReq.RequestDate;
            //    //    editorViewModel.LastRequestID = lastReq.ID;
            //    //}
            //    //if (device.DeviceLogs != null && device.DeviceLogs.Count > 0)
            //    //{
            //    //    var lastRLog = device.DeviceLogs.OrderByDescending(o => o.ID).First();
            //    //    editorViewModel.LastLogDate = lastRLog.CreationDate;
            //    //    editorViewModel.LastLogID = lastRLog.ID;
            //    //}
            //    model.Devices.Add(editorViewModel);
            //}
            //return View(model);
            return View(model);
        }
예제 #2
0
        public ActionResult Index(int? page)
        {
            ttTVMS.Models.MessageViewModel viewModel = new MessageViewModel();
            int pageSize = 20;
            int pageNumber = (page ?? 1);

            var messages = db.Messages.OrderByDescending(r => r.ID);

            List<SelectListItem> selectItems = new List<SelectListItem>();
            Array msgConstants = Enum.GetValues(typeof(MessageContants));
            Array.Sort(msgConstants);
            foreach (int msg in msgConstants)
            {
                selectItems.Add(new SelectListItem() { Text = Enum.GetName(typeof(MessageContants), msg), Value = msg.ToString() });
            }

            ViewBag.Functions = new SelectList(selectItems.ToArray(), "Value", "Text");

            var model = new DeviceSelectionViewModel();
            var items =
                from d in db.Devices
                    select d;
                //join r in db.Requests on d.ID equals r.DeviceID into dr
                //join l in db.DeviceLogs on d.ID equals l.DeviceID into dl
                //select new
                //{
                //    Device = d,
                //    LastRequest = dr.OrderByDescending(r => r.ID).Take(1).FirstOrDefault(),
                //    LastLog = dl.OrderByDescending(r => r.ID).Take(1).FirstOrDefault()
                //};

            foreach (var item in items) // (var device in db.Devices.Include(d => d.Requests.Where(dw => DateTime.Now.Subtract(dw.RequestDate).TotalDays ).Include(d => d.DeviceLogs))
            {
                var editorViewModel = new SelectDeviceEditorViewModel()
                {
                    ID = item.ID, // item.Device.ID,
                    AndriodVer = item.AndriodVer, // .Device.AndriodVer,
                    CreationDate = item.CreationDate, // .Device.CreationDate,
                    CustomerID = item.CustomerID, // .Device.CustomerID,
                    DeviceCode = item.DeviceCode, // .Device.DeviceCode,
                    DeviceType = item.DeviceType, // .Device.DeviceType,
                    ModelNo = item.ModelNo, // .Device.ModelNo,
                    LastRequestDate = item.LastRequestTime, // item.LastRequest == null ? (DateTime?)null : item.LastRequest.RequestDate,
                    LastRequestID = item.LastRequestId, // item.LastRequest == null ? (long?)null : item.LastRequest.ID,
                    LastLogDate = item.LastLogTime, // item.LastLog == null ? (DateTime?)null : item.LastLog.CreationDate,
                    LastLogID = item.LastLogId, // item.LastLog == null ? (long?)null : item.LastLog.ID,

                    Selected = item.DeviceType != 1
                };
                model.Devices.Add(editorViewModel);
            }
            viewModel.Devices = model;
            viewModel.Messages = messages.ToPagedList(pageNumber, pageSize);

            return View(viewModel);
        }
예제 #3
0
        public ActionResult Execute(DeviceSelectionViewModel model)
        {
            string err = null;
            // get the ids of the items selected:
            List<long> selectedIds = model.getSelectedIds();

            // Use the ids to retrieve the records for the selected people
            // from the database:
            var selectedDevices = from x in db.Devices
                                  where selectedIds.Contains(x.ID)
                                  select x;

            switch(model.SelectedFunction)
            {
                case funcPrepareTaskerFile:
                    err = CreateDeviceTemplate(selectedDevices);
                    break;
            }

            return RedirectToAction("Index", new { err = err });
        }