public ActionResult Index() { int CurrentUserId = WebMatrix.WebData.WebSecurity.CurrentUserId; string userName = WebMatrix.WebData.WebSecurity.CurrentUserName; int? groupId = userProfileService.userProfileResponsitory.Single(CurrentUserId).Group_Id; if (userName == "administrator") { ViewBag.listSite = sitesService.sitesResponsitory.GetAll().ToList(); } else { ViewBag.listSite = sitesService.GetBygroupId(groupId).ToList(); } ViewBag.lstBieuDo = observationService.observationResponsitory.GetAll().ToList(); HomeModel model = new HomeModel(); List<Site> sitesInGroup = sitesService.GetBygroupId(groupId).ToList(); model.ThietBiHoatDong = sitesInGroup.Where(i => i.IsActive == true).Count(); model.ThietBiKhongHoatDong = sitesInGroup.Where(i => i.IsActive == false).Count(); ViewBag.listArea = areasService.GetAreasByGroupId(groupId).ToList(); return View(model); }
public ActionResult Update(int id = 0) { CMSHelper help = new CMSHelper(); @ViewBag.Title = ""; @ViewBag.MessageStatus = TempData["MessageStatus"]; @ViewBag.Message = TempData["Message"]; int CurrentUserId = WebMatrix.WebData.WebSecurity.CurrentUserId; string userName = User.Identity.Name; List <Site> sites = new List <Site>(); List <Group> groups = new List <Group>(); if (userName == "administrator") { groups = groupService.groupResponsitory.GetAll().ToList(); sites = sitesService.sitesResponsitory.GetAll().ToList(); } else { int groupId = userProfileService.userProfileResponsitory.Single(CurrentUserId).Group_Id.Value; Group group = groupService.groupResponsitory.Single(groupId); sites = sitesService.GetBygroupId(groupId).ToList(); groups.Add(group); } RegisterSMS pts = registerSMSService.registerResponsitory.Single(id); if (pts == null) { return(RedirectToAction("index")); } ViewBag.listGroup = groups; ViewBag.listObservation = observationService.observationResponsitory.GetAll(); ViewBag.listSite = sites; ViewBag.listSmsServer = sMSServerService.smsServerResponsitory.GetAll(); RegisterSMSModel model = pts.ToModel(); return(View(model)); }
/// <summary> /// Báo cáo thường ngày /// </summary> /// <param name="day"></param> /// <param name="areaId"></param> /// <param name="deviceId"></param> /// <returns></returns> public ActionResult Daily(string Date = "", int?areaId = null, int?deviceId = null, int?groupId = null) { ViewBag.Title = ""; ViewBag.MessageStatus = TempData["MessageStatus"]; ViewBag.Message = TempData["Message"]; int CurrentUserId = WebMatrix.WebData.WebSecurity.CurrentUserId; string userName = User.Identity.Name; groupId = userProfileService.userProfileResponsitory.Single(CurrentUserId).Group_Id; if (userName == "administrator") { ViewBag.listSite = sitesService.sitesResponsitory.GetAll().ToList(); ViewBag.listGroups = groupService.groupResponsitory.GetAll().ToList(); ViewBag.listArea = areasService.areaResponsitory.GetAll().ToList(); } else { ViewBag.listGroups = groupService.GetGroups(groupId).ToList(); ViewBag.listArea = areasService.GetAreasByGroupId(groupId).ToList(); ViewBag.listSite = sitesService.GetBygroupId(groupId).ToList(); } DateTime date = DateTime.Today; if (Date != "") { try { date = Convert.ToDateTime(Date); } catch { } } ReportType rp0 = reportTypeService.GetByCode("RP0").FirstOrDefault(); ReportType rp1 = reportTypeService.GetByCode("RP1").FirstOrDefault(); ReportType rp2 = reportTypeService.GetByCode("RP2").FirstOrDefault(); ReportType rp3 = reportTypeService.GetByCode("RP3").FirstOrDefault(); ReportType rp4 = reportTypeService.GetByCode("RP4").FirstOrDefault(); ReportType rp5 = reportTypeService.GetByCode("RP5").FirstOrDefault(); ReportType rp6 = reportTypeService.GetByCode("RP6").FirstOrDefault(); Report_NhietDo_DoAm_ApSuat_DailyModel nhietDo = reportDailyNhietDoService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_NhietDo_DoAm_ApSuat_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, MinValue = s.MaxValue, MaxValue = s.MinValue, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp0.Measure, ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp0.Description, Title = rp0.Title }).FirstOrDefault(); Report_NhietDo_DoAm_ApSuat_DailyModel doAm = reportDailyDoAmService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_NhietDo_DoAm_ApSuat_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, MinValue = s.MaxValue, MaxValue = s.MinValue, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp1.Measure, ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp1.Description, Title = rp1.Title }).FirstOrDefault(); Report_NhietDo_DoAm_ApSuat_DailyModel apSuat = reportDailyApSuatService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_NhietDo_DoAm_ApSuat_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, MinValue = s.MaxValue, MaxValue = s.MinValue, Measure = rp2.Measure, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Title = rp2.Title, ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp2.Description, }).FirstOrDefault(); Report_MucNuoc_DailyModel mucNuoc = reportDailyMucNuocService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_MucNuoc_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp5.Measure, ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp5.Description, Title = rp5.Title }).FirstOrDefault(); Report_LuongMuc_DailyModel luongMua = reportDailyLuongMuaService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_LuongMuc_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp3.Measure, TongLuongMua = CheckValueReport(s.TongLuongMua, s.ReportTypeCode), ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp3.Description, Title = rp3.Title }).FirstOrDefault(); Report_TocDoGio_DailyModel tocDoGio = reportDailyTocDoGioService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_TocDoGio_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp6.Measure, HuongGioCuaTocDoLonNhat = s.HuongGioCuaTocDoLonNhat, HuongGioCuarTocDoNhoNhat = s.HuongGioCuarTocDoNhoNhat, TocDoGioLonNhat = s.TocDoGioLonNhat, TocDoGioNhoNhat = s.TocDoGioNhoNhat, ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp6.Description, Title = rp6.Title }).FirstOrDefault(); Report_HuongGio_DailyModel huongGio = reportDailyHuongGioService.GetByDeviceIdAndDate(date, deviceId).AsEnumerable().Select(s => new Report_HuongGio_DailyModel { Distance1 = s.Distance1, Distance2 = s.Distance2, Distance3 = s.Distance3, Distance4 = s.Distance4, Distance5 = s.Distance5, Distance6 = s.Distance6, Distance7 = s.Distance7, Distance8 = s.Distance8, Distance9 = s.Distance9, Distance10 = s.Distance10, Distance11 = s.Distance11, Distance12 = s.Distance12, Distance13 = s.Distance13, Distance14 = s.Distance14, Distance15 = s.Distance15, Distance16 = s.Distance16, Distance17 = s.Distance17, Distance18 = s.Distance18, Distance19 = s.Distance19, Distance20 = s.Distance20, Distance21 = s.Distance21, Distance22 = s.Distance22, Distance23 = s.Distance23, Distance24 = s.Distance24, TimeMaxValue = s.TimeMaxValue, TimeMinValue = s.TimeMinValue, Measure = rp4.Measure, HuongGioDacTrungNhieuNhat = GetTenHuongGio(s.HuongGioDacTrungNhieuNhat), HuongGioDacTrungNhieuThuHai = GetTenHuongGio(s.HuongGioDacTrungNhieuThuHai), ReportTypeCode = s.ReportTypeCode.Trim(), ReportTypeName = rp4.Description, Title = rp4.Title }).FirstOrDefault(); ReportDailyViewModel viewModel = new ReportDailyViewModel { Date = date, NhietDo = nhietDo, DoAm = doAm, ApSuat = apSuat, MucNuoc = mucNuoc, LuongMua = luongMua, DeviceId = deviceId, TocDoGio = tocDoGio, HuongGio = huongGio, AreaId = areaId, GroupId = groupId }; return(View(viewModel)); }
public ActionResult Management(int page = 1, int pageSize = 50, string title = "", int?areaId = null, string fromDate = "", string toDate = "", int?siteID = null) { 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(); string userName = User.Identity.Name; int skip = (page - 1) * pageSize; DateTime from = DateTime.Today; DateTime to = from.AddDays(1); if (fromDate != "") { try { from = Convert.ToDateTime(fromDate); to = Convert.ToDateTime(toDate); } catch { } } List <DataObservationModel> list = new List <DataObservationModel>(); int totalRows = 0; if (siteID.HasValue) { int deviceId = sitesService.sitesResponsitory.Single(siteID).DeviceId.Value; list = dataObservationMongoService.GetDataPagingByDeviceId(from, to, deviceId, skip, pageSize, out int total).OrderByDescending(i => i.DateCreate).Select(x => new DataObservationModel { BTI = x.BTI, BTO = x.BTO, BHU = x.BHU, BWS = x.BWS, BAP = x.BAP, BAV = x.BAV, BAC = x.BAC, BAF = x.BAF, NameSite = sitesService.sitesResponsitory.GetAll().Where(i => i.DeviceId == x.Device_Id).FirstOrDefault().Name, DateCreate = x.DateCreate }).ToList(); totalRows = total; } else { list = dataObservationMongoService.GetDataPaging(from, to, skip, pageSize, out int total).OrderByDescending(i => i.DateCreate).Select(x => new DataObservationModel { BTI = x.BTI, BTO = x.BTO, BHU = x.BHU, BWS = x.BWS, BAP = x.BAP, BAV = x.BAV, BAC = x.BAC, BAF = x.BAF, NameSite = sitesService.sitesResponsitory.GetAll().Where(i => i.DeviceId == x.Device_Id).FirstOrDefault().Name, DateCreate = x.DateCreate }).ToList(); totalRows = total; } #region Hiển thị dữ liệu và phân trang DataObservationViewModel viewModel = new DataObservationViewModel { DataO = new StaticPagedList <DataObservationModel>(list, page, pageSize, totalRows), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = pageSize, TotalItems = totalRows }, From = from, To = to, }; #endregion return(View(viewModel)); }