Update nested layer using loop #Challenge

Gautam Parmar

I have MasterPart 1 which is the price of Rs-100 Now if I will change the price of 100 it suppose to change the price of all effected layer as you can see in below image.

it supposed to change the price of all MasterPart 2 to 5 based on the price of Master Part 1

Than It supposed to change price of all 3rd level master part based on the second level

And it not defined how much inner it will be.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gautam Parmar8y ago
Answer For :

It means all nested childs will have dependent price of parent. Please clarify that If Master Par 1 having 100 Rs then how much of part 2 to 5?

Price of master part1 can never be directly changed, because master part1 its self made by manufacturer, they always change raw material, and raw material is M1, M1 is used to create MasterPart1 so Master Part 1 price is get hiked,

Master Part1 is used to create Master Part2-5 so price of Masterpart2-5 will also get affected,

and so on till it will find ends.
Dharmraj Thakur8y ago
Ohkay I got the difference... then It will fine by suggested structure... You can obviously loop over. Did you implete that or any other logic then show me when you are stucked?
Gautam Parmar8y ago
Difference between M1 and Master Part1 is

Some time Master Part1 could be a raw material for any part or it could be a final product as well.

And M1 is raw material which is not final product.

Example If we manufacture Electric Switch Board, Electric Switch board is final product
To make it we need switches.

And if we change the price of light inside used into switches we can say it is M1. so the all price will get affected which are uses M1.
Dharmraj Thakur8y ago
Ohkay, I am little bit confuse that what is difference between Master Part 1 and M1? Is it not possible to store them together in same table?
Gautam Parmar8y ago
Hi Dharmaraj,

Thanks for your effort,

Problem i am facing that how to loop all nested layer

i.e. if i will update Master Part 1 how i will reach to Master Part 7.

And i cannot loop all raw material or part due to it has more than 1lc parts or material.

Dharmraj Thakur8y ago

1. I have created a table with data as you provide.

RowMaterialMaster
ID	Name	Price	HasParent
1	M1	500	0
2	M2	750	0
3	M9	500	0
4	M57	1750	0
5	Master Part 1	0	1
6	Master Part 2	0	1
7	Master Part 3	0	1
8	Master Part 4	0	1
9	Master Part 5	0	1
10	Master Part 6	0	1
11	Master Part 7	0	1

RowMaterialMapping
RowMaterialID	ParentRowMaterialID
5	1
5	2
6	3
6	5
10	4
10	6

2. Now take row materials which have no parent means which is not dependent on another materials like M1, M2, M9 etc...

3. Create a method in c# which will update price of all the row materials based on its 0 level child materials...

this method will take all rows () and

var ids = GetAllIDs("select ID from RowMaterialMaster where HasParent = 1");
//first row it will be 5

//foreach() loop starts here
declare @price as decimal(18,0);
select @price += ParentRowMaterialID from RowMaterialMapping map
INNER JOIN RowMaterialMaster part ON part.ID = map.ParentRowMaterialID
where map.RowMaterialID = ids[i]; //value of ids[i] is 5
select @price as Price; // here you will get total calculated price of given PartID
//now update the price of specified ids[i] with @price
update RowMaterialMaster set Price = @price where ID = ids[i];
//loop ended

4. you should call evertime Step 3 whenever price update of independent materials. Then you will get up to date data as expected...

That it. Try to understand my suggetion and I hope above rough logic will helpful for you. Please Ignore syntax and put exact logic as per your understanding...

Gautam Parmar8y ago
Here is the detailed graph

There is Master Part 1 and to create it two raw materials are required

M1 - 500 Rs.

M2 - 750 Rs.

If we change the price of raw materials of M1 500 Rs to 600 Rs. so the cost of master part 1 is now 1350.

And in hierarchy, as you can see to create Master part 2 as a raw material used as master part 1 - so that price of master part 2 will also get affected.

and to create Master part 6 as raw material Master part 2 is used to it will also get affect and it is so on nth number it is not defined how much deep it could be.

It suppose to update all price of raw material which is in hierarchy
Dharmraj Thakur8y ago
It means all nested childs will have dependent price of parent. Please clarify that If Master Par 1 having 100 Rs then how much of part 2 to 5?