private DashboardViewModels CreateDashboard_Pack83ViewModel(Models.Message deviceMessage) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessage.DeviceId; dashboard.Name = deviceMessage.Device.Name; dashboard.Package = deviceMessage.Data; dashboard.TypePackage = deviceMessage.TypePackage; dashboard.Date = deviceMessage.Date; dashboard.Country = deviceMessage.Country; dashboard.Lqi = deviceMessage.Lqi; dashboard.Bits = deviceMessage.Bits; // set location on dashboard of device // DeviceLocation deviceLocation = GetDeviceLocationByDeviceId(dashboard.DeviceId); // if (deviceLocation != null) // { // dashboard.Latitude = deviceLocation.Latitude.ToString(); // dashboard.Longitude = deviceLocation.Longitude.ToString(); // dashboard.Radius = deviceLocation.Radius; // dashboard.LatitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Latitude, "S"); // dashboard.LongitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Longitude, "W"); // dashboard.RadiusConverted = RadiusFormated(deviceLocation.Radius); // } dashboard.Vazao = deviceMessage.Vazao; dashboard.TotalizacaoParcial = deviceMessage.TotalizacaoParcial; dashboard.Totalizacao = deviceMessage.Totalizacao; dashboard.TempoParcial = deviceMessage.TempoParcial; return(dashboard); }
// GET: ~/ public async Task <ActionResult> Index() { DashboardViewModels dashboard = new DashboardViewModels(); using (UrnDbContext db = new UrnDbContext()) { dashboard.CompleteWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Completed" && urn.CompletedBy == HttpContext.User.Identity.Name). AsNoTracking().CountAsync(); dashboard.ShippedWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Shipped" && urn.CompletedBy == HttpContext.User.Identity.Name) .AsNoTracking().CountAsync(); dashboard.TotalWorkOrders = await db.UrnForms.AsNoTracking().CountAsync(); dashboard.AllQueuedWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Queued") .AsNoTracking().CountAsync(); dashboard.AllCompletedWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Completed") .AsNoTracking().CountAsync(); dashboard.AllIncompleteWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Incomplete") .AsNoTracking().CountAsync(); dashboard.AllShippedWorkOrders = await db.UrnForms.Where(urn => urn.Status == "Shipped") .AsNoTracking().CountAsync(); dashboard.AllBackOrders = await db.UrnForms.Where(urn => urn.Status == "Backorder") .AsNoTracking().CountAsync(); } return(View(dashboard)); }
private DashboardViewModels CreateDashboard_Pack23ViewModel(Models.Message deviceMessage) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessage.DeviceId; dashboard.Name = deviceMessage.Device.Name; dashboard.Package = deviceMessage.Data; dashboard.TypePackage = deviceMessage.TypePackage; dashboard.Date = deviceMessage.Date; dashboard.Country = deviceMessage.Country; dashboard.Lqi = deviceMessage.Lqi; dashboard.Bits = deviceMessage.Bits; dashboard.SeqNumber = deviceMessage.SeqNumber; var _fluxoAgua = FromFloatSafe(deviceMessage.FluxoAgua); var _consumoAgua = FromFloatSafe(deviceMessage.ConsumoAgua); dashboard.FluxoAgua = String.Format("{0:0.0}", _fluxoAgua); dashboard.ConsumoAgua = String.Format("{0:0.0}", _consumoAgua); var _display = Consts.GetDisplayTRM10(dashboard.Bits.BAlertaMax, dashboard.Bits.ModoFechado, dashboard.Bits.ModoAberto); dashboard.Modo = _display.DisplayModo; // modo dashboard.Estado = _display.DisplayEstado; // alerta dashboard.EstadoImage = _display.EstadoImage; dashboard.ModoImage = _display.ModoImage; dashboard.Valvula = _display.DisplayValvula; dashboard.EstadoColor = _display.EstadoColor; return(dashboard); }
public ActionResult Index() { DashboardViewModels model = new DashboardViewModels(); DateTime dtToday = DateTime.UtcNow.Date; DateTime dtYesterday = DateTime.UtcNow.Date.AddDays(-1); int userId = HttpContext.User.Identity.GetUserId <int>(); var userRole = this._userService.GetUserRoleById(userId); model.BreakdownTodayCount = _breakDownService.GetBreakdownCounts(dtToday); model.BreakdownYesterDayCount = _breakDownService.GetBreakdownCounts(dtYesterday); model.PMOverDueCount = _pmServices.GetPMCounts(userId, 1); model.PMPendingCount = _pmServices.GetPMCounts(userId, 2); model.PMShutdownCount = _pmServices.GetPMCounts(userId, 5); model.BreakdownMonthPerCount = _breakDownService.CalcQOS(); model.WhatsNewNotes = this._userService.GetWhatsNewNotes(); model.ReleaseVersion = this._userService.GetVersion(); model.NewFormulationRequestCount = this._formulationRequestService.GetFormulationCount(userId, 1); model.RMRequestCount = this._formulationRequestService.GetFormulationCount(userId, 2); model.RMDispatchCount = this._formulationRequestService.GetFormulationCount(userId, 3); model.ReadyForTestingCount = this._formulationRequestService.GetFormulationCount(userId, 3); model.UserRole = userRole; return(View(model)); }
public IActionResult Dashboard() { var pedidos = pedidoRepository.ObterTodos(); DashboardViewModels DashboardViewModel = new DashboardViewModels(); foreach (var pedido in pedidos) { switch (pedido.Status) { case (uint)StatusPedido.APROVADO: DashboardViewModel.PedidosAprovados++; break; case (uint)StatusPedido.REPROVADO: DashboardViewModel.PedidosReprovados++; break; case (uint)StatusPedido.PENDENTE: DashboardViewModel.PedidosReprovados++; break; default: DashboardViewModel.PedidosPendentes++; DashboardViewModel.Pedido.Add(pedido); // deixar na lista de pedido pendente break; } } DashboardViewModel.NomeView = "Dashboard"; DashboardViewModel.UsuarioEmail = ObterUsuarioSession(); return(View()); }
public ActionResult Index(string Submit, DashboardViewModels model) { if (!string.IsNullOrEmpty(Submit)) { if (Submit.Equals("Excel_ReportBank")) { ExcelReportBank(model); } else if (Submit.Equals("Excel_ReportAccount")) { ExcelReportAccount(model); } else if (Submit.Equals("Excel_CashIn")) { ExcelReportCashIn(model); } else if (Submit.Equals("Excel_CashOut")) { ExcelReportCashOut(model); } } ViewBag.FilterBankList = common.ToSelectList(BankFacilityBusinessLogic.getInstance().getBankFacilityDDL(), "ID", "NAME", model.FilterReportBank); ViewBag.FilterAccountList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", model.FilterReportAccount); ViewBag.FilterCashInList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", model.FilterReportCashIn); ViewBag.FilterCashOutList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", model.FilterReportCashOut); return(View(model)); }
// GET: Dashboard public ActionResult Index() { var users = database.GetUsers(); var teams = tdatabase.GetTeams(); var roleStore = new RoleStore <IdentityRole>(); var roleMngr = new RoleManager <IdentityRole>(roleStore); var banks = bank.GetBankHolidays(); var vacations = CreateVacationList(); var vacationstates = vacationstate.GetVacationStates(); var actualUsermaxdays = maxdays(); var actualuservacations = actualUsermaxdays - actuservacations(); var roles = roleMngr.Roles.ToList(); DashboardViewModels dashboard = new DashboardViewModels() { Userlist = users, TeamList = teams, RoleList = roles, VacationList = vacations, VacationStateList = vacationstates, BankHollyDayList = banks, ActualUserMaxDays = actualUsermaxdays, ActUserVacation = Convert.ToInt32(actualuservacations) }; return(View(dashboard)); }
// GET: Dashboard public ActionResult Index() { var DbUsers = db.UserDetailsModel.ToList(); DashboardViewModels dashboardVM = new DashboardViewModels(); UserDetailsRepository UDR = new UserDetailsRepository(); dashboardVM.UserList = UDR.GetUsers(); TeamRepository TR = new TeamRepository(); dashboardVM.TeamList = TR.GetTeams(); List <IdentityRole> roles = db.Roles.ToList(); dashboardVM.RoleList = roles; VacationRepository vac = new VacationRepository(); BankHolidayRepository bank = new BankHolidayRepository(); CalendarViewModel calendar = new CalendarViewModel(); calendar.BankHolidayList = bank.GetBankHolidays(); calendar.VacationList = vac.GetVacations(); dashboardVM.Calendar = calendar; return(View(dashboardVM)); }
// GET: Admin/Dashboard public ActionResult Index() { DashboardViewModels dashboardViewModels = new DashboardViewModels(); try { dashboardViewModels.NewPaperAbstractCount = db.Makalah.Where(x => x.PaperAbstractStatus == Enums.EPaperAbstractStatus.Baru).Count(); dashboardViewModels.NewPaperAbstractEditCount = db.Makalah.Where(x => x.PaperAbstractStatus == Enums.EPaperAbstractStatus.Edit).Count(); dashboardViewModels.NewFullPaperCount = db.Makalah.Where(x => x.FullPaperStatus == Enums.EFullPaperStatus.Baru).Count(); dashboardViewModels.NewFullPaperEditCount = db.Makalah.Where(x => x.FullPaperStatus == Enums.EFullPaperStatus.Edit).Count(); var role = db.Roles.SingleOrDefault(m => m.Name == "Peserta"); dashboardViewModels.NewParticipantCount = db.Users.Where(m => m.Roles.All(r => r.RoleId == role.Id)).Count(); dashboardViewModels.NewParticipantPaymentConfirmationCount = db.Users.Where(x => x.ParticipantPaymentStatus == Enums.EParticipantPaymentStatus.KonfirmasiPembayaran).Count(); dashboardViewModels.NewPaperPaymentConfirmationCount = db.Makalah.Where(x => x.PaperPaymentStatus == Enums.EPaperPaymentStatus.KonfirmasiPembayaran).Count(); dashboardViewModels.NewMessagesCount = db.PesanPublikToAdmin.Where(x => x.DateAdminRead == null).Count(); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; } return(View(dashboardViewModels)); }
public ActionResult Dashboard(int?id, int?low) { //object of DashboardViewModels DashboardViewModels model = new DashboardViewModels(); //get user Id var user = db.Users.Find(User.Identity.GetUserId()); //get users of Household model.Households = db.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).Households; if (model.Households == null) { return(RedirectToAction("Create", "Households")); } //get in descending order transactions model.Transactions = db.Transactions.Where(a => a.BankAccounts.HouseholdId == user.HouseholdId).OrderByDescending(a => a.Id).Take(6).ToList(); //get all account for this household model.BankAccounts = db.BankAccounts.Where(a => a.HouseholdId == model.Households.Id).ToList(); //get List of existing budgets in this household var getBudget = db.Budgets.Where(a => user.HouseholdId == a.HouseHoldId).ToList(); if (model.Households.Budgets.Count == 0) { return(RedirectToAction("Index", "Budgets")); } //Get currentbudget for this var CurrentBudget = db.Budgets.First(a => a.HouseHoldId == model.Households.Id); if (id == null) { //Viewbag to get list of current existing budget ViewBag.BudgetId = new SelectList(getBudget, "Id", "Name", CurrentBudget.Id); //assign current budget id to existing var to hold the value model.GetBudgetId = CurrentBudget.Id; //assign the current budget to show on chart model.Budgets = CurrentBudget; } else { //dispaly current existing budget in household ViewBag.BudgetId = new SelectList(getBudget, "Id", "Name", id); //assign id to GetBudgetId model.GetBudgetId = (int)id; //get budget assign to id model.Budgets = db.Budgets.First(a => a.Id == id); } var currentDate = DateTime.Now; model.begin = new DateTime(currentDate.Year, currentDate.Month, 1); model.end = currentDate; return(View(model)); }
public IEnumerable <DashboardViewModels> GetReportDataAguamon(string id, int skip = 0, int top = 0, OptionalOutTotalCount totalCount = null) { List <DashboardViewModels> newData = new List <DashboardViewModels>(); IQueryable <Message> reportsQuery = _context.Messages .AsNoTracking().Include(i => i.Device) .Where(w => w.DeviceId == id && (w.TypePackage.Equals("10"))).OrderByDescending(o => o.Id); try { if (totalCount != null) { totalCount.Value = reportsQuery.Count(); } if (skip != 0) { reportsQuery = reportsQuery.Skip(skip); } if (top != 0) { reportsQuery = reportsQuery.Take(top); } foreach (var report in reportsQuery) { DashboardViewModels newItem = new DashboardViewModels(); newItem.DeviceId = report.DeviceId; newItem.Name = report.Device.Name; newItem.Package = report.Data; newItem.TypePackage = report.TypePackage; newItem.Date = report.Date; newItem.Country = report.Country; newItem.Lqi = report.Lqi; newItem.Bits = report.Bits; newItem.Temperature = (decimal.Parse(report.Temperature) * 100).ToString(); newItem.Temperature = report.Temperature.ToString().Substring(0, report.Temperature.Length - 2); newItem.Envio = report.Envio; newItem.PeriodoTransmissao = report.PeriodoTransmissao; newItem.Alimentacao = $"{report.Alimentacao},0"; newItem.AlimentacaoMinima = $"{report.AlimentacaoMinima},0"; newData.Add(newItem); } return(newData.OrderByDescending(o => o.Date).ToArray()); } catch (System.Exception) { return(newData); } }
public async Task <IActionResult> Index() { var UserId = HttpContext.Session.GetInt32(SD.UserId); var claimsIdentity = (ClaimsIdentity)User.Identity; var claim = claimsIdentity.FindFirst(ClaimTypes.NameIdentifier); DashboardViewModels dashboardVM = new DashboardViewModels() { FileRecord = await filesValue.GetAllFiles(_db), }; return(View(dashboardVM)); }
public ActionResult ReportOfAccount(DashboardViewModels model) { try { return(Json(DashboardBusinessLogic.getInstance().getReportOfAccount(model), JsonRequestBehavior.AllowGet)); } catch (Exception e) { Logging.getInstance().CreateLogError(e); return(Json(e.Message, JsonRequestBehavior.AllowGet)); } }
public List <sp_ReportOfBank_Result> getReportOfBank(DashboardViewModels model) { if (!string.IsNullOrEmpty(model.PeriodeReportBank)) { string[] strDate = model.PeriodeReportBank.Split('-'); return(_db.sp_ReportOfBank(model.FilterReportBank, strDate[0].Trim(), strDate[1].Trim(), model.ViewByReportBank).ToList()); } else { return(_db.sp_ReportOfBank(model.FilterReportBank, string.Empty, string.Empty, model.ViewByReportBank).ToList()); } }
public List <sp_ReportOfAccountCashOut_Result> getReportOfCashOut(DashboardViewModels model) { if (!string.IsNullOrEmpty(model.PeriodeReportCashOut)) { string[] strDate = model.PeriodeReportCashOut.Split('-'); return(_db.sp_ReportOfAccountCashOut(model.FilterReportCashOut, strDate[0].Trim(), strDate[1].Trim(), model.ViewByReportCashOut).ToList()); } else { return(_db.sp_ReportOfAccountCashOut(model.FilterReportCashOut, string.Empty, string.Empty, model.ViewByReportCashOut).ToList()); } }
public ActionResult ViewedNews() { ViewBag.ViewedNews = true; ViewBag.ChanelId = new SelectList(Db.Chanels.Where(x => x.Followers.Any(y => y.OwnerId == CurrentUser.Id)), "Id", "Name"); var model = new DashboardViewModels(); model.News = GetNews(false, true, null, 0); //return NotFound404(); return(View("Index", model)); }
public ActionResult Index() { DashboardViewModels models = new DashboardViewModels(); models.HomeTileReport = HomeBusinessLogic.getInstance().GetHomeTile(); ViewBag.FilterBankList = common.ToSelectList(BankFacilityBusinessLogic.getInstance().getBankFacilityDDL(), "ID", "NAME", string.Empty); ViewBag.FilterAccountList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", string.Empty); ViewBag.FilterCashInList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", string.Empty); ViewBag.FilterCashOutList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", string.Empty); return(View(models)); }
// GET: Dashboard public ActionResult Index() { DashboardViewModels model = new DashboardViewModels(); model.AuctionCount = DashboardServices.Instance.GetAuctionCount(); model.UserCount = DashboardServices.Instance.GetUserCount(); model.BidCount = DashboardServices.Instance.GetBidCount(); model.CategoryCount = DashboardServices.Instance.GetCategoryCount(); model.RoleCount = DashboardServices.Instance.GetRoleCount(); model.CommentCount = DashboardServices.Instance.GetCommentCount(); return(View(model)); }
private DashboardViewModels CreateDashboard_Pack81_82ViewModel(Models.Message deviceMessageType81, Models.Message deviceMessageType82) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessageType81.DeviceId; dashboard.Name = deviceMessageType81.Device.Name; if (deviceMessageType82 != null) { dashboard.Package = $"{deviceMessageType81.Data};{deviceMessageType82.Data}"; } else { dashboard.Package = $"{deviceMessageType81.Data}"; } if (deviceMessageType82 != null) { dashboard.TypePackage = $"{deviceMessageType81.TypePackage};{deviceMessageType82.TypePackage}"; } else { dashboard.TypePackage = $"{deviceMessageType81.TypePackage}"; } dashboard.Date = deviceMessageType81.Date; dashboard.Country = deviceMessageType81.Country; dashboard.Lqi = deviceMessageType81.Lqi; dashboard.Temperature = deviceMessageType81.Temperature; dashboard.Ph = deviceMessageType81.Ph; dashboard.Fluor = deviceMessageType81.Fluor; dashboard.Cloro = deviceMessageType81.Cloro; dashboard.Turbidez = deviceMessageType81.Turbidez; if (deviceMessageType82 != null) { dashboard.Rele = new Rele() { Rele1 = Utils.HexaToDecimal(deviceMessageType82.Package.Substring(0, 2)).ToString(), Rele2 = Utils.HexaToDecimal(deviceMessageType82.Package.Substring(2, 2)).ToString(), Rele3 = Utils.HexaToDecimal(deviceMessageType82.Package.Substring(4, 2)).ToString(), Rele4 = Utils.HexaToDecimal(deviceMessageType82.Package.Substring(6, 2)).ToString(), Rele5 = Utils.HexaToDecimal(deviceMessageType82.Package.Substring(8, 2)).ToString() }; } return(dashboard); }
public ActionResult News(int?chanelId) { ViewBag.News = true; if (chanelId != null) { ViewBag.ChanelId = new SelectList(Db.Chanels.Where(x => x.Followers.Any(y => y.OwnerId == CurrentUser.Id)), "Id", "Name", chanelId); } else { ViewBag.ChanelId = new SelectList(Db.Chanels.Where(x => x.Followers.Any(y => y.OwnerId == CurrentUser.Id)), "Id", "Name"); } var model = new DashboardViewModels(); model.News = GetNews(false, false, chanelId, 0); return(View("Index", model)); }
private DashboardViewModels CreateDashboard_Pack21ViewModel(Models.Message deviceMessage) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessage.DeviceId; dashboard.Name = deviceMessage.Device.Name; dashboard.Package = deviceMessage.Data; dashboard.TypePackage = deviceMessage.TypePackage; dashboard.Date = deviceMessage.Date; dashboard.Country = deviceMessage.Country; dashboard.Lqi = deviceMessage.Lqi; dashboard.Bits = deviceMessage.Bits; var _entradaAnalogica = FromFloatSafe(deviceMessage.EntradaAnalogica); var _saidaAnalogica = FromFloatSafe(deviceMessage.SaidaAnalogica); dashboard.EntradaAnalogica = String.Format("{0:0.0}", _entradaAnalogica); dashboard.SaidaAnalogica = String.Format("{0:0.0}", _saidaAnalogica); return(dashboard); }
private DashboardViewModels CreateDashboard_Pack22_23ViewModel(Models.Message deviceMessageType22, Models.Message deviceMessageType23) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessageType22.DeviceId; dashboard.Name = deviceMessageType22.Device.Name; dashboard.Package = $"{deviceMessageType22.Data};{deviceMessageType23.Data}"; dashboard.TypePackage = $"{deviceMessageType22.TypePackage};{deviceMessageType23.TypePackage}"; dashboard.Date = deviceMessageType22.Date; dashboard.Country = deviceMessageType22.Country; dashboard.Lqi = deviceMessageType22.Lqi; dashboard.Bits = deviceMessageType22.Bits; dashboard.Level = deviceMessageType22.Level; dashboard.Light = deviceMessageType22.Light; dashboard.Temperature = deviceMessageType22.Temperature; dashboard.Moisture = deviceMessageType22.Moisture; dashboard.OxigenioDissolvido = deviceMessageType22.OxigenioDissolvido; dashboard.Ph = deviceMessageType23.Ph; dashboard.Condutividade = deviceMessageType23.Condutividade; dashboard.PeriodoTransmissao = deviceMessageType23.PeriodoTransmissao; dashboard.BaseT = deviceMessageType23.BaseT; // set location on dashboard of device DeviceLocation deviceLocation = GetDeviceLocationByDeviceId(dashboard.DeviceId); if (deviceLocation != null) { dashboard.Latitude = deviceLocation.Latitude.ToString(); dashboard.Longitude = deviceLocation.Longitude.ToString(); dashboard.Radius = deviceLocation.Radius; dashboard.LatitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Latitude, "S"); dashboard.LongitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Longitude, "W"); dashboard.RadiusConverted = RadiusFormated(deviceLocation.Radius); } return(dashboard); }
public JsonNetResult GetCounts() { var userId = System.Web.HttpContext.Current.User.Identity.GetUserId <int>(); var user = System.Web.HttpContext.Current.User.Identity.GetUserName(); string firstName = "", lastName = ""; DashboardViewModels model = new DashboardViewModels(); //model.PMPendingCount = this._pmServices.GetPMCounts(userId, 2); //model.PMOverDueCount = this._pmServices.GetPMCounts(userId, 1); //model.PMShutdownCount = this._pmServices.GetPMCounts(userId, 5); //model.MaintenanceRequestOpenCount = this._mrServices.GetMaintenanceRequestOpenCount(userId); //model.MaintenanceRequestInProcessCount = this._mrServices.GetMaintenanceRequestInProcessCount(userId); _userService.GetFnameLname(user, out firstName, out lastName); model.FirstName = firstName; model.LastName = lastName; model.NewFormulationRequestCount = this._formulationRequestService.GetFormulationCount(userId, 1); model.RMRequestCount = this._formulationRequestService.GetFormulationCount(userId, 2); model.RMDispatchCount = this._formulationRequestService.GetFormulationCount(userId, 3); model.ReadyForTestingCount = this._formulationRequestService.GetFormulationCount(userId, 4); return(JsonNet(model, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { var users = database.GetUsers(); var teams = teamrep.GetTeams(); var roles = databaseContext.Roles.ToList(); DashboardViewModels dashboardVM = new DashboardViewModels(); dashboardVM.UserList = users; dashboardVM.TeamList = teams; dashboardVM.Roles = roles; CalendarViewModel calendar = new CalendarViewModel(); AjaxDateModel date = new AjaxDateModel(); date.year = DateTime.Now.Year; date.month = DateTime.Now.Month; calendar = getMonthDays(date); dashboardVM.Calendar = calendar; return(View(dashboardVM)); }
private DashboardViewModels CreateDashboard_Pack10ViewModel(Models.Message deviceMessage) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessage.DeviceId; dashboard.Name = deviceMessage.Device.Name; dashboard.Package = deviceMessage.Data; dashboard.TypePackage = deviceMessage.TypePackage; dashboard.Date = deviceMessage.Date; dashboard.Country = deviceMessage.Country; dashboard.Lqi = deviceMessage.Lqi; dashboard.Bits = deviceMessage.Bits; // set location on dashboard of device DeviceLocation deviceLocation = GetDeviceLocationByDeviceId(dashboard.DeviceId); if (deviceLocation != null) { dashboard.Latitude = deviceLocation.Latitude.ToString(); dashboard.Longitude = deviceLocation.Longitude.ToString(); dashboard.Radius = deviceLocation.Radius; dashboard.LatitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Latitude, "S"); dashboard.LongitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Longitude, "W"); dashboard.RadiusConverted = RadiusFormated(deviceLocation.Radius); } dashboard.Temperature = (decimal.Parse(deviceMessage.Temperature) * 100).ToString(); dashboard.Temperature = dashboard.Temperature.ToString().Substring(0, dashboard.Temperature.Length - 2); dashboard.Envio = deviceMessage.Envio; dashboard.PeriodoTransmissao = deviceMessage.PeriodoTransmissao; dashboard.Alimentacao = $"{deviceMessage.Alimentacao},0"; dashboard.AlimentacaoMinima = $"{deviceMessage.AlimentacaoMinima},0"; return(dashboard); }
public IEnumerable <DashboardViewModels> GetReportDataTRM10(string id, int skip = 0, int top = 0, string de = null, string ate = null, OptionalOutTotalCount totalCount = null, bool isCallByGraphic = false) { List <DashboardViewModels> newData = new List <DashboardViewModels>(); IQueryable <Message> reportsQuery = _context.Messages.AsNoTracking().Include(i => i.Device).Where(w => w.DeviceId == id && (w.TypePackage.Equals("23"))).OrderByDescending(o => o.Id); try { if (!de.Equals("null")) { DateTime firstDate = Convert.ToDateTime(de).ToUniversalTime(); reportsQuery = reportsQuery.Where(c => c.OperationDate.Value.Year >= firstDate.Year && c.OperationDate.Value.Month >= firstDate.Month && c.OperationDate.Value.Day >= firstDate.Day); } if (!ate.Equals("null")) { var lastDate = Convert.ToDateTime(ate).ToUniversalTime(); reportsQuery = reportsQuery.Where(c => c.OperationDate.Value.Year <= lastDate.Year && c.OperationDate.Value.Month <= lastDate.Month && c.OperationDate.Value.Day <= lastDate.Day); } if (totalCount != null) { totalCount.Value = reportsQuery.Count(); } if (skip != 0) { reportsQuery = reportsQuery.Skip(skip); } if (top != 0) { reportsQuery = reportsQuery.Take(top); } foreach (var report in reportsQuery) { DashboardViewModels newItem = new DashboardViewModels(); newItem.DeviceId = report.DeviceId; newItem.Name = report.Device.Name; newItem.Package = report.Data; newItem.TypePackage = report.TypePackage; newItem.Date = report.Date; newItem.Country = report.Country; newItem.Lqi = report.Lqi; newItem.Bits = report.Bits; var _fluxoAgua = FromFloatSafe(report.FluxoAgua); var _consumoAgua = FromFloatSafe(report.ConsumoAgua); newItem.FluxoAgua = String.Format("{0:0.0}", _fluxoAgua); newItem.ConsumoAgua = String.Format("{0:0.0}", _consumoAgua); if (!isCallByGraphic) { var _display = Consts.GetDisplayTRM10(newItem.Bits.BAlertaMax, newItem.Bits.ModoFechado, newItem.Bits.ModoAberto); newItem.Modo = _display.DisplayModo; // modo newItem.Estado = _display.DisplayEstado; // alerta newItem.Valvula = _display.DisplayValvula; // válvula newItem.EstadoColor = _display.EstadoColor; } newData.Add(newItem); } return(newData.OrderBy(o => o.Date).ToArray()); } catch (System.Exception ex) { _log.Log("Erro GetReportDataTRM.", ex.Message, true); return(newData); } }
public IEnumerable <DashboardViewModels> GetReportDataDJRF(string id, int skip = 0, int top = 0, string de = null, string ate = null, bool blocked = false, OptionalOutTotalCount totalCount = null, bool isCallByGraphic = false) { List <DashboardViewModels> newData = new List <DashboardViewModels>(); IQueryable <Message> messages = _context.Messages .AsNoTracking() .Include(i => i.Device) .Where(w => w.DeviceId == id && (w.TypePackage.Equals("12") || w.TypePackage.Equals("13"))) .OrderByDescending(o => o.Time); try { // verificar status de bloqueado ou has-out if (blocked) { messages = messages.Where(c => c.Bits.EstadoBloqueio || c.Bits.EstadoSaidaRastreador); } if (!de.Equals("null")) { var firstDate = Convert.ToDateTime(de).ToUniversalTime().AddHours(-3); messages = messages.Where(c => c.Date >= firstDate); } if (!ate.Equals("null")) { var lastDate = Convert.ToDateTime(ate).ToUniversalTime().AddHours(-3).AddDays(1); messages = messages.Where(c => c.Date <= lastDate); } if (messages == null) { return(null); } List <Message> tmpMessages = messages.ToList(); if (totalCount != null) { totalCount.Value = tmpMessages.Count(); } if (isCallByGraphic) { top = totalCount.Value; } while (tmpMessages.Count() > 0 && newData.Count() <= top) { DashboardViewModels newItem = new DashboardViewModels(); var message12 = tmpMessages.FirstOrDefault(w => w.TypePackage.Equals("12")); var message13 = tmpMessages.FirstOrDefault(w => w.TypePackage.Equals("13")); // Convertendo os dados para pacote 12 if (message12 != null) { newItem.DeviceId = message12.DeviceId; newItem.Name = message12.Device.Name; newItem.Package = message12.Data; newItem.TypePackage = message12.TypePackage; newItem.Date = message12.Date; newItem.Country = message12.Country; newItem.Lqi = message12.Lqi; newItem.Bits = message12.Bits; newItem.EstadoDetector = message12.EstadoDetector; newItem.PeriodoTransmissao = message12.PeriodoTransmissao; newItem.ContadorCarencias = message12.ContadorCarencias; newItem.ContadorBloqueios = message12.ContadorBloqueios; } // Convertendo os dados para pacote 13 if (message13 != null) { var firstCaracter = message13.Temperature.Substring(0, message13.Temperature.Length - 1); var lastCaracter = message13.Temperature.Substring(message13.Temperature.Length - 1, 1); newItem.Temperature = $"{firstCaracter},{lastCaracter}"; newItem.Alimentacao = message13.Alimentacao; } // set location on dashboard of device // DeviceLocation deviceLocation = GetDeviceLocationByDeviceId(id); // if (deviceLocation != null) // { // newItem.Latitude = deviceLocation.Latitude.ToString(); // newItem.Longitude = deviceLocation.Longitude.ToString(); // newItem.Radius = deviceLocation.Radius; // newItem.LatitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Latitude, "S"); // newItem.LongitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Longitude, "W"); // newItem.RadiusConverted = RadiusFormated(deviceLocation.Radius); // } newData.Add(newItem); tmpMessages.Remove(message12); tmpMessages.Remove(message13); } if (skip != 0 && top != 0) { if (isCallByGraphic) { return(newData.Skip(skip).Take(top).OrderBy(o => o.Date).ToArray()); } return(newData.Skip(skip).Take(top).OrderByDescending(o => o.Date).ToArray()); } if (skip != 0 && top == 0) { if (isCallByGraphic) { return(newData.Skip(skip).OrderBy(o => o.Date).ToArray()); } return(newData.Skip(skip).OrderByDescending(o => o.Date).ToArray()); } if (skip == 0 && top != 0) { if (isCallByGraphic) { return(newData.Take(top).OrderBy(o => o.Date).ToArray()); } return(newData.Take(top).OrderByDescending(o => o.Date).ToArray()); } if (isCallByGraphic) { return(newData.OrderBy(o => o.Date).ToArray()); } return(newData.OrderByDescending(o => o.Date).ToArray()); } catch (System.Exception) { return(newData); } }
private void ExcelReportCashOut(DashboardViewModels model) { ExcelPackage Package = new ExcelPackage(); ExcelWorksheet ws = Package.Workbook.Worksheets.Add("Data"); ExcelWorksheet wsComChart = Package.Workbook.Worksheets.Add("Chart"); OfficeOpenXml.Style.ExcelBorderStyle DefaultBorder = OfficeOpenXml.Style.ExcelBorderStyle.Thin; Color colFromHex = System.Drawing.ColorTranslator.FromHtml("#00b0f0"); ws.Cells["A1"].LoadFromText("Month"); ws.Cells["A1"].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["A1"].Style.Font.Color.SetColor(Color.White); ws.Cells["A1"].Style.Font.Bold = true; ws.Cells["A1"].Style.Fill.PatternType = ExcelFillStyle.Solid; ws.Cells["A1"].Style.Fill.BackgroundColor.SetColor(colFromHex); ws.Cells["A1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["A1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["A1"].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["A1"].Style.Border.Left.Style = DefaultBorder; ws.Cells["A1"].Style.Border.Top.Style = DefaultBorder; ws.Cells["A1"].Style.Border.Right.Style = DefaultBorder; ws.Cells["B1"].LoadFromText("Operation"); ws.Cells["B1"].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["B1"].Style.Font.Color.SetColor(Color.White); ws.Cells["B1"].Style.Font.Bold = true; ws.Cells["B1"].Style.Fill.PatternType = ExcelFillStyle.Solid; ws.Cells["B1"].Style.Fill.BackgroundColor.SetColor(colFromHex); ws.Cells["B1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["B1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["B1"].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["B1"].Style.Border.Left.Style = DefaultBorder; ws.Cells["B1"].Style.Border.Top.Style = DefaultBorder; ws.Cells["B1"].Style.Border.Right.Style = DefaultBorder; ws.Cells["C1"].LoadFromText("Accounting"); ws.Cells["C1"].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["C1"].Style.Font.Color.SetColor(Color.White); ws.Cells["C1"].Style.Font.Bold = true; ws.Cells["C1"].Style.Fill.PatternType = ExcelFillStyle.Solid; ws.Cells["C1"].Style.Fill.BackgroundColor.SetColor(colFromHex); ws.Cells["C1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["C1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["C1"].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["C1"].Style.Border.Left.Style = DefaultBorder; ws.Cells["C1"].Style.Border.Top.Style = DefaultBorder; ws.Cells["C1"].Style.Border.Right.Style = DefaultBorder; int idx = 1; var list = DashboardBusinessLogic.getInstance().getReportOfAccountCashIn(model); foreach (var item in list) { idx++; ws.Cells["A" + idx.ToString()].LoadFromText(item.Month); ws.Cells["A" + idx.ToString()].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["A" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["A" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["A" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["A" + idx.ToString()].Style.Border.Left.Style = DefaultBorder; ws.Cells["A" + idx.ToString()].Style.Border.Top.Style = DefaultBorder; ws.Cells["A" + idx.ToString()].Style.Border.Right.Style = DefaultBorder; ws.Cells["B" + idx.ToString()].LoadFromText((Convert.ToDecimal(item.Accounting)).ToString()); ws.Cells["B" + idx.ToString()].Style.Numberformat.Format = "#,##"; ws.Cells["B" + idx.ToString()].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["B" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["B" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["B" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["B" + idx.ToString()].Style.Border.Left.Style = DefaultBorder; ws.Cells["B" + idx.ToString()].Style.Border.Top.Style = DefaultBorder; ws.Cells["B" + idx.ToString()].Style.Border.Right.Style = DefaultBorder; ws.Cells["C" + idx.ToString()].LoadFromText((Convert.ToDecimal(item.Operation)).ToString()); ws.Cells["C" + idx.ToString()].Style.Numberformat.Format = "#,##"; ws.Cells["C" + idx.ToString()].Style.Font.SetFromFont(new Font("Cambria", 10)); ws.Cells["C" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; ws.Cells["C" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; ws.Cells["C" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder; ws.Cells["C" + idx.ToString()].Style.Border.Left.Style = DefaultBorder; ws.Cells["C" + idx.ToString()].Style.Border.Top.Style = DefaultBorder; ws.Cells["C" + idx.ToString()].Style.Border.Right.Style = DefaultBorder; } List <DataSerie> SeriesList = new List <DataSerie>(); SeriesList.Add(new DataSerie() { name = "Month", Series = ws.Cells["A" + (idx - 1) + ":A" + idx], xSeries = ws.Cells["B" + (idx - 1) + ":C" + idx] }); SeriesList.Add(new DataSerie() { name = "Accounting", Series = ws.Cells["B" + (idx - 1) + ":B" + idx], xSeries = ws.Cells["B" + (idx - 1) + ":C" + idx] }); SeriesList.Add(new DataSerie() { name = "Operation", Series = ws.Cells["C" + (idx - 1) + ":C" + idx], xSeries = ws.Cells["B" + (idx - 1) + ":C" + idx] }); ExcelChart chart = AddBarChart(wsComChart, "ReportOfAccountCashOut", OfficeOpenXml.Drawing.Chart.eChartType.ColumnClustered, SeriesList); chart.Title.Text = "Report Of Account Cash Out"; chart.SetPosition(0, 0, 0, 0); chart.SetSize(BarOptions.width, BarOptions.Height); Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename=ReportOfAccountCashOut_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".xlsx"); Response.BinaryWrite(Package.GetAsByteArray()); Response.End(); }
private DashboardViewModels CreateDashboard_Pack12ViewModel(Models.Message deviceMessage_12, Models.Message deviceMessage_13, DeviceRegistration deviceRegistration) { DashboardViewModels dashboard = new DashboardViewModels(); dashboard.DeviceId = deviceMessage_12.DeviceId; dashboard.Name = deviceMessage_12.Device.Name; dashboard.Package = deviceMessage_12.Data; dashboard.TypePackage = deviceMessage_12.TypePackage; dashboard.Date = deviceMessage_12.Date; dashboard.Country = deviceMessage_12.Country; dashboard.Lqi = deviceMessage_12.Lqi; dashboard.Bits = deviceMessage_12.Bits; // set location on dashboard of device DeviceLocation deviceLocation = GetDeviceLocationByDeviceId(dashboard.DeviceId); if (deviceLocation != null) { dashboard.Latitude = deviceLocation.Latitude.ToString(); dashboard.Longitude = deviceLocation.Longitude.ToString(); dashboard.Radius = deviceLocation.Radius; dashboard.LatitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Latitude, "S"); dashboard.LongitudeConverted = LocationDecimalToDegrees((decimal)deviceLocation.Longitude, "W"); dashboard.RadiusConverted = RadiusFormated(deviceLocation.Radius); } // converter os bits deste dashboard.EstadoDetector = deviceMessage_12.EstadoDetector; dashboard.PeriodoTransmissao = deviceMessage_12.PeriodoTransmissao; dashboard.AlertaFonteBaixa = deviceMessage_12.AlertaFonteBaixa; dashboard.ContadorCarencias = deviceMessage_12.ContadorCarencias; dashboard.ContadorBloqueios = deviceMessage_12.ContadorBloqueios; var firstCaracter = deviceMessage_13.Temperature.Substring(0, deviceMessage_13.Temperature.Length - 1); var lastCaracter = deviceMessage_13.Temperature.Substring(deviceMessage_13.Temperature.Length - 1, 1); dashboard.Temperature = $"{firstCaracter},{lastCaracter}"; // dashboard.Alimentacao = deviceMessage_13.Alimentacao; if (deviceMessage_13.Alimentacao == "0") { if (deviceMessage_13.AlimentacaoH != "0") { dashboard.Alimentacao = $"{deviceMessage_13.AlimentacaoL}{deviceMessage_13.AlimentacaoH}"; } else { dashboard.Alimentacao = deviceMessage_13.AlimentacaoL.Contains(",") ? $"{deviceMessage_13.AlimentacaoL}" : $"{deviceMessage_13.AlimentacaoL},0"; } } else { dashboard.Alimentacao = deviceMessage_13.Alimentacao.Contains(",") ? $"{deviceMessage_13.Alimentacao}" : $"{deviceMessage_13.Alimentacao},0"; } if (deviceRegistration.DataDownloadLink != null) { dashboard.Envio = deviceRegistration.Envio; dashboard.PeriodoTransmissao = deviceRegistration.PeriodoTransmissao; dashboard.Bits.BaseTempoUpLink = deviceRegistration.BaseTempoUpLink; dashboard.TensaoMinima = deviceRegistration.TensaoMinima; } return(dashboard); }
public ActionResult Index() { List <DashboardViewModel> dashboardItems = new List <DashboardViewModel>(); List <DashboardViewModel> items = new List <DashboardViewModel>(); var viewModel = new DashboardViewModels(); SupportService supportService = new SupportService(); TimeSheetService timesheetService = new TimeSheetService(); ExpenseService expenseService = new ExpenseService(); LOAService loaService = new LOAService(); var roles = ((ClaimsIdentity)User.Identity).Claims .Where(c => c.Type == ClaimTypes.Role) .Select(c => c.Value); if (roles.Contains("TimeSheetAdmin")) { viewModel.AdminPendingExpensesCount = expenseService.GetPendingExpensesCount(); viewModel.AdminPendingLOAsCount = loaService.GetPendingLOAsCount(); viewModel.AdminPendingTimesheetsCount = timesheetService.GetPendingTimesheetsCount(); // viewModel.DasboardList.AddRange(ExpenseModuleAdmin()); } else if (roles.Contains("TimeSheetManager")) { viewModel.ManagerPendingTimesheetsCount = timesheetService.GetPendingTimesheetsCount(); viewModel.MangerPendingExpensesCount = expenseService.GetPendingExpensesCount(); viewModel.MangerPendingLOAsCount = loaService.GetPendingLOAsCount(); // viewModel.DasboardList.AddRange(TimeSheetModuleManager()); // viewModel.DasboardList.AddRange(LOAModuleManager()); // items.AddRange(ExpenseModuleManager()); } if (roles.Contains("TimeSheetReportingManager")) { viewModel.ReportingManagerPendingExpensesCount = expenseService.GetPendingExpensesCount(User.Identity.GetUserId()); viewModel.ReportingManagerPendingLOAsCount = loaService.GetPendingLOAsCount(User.Identity.GetUserId()); viewModel.ReportingManagerPendingTimesheetsCount = timesheetService.GetPendingTimesheetsCount(User.Identity.GetUserId()); // viewModel.DasboardList.AddRange(TimeSheetModuleReportingManager()); // viewModel.DasboardList.AddRange(LOAModuleReportingManager()); // viewModel.DasboardList.AddRange(ExpenseModuleReportingManager()); } if (roles.Contains("SupportUser")) { //viewModel.DasboardList.AddRange(SupportModuleUserPendingRequest()); //viewModel.DasboardList.AddRange(SupportModuleUserDoneRequest()); //viewModel.DasboardList.AddRange(SupportModuleUserClosedRequest()); viewModel.MyPendingRequestsCount = supportService.GetMyPendingRequestsCount(User.Identity.GetUserId()); viewModel.MyClosedRequestsCount = supportService.GetMyClosedRequestsCount(User.Identity.GetUserId()); viewModel.MyDoneRequestsCount = supportService.GetMyDoneRequestsCount(User.Identity.GetUserId()); } //viewModel.DasboardList.AddRange(items); //dashboardItems.AddRange(items); return(View(viewModel)); }