public ActionResult GetPSLIdPIPPriority(string parentarea, string salesOffice, string dateRangeFrom, string dateRangeEnd, string inventory, string rental, string hid, string others, string pslType, string storeName, string area) { var splitPSLType = new string[] { }; var splitArea = new string[] { }; var splitStoreName = new string[] { }; if (!string.IsNullOrWhiteSpace(pslType)) { splitPSLType = pslType.Split(','); } if (!string.IsNullOrWhiteSpace(storeName)) { splitStoreName = storeName.Split(','); } if (!string.IsNullOrWhiteSpace(area)) { splitArea = area.Split(','); } var modelFormCollection = new GetFormCollectionPSLCompletionPip(); modelFormCollection.DateRangeFrom = dateRangeFrom; modelFormCollection.DateRangeEnd = dateRangeEnd; modelFormCollection.Inventory = inventory; modelFormCollection.Rental = rental; modelFormCollection.HID = hid; modelFormCollection.Others = others; modelFormCollection.Area = area; modelFormCollection.PSLId = ""; modelFormCollection.PSLType = pslType; modelFormCollection.StoreName = ""; ViewBag.ModelFormCollectionPSLCompletionPip = modelFormCollection; ViewBag.ListPSLIdPipPriority = pslBS.GetListPSLIdForCompletionPipPriority(parentarea, salesOffice, dateRangeFrom, dateRangeEnd, inventory, rental, hid, others, splitPSLType, splitArea, splitStoreName); ViewBag.Domain = WebConfigure.GetDomain(); return(View()); }
public ActionResult GetSalesOfficePIPPriority(string parent, string dateRangeFrom, string dateRangeEnd, string inventory, string rental, string hid, string others, string pslType, string storeName, string area) { var splitPSLType = new string[] { }; var splitArea = new string[] { }; var splitStoreName = new string[] { }; if (!string.IsNullOrWhiteSpace(pslType)) { splitPSLType = pslType.Split(','); } if (!string.IsNullOrWhiteSpace(storeName)) { splitStoreName = storeName.Split(','); } if (!string.IsNullOrWhiteSpace(area)) { splitArea = area.Split(','); } var PSLData = pslBS.GetListSalesOfficeForCompletionPipPriority(parent, dateRangeFrom, dateRangeEnd, inventory, rental, hid, others, splitPSLType, splitArea, splitStoreName); List <Ticket> PSLDataTemp = new List <Ticket>(); foreach (var item in PSLData) { Ticket tempPSL = new Ticket() { Title = item.Replace(" ", ""), TicketNo = item }; PSLDataTemp.Add(tempPSL); } var modelFormCollection = new GetFormCollectionPSLCompletionPip(); modelFormCollection.DateRangeFrom = dateRangeFrom; modelFormCollection.DateRangeEnd = dateRangeEnd; modelFormCollection.Inventory = inventory; modelFormCollection.Rental = rental; modelFormCollection.HID = hid; modelFormCollection.Others = others; modelFormCollection.Area = parent; modelFormCollection.PSLId = pslType; modelFormCollection.PSLType = ""; modelFormCollection.StoreName = ""; ViewBag.ModelFormCollectionPSLCompletionPip = modelFormCollection; ViewBag.ListSalesOfficePipPriority = PSLDataTemp; ViewBag.AreaPriority = parent; ViewBag.Domain = WebConfigure.GetDomain(); return(View()); }
// GET: DashboardCompletionPip public ActionResult DashboardCompletionPip() { this.setViewBag(); var getListArea = pslBS.GetListArea(); var getListSalesOffice = pslBS.GetListSalesOffice(); var getListPSLId = pslBS.GetListPSLNo(); ViewBag.ListArea = getListArea; ViewBag.ListSalesOffice = getListSalesOffice; ViewBag.ListPSLId = getListPSLId; var strArea = new string[] { }; var strSalesOffice = new string[] { }; var strPSLId = new string[] { }; var strPslType = new string[] { }; var strDateFrom = ""; var strDateEnd = ""; ViewBag.DateFrom = strDateFrom; ViewBag.DateEnd = strDateEnd; var strInventory = ""; var strRental = ""; var strHid = ""; var strOthers = ""; var stringArea = ""; var strStoreName = ""; var stringPSLId = ""; var stringPSLType = ""; var hid = ""; var rental = ""; var inventory = ""; var getData = pslBS.GetDataForChartCompletionFilterSafetyCompletion(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); decimal scoreSafety = 0; decimal scoreSafetyLegacy = 0; decimal scorePriority = 0; if (getData.Completed >= 88 && getData.Completed < 93) { scoreSafety = 1; } else if (getData.Completed >= 93 && getData.Completed < 98) { scoreSafety = 2; } else if (getData.Completed >= 98) { scoreSafety = 3; } else { scoreSafety = 0; } ViewBag.ScorePipSafety = scoreSafety; ViewBag.CountPendingData = getData.CountPending; var getDataPriority = pslBS.GetDataForChartCompletionFilterPriority(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); if (getDataPriority.Completed >= 88 && getDataPriority.Completed < 93) { scorePriority = 1; } else if (getDataPriority.Completed >= 93 && getDataPriority.Completed < 98) { scorePriority = 2; } else if (getDataPriority.Completed >= 98) { scorePriority = 3; } else { scorePriority = 0; } ViewBag.ScorePriority = scorePriority; ViewBag.CountPendingPriority = getDataPriority.CountPending; var getDataSafetyLegacy = pslBS.GetDataForChartCompletionFilterSafetyLegacy(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); if (getDataSafetyLegacy.Completed == 0) { scoreSafetyLegacy = 3; } else if (getDataSafetyLegacy.Completed >= 1 && getDataSafetyLegacy.Completed <= 2) { scoreSafetyLegacy = 2; } else if (getDataSafetyLegacy.Completed > 2 && getDataSafetyLegacy.Completed <= 25) { scoreSafetyLegacy = 1; } else if (getDataSafetyLegacy.Completed > 25) { scoreSafetyLegacy = 0; } ViewBag.ScoreSafetyLegacy = scoreSafetyLegacy; ViewBag.CountDataPendingLegacy = getDataSafetyLegacy.Completed; var averageScore = (scoreSafety + scorePriority + scoreSafetyLegacy) / 3; ViewBag.AverageScore = Math.Round(averageScore, 2); var getDataFilterSafetyCompletion = pslBS.GetDataForChartCompletionFilterSafetyCompletion(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); ViewBag.GetDataElementSafetyCompletion = getDataFilterSafetyCompletion.ElementScoreFilterSafetyCompletion; ViewBag.GetDataAreaSafetyCompletion = getDataFilterSafetyCompletion.Area; ViewBag.GetDataPSLIdSafetyCompletion = getDataFilterSafetyCompletion.PSLId; ViewBag.GetDataSalesOfficeSafetyCompletion = getDataFilterSafetyCompletion.SalesOffice; ViewBag.GetDataFilterSafetyCompletion = getDataFilterSafetyCompletion; var getDataFilterPriority = pslBS.GetDataForChartCompletionFilterPriority(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); ViewBag.GetDataElementPriority = getDataFilterPriority.ElementScoreFilterPriority; ViewBag.GetDataAreaPriority = getDataFilterPriority.Area; ViewBag.GetDataPSLIdPriority = getDataFilterPriority.PSLId; ViewBag.GetDataSalesOffice = getDataFilterPriority.SalesOffice; var getDataFilterSafetyLegacy = pslBS.GetDataForChartCompletionFilterSafetyLegacy(strArea, strPSLId, strSalesOffice, strPslType, strDateFrom, strDateEnd, hid, rental, inventory, strOthers); ViewBag.GetDataElementSafetyLegacy = getDataFilterSafetyLegacy.ElementScoreFilterSafetyLegacy; ViewBag.GetDataAreaSafetyLegacy = getDataFilterSafetyLegacy.Area; ViewBag.GetDataPSLIdSafetyLegacy = getDataFilterSafetyLegacy.PSLId; ViewBag.GetDataSalesOfficeSafetyLegacy = getDataFilterSafetyLegacy.SalesOffice; var modelFormCollection = new GetFormCollectionPSLCompletionPip(); modelFormCollection.DateRangeFrom = strDateFrom; modelFormCollection.DateRangeEnd = strDateEnd; modelFormCollection.Inventory = strInventory; modelFormCollection.Rental = strRental; modelFormCollection.HID = strHid; modelFormCollection.Others = strOthers; modelFormCollection.Area = stringArea; modelFormCollection.StoreName = strStoreName; modelFormCollection.PSLId = stringPSLId; modelFormCollection.PSLType = stringPSLType; ViewBag.ModelFormCollectionPSLCompletionPip = modelFormCollection; return(View()); }
public ActionResult DashboardCompletionPip(FormCollection fc) { ViewBag.Domain = WebConfigure.GetDomain(); var dateRangeFrom = ""; var dateRangeEnd = ""; if (fc["dateRange"] != null) { var strList = fc["dateRange"].Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { dateRangeFrom = strList[0]; dateRangeEnd = strList[4]; } else { dateRangeFrom = strList[0]; } } else { dateRangeFrom = ""; dateRangeEnd = ""; } var strDateFrom = (!string.IsNullOrWhiteSpace(dateRangeFrom)) ? dateRangeFrom : ""; var strDateEnd = (!string.IsNullOrWhiteSpace(dateRangeEnd)) ? dateRangeEnd : ""; ViewBag.DateFrom = strDateFrom; ViewBag.DateEnd = strDateEnd; var strInventory = (fc["inventory"] != null) ? fc["inventory"] : ""; var strRental = (fc["rental"] != null) ? fc["rental"] : ""; var strHid = (fc["hid"] != null) ? fc["hid"] : ""; var strOthers = (fc["others"] != null) ? fc["others"] : ""; var strArea = (fc["Area[]"] != null) ? fc["Area[]"] : ""; var strStoreName = (fc["storeName[]"] != null) ? fc["storeName[]"] : ""; var strPSLId = (fc["pslId[]"] != null) ? fc["pslId[]"] : ""; var strPslType = (fc["PSLType[]"] != null) ? fc["PSLType[]"] : ""; var splitArea = new string[] { }; var splitSalesOffice = new string[] { }; var splitPSLId = new string[] { }; var splitPSLType = new string[] { }; if (!string.IsNullOrWhiteSpace(strArea)) { splitArea = strArea.Split(','); } if (!string.IsNullOrWhiteSpace(strStoreName)) { splitSalesOffice = strStoreName.Split(','); } if (!string.IsNullOrWhiteSpace(strPSLId)) { splitPSLId = strPSLId.Split(','); } if (!string.IsNullOrWhiteSpace(strPslType)) { splitPSLType = strPslType.Split(','); } var getData = pslBS.GetDataForChartCompletionFilterSafetyCompletion(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); decimal scoreSafety = 0; decimal scoreSafetyLegacy = 0; decimal scorePriority = 0; if (getData.Completed >= 88 && getData.Completed < 93) { scoreSafety = 1; } else if (getData.Completed >= 93 && getData.Completed < 98) { scoreSafety = 2; } else if (getData.Completed >= 98) { scoreSafety = 3; } ViewBag.ScorePipSafety = scoreSafety; ViewBag.CountPendingData = getData.CountPending; var getDataPriority = pslBS.GetDataForChartCompletionFilterPriority(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); if (getDataPriority.Completed >= 88 && getDataPriority.Completed < 93) { scorePriority = 1; } else if (getDataPriority.Completed >= 93 && getDataPriority.Completed < 98) { scorePriority = 2; } else if (getDataPriority.Completed >= 98) { scorePriority = 3; } ViewBag.ScorePriority = scorePriority; ViewBag.CountPendingPriority = getDataPriority.CountPending; var getDataSafetyLegacy = pslBS.GetDataForChartCompletionFilterSafetyLegacy(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); if (getDataSafetyLegacy.Completed == 0) { scoreSafetyLegacy = 3; } else if (getDataSafetyLegacy.Completed >= 1 && getDataSafetyLegacy.Completed <= 2) { scoreSafetyLegacy = 2; } else if (getDataSafetyLegacy.Completed > 2 && getDataSafetyLegacy.Completed <= 25) { scoreSafetyLegacy = 1; } else if (getDataSafetyLegacy.Completed > 25) { scoreSafetyLegacy = 0; } ViewBag.ScoreSafetyLegacy = scoreSafetyLegacy; ViewBag.CountDataPendingLegacy = getDataSafetyLegacy.Completed; var averageScore = (scoreSafety + scorePriority + scoreSafetyLegacy) / 3; ViewBag.AverageScore = Math.Round(averageScore, 2); var getDataFilterSafetyCompletion = pslBS.GetDataForChartCompletionFilterSafetyCompletion(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); ViewBag.GetDataElementSafetyCompletion = getDataFilterSafetyCompletion.ElementScoreFilterSafetyCompletion; ViewBag.GetDataAreaSafetyCompletion = getDataFilterSafetyCompletion.Area; ViewBag.GetDataPSLIdSafetyCompletion = getDataFilterSafetyCompletion.PSLId; ViewBag.GetDataSalesOfficeSafetyCompletion = getDataFilterSafetyCompletion.SalesOffice; ViewBag.GetDataFilterSafetyCompletion = getDataFilterSafetyCompletion; var getDataFilterPriority = pslBS.GetDataForChartCompletionFilterPriority(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); ViewBag.GetDataElementPriority = getDataFilterPriority.ElementScoreFilterPriority; ViewBag.GetDataAreaPriority = getDataFilterPriority.Area; ViewBag.GetDataPSLIdPriority = getDataFilterPriority.PSLId; ViewBag.GetDataSalesOffice = getDataFilterPriority.SalesOffice; var getDataFilterSafetyLegacy = pslBS.GetDataForChartCompletionFilterSafetyLegacy(splitArea, splitPSLId, splitSalesOffice, splitPSLType, strDateFrom, strDateEnd, strHid, strRental, strInventory, strOthers); ViewBag.GetDataElementSafetyLegacy = getDataFilterSafetyLegacy.ElementScoreFilterSafetyLegacy; ViewBag.GetDataAreaSafetyLegacy = getDataFilterSafetyLegacy.Area; ViewBag.GetDataPSLIdSafetyLegacy = getDataFilterSafetyLegacy.PSLId; ViewBag.GetDataSalesOfficeSafetyLegacy = getDataFilterSafetyLegacy.SalesOffice; var modelFormCollection = new GetFormCollectionPSLCompletionPip(); modelFormCollection.DateRangeFrom = strDateFrom; modelFormCollection.DateRangeEnd = strDateEnd; modelFormCollection.Inventory = strInventory; modelFormCollection.Rental = strRental; modelFormCollection.HID = strHid; modelFormCollection.Others = strOthers; modelFormCollection.Area = strArea; modelFormCollection.PSLId = strPSLId; modelFormCollection.PSLType = strPslType; modelFormCollection.StoreName = strStoreName; ViewBag.ModelFormCollectionPSLCompletionPip = modelFormCollection; var getListArea = pslBS.GetListArea(); var getListSalesOffice = pslBS.GetListSalesOffice(); var getListPSLId = pslBS.GetListPSLNo(); ViewBag.ListArea = getListArea; ViewBag.ListSalesOffice = getListSalesOffice; ViewBag.ListPSLId = getListPSLId; return(View()); }