internal async Task <Material> RemoveMaterialFinishing(int id, int idf)
{
var finishing = await context.Product.FindAsync(id);
var material = await context.Material.FindAsync(idf);
MaterialFinishing mfs = null;
if (finishing == null || material == null)
{
return(null);
}
foreach (MaterialFinishing mf in material.MaterialFinishings)
{
if (mf.MaterialId == idf)
{
mfs = mf;
}
}
if (mfs == null)
{
return(null);
}
context.MaterialFinishing.Remove(mfs);
await context.SaveChangesAsync();
return(material);
}
internal async Task <Material> AddMaterialFinishing(int id, int idf)
{
var material = await context.Material.FindAsync(id);
var finishing = await context.Finishing.FindAsync(idf);
if (material == null || finishing == null)
{
return(null);
}
if (context.MaterialFinishing.Any(mfs => mfs.FinishingId == idf && mfs.MaterialId == id))
{
return(null);
}
MaterialFinishing mf = new MaterialFinishing();
mf.FinishingId = finishing.FinishingId;
mf.Finishing = finishing;
mf.MaterialId = material.MaterialId;
mf.Material = material;
finishing.MaterialFinishings.Add(mf);
material.MaterialFinishings.Add(mf);
context.Entry(material).State = EntityState.Modified;
context.Entry(finishing).State = EntityState.Modified;
context.MaterialFinishing.Add(mf);
try
{
await context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(null);
}
return(material);
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new SiCContext(
serviceProvider.GetRequiredService <DbContextOptions <SiCContext> >()))
{
if (context.Product.Any())
{
return; // DB has been seeded
}
City c = new City("Aveiro", 40.641190, -8.653620);
City c1 = new City("Beja", 38.015621, -7.865230);
City c2 = new City("Braga", 41.545448, -8.426507);
City c3 = new City("Braganca", 41.806114, -6.756738);
City c4 = new City("Castelo Branco", 39.819714, -7.496466);
City c5 = new City("Coimbra", 40.203316, -8.410257);
City c6 = new City("Evora", 38.571430, -7.913502);
City c7 = new City("Faro", 37.015362, -7.935110);
City c8 = new City("Guarda", 40.537128, -7.267850);
City c9 = new City("Leiria", 39.749535, -8.807683);
City c10 = new City("Lisboa", 38.722252, -9.139337);
City c11 = new City("Portalegre", 39.296707, -7.428476);
City c12 = new City("Porto", 41.157944, -8.629105);
City c13 = new City("Santarem", 39.236179, -8.687080);
City c14 = new City("Setubal", 38.525406, -8.894100);
City c15 = new City("Viana do Castelo", 41.691807, -8.834451);
City c16 = new City("Vila Real", 41.295898, -7.746350);
City c17 = new City("Viseu", 40.656586, -7.912471);
Factory Factory = new Factory();
Factory.City = c12;
Factory.Description = "Fabrica situada no Porto";
Measure Depth = new Measure(20.0, 40.0);
Measure Height = new Measure(80);
Measure Width = new Measure(30, 50);
Measure Depth_Part = new Measure(10.0, 20.0);
Measure Height_Part = new Measure(40);
Measure Width_Part = new Measure(15, 25);
Dimension Dimension_Product = new Dimension();
Dimension_Product.Depth = Depth;
Dimension_Product.Height = Height;
Dimension_Product.Width = Width;
Dimension Dimension_Product_Part_A1 = new Dimension();
Dimension_Product_Part_A1.Depth = Depth_Part;
Dimension_Product_Part_A1.Height = Height_Part;
Dimension_Product_Part_A1.Width = Width_Part;
Dimension Dimension_Product_Part_A2 = new Dimension();
Dimension_Product_Part_A2.Depth = Depth_Part;
Dimension_Product_Part_A2.Height = Height_Part;
Dimension_Product_Part_A2.Width = Width_Part;
Price Finishing_Price = new Price();
Finishing_Price.date = DateTime.Parse("2019-01-06");
Finishing_Price.designation = "Polimento";
Finishing_Price.price = 2.50;
Price Material_Price = new Price();
Material_Price.date = DateTime.Parse("2019-01-06");
Material_Price.designation = "Madeira";
Material_Price.price = 5.0;
Finishing Finishing = new Finishing();
Finishing.name = "Polimento";
Finishing.description = "Acabamento que confere brilho e protecao do material quando aplicado";
Finishing.MaterialFinishings = new List <MaterialFinishing>();
Finishing.Prices = new List <Price>();
Material Material = new Material();
Material.name = "Madeira";
Material.description = "Madeira de pinho de elevada durabilidade";
Material.MaterialFinishings = new List <MaterialFinishing>();
Material.ProductMaterials = new List <ProductMaterial>();
Material.Prices = new List <Price>();
Category Category = new Category();
Category.name = "armario";
Category.description = "Esta categoria representa o topo da taxonomia";
Category Category_Part = new Category();
Category_Part.name = "gaveta";
Category_Part.description = "Categoria desenvolvida para teste";
Category_Part.parent = Category;
Product Product = new Product();
Product.name = "G8579";
Product.description = "Produto desenvolvido para teste";
Product.category = Category;
Product.ProductMaterials = new List <ProductMaterial>();
Product.CatalogProducts = new List <CatalogProduct>();
Product.CollectionProducts = new List <CollectionProduct>();
Product.dimensions = new List <Dimension>();
Product.dimensions.Add(Dimension_Product);
Product Product_Part1 = new Product();
Product_Part1.name = "G8579_Part_A1";
Product_Part1.description = "Produto desenvolvido para teste";
Product_Part1.category = Category_Part;
Product_Part1.ProductMaterials = new List <ProductMaterial>();
Product_Part1.CatalogProducts = new List <CatalogProduct>();
Product_Part1.CollectionProducts = new List <CollectionProduct>();
Product_Part1.dimensions = new List <Dimension>();
Product_Part1.dimensions.Add(Dimension_Product_Part_A1);
Product Product_Part2 = new Product();
Product_Part2.name = "G8579_Part_A2";
Product_Part2.description = "Produto desenvolvido para teste";
Product_Part2.category = Category_Part;
Product_Part2.ProductMaterials = new List <ProductMaterial>();
Product_Part2.CatalogProducts = new List <CatalogProduct>();
Product_Part2.CollectionProducts = new List <CollectionProduct>();
Product_Part2.dimensions = new List <Dimension>();
Product_Part2.dimensions.Add(Dimension_Product_Part_A2);
Combination Combination_P_P1 = new Combination(Product, Product_Part1, true);
Combination Combination_P_P2 = new Combination(Product, Product_Part2, false);
Catalog Catalog = new Catalog();
Catalog.CatalogName = "Catalogo G8579";
Catalog.CatalogDescription = "Catalogo desenvolvido para teste";
Catalog.Date = "2019-01-06";
Catalog.CatalogProducts = new List <CatalogProduct>();
Collection Collection = new Collection();
Collection.collectionName = "Madeira e mais Madeira";
Collection.aestheticParameter = "Madeira";
Collection.CollectionProducts = new List <CollectionProduct>();
MaterialFinishing MF = new MaterialFinishing();
MF.Finishing = Finishing;
MF.Material = Material;
Finishing.MaterialFinishings.Add(MF);
Material.MaterialFinishings.Add(MF);
ProductMaterial PM = new ProductMaterial();
PM.Material = Material;
PM.Product = Product;
Product.ProductMaterials.Add(PM);
Material.ProductMaterials.Add(PM);
CatalogProduct CatP = new CatalogProduct();
CatP.Catalog = Catalog;
CatP.Product = Product;
Product.CatalogProducts.Add(CatP);
Catalog.CatalogProducts.Add(CatP);
CollectionProduct ColP = new CollectionProduct();
ColP.Collection = Collection;
ColP.Product = Product;
Product.CollectionProducts.Add(ColP);
Collection.CollectionProducts.Add(ColP);
context.City.Add(c);
context.City.Add(c1);
context.City.Add(c2);
context.City.Add(c3);
context.City.Add(c4);
context.City.Add(c5);
context.City.Add(c6);
context.City.Add(c7);
context.City.Add(c8);
context.City.Add(c9);
context.City.Add(c10);
context.City.Add(c11);
context.City.Add(c12);
context.City.Add(c13);
context.City.Add(c14);
context.City.Add(c15);
context.City.Add(c16);
context.City.Add(c17);
context.Factory.Add(Factory);
context.Measure.Add(Depth);
context.Measure.Add(Height);
context.Measure.Add(Width);
context.Measure.Add(Depth_Part);
context.Measure.Add(Height_Part);
context.Measure.Add(Width_Part);
context.Dimension.Add(Dimension_Product);
context.Dimension.Add(Dimension_Product_Part_A1);
context.Dimension.Add(Dimension_Product_Part_A2);
context.Price.Add(Material_Price);
context.Price.Add(Finishing_Price);
context.Finishing.Add(Finishing);
context.Material.Add(Material);
context.Category.Add(Category);
context.Category.Add(Category_Part);
context.Product.Add(Product);
context.Product.Add(Product_Part1);
context.Product.Add(Product_Part2);
context.Combination.Add(Combination_P_P1);
context.Combination.Add(Combination_P_P2);
context.Catalog.Add(Catalog);
context.Collection.Add(Collection);
MF.MaterialId = Material.MaterialId;
MF.FinishingId = Finishing.FinishingId;
context.MaterialFinishing.Add(MF);
PM.MaterialId = Material.MaterialId;
PM.ProductId = Product.ProductId;
context.ProductMaterial.Add(PM);
CatP.CatalogId = Catalog.CatalogId;
CatP.ProductId = Product.ProductId;
context.CatalogProduct.Add(CatP);
ColP.CollectionId = Collection.CollectionId;
ColP.ProdutctId = Product.ProductId;
context.CollectionProduct.Add(ColP);
context.SaveChanges();
}
}
