/// <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);
