public ActionResult GetAreasByGroupId(int idGroup)
{
List <Area> areas = new List <Area>();
areas = areasService.GetAreasByGroupId(idGroup).ToList();
return(PartialView("_AreasPartialView", areas));
}
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);
}
/// <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));
}
