Garima Bansal

Garima Bansal

  • 1.1k
  • 680
  • 39.7k

how to deal with master table in asp.net mvc

Dec 21 2022 7:13 AM

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


Answers (8)