I am working on Asp.net MVC5(Entity Framework) in which :
1: I have one master table (FeeMaster)
2: all fields have default value 0.
3: another table (Basic Details),SELECT TOP (1000) [Id] ,[Name_Department] ,[Father_OrgName] ,[City] ,[Street] ,[Locality] ,[Pincode] ,[PlotNo] ,[District] ,[Tehsil] ,[Village] ,[Ward] ,[KhasraNo] ,[KhewetNo] ,[KhataNo] ,[CompoundWall] ,[LandDevelopment] ,[MeasureGround] ,[MeasureBase] ,[MeasureTotal] ,[NoOfFloor] ,[Floor1] ,[Area1] ,[Floor2] ,[Area2] ,[Floor3] ,[Area3] ,[Floor4] ,[Area4] ,[Floor5] ,[Area5] FROM [dbname].[dbo].[BasicDetails]
in which if i enter MeasureBase = 700 then its multiply by RateBase i.e. 10 Rs/Sqt similarly if i enter MeasureGround = 700 then its multiply by Rate ground i.e 15 Rs/Sqt, and if i enter Number of floor = 2 then it multiply by RateFloor i.e 20 rs/sqt , as with compundwall = 300 then it multiply by CompundWall i.e 10 Rs/rft and Landscapping 200 then it multiply by 25 Rs/sft, after all the calculation(multiplication and addition) it give value in Measure Total.
How can i use master table and all the calculation