How to allocate warehouse rack with palate volume?

See more:

ASP.NET

Hi Sir

I have no idea how to fit the pallet into fixed Rack

scenario

1. Receiving pallet, we can calculate volume (H x W x L)
2. We have fixed Metal Rack, we also know volume ((H x W x L) each and every Rack.
3. Rack Example: Row A1 has 6 Rack which we know the volume.
4. We have fixed each Rack with code. Example: A1-01,A1-02 etc...
5. Each pallet has the barcode and also volume which we upload excel file into MSSQl 2017
6. Once scan bar code, system will display volume of the pallet.

Here is my requirements.

Once user scans the bar code, application has to tell the user that this Rack(Exp:A1-02) can be fit
Example. Rack A1-02 has volume 50000. and pallet (bar code 1245782) has volume 10000
so Rack A1-02 has fit multiple pallets (with different bar code).
So application have to tell user when scan first pallet (volume 10000), A1-02 is available, then balance volume 40000
if scan the second pallet (volume 25000) , A1-02 is available, then balance volume 15000 in A1-02.
if scan the third pallet (volume 20000) , A2-01 is available, and so on. because A1-02 has balance volume 15000 only
after few pallet, one pallet (volume 15000), application has to tell the A1-02 is available, then A1-02 is full.

We are developing in ASP.Net web application.

Can anybody advice me, how to do it.

Thank you

Maideen

What I have tried:

I have done only upload excel, Pallet details and volume into database and generate the Pallet Bar code with Combination of date+location code+serial No.

After that I could not move Further.