public ActionResult Index() { var cachedModel = TwoLevelCache.GetLocalStoreOnly("DashboardPageModel", TimeSpan.FromMinutes(5), BuildingRow.Fields.GenerationKey, () => { var model = new DashboardPageModel(); var connection = SqlConnections.NewByKey("Default"); #region Zoning model.TotalBuildings = connection.Count <BuildingRow>(); model.TotalApartments = connection.Count <ApartmentRow>(); #endregion #region Parameter model.ParametersList = connection.List <ParameterRow>(); #endregion #region Meter model.MetersList = connection.List <MeterRow>(); model.TotalMeters = connection.Count <MeterRow>(); #endregion #region EMSDevice model.TotalEMSDevices = connection.Count <EmsDeviceRow>(); #endregion #region Charts model.BarLstModel = new List <SimpleReportViewModel>(); model.BarLstModel = Bar(); model.PieLstModel = new List <SimpleReportViewModel>(); model.PieLstModel = Pie(); #endregion return(model); }); return(View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel)); }
public ActionResult Index() { var cachedModel = TwoLevelCache.GetLocalStoreOnly("DashboardPageModel", TimeSpan.FromMinutes(5), OrderRow.Fields.GenerationKey, () => { var model = new DashboardPageModel(); var o = OrderRow.Fields; using (var connection = SqlConnections.NewFor <OrderRow>()) { model.OpenOrders = connection.Count <OrderRow>(o.ShippingState == (int)OrderShippingState.NotShipped); var closedOrders = connection.Count <OrderRow>(o.ShippingState == (int)OrderShippingState.Shipped); var totalOrders = model.OpenOrders + closedOrders; model.ClosedOrderPercent = (int)Math.Round(totalOrders == 0 ? 100 : ((double)closedOrders / (double)totalOrders * 100)); model.CustomerCount = connection.Count <CustomerRow>(); model.ProductCount = connection.Count <ProductRow>(); } return(model); }); return(View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel)); }
public ActionResult Index() { var cachedModel = TwoLevelCache.GetLocalStoreOnly("DashboardPageModel", TimeSpan.FromMinutes(5), OrderRow.Fields.GenerationKey, () => { var model = new DashboardPageModel(); var o = OrderRow.Fields; using (var connection = SqlConnections.NewFor<OrderRow>()) { model.OpenOrders = connection.Count<OrderRow>(o.ShippingState == (int)OrderShippingState.NotShipped); var closedOrders = connection.Count<OrderRow>(o.ShippingState == (int)OrderShippingState.Shipped); var totalOrders = model.OpenOrders + closedOrders; model.ClosedOrderPercent = (int)Math.Round(totalOrders == 0 ? 100 : ((double)closedOrders / (double)totalOrders * 100)); model.CustomerCount = connection.Count<CustomerRow>(); model.ProductCount = connection.Count<ProductRow>(); } return model; }); return View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel); }
public ActionResult Index() { var model = new DashboardPageModel(); using (var connection = SqlConnections.NewFor <OffersRow>()) { var offerStatuses = new OfferStatusesRepository().List(connection, new ListRequest { ColumnSelection = ColumnSelection.Details }); model.OfferStatuses = offerStatuses.Entities; var softwareFrameworks = new SoftwareFrameworksRepository().List(connection, new ListRequest { ColumnSelection = ColumnSelection.Details }); model.SoftwareFrameworks = softwareFrameworks.Entities; var offers = new OffersRepository().List(connection, new ListRequest { ColumnSelection = ColumnSelection.Details }); model.Offers = offers.Entities; var taskStatuses = new TaskStatusesRepository().List(connection, new ListRequest { ColumnSelection = ColumnSelection.Details }); model.TaskStatuses = taskStatuses.Entities; var offerCategoryTasks = new OfferCategoryTasksRepository().List(connection, new ListRequest { ColumnSelection = ColumnSelection.Details }); model.OfferCategoryTasks = offerCategoryTasks.Entities; } return(View(MVC.Views.Common.Dashboard.DashboardIndex, model)); }
public ActionResult Index() { /* * var cahcedModel = TwoLevelCache.GetLocalStoreOnly("DashboardPageModel", TimeSpan.FromMinutes(5), OrderRow.Fields.GenerationKey, () => * { * var model = new DashboardPageModel(); * var o = OrderRow.Fields; * using (var connection = SqlConnections.NewFor<OrderRow>()) * { * model.OpenOrders = connection.Count<OrderRow>(o.ShippingState == (int)OrderShippingState.NotShipped); * var closedOrders = connection.Count<OrderRow>(o.ShippingState == (int)OrderShippingState.Shipped); * var totalOrders = model.OpenOrders + closedOrders; * model.ClosedOrderPercent = (int).Math.Round(totalOrder == 0 ? 100 : ((double)closedOrders / (double)totalOrders * 100); * model.CustomerCount = connection.Count<CustomerRow>(); * model.ProductCount = connection.Count<ProductRow>(); * } * return model; * }); */ var cachedModel = TwoLevelCache.GetLocalStoreOnly("DashboardPageModel", TimeSpan.FromSeconds(1), OrdersRow.Fields.GenerationKey, () => { var model = new DashboardPageModel(); var o = OrdersRow.Fields; var p = ProductsRow.Fields; using (var connection = SqlConnections.NewByKey("Default")) { model.OrderCount = connection.Count <OrdersRow>(o.DatetimeOrder == DateTime.Today); model.CustomerCount = connection.Count <CustomersRow>(); model.ProductCount = connection.Count <ProductsRow>(); model.RunsOutProductCount = connection.Count <ProductsRow>(p.StockQuantityProduct < 20); model.LowStockProductCount = connection.Count <ProductsRow>(p.StockQuantityProduct >= 20 && p.StockQuantityProduct <= 50); } return(model); }); //return View(MVC.Views.Common.Dashboard.DashboardIndex, new DashboardPageModel()); return(View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel)); }
public ActionResult Index() { var cachedModel = new DashboardPageModel(); return(View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel)); }
public JsonResult GetVisitsTasks(string start, string end) { var user = (UserDefinition)Authorization.UserDefinition; var startDate = DateTime.ParseExact(start, "yyyy-MM-dd", new CultureInfo("en-US"), DateTimeStyles.None); var endDate = DateTime.ParseExact(end, "yyyy-MM-dd", new CultureInfo("en-US"), DateTimeStyles.None); var cabinetIdActive = Request.Cookies["CabinetPreference"]; var model = new DashboardPageModel(); using (var connection = SqlConnections.NewFor <VisitsRow>()) { var visitFlds = VisitsRow.Fields.As("vis"); var patient = PatientsRow.Fields.As("ptn"); var visitType = VisitTypesRow.Fields.As("vstt"); var users = UserRow.Fields.As("assUsr"); var query = new SqlQuery() .From(visitFlds) .Select("*") .Where(~( new Criteria(visitFlds.StartDate) >= startDate & new Criteria(visitFlds.EndDate) <= endDate & new Criteria(visitFlds.CabinetId) == int.Parse(cabinetIdActive) )) .LeftJoin(users, visitFlds.AssignedUserId == users.UserId) .Select(users.DisplayName = visitFlds.AssignedUserName) .LeftJoin(patient, visitFlds.PatientId == patient.PatientId) .Select(patient.Name = visitFlds.PatientName, patient.NotifyOnChange = visitFlds.PatientNotifyOnChange) .LeftJoin(visitType, visitFlds.VisitTypeId == visitType.VisitTypeId) .Select(visitType.BackgroundColor = visitFlds.VisitTypeBackgroundColor, visitType.BorderColor = visitFlds.VisitTypeBorderColor) ; if (!Authorization.HasPermission(PermissionKeys.Tenants)) { query.Where(visitFlds.TenantId == user.TenantId); } var result = connection.Query <VisitsRow>(query); foreach (VisitsRow visit in result) { model.EventsList.Add(new Event { id = visit.VisitId ?? 0, patientId = visit.PatientId ?? 0, assignedToUser = visit.AssignedUserName, patientAutoEmailActive = visit.PatientNotifyOnChange ?? false, title = string.Join("\n", string.IsNullOrEmpty(visit.PatientName)?"* " + LocalText.Get("Db.PatientManagement.Visits.FreeForReservation") + " *": visit.PatientName , visit.Description), start = (visit.StartDate ?? DateTime.Now).ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz"), end = (visit.EndDate ?? DateTime.Now).ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz"), allDay = false, backgroundColor = visit.VisitTypeBackgroundColor, borderColor = visit.VisitTypeBorderColor }); } } return(Json(model.EventsList)); }
public ActionResult Index() { var cachedModel = new DashboardPageModel(); return View(MVC.Views.Common.Dashboard.DashboardIndex, cachedModel); }