public static double Total(Models.Entity.Data data, string code, double input) { if (code == "RP0") { input += data.BTI; } else if (code == "RP1") { input += data.BHU; } else if (code == "RP2") { input += data.BAV; } else if (code == "RP3") { input += data.BAC; } else if (code == "RP4") { input += data.BAP; } else if (code == "RP5") { input += data.BAF; } else if (code == "RP6") { input += data.BWS; } return(input); }
public ActionResult GetDataTable() { DateTime from = DateTime.Today; DateTime to = DateTime.Now; int CurrentUserId = WebMatrix.WebData.WebSecurity.CurrentUserId; string userName = User.Identity.Name; List<Site> sites = new List<Site>(); List<DataObservationModel> list = new List<DataObservationModel>(); if (userName == "administrator") { sites = sitesService.sitesResponsitory.GetAll().ToList(); foreach (var site in sites) { if (site.DeviceId.HasValue) { Models.Entity.Data data = dataObservationMongoService.GetDataPagingByDeviceId(from, to, site.DeviceId.Value, 0, 1, out int total).FirstOrDefault(); if (data != null) { DataObservationModel model = data.ToModel(); model.NameSite = site.Name; list.Add(model); } } } } else { int? groupId = userProfileService.userProfileResponsitory.Single(CurrentUserId).Group_Id; sites = sitesService.GetBygroupId(groupId).ToList(); foreach (var site in sites) { Models.Entity.Data data = dataObservationMongoService.GetDataPagingByDeviceId(from, to, site.DeviceId.Value, 0, 1, out int total).FirstOrDefault(); if (data != null) { DataObservationModel model = data.ToModel(); model.NameSite = site.Name; list.Add(model); } } } return PartialView("_DataTablePartialView", list); }
public static DataObservationModel ToModel(this Models.Entity.Data entity) { return(new DataObservationModel() { DateCreate = entity.DateCreate, BTI = entity.BTI, BTO = entity.BTO, BHU = entity.BHU, BWS = entity.BWS, BAP = entity.BAP, BAV = entity.BAV, BAF = entity.BAF, BAC = entity.BAC, BA1 = entity.BA1, BA2 = entity.BA2, BA3 = entity.BA3, BA4 = entity.BA4, BB1 = entity.BB1, BB2 = entity.BB2, BB3 = entity.BB3, BB4 = entity.BB4, BC1 = entity.BC1, BC2 = entity.BC2, BDR = entity.BDR, BFA = entity.BFA, BFD = entity.BFD, BFL = entity.BFL, BFR = entity.BFR, BPS = entity.BPS, BPW = entity.BPW, BSE = entity.BSE, BT1 = entity.BT1, BT2 = entity.BT2, BV1 = entity.BV1, BV2 = entity.BV2, Device_Id = entity.Device_Id, IsSEQ = entity.IsSEQ }); }
public ActionResult Management(int page = 1, int pageSize = 50, string title = "", int? areaId = null, int? siteId = null, string fromDate = "", string toDate = "") { ViewBag.Title = ""; ViewBag.MessageStatus = TempData["MessageStatus"]; ViewBag.Message = TempData["Message"]; if (pageSize == 1) { pageSize = CMSHelper.pageSizes[0]; } @ViewBag.PageSizes = CMSHelper.pageSizes; int CurrentUserId = WebMatrix.WebData.WebSecurity.CurrentUserId; int? groupId = userProfileService.userProfileResponsitory.Single(CurrentUserId).Group_Id; ViewBag.lstTram = sitesService.GetBygroupId(groupId).ToList(); ViewBag.lstArea = areasService.GetAreasByGroupId(groupId).ToList(); string userName = User.Identity.Name; int skip = (page - 1) * pageSize; DateTime from = DateTime.Today; DateTime to = DateTime.Now; if (fromDate != "" && toDate != null) { try { from = Convert.ToDateTime(fromDate); to = from.AddDays(1); } catch { } } List<Site> sites = new List<Site>(); List<DataObservationModel> list = new List<DataObservationModel>(); if (userName == "administrator") { sites = sitesService.sitesResponsitory.GetAll().ToList(); foreach (var site in sites) { if (site.DeviceId.HasValue) { Models.Entity.Data data = dataObservationMongoService.GetDataPagingByDeviceId(from, to, site.DeviceId.Value, 0, 1, out int total).FirstOrDefault(); if (data != null) { DataObservationModel model = data.ToModel(); model.NameSite = site.Name; list.Add(model); } } } } else { if (siteId.HasValue) { var tram = sitesService.sitesResponsitory.Single(siteId); list = dataObservationMongoService.GetDataPagingByDeviceId(from, to, tram.DeviceId.Value, skip, pageSize, out int total).Select(item => new DataObservationModel { DateCreate = item.DateCreate, BTI = item.BTI, BTO = item.BTO, BHU = item.BHU, BWS = item.BWS, BAP = item.BAP, BAV = item.BAV, BAF = item.BAF, BAC = item.BAC, BA1 = item.BA1, BA2 = item.BA2, BA3 = item.BA3, BA4 = item.BA4, BB1 = item.BB1, BB2 = item.BB2, BB3 = item.BB3, BB4 = item.BB4, BC1 = item.BC1, BC2 = item.BC2, BDR = item.BDR, BFA = item.BFA, BFD = item.BFD, BFL = item.BFL, BFR = item.BFR, BPS = item.BPS, BPW = item.BPW, BSE = item.BSE, BT1 = item.BT1, BT2 = item.BT2, BV1 = item.BV1, BV2 = item.BV2, Device_Id = item.Device_Id, IsSEQ = item.IsSEQ, NameSite = tram.Name }).ToList(); } else { sites = sitesService.GetBygroupId(groupId).ToList(); foreach (var site in sites) { Models.Entity.Data data = dataObservationMongoService.GetDataPagingByDeviceId(from, to, site.DeviceId.Value, 0, 1, out int total).FirstOrDefault(); if (data != null) { DataObservationModel model = data.ToModel(); model.NameSite = site.Name; list.Add(model); } } } } #region Hiển thị dữ liệu và phân trang DataObservationViewModel viewModel = new DataObservationViewModel { DataO = new StaticPagedList<DataObservationModel>(list, page, pageSize, list.Count()), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = pageSize, TotalItems = list.Count() }, From = from, To = to, }; #endregion return View(viewModel); }