Exemplo n.º 1
0
        /// <summary>
        /// Check GoalSet value and CategoryL1 and CategoryL2 values
        /// and determine if selections are valid children of each
        /// </summary>
        /// <param name="sheetData"></param>
        public static bool ValidateGoalSetCategories(DomainManager domainManager, Dictionary <string, string> originalLookup, KPListItem item, ImportStatus importErrors)
        {
            string ERR_CATL1_MISMATCH         = "Row: {0}, CategoryL1 Mismatch: {1}";
            string ERR_CATL2_MISMATCH         = "Row: {0}, CategoryL2 Mismatch: {1}";
            string ERR_CATL1_INVALID          = "Row: {0}, CategoryL1 has an invalid value so unable to match CategoryL2: {1}";
            string ERR_MISSING_CATEGORY_VALUE = "Row {0} contains a value for Category Level 2, but not for Category Level 1.";
            string ERR_MISSING_GOALSET_VALUE  = "Row {0} does not contain a value for GoalSet, but has values for Category Level 1 or 2. Please include GoalSet.";

            bool success           = true;
            bool categoryL1Invalid = false;

            // keep item count to message user
            int itemCount = 1;

            // have CL1 or CL2 missing goal set
            if ((item.ContainsKey("CategoryL1") || item.ContainsKey("CategoryL2")) && !item.ContainsKey("GoalSet"))
            {
                importErrors.Messages.Add(string.Format(ERR_MISSING_GOALSET_VALUE, itemCount + 1));
                importErrors.SkippedRowCount++;
            }
            else
            {
                // have CL2 missing CL1
                if (item.ContainsKey("CategoryL2") && !item.ContainsKey("CategoryL1"))
                {
                    importErrors.Messages.Add(string.Format(ERR_MISSING_CATEGORY_VALUE, itemCount + 1));
                    importErrors.SkippedRowCount++;
                    success = false;
                }
                else
                {
                    // we do have a CL1
                    if (item.ContainsKey("CategoryL1"))
                    {
                        // get the mapped value
                        CategoryL1 CL1 = domainManager.CategoryL1Repository.Items.Find(cl1 => cl1.KPID.ToString() == item["CategoryL1"].Value);

                        // if we have one check if the CategoryL1 is in the GoalSet
                        if (CL1 == null || CL1.GoalSetId.ToString() != item["GoalSet"].Value)
                        {
                            importErrors.Messages.Add(string.Format(ERR_CATL1_MISMATCH, itemCount, originalLookup["CategoryL1"]));
                            importErrors.SkippedColumns.Add("Category L1: [No GoalSet]");
                            item["CategoryL1"].Value = string.Empty;
                            categoryL1Invalid        = true;
                            success = false;
                        }
                    }

                    if (item.ContainsKey("CategoryL2"))
                    {
                        if (!categoryL1Invalid)
                        {
                            CategoryL2 CL2 = domainManager.CategoryL2Repository.Items.Find(cl2 => cl2.KPID.ToString() == item["CategoryL2"].Value);
                            // check if the CategoryL2 is in the CategoryL1
                            if (CL2 == null || CL2.CategoryL1Id.ToString() != item["CategoryL1"].Value)
                            {
                                importErrors.Messages.Add(string.Format(ERR_CATL2_MISMATCH, itemCount, originalLookup["CategoryL2"]));
                                importErrors.SkippedColumns.Add("Category L2: [Invalid]");
                                item["CategoryL2"].Value = string.Empty;
                                success = false;
                            }
                        }
                        else
                        {
                            importErrors.Messages.Add(string.Format(ERR_CATL1_INVALID, itemCount, originalLookup["CategoryL2"]));
                            importErrors.SkippedColumns.Add("Category L2: [No Category L1]");
                            item["CategoryL2"].Value = string.Empty;
                            success = false;
                        }
                    }

                    itemCount++;
                }
            }
            return(success);
        }
Exemplo n.º 2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="ctx"></param>
        /// <param name="entityName"></param>
        /// <param name="dataMsg"></param>
        /// <returns></returns>
        public Message SaveLookup(WebOperationContext ctx, string entityName, Message dataMsg)
        {
            Message responseMsg = null;
            string  jsonData    = JSON.GetPayload(dataMsg);

            try
            {
                switch (entityName)
                {
                case "EntityLinks":
                    EntityLinks entityLinks = this.SaveLookup <EntityLinks>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <EntityLinks>(ctx, entityLinks, this.timer);
                    break;

                case "EventLogging":
                    EventLogger eventLogger = this.SaveLookup <EventLogger>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <EventLogger>(ctx, eventLogger, this.timer);
                    break;

                case "KPAdmins":
                    Admin kpAdmin = this.SaveLookup <Admin>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <Admin>(ctx, kpAdmin, this.timer);
                    break;

                case "KPCategoryL1":
                    CategoryL1 kpCatL1 = this.SaveLookup <CategoryL1>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <CategoryL1>(ctx, kpCatL1, this.timer);
                    break;

                case "KPCategoryL2":
                    CategoryL2 kpCatL2 = this.SaveLookup <CategoryL2>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <CategoryL2>(ctx, kpCatL2, this.timer);
                    break;

                case "KPConfigList":
                    ConfigList kpConfigList = this.SaveLookup <ConfigList>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <ConfigList>(ctx, kpConfigList, this.timer);
                    break;

                //case "KPCountry":
                //    Country kpCountry = this.SaveLookup<Country>(entityName, jsonData);
                //    responseMsg = ctx.CreateJsonResponse<Country>(kpCountry);
                //    break;
                case "KPCustomers":
                    Customer kpCustomers = this.SaveLookup <Customer>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <Customer>(ctx, kpCustomers, this.timer);
                    break;

                //case "KPEffortInstances":
                //    EffortInstance kpEffortInstances = this.SaveLookup<EffortInstance>(entityName, jsonData);
                //    responseMsg = ctx.CreateJsonResponse<EffortInstance>(kpEffortInstances);
                //    break;
                //case "KPEfforts":
                //    Effort kpEfforts = this.SaveLookup<Effort>(entityName, jsonData);
                //    responseMsg = ctx.CreateJsonResponse<Effort>(kpEfforts);
                //    break;
                case "KPGoalSetLocks":
                    GoalSetLock kpGoalSetLock = this.SaveLookup <GoalSetLock>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <GoalSetLock>(ctx, kpGoalSetLock, this.timer);
                    break;

                case "KPGoalSets":
                    GoalSet kpGoalSet = this.SaveLookup <GoalSet>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <GoalSet>(ctx, kpGoalSet, this.timer);
                    break;

                //case "KPPerspectives":
                //    Perspective kpPerspective = this.SaveLookup<Perspective>(entityName, jsonData);
                //    responseMsg = ctx.CreateJsonResponse<Perspective>(kpPerspective);
                //    break;
                case "KPPerspectiveInstances":
                    PerspectiveInstance kpPerspectiveInstance = this.SaveLookup <PerspectiveInstance>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <PerspectiveInstance>(ctx, kpPerspectiveInstance, this.timer);
                    break;

                case "KingpinLockdown":
                    KingpinLockdown lockdown = this.SaveLookup <KingpinLockdown>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <KingpinLockdown>(ctx, lockdown, this.timer);
                    break;

                case "Announcements":
                    Announcement announcement = this.SaveLookup <Announcement>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <Announcement>(ctx, announcement, this.timer);
                    break;

                case "KPTeams":
                    Team kpTeam = this.SaveLookup <Team>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <Team>(ctx, kpTeam, this.timer);
                    break;

                case "KPVPs":
                    VP kpVP = this.SaveLookup <VP>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <VP>(ctx, kpVP, this.timer);
                    break;

                case "OneOffConfigurations":
                    OneOffConfiguration oneOffConfiguration = this.SaveLookup <OneOffConfiguration>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <OneOffConfiguration>(ctx, oneOffConfiguration, this.timer);
                    break;

                case "UserEventLogging":
                    UserLogging userEvent = this.SaveLookup <UserLogging>(entityName, jsonData);
                    responseMsg = HttpUtilities.GenerateResponse <UserLogging>(ctx, userEvent, this.timer);
                    break;

                default:
                    string errMsg = string.Format("Error: No lookup list found with the name: {0}", entityName);
                    responseMsg = HttpUtilities.GenerateExceptionResponse(ctx, new Exception(errMsg), "POST/PUT", HttpStatusCode.BadRequest);
                    break;
                }
            }
            catch (Exception ex)
            {
                responseMsg = HttpUtilities.GenerateExceptionResponse(ctx, ex, "POST/PUT", HttpStatusCode.InternalServerError);
            }

            this.timer.Stop();
            return(responseMsg);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Gets the lookup value for an item field
        /// TODO: Create an IRespository
        /// </summary>
        /// <param name="fieldName"></param>
        /// <param name="fieldValue"></param>
        /// <returns></returns>
        public string GetLookupValue(string fieldName, string fieldValue, string lookupField)
        {
            string value = string.Empty;

            switch (fieldName)
            {
            case "KPTeam":
                Team team = this.spDataAccess.Teams.Find(i => i.Nick == fieldValue || i.Title == fieldValue);
                value = (team != null) ? team.KPID.ToString() : string.Empty;
                break;

            case "GoalSet":
                GoalSet goalSet = this.GoalSetRepository.Items.Find(i => i.Title == fieldValue);
                value = (goalSet != null) ? goalSet.KPID.ToString() : string.Empty;
                break;

            case "KPPrimaryVP":
                VP vp = this.VPRepository.Items.Find(i => i.Nick == fieldValue);
                value = (vp != null) ? vp.KPID.ToString() : string.Empty;
                break;

            case "KPSecondaryVPs":
                // handle multiple
                string[]      values;
                List <string> newValues = new List <string>();
                if (fieldValue.Contains(","))
                {
                    values = fieldValue.Split(',');
                    foreach (string val in values)
                    {
                        VP svp = this.VPRepository.Items.Find(i => i.Nick == val);
                        value = (svp != null) ? svp.KPID.ToString() : string.Empty;
                        // leave loop since we have a value mismatch
                        if (string.IsNullOrEmpty(value))
                        {
                            break;
                        }
                        // otherwise we'll continue adding values
                        newValues.Add(value);
                        value = string.Join(",", newValues.ToArray());
                    }
                }
                else
                {
                    VP svp = this.VPRepository.Items.Find(i => i.Nick == fieldValue);
                    value = (svp != null) ? svp.KPID.ToString() : string.Empty;
                }
                break;

            case "CategoryL1":
                CategoryL1 catL1 = this.CategoryL1Repository.Items.Find(i => i.Title == fieldValue);
                value = (catL1 != null) ? catL1.KPID.ToString() : string.Empty;
                break;

            case "CategoryL2":
                CategoryL2 catL2 = this.CategoryL2Repository.Items.Find(i => i.Title == fieldValue);
                value = (catL2 != null) ? catL2.KPID.ToString() : string.Empty;
                break;
            }

            return(value);
        }