Example #1
0
        public ActionResult LoadSuppliers()
        {
            RatingsViewModel RatingModel = (RatingsViewModel)TempData["SearchedResults"];

            TempData.Keep("SearchedResults");
            if (RatingModel != null)
            {
                var rateSuppliers = RatingModel.RatingRecords.Select(r => new SelectListItem {
                    Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
                }).ToList();
                //var modifiedlist = selectSuppliers.Select(r => new SelectListItem { Text = r.Text + " CID:" + r.Value, Value = r.Value }).ToList();
                var modifiedlist       = selectSupplierscid;
                var NotinListSuppliers = (from fulllist in modifiedlist
                                          where !(rateSuppliers.Any(i => i.Value == fulllist.Value))
                                          select fulllist).ToList();
                if (NotinListSuppliers != null)
                {
                    ViewBag.Suppliers = NotinListSuppliers;
                }
                else
                {
                    ViewBag.Suppliers = modifiedlist;
                }
            }
            else
            {
                var modifiedlist = selectSupplierscid;
                ViewBag.Suppliers = modifiedlist;
            }
            return(PartialView("_AddSupplier"));
        }
        public ActionResult AddRowReload(int CID)
        {
            //RatingsViewModel RatingModel = new RatingsViewModel();

            RatingsViewModel RatingModel = (RatingsViewModel)TempData["SearchedResults"];

            RatingRecord NewRec = GetSupplierDataByCID(CID, RatingModel.SiteID.Value);

            RatingModel.RatingRecords.Add(NewRec);

            TempData["SearchedResults"] = RatingModel;
            //List<RatingRecord> Records = new List<RatingRecord>();

            //ViewBag.newIndex = count;
            //for(int i =0;i<count; i++)
            //{
            //    RatingRecord empRec = new RatingRecord();
            //    empRec.CID = 0;
            //    Records.Add(empRec);

            //}

            //Records.Add(NewRec);

            //RatingModel.RatingRecords = Records;

            //return PartialView("_AppendRow", RatingModel);
            var rateSuppliers = RatingModel.RatingRecords.Select(r => new SelectListItem {
                Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
            }).ToList();

            ViewBag.RatingSuppliers = rateSuppliers;
            return(PartialView("_SupplierRatings", RatingModel));
        }
        public ActionResult UploadIndex(ExcelRatingsViewModel RatingModel)
        {
            RatingsViewModel rating = new RatingsViewModel();

            rating = Merge(RatingModel);
            TempData["SearchedResults"] = rating;

            var rateSuppliers = rating.RatingRecords.Select(r => new SelectListItem {
                Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
            }).ToList();
            var modifiedlist = selectSuppliers.Select(r => new SelectListItem {
                Text = r.Text + " CID:" + r.Value, Value = r.Value
            }).ToList();

            ViewBag.RatingSuppliers = rateSuppliers;
            var NotinListSuppliers = (from fulllist in modifiedlist
                                      where !(rateSuppliers.Any(i => i.Value == fulllist.Value))
                                      select fulllist).ToList();

            if (NotinListSuppliers != null)
            {
                ViewBag.Suppliers = NotinListSuppliers;
            }
            else
            {
                ViewBag.Suppliers = modifiedlist;
            }
            // ViewBag.Suppliers = modifiedlist;
            return(View("UploadIndex", rating));
        }
Example #4
0
        public List <RatingRecord> IncidentSpendOrder(RatingsViewModel RatingModel)
        {
            List <RatingRecord> recordsChild  = new List <RatingRecord>();
            List <RatingRecord> recordsParent = new List <RatingRecord>();
            List <RatingRecord> Mergedrecords = new List <RatingRecord>();
            List <RatingRecord> Sortedrecords = new List <RatingRecord>();

            using (Repository Rep = new Repository())
            {
                recordsChild = (from site in Rep.Context.SPFS_SITES
                                join spend in Rep.Context.SPFS_SPEND_SUPPLIERS on site.SiteID equals spend.SiteID
                                join sup in Rep.Context.SPFS_SUPPLIERS on spend.CID equals sup.CID
                                where spend.SiteID == RatingModel.SiteID
                                select new RatingRecord
                {
                    CID = spend.CID,
                    SiteID = spend.SiteID,
                    Gdis_org_entity_ID = site.Gdis_org_entity_ID,
                    Gdis_org_Parent_ID = site.Gdis_org_Parent_ID,
                    Reject_incident_count = spend.Reject_incident_count,
                    Reject_parts_count = spend.Reject_parts_count,
                    SupplierName = sup.Name,
                    DUNS = sup.Duns
                }).ToList();

                var parentID = recordsChild.Max(p => p.Gdis_org_Parent_ID);


                recordsParent = (from spend in Rep.Context.SPFS_SPEND_SUPPLIERS
                                 where spend.Gdis_org_Parent_ID == parentID
                                 group spend by new { spend.CID, spend.Gdis_org_Parent_ID } into g
                                 select new RatingRecord
                {
                    CID = g.Key.CID,
                    Gdis_org_Parent_ID = g.Key.Gdis_org_Parent_ID,
                    Total_Spend = g.Sum(x => x.Total_Spend)
                }).ToList();
            }
            Mergedrecords = (from child in recordsChild
                             join parent in recordsParent on
                             new { child.CID, child.Gdis_org_Parent_ID } equals
                             new { parent.CID, parent.Gdis_org_Parent_ID } into merged
                             from m in merged.DefaultIfEmpty()
                             select new RatingRecord
            {
                CID = child.CID,
                DUNS = child.DUNS,
                SiteID = child.SiteID,
                Gdis_org_entity_ID = child.Gdis_org_entity_ID,
                Gdis_org_Parent_ID = child.Gdis_org_Parent_ID,
                Reject_incident_count = child.Reject_incident_count,
                Reject_parts_count = child.Reject_parts_count,
                Total_Spend = m == null ? 0 : m.Total_Spend,
                SupplierName = child.SupplierName
            }).ToList();

            Sortedrecords = Mergedrecords.OrderByDescending(x => x.Reject_incident_count).ThenByDescending(x => x.Total_Spend).ToList();

            return(Sortedrecords);
        }
Example #5
0
        public ActionResult SaveRating(int id, Rating rating)
        {
            if (!ModelState.IsValid)
            {
                var book = _context.Books.SingleOrDefault(b => b.Id == id);

                var viewModel = new RatingsViewModel
                {
                    Rating = new Rating(),
                    Book   = book
                };
                return(View("Ratings", viewModel));
            }
            if (rating.Id == 0)
            {
                _context.Ratings.Add(rating);
            }
            try
            {
                _context.SaveChanges();
            }
            catch (DbEntityValidationException e)
            {
                Console.WriteLine(e);
            }

            return(RedirectToAction("Index", "Books"));
        }
Example #6
0
        public ActionResult Ratings(int id)
        {
            var book      = _context.Books.SingleOrDefault(b => b.Id == id);
            var viewModel = new RatingsViewModel
            {
                Rating = new Rating(),
                Book   = book
            };

            return(View("Ratings", viewModel));
        }
        public RatingsViewModel ViewListVotes(string userId)
        {
            RatingsViewModel vm = new RatingsViewModel();

            vm.Value1 = db.Ratings.Where(x => x.Value == 1 && x.UserId == userId).Count();
            vm.Value2 = db.Ratings.Where(x => x.Value == 2 && x.UserId == userId).Count();
            vm.Value3 = db.Ratings.Where(x => x.Value == 3 && x.UserId == userId).Count();
            vm.Value4 = db.Ratings.Where(x => x.Value == 4 && x.UserId == userId).Count();
            vm.Value5 = db.Ratings.Where(x => x.Value == 5 && x.UserId == userId).Count();

            return(vm);
        }
        public ActionResult SaveData(RatingsViewModel ratingModel)
        {
            if (true)
            {
                ModelState.AddModelError("", "error");
            }

            if (ModelState.IsValid)
            {
            }


            return(View("UploadIndex", ratingModel));
        }
        public ActionResult Ratings()
        {
            var userId  = User.Identity.GetUserId();
            var ratings = _unitOfWork.Ratings.GetUserRatings(userId);

            var viewModel = new RatingsViewModel
            {
                RatingsToDisplay = ratings,
                ShowActions      = true,
                Heading          = "My Ratings"
            };

            return(View("Ratings", viewModel));
        }
Example #10
0
 private static List <RatingRecord> ProdRecords(RatingsViewModel ratingModel, int CheckingDate, Repository Rep)
 {
     return((from ratings in Rep.Context.SPFS_SUPPLIER_RATINGS
             where ratings.SiteID == ratingModel.SiteID && ratings.Rating_period == CheckingDate
             select new RatingRecord
     {
         CID = ratings.CID,
         SiteID = ratings.SiteID,
         Inbound_parts = ratings.Inbound_parts,
         OTR = ratings.OTR,
         OTD = ratings.OTD,
         PFR = ratings.PFR
     }).ToList());
 }
Example #11
0
        public ActionResult MyInteractions()
        {
            var UserId = System.Web.HttpContext.Current.User.Identity.GetUserId();

            MyInteractionsViewModel myInteractions = new MyInteractionsViewModel();

            myInteractions.Interactions = new List <InteractionViewModel>();
            UserToActivityViewModel userToActivity = new UserToActivityViewModel();

            userToActivity.UserToActivities = new List <UserToActivityModel>();
            foreach (var row in db.UserToActivity.Include(n => n.User))
            {
                userToActivity.UserToActivities.Add(row);
            }
            RatingsViewModel ratings = new RatingsViewModel();

            ratings.Ratings = new List <RatingModel>();
            foreach (var rating in db.Rating)
            {
                ratings.Ratings.Add(rating);
            }

            //Selects all activities the user has taken part in.
            foreach (var row in db.UserToActivity.Include(n => n.Activity).Where(n => n.UserId == UserId).Where(n => n.Activity.TimeEnd < DateTime.Now))
            {
                //selects all other participants in those same activities
                foreach (var person in userToActivity.UserToActivities.Where(n => n.ActivityId == row.ActivityId).Where(n => n.UserId != null))
                {
                    //do not include users previously reviewd by this user
                    InteractionViewModel interaction = new InteractionViewModel {
                        Activity = row.Activity
                    };
                    interaction.User = person.User;
                    if (interaction.User.Id != UserId)
                    {
                        myInteractions.Interactions.Add(interaction);
                    }
                    foreach (var rating in ratings.Ratings.Where(n => n.UserId == person.UserId))
                    {
                        if (rating.ReviewerId == UserId)
                        {
                            myInteractions.Interactions.Remove(interaction);
                        }
                    }
                }
            }
            return(View(myInteractions));
        }
Example #12
0
        //public ActionResult LoadAlertData(RatingsViewModel RatingModel, bool isStaging ,bool isLastmonth)
        public ActionResult LoadAlertData(int SiteID, int Year, int Month, bool isStaging, bool isLastmonth)
        {
            RatingsViewModel RatingModel = new RatingsViewModel()
            {
                SiteID = SiteID, Year = Year, Month = Month
            };

            using (Repository Rep = new Repository())
            {
                int CheckingDate;
                if (isStaging)
                {
                    if (isLastmonth)
                    {
                        CheckingDate = Convert.ToInt32("" + RatingModel.Year + (RatingModel.Month - 1).ToString().PadLeft(2, '0'));
                    }
                    else
                    {
                        CheckingDate = Convert.ToInt32("" + RatingModel.Year + (RatingModel.Month).ToString().PadLeft(2, '0'));
                    }
                    RatingModel.RatingRecords = StageRecords(RatingModel, CheckingDate, Rep);
                }
                else
                {
                    CheckingDate = Convert.ToInt32("" + RatingModel.Year + (RatingModel.Month).ToString().PadLeft(2, '0'));
                    RatingModel.RatingRecords = ProdRecords(RatingModel, CheckingDate, Rep);
                }
            }
            CreateListViewBags();
            // ViewBag.Suppliers = selectSuppliers;  ratingModel.RatingRecords = IncidentSpendOrder(ratingModel);

            RatingsViewModel UpdatedModel = Merge(RatingModel);

            var rateSuppliers = UpdatedModel.RatingRecords.Select(r => new SelectListItem {
                Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
            }).ToList();

            LoadDropdowns(rateSuppliers);

            UpdatedModel.ShowResult     = true;
            UpdatedModel.OldResults     = false;
            UpdatedModel.EditMode       = true;
            TempData["SearchedResults"] = UpdatedModel;

            return(View("Index", UpdatedModel));
        }
Example #13
0
        // GET: Ratings
        public ActionResult Index(int?SiteID, bool isUpload = false)
        {
            RatingsViewModel ratingsViewModel = new RatingsViewModel {
                SiteID = SiteID, isUpload = isUpload, RatingRecords = new List <RatingRecord>()
            };

            ratingsViewModel.Month = DateTime.Now.Month - 1;
            ratingsViewModel.Year  = DateTime.Now.Year;

            CreateListViewBags();
            ViewBag.Suppliers = selectSuppliers.Select(r => new SelectListItem {
                Text = r.Text + " CID:" + r.Value, Value = r.Value
            }).ToList();
            ratingsViewModel.ShowResult = false;
            ratingsViewModel.OldResults = false;
            ratingsViewModel.EditMode   = true;
            return(View(ratingsViewModel));
        }
Example #14
0
        public JsonResult UpdateRating(int CID, int Inbound, int OTR, int OTD, int PFR, double PPM, double IPM, double PCT)
        {
            //RatingsViewModel RatingModel = new RatingsViewModel();

            RatingsViewModel RatingModel = (RatingsViewModel)TempData["SearchedResults"];

            RatingRecord Rec = RatingModel.RatingRecords.Where(r => r.CID.Equals(CID)).Select(r =>
            {
                r.Inbound_parts = Inbound;
                r.IPM           = IPM; r.OTD = OTD; r.OTR = OTR; r.PCT = PCT; r.PFR = PFR; r.PPM = PPM; return(r);
            }).FirstOrDefault();


            TempData["SearchedResults"] = RatingModel;


            return(Json(true, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GetSupplierbyName(string nameString, bool?errorCheck)
        {
            if (!errorCheck.HasValue)
            {
                RatingsViewModel RatingModel = (RatingsViewModel)TempData["SearchedResults"];
                TempData.Keep("SearchedResults");
                List <SelectListItem> SupplierList;
                if (RatingModel != null)
                {
                    var rateSuppliers = RatingModel.RatingRecords.Select(r => new SelectListItem {
                        Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
                    }).ToList();
                    var modifiedlist       = selectSupplierscid;
                    var NotinListSuppliers = (from fulllist in modifiedlist
                                              where !(rateSuppliers.Any(i => i.Value == fulllist.Value))
                                              select fulllist).ToList();


                    if (NotinListSuppliers != null)
                    {
                        SupplierList = NotinListSuppliers;
                    }
                    else
                    {
                        SupplierList = modifiedlist;
                    }
                }
                else
                {
                    var modifiedlist = selectSupplierscid;
                    SupplierList = modifiedlist;
                }

                var newSuppliercache = string.IsNullOrWhiteSpace(nameString) ? SupplierList :
                                       SupplierList.Where(s => s.Text.StartsWith(nameString, StringComparison.InvariantCultureIgnoreCase));
                return(Json(newSuppliercache, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var newSuppliercache = string.IsNullOrWhiteSpace(nameString) ? selectSupplierscid :
                                       selectSupplierscid.Where(s => s.Text.StartsWith(nameString, StringComparison.InvariantCultureIgnoreCase));
                return(Json(newSuppliercache, JsonRequestBehavior.AllowGet));
            }
        }
        public RatingsViewModel GetRatings(int vehicleId)
        {
            RatingsViewModel model = new RatingsViewModel()
            {
                ratings = _context.Ratings.Include(x => x.User).Where(x => x.VehicleId == vehicleId).Select(x => new RatingsViewModel.Ratings
                {
                    Comment      = x.Comment,
                    DateReviewed = x.DateReviewed.ToString("dd-MM-yyyy"),
                    User         = new Model.UserViewModel
                    {
                        FirstName = x.User.FirstName,
                        LastName  = x.User.LastName,
                        Username  = x.User.Username
                    },
                    RatingMark = x.RatingMark
                }).OrderByDescending(x => x.DateReviewed).ToList()
            };

            return(model);
        }
Example #17
0
        private ActionResult LoadData(RatingsViewModel ratingModel, bool dataExists)
        {
            CreateListViewBags();
            RatingsViewModel UpdatedModel = new RatingsViewModel();

            // ViewBag.Suppliers = selectSuppliers;  ratingModel.RatingRecords = IncidentSpendOrder(ratingModel);
            if (dataExists)
            {
                UpdatedModel = Merge(ratingModel);

                var rateSuppliers = UpdatedModel.RatingRecords.Select(r => new SelectListItem {
                    Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
                }).ToList();
                LoadDropdowns(rateSuppliers);
            }
            else
            {
                UpdatedModel.RatingRecords = IncidentSpendOrder(ratingModel);
                UpdatedModel.isUpload      = false;
                UpdatedModel.Month         = ratingModel.Month;
                UpdatedModel.Year          = ratingModel.Year;
                UpdatedModel.SiteID        = ratingModel.SiteID;
                SelectSiteGDIS gdis = selectGDIS.Where(g => g.SiteID.Equals(ratingModel.SiteID)).FirstOrDefault();

                UpdatedModel.SiteName = gdis.Name;
                var rateSuppliers = ratingModel.RatingRecords.Select(r => new SelectListItem {
                    Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
                }).ToList();
                LoadDropdowns(rateSuppliers);
            }



            UpdatedModel.ShowResult     = true;
            UpdatedModel.OldResults     = false;
            UpdatedModel.EditMode       = true;
            TempData["SearchedResults"] = UpdatedModel;

            return(View("Index", UpdatedModel));
        }
Example #18
0
        public MovieViewModel GetMoviesByMovieID(int mid, int uid)
        {
            Movies         m   = mr.GetMoviesByMovieID(mid).FirstOrDefault();
            MovieViewModel mvm = null;

            if (m != null)
            {
                var     config = new MapperConfiguration(cfg => { cfg.CreateMap <Movies, MovieViewModel>(); cfg.IgnoreUnmapped(); });
                IMapper mapper = config.CreateMapper();

                mvm = mapper.Map <Movies, MovieViewModel>(m);
                foreach (var item in mvm.Reviews)
                {
                    item.CurrentUserRatingType = 0;
                    RatingsViewModel vote = item.Ratings.Where(temp => temp.UserID == uid).FirstOrDefault();
                    if (vote != null)
                    {
                        item.CurrentUserRatingType = vote.RatingValue;
                    }
                }
            }
            return(mvm);
        }
        private RatingsViewModel Merge(ExcelRatingsViewModel RatingModel)
        {
            List <RatingRecord> Records = (List <RatingRecord>)TempData["RatingRecords"];
            //TempData.Keep("RatingRecords");
            ExcelRatingsViewModel AggregatedModel = AggregateRecords(RatingModel, Records);
            RatingsViewModel      ConvertedModel  = new RatingsViewModel();

            List <RatingRecord> ISORecords = IncidentSpendOrder(RatingModel);
            //List<RatingRecord> HistoryRecords = IncidentSpendOrder(RatingModel);
            List <RatingRecord> MergedRecords    = new List <RatingRecord>();
            List <RatingRecord> UnMatchedRecords = new List <RatingRecord>();

            var query = from x in ISORecords
                        join y in AggregatedModel.RatingRecords
                        on x.CID equals y.CID
                        select new { x, y };

            foreach (var match in query)
            {
                match.x.Inbound_parts         = match.y.Inbound_parts;
                match.x.OTD                   = match.y.OTD;
                match.x.OTR                   = match.y.OTR;
                match.x.PFR                   = match.y.PFR;
                match.x.Reject_incident_count = match.y.Reject_incident_count;
                match.x.Reject_parts_count    = match.y.Reject_parts_count;
                match.x.Temp_Upload_          = match.y.Temp_Upload_;
                match.x.ErrorInformation      = match.y.ErrorInformation;
            }

            //  MergedRecords = ISORecords;
            var unmatch = (from agrr in AggregatedModel.RatingRecords
                           where !(ISORecords.Any(i => i.CID == agrr.CID))
                           select agrr).ToList();

            if (unmatch != null)
            {
                ISORecords.AddRange(unmatch);
            }

            MergedRecords = ISORecords;

            foreach (RatingRecord rec in MergedRecords)
            {
                if (rec.Inbound_parts != 0)
                {
                    double ppm = (double)rec.Reject_parts_count / rec.Inbound_parts;
                    rec.PPM = Math.Round(ppm * 1000000);
                    double ipm = (double)rec.Reject_incident_count / rec.Inbound_parts;
                    rec.IPM = Math.Round((ipm * 1000000), 2);
                }
                else
                {
                    rec.PPM = 0;
                    rec.IPM = 0.00;
                }
                if (rec.OTD != 0)
                {
                    double pct = (double)rec.OTR / rec.OTD;
                    rec.PCT = Math.Round(pct * 100);
                }
                else
                {
                    rec.PCT = 0;
                }
            }
            ConvertedModel.RatingRecords = MergedRecords;
            ConvertedModel.isUpload      = true;
            ConvertedModel.Month         = RatingModel.Month;
            ConvertedModel.Year          = RatingModel.Year;
            ConvertedModel.SiteID        = RatingModel.SiteID;
            SelectSiteGDIS gdis = selectGDIS.Where(g => g.SiteID.Equals(RatingModel.SiteID)).FirstOrDefault();

            ConvertedModel.SiteName = gdis.Name;
            //var count = 0;
            //foreach (var record in GroupedRecords)
            //{
            //    if ((record.ErrorInformation != null ? record.ErrorInformation.Count : 0) > 0)
            //    {
            //        count++;
            //    }
            //}
            return(ConvertedModel);
        }
Example #20
0
        public ActionResult Search(RatingsViewModel ratingModel)
        {
            RatingsViewModel excelViewModel = new RatingsViewModel();
            var      historicalRecords      = new List <HistoricalRecordsCheck>();
            DateTime date    = new DateTime(ratingModel.Year, ratingModel.Month, 01);
            DateTime current = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 01);

            // ratingModel.Month  = Convert.ToInt32(ratingModel.Month.ToString().PadLeft(2, '0'));
            if (current.AddMonths(-4) < date)
            {
                int CheckingDate = Convert.ToInt32("" + ratingModel.Year + ratingModel.Month.ToString().PadLeft(2, '0'));
                List <RatingRecord> StagingRecords              = new List <RatingRecord>();
                List <RatingRecord> CurrentRecords              = new List <RatingRecord>();
                List <RatingRecord> PreviousMonthRecords        = new List <RatingRecord>();
                List <RatingRecord> PreviousMonthRecordsStaging = new List <RatingRecord>();
                Utilities           util = new Utilities();
                using (Repository Rep = new Repository())
                {
                    CurrentRecords = ProdRecords(ratingModel, CheckingDate, Rep);

                    int CurrentCount = CurrentRecords != null ? CurrentRecords.Count : 0;
                    if (CurrentCount <= 0)
                    {
                        StagingRecords = StageRecords(ratingModel, CheckingDate, Rep);

                        if (StagingRecords.Count > 0)
                        {
                            ratingModel.IsStagingRatings = true;
                            ratingModel.RatingRecords    = StagingRecords;
                            ViewBag.divmsg = "Data exists for this rating period that has <strong>Not</strong> been <strong>Submitted</strong>";
                            //There are existing records submitted for this month
                            //display data from staging
                            return(LoadData(ratingModel, ratingModel.IsStagingRatings));
                        }
                        else
                        {
                            if (current.AddMonths(-1) <= date)
                            {
                                int CheckingDate_Previous = Convert.ToInt32("" + date.Year + (date.Month - 1).ToString().PadLeft(2, '0'));

                                PreviousMonthRecords = ProdRecords(ratingModel, CheckingDate_Previous, Rep);

                                if (PreviousMonthRecords.Count > 0)
                                {
                                    //display current months grid
                                    ratingModel.IsPreviousRatings = true;
                                    ratingModel.RatingRecords     = CurrentRecords;
                                    ViewBag.divmsg = "Last month data check was succesfull";
                                    return(LoadData(ratingModel, false));
                                }
                                else
                                {
                                    PreviousMonthRecordsStaging = StageRecords(ratingModel, CheckingDate_Previous, Rep);

                                    if (PreviousMonthRecordsStaging.Count > 0)
                                    {
                                        //you havent submitted last months data. would you like to finish
                                        //Yes - Load last months data
                                        //No - Continue with current ratings
                                        ratingModel.IsAlert = true;
                                        ratingModel.IsPreviousStagingRatings = true;
                                        ViewBag.alertmsg       = "Data exists for last ratings period which has <strong>Not</strong> been <strong>Submitted!</strong>";
                                        ratingModel.ShowResult = false;
                                        ratingModel.EditMode   = false;
                                        CreateListViewBags();
                                        return(View("Index", ratingModel));
                                    }
                                    else
                                    {
                                        //display current months grid
                                        ratingModel.RatingRecords = CurrentRecords;
                                        ViewBag.divmsg            = "This is not current period";
                                        return(LoadData(ratingModel, false));
                                    }
                                }
                            }
                            else
                            {
                                //display grid
                                ratingModel.RatingRecords = CurrentRecords;
                                ViewBag.divmsg            = "This is not current period";
                                return(LoadData(ratingModel, false));
                            }
                        }
                    }
                    else
                    {
                        //data exists for you and any changes will overwrite existing data. Press clear to stop editing submittedratings
                        ratingModel.IsAlert          = true;
                        ratingModel.IsCurrentRatings = true;
                        ViewBag.alertmsg             = "Data exists and has been <strong>Submitted</strong> for this rating period. Do you wish to <strong>Edit</strong> these previously <strong>Submitted</strong> ratings?";
                        ratingModel.ShowResult       = false;
                        ratingModel.EditMode         = false;
                        CreateListViewBags();
                        return(View("Index", ratingModel));
                    }
                }
            }
            else
            {
                int CheckingDate = Convert.ToInt32("" + ratingModel.Year + ratingModel.Month.ToString().PadLeft(2, '0'));
                List <RatingRecord> OldRecords = new List <RatingRecord>();
                using (Repository Rep = new Repository())
                {
                    OldRecords = ProdRecords(ratingModel, CheckingDate, Rep);
                }
                if (OldRecords.Count > 0)
                {
                    List <RatingRecord> OldRecordsUpdated = new List <RatingRecord>();
                    foreach (RatingRecord rec in OldRecords)
                    {
                        rec.DUNS         = GetDUNSfromCID(rec.CID);
                        rec.SupplierName = selectSuppliers.Where(r => r.Value == rec.CID.ToString()).First().Text;
                        OldRecordsUpdated.Add(rec);
                    }
                    ratingModel.RatingRecords = OldRecordsUpdated;

                    CreateListViewBags();
                    // ViewBag.Suppliers = selectSuppliers;
                    RatingsViewModel UpdatedModel = Merge(ratingModel);

                    var rateSuppliers = UpdatedModel.RatingRecords.Select(r => new SelectListItem {
                        Text = r.SupplierName + " CID:" + r.CID, Value = r.CID.ToString()
                    }).ToList();
                    var modifiedlist = selectSuppliers.Select(r => new SelectListItem {
                        Text = r.Text + " CID:" + r.Value, Value = r.Value
                    }).ToList();
                    ViewBag.RatingSuppliers = rateSuppliers;
                    ratingModel.ShowResult  = true;
                    ratingModel.OldResults  = true;
                    ratingModel.EditMode    = false;
                    return(View("Index", UpdatedModel));
                }
                else
                {
                    ratingModel.ShowResult = false;
                    ratingModel.EditMode   = false;
                    CreateListViewBags();
                    return(View("Index", ratingModel));
                }
            }
        }
 public RatingsPage()
 {
     InitializeComponent();
     BindingContext = new RatingsViewModel();
 }
Example #22
0
 public ActionResult SubmitData(RatingsViewModel ratingModel)
 {
     return(View("Index", ratingModel));
 }
Example #23
0
        private RatingsViewModel Merge(RatingsViewModel RatingModel)
        {
            RatingsViewModel RateModel = new RatingsViewModel();

            List <RatingRecord> ISORecords    = IncidentSpendOrder(RatingModel);
            List <RatingRecord> MergedRecords = new List <RatingRecord>();
            //List<RatingRecord> UnMatchedRecords = new List<RatingRecord>();

            var query = from x in ISORecords
                        join y in RatingModel.RatingRecords
                        on x.CID equals y.CID
                        select new { x, y };

            foreach (var match in query)
            {
                match.x.Inbound_parts    = match.y.Inbound_parts;
                match.x.OTD              = match.y.OTD;
                match.x.OTR              = match.y.OTR;
                match.x.PFR              = match.y.PFR;
                match.x.Temp_Upload_     = match.y.Temp_Upload_;
                match.x.ErrorInformation = match.y.ErrorInformation;
            }

            //  MergedRecords = ISORecords;
            //var unmatch = (from agrr in RatingModel.RatingRecords
            //               where !(ISORecords.Any(i => i.CID == agrr.CID))
            //               select agrr).ToList();
            //if (unmatch != null)
            //{
            //    ISORecords.AddRange(unmatch);
            //}

            MergedRecords = ISORecords;
            foreach (RatingRecord rec in MergedRecords)
            {
                if (rec.Inbound_parts != 0)
                {
                    double ppm = (double)rec.Reject_parts_count / rec.Inbound_parts;
                    rec.PPM = Math.Round(ppm * 1000000);
                    double ipm = (double)rec.Reject_incident_count / rec.Inbound_parts;
                    rec.IPM = Math.Round((ipm * 1000000), 2);
                }
                else
                {
                    rec.PPM = 0;
                    rec.IPM = 0.00;
                }
                if (rec.OTD != 0)
                {
                    double pct = (double)rec.OTR / rec.OTD;
                    rec.PCT = Math.Round(pct * 100);
                }
                else
                {
                    rec.PCT = 0;
                }
            }
            RateModel.RatingRecords = MergedRecords;
            RateModel.isUpload      = false;
            RateModel.Month         = RatingModel.Month;
            RateModel.Year          = RatingModel.Year;
            RateModel.SiteID        = RatingModel.SiteID;
            SelectSiteGDIS gdis = selectGDIS.Where(g => g.SiteID.Equals(RatingModel.SiteID)).FirstOrDefault();

            RateModel.SiteName = gdis.Name;

            return(RateModel);
        }