public static ProductShelf ToProductShelf(dtoProductShop dtoProductShop)
{
try
{
string str = "";
GeneralDB db = new GeneralDB();
//זה חייב להיות כזה מסובך?
//var q5 = db.MyDb.ProductShelves.Where(x => x.CodeProduct == dtoProductShop.CodeProduct).ToList();
//var q6 = db.MyDb.ProductShops.Where(x => x.CodeProduct == dtoProductShop.CodeProduct && x.CodeShop == dtoProductShop.CodeShop).ToList();
var q = db.MyDb.Shops.First(shop => shop.Code == dtoProductShop.CodeShop);
var q1 = q.Stands.ToList();
var q2 = q1.ToList().Select(stand => stand.Shelves).ToList();
var q3 = q2.Select(x => x.Select(y => y.ProductShelves).ToList()).ToList();
var q4 = q3.Select(a => a.Select(b => b.Where(c => c.CodeProduct == dtoProductShop.CodeProduct).ToList()).ToList()).ToList();
ProductShelf ps = null;
q4.ForEach(a => a.ForEach(b => b.ForEach(c => { str += "codeProduct: " + c.CodeProduct + " codeShelf: " + c.CodeShelf + "\n"; ps = c; })));
// MessageBox.Show(str);
//.Select(shelf => shelf.ProductShelves.Where(productShelf => productShelf.CodeProduct == dtoProductShop.CodeProduct)));
return(ps);
}
catch
{
MessageBox.Show("לא מצליח להמיר ממוצר חנות למוצר מדף");
return(null);
}
}
public static ProductShop ToProductShop(dtoProductShop dtoProductShop)
{
return(new ProductShop()
{
Code = dtoProductShop.Code, CodeProduct = dtoProductShop.CodeProduct, CodeShop = dtoProductShop.CodeShop
});
}
//[Route("Post")]
public void Post(dtoProductShop product)
{
//זה מה שצריך לעבוד בסוף
product.Insert();
}
