/// <summary> /// Delete the current DashboardParameters based on the DashboardParameters ID passed in the DashboardParametersModel /// </summary> /// <param name="id"> /// The identifier. /// </param> /// <returns> /// The <see cref="ActionResult"/>. /// </returns> public ActionResult DeleteDashboardParameters(int id) { using (var bal = new DashboardParametersBal()) { // Get DashboardParameters model object by current DashboardParameters ID DashboardParameters model = bal.GetDashboardParametersById(id); int userId = Helpers.GetLoggedInUserId(); var list = new List <DashboardParametersCustomModel>(); DateTime currentDate = Helpers.GetInvariantCultureDateTime(); // Check If DashboardParameters model is not null if (model != null) { int corporateid = Helpers.GetSysAdminCorporateID(); int facilityid = Helpers.GetDefaultFacilityId(); model.ModifiedBy = userId; model.ModifiedDate = currentDate; model.CorporateId = corporateid; model.FacilityId = facilityid; // Update Operation of current DashboardParameters list = bal.DeleteDashboardParameters(model); // return deleted ID of current DashboardParameters as Json Result to the Ajax Call. } // Pass the ActionResult with List of DashboardParametersViewModel object to Partial View DashboardParametersList return(this.PartialView(PartialViews.DashboardParametersList, list)); } }
public KPIReport GetKPIReport(DashboardParameters para) { DashboardDataHelper rdHelper = new DashboardDataHelper(); KPIReport kPIReport = new KPIReport(); var TotalUnits = rdHelper.GetTotalUnits(para); var UnitsWithinRange = rdHelper.GetUnitsWithinWeightRange(para); decimal Precision = 0; if (TotalUnits != 0) { Precision = (UnitsWithinRange / TotalUnits) * 100; } var UnitsWithinFillTimeLimits = rdHelper.GetUnitsWithinFillTimeLimits(para); decimal Performance = 0; if (TotalUnits != 0) { Performance = (UnitsWithinFillTimeLimits / TotalUnits) * 100; } kPIReport.Precision = Math.Round(Precision, 2); kPIReport.Performance = Math.Round(Performance); kPIReport.Efficiency = Math.Round((Performance + Precision) / 2, 2); return(kPIReport); }
public List <DensityTrend> GetDensityTrend([FromBody] DashboardParameters para) { DashboardData reportData = new DashboardData(); List <DensityTrend> densityTrend = reportData.GetBatchDensityTrend(para); return(densityTrend); }
public KPIReport GetKPIReport([FromBody] DashboardParameters para) { DashboardData reportData = new DashboardData(); KPIReport kPIReport = reportData.GetKPIReport(para); return(kPIReport); }
public DashboardReport GetDashboardReport([FromBody] DashboardParameters para) { DashboardData reportData = new DashboardData(); DashboardReport dashboardReport = reportData.GetDashboardReport(para); return(dashboardReport); }
/// <summary> /// Get the details of the current DashboardParameters in the view model by ID /// </summary> /// <param name="id"> /// The identifier. /// </param> /// <returns> /// The <see cref="JsonResult"/>. /// </returns> public JsonResult GetDashboardParametersDetails(int id) { using (var bal = new DashboardParametersBal()) { // Call the AddDashboardParameters Method to Add / Update current DashboardParameters DashboardParameters current = bal.GetDashboardParametersById(id); // Pass the ActionResult with the current DashboardParametersViewModel object as model to PartialView DashboardParametersAddEdit return(this.Json(current)); } }
public PartialViewResult GetCharts(DashboardParameters parameters) { ProductAssetCharts model = new ProductAssetCharts(); var client = new RestClient(CommonFunctions.GetAPIPath() + "Dashboard/GetChartData"); var request = new RestRequest(Method.POST); request.AddParameter("application/json; charset=utf-8", JsonConvert.SerializeObject(parameters), ParameterType.RequestBody); IRestResponse response = client.Execute(request); model = JsonConvert.DeserializeObject <ProductAssetCharts>(response.Content); return(PartialView("_ProductAssetDetails", model)); }
public PartialViewResult GetSlidersData(DashboardParameters parameters) { Slider model = new Slider(); var client = new RestClient(CommonFunctions.GetAPIPath() + "Dashboard/GetSliderDetails"); var request = new RestRequest(Method.POST); request.AddParameter("application/json; charset=utf-8", JsonConvert.SerializeObject(parameters), ParameterType.RequestBody); IRestResponse response = client.Execute(request); model.Details = JsonConvert.DeserializeObject <List <Slider> >(response.Content); return(PartialView("_SliderDetails", model)); }
public List <DensityTrend> GetBatchDensityTrend(DashboardParameters para) { IQueryable <TransactionLog> result = _db.TransactionLogs; string rptStartDate = ""; string rptEndDate = ""; if (para.ProductCode != "All") { result = result.Where(p => p.ProductCode == para.ProductCode); } if (para.Duration == 0) { DateTime dateTimeFrom = DateHelper.StartOfDay(DateTime.Now).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(DateTime.Now).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); rptStartDate.ToString(); rptEndDate = dateTimeTo.ToString(); } else { DateTime start = DateHelper.StartDate(para.Duration); DateTime end = DateHelper.EndDate(para.Duration); DateTime dateTimeFrom = DateHelper.StartOfDay(start).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(end).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); rptStartDate.ToString(); rptEndDate = dateTimeTo.ToString(); } List <DensityTrend> data = result .Where(p => p.ClientId == para.ClientId) .GroupBy(p => new { p.BatchCode }, (key, group) => new { BatchCode = key.BatchCode, Result = group.ToList() }) .Select(s => new DensityTrend { BatchCode = s.BatchCode, startDate = rptStartDate, endDate = rptEndDate, avgDensity = s.Result.Average(p => p.ProductDensity) }).ToList(); return(data.ToList()); }
/// <summary> /// Method to Delete the Entity in the database. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> public List <DashboardParametersCustomModel> DeleteDashboardParameters(DashboardParameters model) { using (var rep = UnitOfWork.DashboardParametersRepository) { if (model.ParameterId > 0) { var current = rep.GetSingle(model.ParameterId); rep.Delete(model.ParameterId); } var list = GetDashboardParametersList(model.CorporateId, model.FacilityId); return(list); } }
public async Task <PartialViewResult> GetCashFlowTable(DashboardParameters param) { CashFlowData model = new CashFlowData(); JsonResponse jsonResponse = new JsonResponse(); var client = new RestClient(CommonFunctions.GetAPIPath() + "Dashboard/GetCashFlowDataSummary"); var request = new RestRequest(Method.POST); request.AddParameter("application/json; charset=utf-8", JsonConvert.SerializeObject(param), ParameterType.RequestBody); IRestResponse response = client.Execute(request); jsonResponse = JsonConvert.DeserializeObject <JsonResponse>(response.Content); model.cashFlowDatasList = JsonConvert.DeserializeObject <List <CashFlowData> >(jsonResponse.Data.ToString()); model.LastUpdatedOn = jsonResponse.LastUpdatedOn; HttpContext.Session.SetObject("CashGridData", model.cashFlowDatasList); return(PartialView("_CashFlowDataTable", model)); }
/// <summary> /// Method for getting Software mapping list /// </summary> /// <param name="param"></param> /// <param name="pageIndex"></param> /// <returns></returns>'Session has not been configured for this application or request.' public JsonResult GetAssetSummary(DashboardParameters param) { JsonResponse jsonResponse = new JsonResponse(); var client = new RestClient(CommonFunctions.GetAPIPath() + "Dashboard/GetAssetDataSummary"); var request = new RestRequest(Method.POST); request.AddParameter("application/json; charset=utf-8", JsonConvert.SerializeObject(param), ParameterType.RequestBody); IRestResponse response = client.Execute(request); jsonResponse = JsonConvert.DeserializeObject <JsonResponse>(response.Content); IEnumerable <AssetData> summary = JsonConvert.DeserializeObject <IEnumerable <AssetData> >(jsonResponse.Data.ToString()); HttpContext.Session.SetObject("GridData", summary); int totalconsumable = summary.Count(); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { summary = summary.Where(z => z.AssetClass.ToLower().Contains(param.sSearch.ToLower())); } summary = sortColumnIndex switch { 0 => sortDirection == "asc" ? summary.OrderBy(z => z.AssetClass) : summary.OrderByDescending(z => z.AssetClass), 1 => sortDirection == "asc" ? summary.OrderBy(z => z.ValueAtCost) : summary.OrderByDescending(z => z.ValueAtCost), 2 => sortDirection == "asc" ? summary.OrderBy(z => z.MarketValue) : summary.OrderByDescending(z => z.MarketValue), 3 => sortDirection == "asc" ? summary.OrderBy(z => z.Weightage) : summary.OrderByDescending(z => z.Weightage), _ => sortDirection == "desc" ? summary.OrderBy(z => z.UnrealizedGL) : summary.OrderByDescending(z => z.UnrealizedGL), }; int filteredconsumableCount = summary.Count(); if (param.iDisplayLength > 0) { summary = summary.Skip(param.iDisplayStart).Take(param.iDisplayLength); } return(Json(new { param.sEcho, iTotalRecords = totalconsumable, iTotalDisplayRecords = filteredconsumableCount, aaData = summary })); }
/// <summary> /// Method to add/Update the Entity in the database. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> public List <DashboardParametersCustomModel> SaveDashboardParameters(DashboardParameters model) { using (var rep = UnitOfWork.DashboardParametersRepository) { if (model.ParameterId > 0) { var current = rep.GetSingle(model.ParameterId); model.CreatedBy = current.CreatedBy; model.CreatedDate = current.CreatedDate; rep.UpdateEntity(model, model.ParameterId); } else { rep.Create(model); } var list = GetDashboardParametersList(model.CorporateId, model.FacilityId); return(list); } }
public decimal GetUnitsWithinFillTimeLimits(DashboardParameters para) { IQueryable <TransactionLog> result = _db.TransactionLogs; if (para.Plant != "All") { result = result.Where(p => p.PlantId == para.Plant); } if (para.FillingMachine != "All") { result = result.Where(p => p.MachineName == para.FillingMachine); } if (para.ProductCode != "All") { result = result.Where(p => p.ProductCode == para.ProductCode); } if (para.Duration == 0) { DateTime dateTimeFrom = DateHelper.StartOfDay(DateTime.Now).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(DateTime.Now).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); } else { DateTime start = DateHelper.StartDate(para.Duration); DateTime end = DateHelper.EndDate(para.Duration); DateTime dateTimeFrom = DateHelper.StartOfDay(start).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(end).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); } var data = result .Where(p => p.ClientId == para.ClientId && p.ActualFillTime <= p.ExpectedFillTime); return(data.Count()); }
/// <summary> /// Add New or Update the DashboardParameters based on if we pass the DashboardParameters ID in the /// DashboardParametersViewModel object. /// </summary> /// <param name="model"> /// The model. /// </param> /// <returns> /// returns the newly added or updated ID of DashboardParameters row /// </returns> public ActionResult SaveDashboardParameters(DashboardParameters model) { // Initialize the newId variable int userId = Helpers.GetLoggedInUserId(); DateTime currentDate = Helpers.GetInvariantCultureDateTime(); var list = new List <DashboardParametersCustomModel>(); // Check if Model is not null if (model != null) { int corporateid = Helpers.GetSysAdminCorporateID(); int facilityid = Helpers.GetDefaultFacilityId(); model.CorporateId = corporateid; model.FacilityId = facilityid; using (var bal = new DashboardParametersBal()) { if (model.ParameterId > 0) { model.ModifiedBy = userId; model.ModifiedDate = currentDate; } else { model.CreatedBy = userId; model.CreatedDate = currentDate; } // Call the AddDashboardParameters Method to Add / Update current DashboardParameters list = bal.SaveDashboardParameters(model); } } // Pass the ActionResult with List of DashboardParametersViewModel object to Partial View DashboardParametersList return(this.PartialView(PartialViews.DashboardParametersList, list)); }
public DashboardReport GetDashboardReport(DashboardParameters para) { IQueryable <TransactionLog> result = _db.TransactionLogs; if (para.Plant != "All") { result = result.Where(p => p.PlantId == para.Plant); } if (para.FillingMachine != "All") { result = result.Where(p => p.MachineName == para.FillingMachine); } if (para.ProductCode != "All") { result = result.Where(p => p.ProductCode == para.ProductCode); } if (para.Duration == 0) { DateTime dateTimeFrom = DateHelper.StartOfDay(DateTime.Now).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(DateTime.Now).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); } else { DateTime start = DateHelper.StartDate(para.Duration); DateTime end = DateHelper.EndDate(para.Duration); DateTime dateTimeFrom = DateHelper.StartOfDay(start).ToUniversalTime(); DateTime dateTimeTo = DateHelper.EndOfDay(end).ToUniversalTime(); result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo)); } ///.Where(p => (p.TransactionDate >= para.DateFrom && p.TransactionDate <= para.DateTo)) var data = result .Where(p => p.ClientId == para.ClientId) .GroupBy(p => p.ProductCode) .Select(s => new DashboardReport { Units = s.Count(), RequiredWeight = s.Sum(p => p.TargetWeight), ActualWeight = s.Sum(p => p.ActualWeight), AverageWeight = s.Average(p => p.ActualWeight), PercDiffWeight = ((s.Sum(p => p.ActualWeight) - s.Sum(p => p.TargetWeight)) / s.Sum(p => p.TargetWeight)) * 100, AverageFillTime = s.Average(p => p.ActualFillTime) }).FirstOrDefault(); if (data == null) { data = new DashboardReport { Units = 0, RequiredWeight = 0, ActualWeight = 0, AverageWeight = 0, PercDiffWeight = 0, AverageFillTime = 0 }; } return((DashboardReport)data); }