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);
}
