private void fillTableBtn_Click(object sender, EventArgs e)
{
using (catalogDb db = new catalogDb())
{
if (!db.CatalogLevelSet.Any())
{
var catalog = db.CatalogSet.ToList();
foreach (var item in catalog)
{
Catalog_level newItem = addRow(null, item.Name, item.Description, db);
int newCatalogId = newItem.Id;
var catalog_aggr = db.CatalogAggrSet.Where(u => u.CatalogId == item.Id).ToList();
foreach (var item2 in catalog_aggr)
{
newItem = addRow(newCatalogId, item2.Name, item2.Description, db);
int newCatalogAggrId = newItem.Id;
var catalog_model = db.CatalogModels.Where(u => u.Catalog_aggregateId == item2.Id).ToList();
foreach (var item3 in catalog_model)
{
newItem = addRow(newCatalogAggrId, item3.Model, item3.Description, db);
}
}
}
}
}
}
private void ClearTableBtn_Click(object sender, EventArgs e)
{
using (catalogDb db = new catalogDb())
{
db.Database.ExecuteSqlCommand("DELETE FROM Catalog_level");
}
}
Catalog_level addRow(int?parent_id, string name, string descr, catalogDb db)
{
Catalog_level newItem = new Catalog_level {
Parent_Id = parent_id, Name = name, Description = descr
};
db.CatalogLevelSet.Add(newItem);
db.SaveChanges();
return(newItem);
}
private void fillTreeBtn_Click(object sender, EventArgs e)
{
catalogTreeView.Nodes.Clear();
using (catalogDb db = new catalogDb())
{
TreeNode tr = null;
var curLevel = db.CatalogLevelSet.AsNoTracking().OrderBy(v => v.Id).Select(u => u);
foreach (var i in curLevel)
{
fillTree(i, ref tr, catalogTreeView);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
using (catalogDb db = new catalogDb())
{
if (!db.CatalogSet.Any())
{
db.CatalogSet.Add(new Catalog {
Id = 1, Description = "volvo description", Name = "VOLVO"
});
db.CatalogSet.Add(new Catalog {
Id = 2, Description = "ER description", Name = "ER"
});
db.CatalogAggrSet.Add(new Catalog_aggregate {
Id = 1, CatalogId = 1, Description = "КПП asdfasf", Name = "КПП", Url = "sdf"
});
db.CatalogAggrSet.Add(new Catalog_aggregate {
Id = 2, CatalogId = 2, Description = "Двигатель asdfasf", Name = "Двигатель", Url = "aaaa"
});
db.CatalogAggrSet.Add(new Catalog_aggregate {
Id = 3, CatalogId = 2, Description = "КПП sdf", Name = "КПП", Url = "cvvv"
});
db.CatalogModels.Add(new Catalog_model {
Id = 1, Catalog_aggregateId = 1, Model = "A635", Description = "aaa", Url = "asdf"
});
db.CatalogModels.Add(new Catalog_model {
Id = 2, Catalog_aggregateId = 2, Model = "M4566", Description = "bbb", Url = "asdf"
});
db.CatalogModels.Add(new Catalog_model {
Id = 3, Catalog_aggregateId = 2, Model = "FG4511", Description = "ccc", Url = "ccacc"
});
db.CatalogModels.Add(new Catalog_model {
Id = 4, Catalog_aggregateId = 3, Model = "T45459", Description = "ddd", Url = "cccc"
});
db.CatalogModels.Add(new Catalog_model {
Id = 5, Catalog_aggregateId = 2, Model = "A77", Description = "iii", Url = "cccc"
});
db.CatalogSet.Add(new Catalog {
Id = 3, Description = "TT description", Name = "TT"
});
db.CatalogAggrSet.Add(new Catalog_aggregate {
Id = 4, CatalogId = 1, Description = "КПП1 sdf", Name = "КПП1", Url = "cvvv"
});
db.SaveChanges();
}
}
}
