public static void SetCategories(Categories categories)
        {
            Category category = categories[tennisCat1];

            if (category == null)
            {
                categories.Add(tennisCat1, OlCategoryColor.olCategoryColorDarkOlive);
            }
            category = categories[tennisCat2];
            if (category == null)
            {
                categories.Add(tennisCat2, OlCategoryColor.olCategoryColorDarkGreen);
            }
            category = categories[tennisCat3];
            if (category == null)
            {
                categories.Add(tennisCat3, OlCategoryColor.olCategoryColorDarkBlue);
            }
            category = categories[cancelledTennisCat];
            if (category == null)
            {
                categories.Add(cancelledTennisCat, OlCategoryColor.olCategoryColorDarkRed);
            }
            //else
            //{
            //    categories.Remove( tennisCat1 );
            //    categories.Add( tennisCat1, Outlook.OlCategoryColor.olCategoryColorDarkOlive );
            //    categories.Remove( tennisCat2 );
            //    categories.Add( tennisCat2, Outlook.OlCategoryColor.olCategoryColorDarkGreen );
            //    //
            //}
        }
 private bool Excluded(ITestMethodInfo testMethod) {
    if(_excludedCategories.IsEmpty) {
       return false;
    }
    var local = new Categories();
    local.Add(testMethod.Categories);
    local.Add(testMethod.InheritedCategories);
    return local.Intersect(_excludedCategories).Count > 0;
 }
Beispiel #3
0
        public void AddFiresModifiedEventOnlyIfSomethingHasBeenAdded()
        {
            var eventListener = new ModifiedListener();
            var cats          = new Categories();

            cats.Add("bla");
            cats.Modified += eventListener.OnModified;
            cats.Add("bla"); // adding the same shouldn't fire
            Assert.Equals(0, eventListener.EventCount,
                          "Modified event was fired unnecessarily.");
        }
Beispiel #4
0
        private bool Excluded(ITestMethodInfo testMethod)
        {
            if (_excludedCategories.IsEmpty)
            {
                return(false);
            }
            var local = new Categories();

            local.Add(testMethod.Categories);
            local.Add(testMethod.InheritedCategories);
            return(local.Intersect(_excludedCategories).Count > 0);
        }
Beispiel #5
0
        private bool IsIncluded(ITestFixture testFixture)
        {
            if (_includedCategories.IsEmpty ||
                (testFixture.Categories.IsEmpty &&
                 testFixture.InheritedCategories.IsEmpty))
            {
                return(true);
            }
            var local = new Categories();

            local.Add(testFixture.Categories);
            local.Add(testFixture.InheritedCategories);
            return(local.Intersect(_includedCategories).Count > 0);
        }
        public void PopulateDropdown()
        {
            Games.Clear();
            var context = DataEntitiesProvider.Provide();

            Categories.Clear();
            Categories.Add(new GameCategoryVm()
            {
                Id = 0, Name = "(No category)"
            });
            foreach (var c in context.GameCategories.Select(x => new GameCategoryVm {
                Id = x.Id, Name = x.NAME
            }))
            {
                Categories.Add(c);
            }

            Games.Add(new GameVm {
                Text = "New Game", Value = 0
            });
            foreach (var game in context.Games.OrderBy(x => x.Code))
            {
                Games.Add(new GameVm {
                    Text = game.Code + " : " + game.Mind_Sport, Value = game.Id
                });
            }
        }
        protected override void Awake()
        {
            base.Awake();

            Categories.Add(QuickMenuType.Placed, PlacedCategory);
            Categories.Add(QuickMenuType.Recent, RecentCategory);
        }
        public TravelListDetailViewModel(string id, Geoposition positionUser)
        {
            AddItemCommand         = new RelayCommand(AddItem);
            DeleteItemCommand      = new RelayCommand(DeleteItem);
            ShowDestinationCommand = new RelayCommand(ShowDestination);
            UserLocation           = new Geopoint(new BasicGeoposition()
            {
                Latitude = positionUser.Coordinate.Latitude, Longitude = positionUser.Coordinate.Longitude
            });
            Task task = Task.Run(async() =>
            {
                TravelList     = await http.GetAsync <TravelList>($"http://localhost:5000/api/TravelList/{id}");
                TravelLocation = new Geopoint(new BasicGeoposition()
                {
                    Latitude = TravelList.Location.LatCoord, Longitude = TravelList.Location.LngCoord
                });
                var categories = await http.GetAsync <List <Category> >($"http://localhost:5000/api/User/GetCategories");
                categories.ForEach(x =>
                {
                    Categories.Add(x);
                });

                TravelList.Items.ForEach(item =>
                {
                    Items.Add(item);
                });
            });

            task.Wait();
            PopulateListView();
        }
Beispiel #9
0
        public void EmptyStringIsIgnoredAsCategory()
        {
            var cats = new Categories();

            cats.Add(string.Empty);
            Assert.Equals(0, cats.Count);
        }
Beispiel #10
0
        private void CategoryLoad()
        {
            string text;

            string[] items;
            string[] splits = new string[1];
            splits[0] = OVERHEAD;

            try
            {
                foreach (var txtFile in categoryDirectoryInfo.GetFiles())
                {
                    text  = File.ReadAllText(CATEGORY_FILE_PATH + txtFile);
                    items = text.Split(splits, StringSplitOptions.RemoveEmptyEntries);

                    Category category = new Category
                    {
                        Name = items[0],
                        Kind = (ECategory)Enum.Parse(typeof(ECategory), items[1])
                    };


                    Categories.Add(category);
                    CategoryNames.Add(category.Name);
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex + DateTime.Now.ToLongTimeString());
            }
        }
        private async System.Threading.Tasks.Task LoadCategories()
        {
            Categories.Clear();
            if (Project != null)
            {
                try
                {
                    Project.Categories = Categories;
                    List <Category> categories = await _taskService.ReadAllCategoriesByProjectAsync(Project);

                    foreach (var category in categories)
                    {
                        Categories.Add(category);
                    }

                    List <User> users = await _adminService.ReadAllUsersByProjectAsync(Project);

                    Project.ProjectUsers.Clear();
                    foreach (var user in users)
                    {
                        Project.ProjectUsers.Add(user);
                    }
                }
                catch (TimeoutException timeoutEx)
                {
                    _eventAggregator.GetEvent <TimeoutErrorEvent>().Publish(timeoutEx);
                }
            }
        }
Beispiel #12
0
        /// <summary>
        /// Constructs a new EmailListEntry instance with the appropriate category
        /// to indicate that it is a email list.
        /// </summary>
        public EmailListEntry()
            : base()
        {
            Categories.Add(EMAILLIST_CATEGORY);

            GAppsExtensions.AddProvisioningExtensions(this);
        }
Beispiel #13
0
        public PageResult(Data.Entity.Models.Page page, string culture)
        {
            Id              = page.Id;
            Brand           = page.Company.Slug;
            Tenant          = page.Tenant?.Slug;
            Name            = page.Translations.FirstOrDefault(t => t.Language.Culture == culture)?.Name;
            Title           = page.Translations.FirstOrDefault(t => t.Language.Culture == culture)?.Title;
            Description     = page.Translations.FirstOrDefault(t => t.Language.Culture == culture)?.Description;
            H2              = page.Translations.FirstOrDefault(t => t.Language.Culture == culture)?.Header;
            BackgroundImage = page.BackgroundImage;
            CtaText         = page.Translations.FirstOrDefault(t => t.Language.Culture == culture)?.CallToAction;
            CtaLink         = page.CallToActionLink;
            Custom          = page.Custom is null ? null : JsonConvert.DeserializeObject <dynamic>(page.Custom);
            FeaturedImage   = page.FeaturedImage;
            Slug            = page.Slug;

            var imageResults = page.Images.OrderBy(i => i.Order).Select(i => new ImageResult(i));

            Images.AddRange(imageResults);

            var storyResults = page.Cards.OrderBy(c => c.Order).Select(c => new StoryResult(c.Id, c.Text,
                                                                                            c.CallToAction,
                                                                                            c.CallToActionUrl, c.BackgroundUrl, c.PosterUrl, c.CardType));

            Stories.AddRange(storyResults);

            if (page.Category != null)
            {
                Categories.Add(new CategoryResult(page.Category));
            }

            AddHotelModule(page.Hotel, culture);
        }
Beispiel #14
0
        public async Task <IActionResult> OnGetAsync(string id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            Performances = await Context.Performances
                           .Include(p => p.Theatre)
                           .Include(p => p.PerformanceDates)
                           .Include(p => p.PerformanceCategories)
                           .FirstOrDefaultAsync(m => m.Id == id);

            if (Performances == null)
            {
                return(NotFound());
            }

            foreach (var item in Performances.PerformanceCategories)
            {
                Categories.Add(Context.Categories.FirstOrDefault(c => c.Id == item.CategoryId));
            }

            this.returnToPage = returnToPage;
            return(Page());
        }
Beispiel #15
0
        private void OnDeserialized(StreamingContext context)
        {
            foreach (var token in _additionalData["categories"])
            {
                Categories.Add(token["description"].ToString());
            }

            foreach (var token in _additionalData["genres"])
            {
                Genres.Add(token["description"].ToString());
            }

            if (_additionalData.ContainsKey("recommendations"))
            {
                var token = _additionalData["recommendations"];
                if (token["total"] != null)
                {
                    RecommendationCount = token["total"].ToObject <int>();
                }
            }

            if (_additionalData.ContainsKey("metacritic"))
            {
                var token = _additionalData["metacritic"];
                if (token["total"] != null)
                {
                    MetacriticScore = token["score"].ToObject <int>();
                }
            }
        }
Beispiel #16
0
        public override void Populate()
        {
            var          txtFileLines = File.ReadAllLines(Install.GetPath("misc.txt"));
            var          typeNames    = txtFileLines[1].Split(Separators);
            TileCategory category     = null;

            for (int i = 2; i < txtFileLines.Length; i++)
            {
                var infos = txtFileLines[i].Split('\t');

                if (infos[1] == "0")
                {
                    category      = new TileCategory(Int32.Parse(infos[2]));
                    category.Name = infos.Last();
                    Categories.Add(category);
                }
                var style = new TileStyle();
                category.AddStyle(style);
                style.Name  = infos.Last();
                style.Index = Int32.Parse(infos[1]);
                for (int j = 3; j < typeNames.Length - 2; j++)
                {
                    if (infos[j] != "0")
                    {
                        var tile = new TileMisc {
                            Id = short.Parse(infos[j])
                        };
                        style.AddTile(tile);
                    }
                }
            }
            TilesCategorySDKModule.Supp.PositionCheck(Categories);
        }
Beispiel #17
0
        public void AddTag(IDmKeyword tagReference)
        {
            switch (tagReference.Type)
            {
            case TagType.Autor:
                Autors.Add((DmAutor)tagReference);
                break;

            case TagType.Category:
                Categories.Add((DmCategory)tagReference);
                break;

            case TagType.Genre:
                Genres.Add((DmGenre)tagReference);
                break;

            case TagType.People:
                Peoples.Add((DmPeople)tagReference);
                break;

            case TagType.Tag:
                Keywords.Add((DmKeyword)tagReference);
                break;

            case TagType.Collection:
                Collections.Add((DmCollection)tagReference);
                break;
            }
        }
Beispiel #18
0
        private void UpdateCategories()
        {
            var oldSelectedCategory = _selectedCategory;

            Categories.Clear();
            var allCategory = new ItemCategory {
                ID = -1, Name = "All"
            };

            Categories.Add(new ItemCategoryVM {
                Model = allCategory
            });
            using (var context = new ERPContext())
            {
                var categoriesFromDatabase = context.Categories.OrderBy(category => category.Name);
                foreach (var category in categoriesFromDatabase)
                {
                    Categories.Add(new ItemCategoryVM {
                        Model = category
                    });
                }
            }

            UpdateSelectedCategory(oldSelectedCategory);
        }
Beispiel #19
0
        /// <summary>
        /// This method retrieves the most up-to-date list of categories from the database.
        /// </summary>
        /// <returns>True if success, false otherwise.</returns>
        public async Task <bool> RefreshCategoriesAsync()
        {
            // Load the categories from the Database
            string query = "SELECT id_category, category_name FROM project_category";

            SqlCommand cmd = DBSqlHelper.Connection.CreateCommand();

            cmd.CommandText = query;

            // Execute query
            using (DbDataReader reader = await cmd.ExecuteReaderAsync())
            {
                // Check if category exists
                if (reader.HasRows)
                {
                    Categories.Clear();

                    while (await reader.ReadAsync())
                    {
                        Category category = new Category((int)reader[0], reader[1].ToString());
                        Categories.Add(category);
                    }

                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
Beispiel #20
0
        private void OnAddCategory(string value)
        {
            var values =
                InteractionService.UserIntraction
                .GetStringFromUser(Resources.Categories, Resources.AddCategoryHint)
                .Where(x => !Categories.Select(y => y.Name).Contains(x)).Distinct().ToList();

            foreach (string val in values)
            {
                Categories.Add(new ScreenMenuCategoryViewModel(Model.AddCategory(val)));
            }
            if (values.Any())
            {
                var answer = InteractionService.UserIntraction.AskQuestion(
                    Resources.AutoSelectProductsQuestion);
                if (answer)
                {
                    foreach (var val in values)
                    {
                        var menuItems = GetMenuItemsByGroupCode(val);
                        if (menuItems.Any())
                        {
                            Model.AddItemsToCategory(val, menuItems.ToList());
                        }
                    }
                }
            }
        }
Beispiel #21
0
        /// <summary>
        /// Initializes a new instance of the <see cref="PointScheme"/> class.
        /// </summary>
        public PointScheme()
        {
            Configure();
            PointCategory def = new PointCategory();

            Categories.Add(def);
        }
Beispiel #22
0
        /// <summary>
        /// Initializes a new instance of the <see cref="PointScheme"/> class.
        /// </summary>
        /// <param name="extent">The geographic point size for the default will be 1/100th the specified extent.</param>
        public PointScheme(IRectangle extent)
        {
            Configure();
            PointCategory def = new PointCategory(extent);

            Categories.Add(def);
        }
Beispiel #23
0
        public override void Populate()
        {
            var          txtFileLines = File.ReadAllLines(DataManager.Location.LocalPath + "roofs.txt");
            var          typeNames    = txtFileLines[1].Split(Separators);
            TileCategory category     = null;

            for (int i = 2; i < txtFileLines.Length; i++)
            {
                var infos = txtFileLines[i].Split('\t');

                if (infos[1] == "0")
                {
                    category = new TileCategory(Int32.Parse(infos[2]), TypeTile.Roofs)
                    {
                        Name = infos.Last()
                    };
                    Categories.Add(category);
                }
                var style = new TileStyle();
                category.AddStyle(style);
                style.Name = infos.Last();
                style.Id   = Int32.Parse(infos[1]);
                for (int j = 3; j < typeNames.Length - 3; j++)
                {
                    if (infos[j] != "0")
                    {
                        var tile = new TileRoof {
                            Id = uint.Parse(infos[j])
                        };
                        style.AddTile(tile);
                        tile.Position = (j - 2);
                    }
                }
            }
        }
Beispiel #24
0
 public void AddCategory(List <string> categoryList)
 {
     foreach (string category in categoryList)
     {
         Categories.Add(category);
     }
 }
Beispiel #25
0
        async Task ExecuteLoadCategoriesCommand()
        {
            if (IsBusy)
            {
                return;
            }

            IsBusy = true;

            try
            {
                Categories.Clear();
                await DataStore.UpdateLocal();

                var categories = await DataStore.GetCategoriesAsync(true);

                foreach (var category in categories)
                {
                    Categories.Add(category);
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
            }
            finally
            {
                IsBusy = false;
            }
        }
Beispiel #26
0
 private void OnAddCategory(string value)
 {
     string[] values = InteractionService.UserIntraction.GetStringFromUser(Resources.Categories, Resources.AddCategoryHint);
     foreach (string val in values)
     {
         Categories.Add(new ScreenMenuCategoryViewModel(Model.AddCategory(val)));
     }
     if (values.Count() > 0)
     {
         bool answer = InteractionService.UserIntraction.AskQuestion(
             Resources.AutoSelectProductsQuestion);
         if (answer)
         {
             foreach (var val in values)
             {
                 //TODO EF ile çalışırken tolist yapmazsak count sql sorgusu üretiyor mu kontrol et.
                 var menuItems = GetMenuItemsByGroupCode(val).ToList();
                 if (menuItems.Count > 0)
                 {
                     Model.AddItemsToCategory(val, menuItems);
                 }
             }
         }
     }
 }
Beispiel #27
0
        internal void AddImageCategories(List <string> imageNames)
        {
            List <string> rootCategories = new List <string>();

            foreach (string imageName in imageNames)
            {
                foreach (string category in imageName.Split(new char[] { '_' }, StringSplitOptions.RemoveEmptyEntries))
                {
                    if (!rootCategories.Contains(category))
                    {
                        rootCategories.Add(category);
                        CategoryString categoryString = null;
                        foreach (CategoryString cat in Categories)
                        {
                            if (cat.Name == category)
                            {
                                categoryString = cat;
                                break;
                            }
                        }
                        if (categoryString == null)
                        {
                            categoryString = new CategoryString(this, category);
                            Categories.Add(categoryString);
                        }
                    }
                }
            }
        }
        async Task ExecuteLoadCategoriesCommand()
        {
            IsBusy = true;
            try
            {
                Categories.Clear();
                var categories = await DataStore.GetCategoriesAsync();

                foreach (var category in categories)
                {
                    Categories.Add(category);
                }
                var categorySelected = await DataStore.GetCategoryByTitleAsync(CategoryName);

                SelectedDepartment = categorySelected;
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
            }
            finally
            {
                IsBusy = false;
            }
        }
Beispiel #29
0
 /// <summary>
 /// Construct attribute for a given category based on
 /// a name. The name may not contain the characters ',',
 /// '+', '-' or '!'. However, this is not checked in the
 /// constructor since it would cause an error to arise at
 /// as the test was loaded without giving a clear indication
 /// of where the problem is located. The error is handled
 /// in NUnitFramework.cs by marking the test as not
 /// runnable.
 /// </summary>
 /// <param name="name">The name of the category</param>
 public CategoryAttribute(string names)
 {
     foreach (string name in names.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
     {
         Categories.Add(name.Trim());
     }
 }
Beispiel #30
0
 public void AddCategoriesFiresModifiedEvent() {
    var eventListener = new ModifiedListener();
    var cats = new Categories();
    cats.Modified += eventListener.OnModified;
    var otherCats = new Categories();
    otherCats.Add(new[] { "red", "green", "blue" });
    cats.Add(otherCats);
    Assert.Equals(1, eventListener.EventCount, "Modified event wasn't fired.");
 }
Beispiel #31
0
 public void AddFiresModifiedEventOnlyIfSomethingHasBeenAdded() {
    var eventListener = new ModifiedListener();
    var cats = new Categories();
    cats.Add("bla");
    cats.Modified += eventListener.OnModified;
    cats.Add("bla"); // adding the same shouldn't fire
    Assert.Equals(0, eventListener.EventCount, 
       "Modified event was fired unnecessarily.");
 }
 public void ExcludedSurvivesRefresh() {
    RecipeFactory.Type = typeof(ASpecialRecipe);
    RecipeFactory.NewRecipe(string.Empty);
    _fc.ResetAllCategories();
    _fc.ExcludeCategory("Blue");
    _fc.RefreshCategoriesList();
    var expected = new Categories();
    expected.Add("Blue");
    Assert.Equals(expected, _fc.ExcludedCategories);
 }
Beispiel #33
0
 private bool IsIncluded(ITestFixture testFixture) {
    if(   _includedCategories.IsEmpty
       || (testFixture.Categories.IsEmpty
       && testFixture.InheritedCategories.IsEmpty) ) {
       return true;
    }
    var local = new Categories();
    local.Add(testFixture.Categories);
    local.Add(testFixture.InheritedCategories);
    return local.Intersect(_includedCategories).Count > 0;
 }
Beispiel #34
0
 public void AddStringArrayFiresOnceOnly() {
    var eventListener = new ModifiedListener();
    var cats = new Categories();
    cats.Modified += eventListener.OnModified;
    cats.Add(new[] { "red", "green", "blue" });
    Assert.Equals(1, eventListener.EventCount, "Modified event wasn't fired.");
 }
Beispiel #35
0
 private static void DeserializeCategories(XmlNode doc, string categoriesGroupName,
    Categories categoriesCollection) {
    var includedCatNodes = doc.SelectNodes("categorySelector/" + categoriesGroupName + "/category");
    foreach(XmlElement elem in includedCatNodes) {
       categoriesCollection.Add(elem.InnerText);
    }
 }
Beispiel #36
0
 public void ClearOnNonEmptyFiresModifiedEvent() {
    var eventListener = new ModifiedListener();
    var cats = new Categories();
    cats.Modified += eventListener.OnModified;
    cats.Add("bla");
    cats.Clear();
    Assert.Equals(2, eventListener.EventCount, "Modified event wasn't fired.");
 }
Beispiel #37
0
 public void StringsTrimmedWhenArrayAdded() {
    var strings = new[] { " blue ", " green " };
    var cats = new Categories();
    cats.Add(strings);
    Assert.Equals(2, cats.Count);
    Assert.Contains("blue", cats.ToArray());
    Assert.DoesNotContain(" blue ", cats.ToArray());
    Assert.Contains("green", cats.ToArray());
    Assert.DoesNotContain(" green ", cats.ToArray());
 }
Beispiel #38
0
 public void RemoveFiresOnlyWhenCatRemoved() {
    var eventListener = new ModifiedListener();
    var cats = new Categories();
    cats.Modified += eventListener.OnModified;
    cats.Add("blue");
    cats.Remove("red");
    Assert.Equals(1, eventListener.EventCount, "Modified event wasn't fired.");
 }
Beispiel #39
0
        public Categories GetCategory(string[] ids, int ipage)
        {
            if (ids == null || ids.Length == 0)
                return new Categories();

            if (IdCateDic.Count == 0)
            {
                TryToLoadCategoriesDicFromFile();
            }

            if (IdCateDic.ContainsKey(ids[0]))
            {
                Categories categories = new Categories();
                foreach (var id in ids)
                {
                    categories.Add(IdCateDic[id]);
                }
                return categories;
            }
            else
            {
                return GetCategoryFromNetwork(ids, ipage);
            }
        }
Beispiel #40
0
        static void Main(string[] args) {
            var osInfo = System.Environment.OSVersion;
            Settings.Load(Toolkit.CurrentDirectory.FindPrecedingFile("settings.json").FullPath);
            var pwd = Settings.Passcode;

            var dbcfg = Settings.Databases["default"];


            var cats = new Categories().Select();
            var parents = new Categories().Where(new { ParentID = DBNull.Value });
            var productData = Util.IO.File.ReadText("C:\\Work\\products.json");
            var products = AOI.Util.Codecs.JSON.Decode<List<Dictionary<string, dynamic>>>(productData);
            foreach (var product in products) {
                var productCategory = ((string)product["category"]).ToUpper();
                var parts = productCategory.Split('/');
                var parentCategory = parts[0];
                var pc = parents.Where(c => c.Label.ToUpper() == parentCategory).FirstOrDefault();
                if (pc == null) {
                    pc = new Categories().Single(new { Label = productCategory });
                    if (pc == null) {
                        pc = new Categories().Add(new {
                            Label = parentCategory
                        });
                        parents.Add(pc);
                    }
                }

                if (parts.Length > 1) {
                    var childCategory = parts[1];
                    var child = pc.Child(childCategory, true);
                    product["category_id"] = child.ID;
                } else {
                    product["category_id"] = pc.ID;
                }

                var description = product["description"];
                description = Util.Toolkit.UrlDecode(description);
                var url = product["picture"];
                
                //var data = Util.Http.GET(url);
                //Util.IO.File.WriteBinary("C:\\Work\\product.jpg", data);
                //product["picture_snapshot"] = data;
            }


            Log.Trace("...");
            
            //new Categories().Fetch(
            //    new {
            //        ParentID = 1
            //    }
            //);

            //var filtered = new Categories().Where(new {
            //    ParentID = 2
            //});

            //var categories = new Categories().Select();
            //var category = categories[0];
            //var childrens = category.Children;
            ////category.Update(new {
            ////    Description = "This is a category."
            //// });

            //var child = category.Create("MIRRORS");
            //var children = category.Children;


            var db = AOI.Data.Database.Open("DefaultConnection");
            //db.Insert(new Query("INSERT INTO categories (label, ParentID) VALUES (@label, @ParentID);").Set("Label", "ACCESSORIES").Set("ParentID", 2));

            //var people = db.SelectRecords<Person>("SELECT applicant_transaction_number as ID, first_name as FirstName, last_name as LastName FROM \"Applicants\" LIMIT 10;");
            //var records = db.SelectRecords("SELECT first_name as FirstName, last_name as LastName FROM \"Applicants\" LIMIT 10;");
            //var records = db.SelectRecords("SELECT * FROM \"Applicants\";");
            
            //db.Insert(new Query("INSERT INTO categories (label) VALUES (@label);").Set("Label", "ACCESSORIES"));
            //db.Insert(new Query("INSERT INTO categories (label) VALUES (@label);").Set("Label", "ARCHITECTURAL"));
            //db.Insert(new Query("INSERT INTO categories (label) VALUES (@label);").Set("Label", "FURNISHINGS"));
            //db.Insert(new Query("INSERT INTO categories (label) VALUES (@label);").Set("Label", "TEXTILES"));

            var records = db.SelectRecords<Category>("SELECT * FROM Categories;");
            Console.WriteLine("...");
        }
Beispiel #41
0
 public void EmptyStringIsIgnoredAsCategory() {
    var cats = new Categories();
    cats.Add(string.Empty);
    Assert.Equals(0, cats.Count);
 }
Beispiel #42
0
 public void AddedStringIsTrimmed() {
    var cats = new Categories();
    cats.Add(" blue ");
    Assert.Equals(1, cats.Count);
    Assert.Contains("blue", cats.ToArray());
    Assert.DoesNotContain(" blue ", cats.ToArray());
 }