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