/// <summary> /// Erstellt eine neue Produktkategorie mit uebergebenem Namen. /// </summary> /// <param name="name">Name der Kategorie.</param> /// <param name="dbContext">Datenbankkontext, mit dem die Kategorie erstellt wird.</param> /// <returns>Die neu erstellte Produktkategorie.</returns> public static ProductCategory CreateProductCategory(string name, DataClasses1DataContext dbContext) { var item = new ProductCategory() { LogDBContext = dbContext, Name = name }; dbContext.ProductCategory.InsertOnSubmit(item); dbContext.SubmitChanges(); dbContext.WriteLogItem("Produktkategorie " + item.Name + " angelegt.", LogTypes.INSERT, item.Id, "ProductCategory"); return item; }
public static void CreateCategorys() { DataClasses1DataContext dbContext = new DataClasses1DataContext(new Guid("E6232890-B6E9-4AA4-B68C-36CF5C9A0918")); var allCategories = from cat in dbContext.temp_Products group cat by cat.Warengruppe.Trim() into g select new { gruppe = g.Key }; foreach(var allc in allCategories) { if (dbContext.ProductCategory.FirstOrDefault(s => s.Name.Trim() == allc.gruppe.Trim()) == null) { ProductCategory pr = new ProductCategory { Id = Guid.NewGuid(), Name = allc.gruppe }; dbContext.ProductCategory.InsertOnSubmit(pr); dbContext.SubmitChanges(); } } }
partial void UpdateProductCategory(ProductCategory instance);
partial void DeleteProductCategory(ProductCategory instance);
partial void InsertProductCategory(ProductCategory instance);