how to deal with master table in asp.net mvc

@Garima

for MeasureTotal 

you need to sum all textbox values (except one pair obviously all other will be zero, so it won't affect the calculation)

var sumMeasureTotal= parseInt($("#field1").val(),10)+parseInt($("#field1").val(),10)+....so on.
$("#MeasureTotal").val(sumMeasureTotal);

@Garima, as per your design it is even easier

$("#MeasureBase").change(function(){
$(this).val($(this).val()*parseInt($("#RateBase").val(),10));
});

same for other controls.

Sachin Singh

i have two database table one is BasicDetails and other is Feemaster is a master table, so i create this in controller

ViewBag.RateBase = "";
ViewBag.RateGround = "";
ViewBag.RateFloor = "";
ViewBag.CompoundWall = "";
ViewBag.LandScapping = "";
FeeMaster mastertable = (db.FeeMasters.Where(x => x.Id == 1)).SingleOrDefault();
if (mastertable != null)
{
    ViewBag.RateBase = mastertable.RateBase;
    ViewBag.RateGround = mastertable.RateGround;
    ViewBag.RateFloor = mastertable.RateFloor;
    ViewBag.CompoundWall = mastertable.CompoundWall;
    ViewBag.LandScapping = mastertable.LandScapping;
}

Then in View, i created hidden fileds for mastertable 

 

     

         

             Measure Grd
             
             
         
         

         

         

             Measure Base
             
            
         
         

         

         
     

         
 

     

         

             No Of Floor
             
             
         
         

         

         

         

             Measure Total
             
             
         
         

         

         
     

 

     

         

             Compound Wall(Rft.)
             
             

         
         

         

         

             Area LandDevelopment(Sqft.)
             
             

         
         

         

         

Now the scenerio is, if user 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.

Vishal Joshi

this scenario doesnt work

ViewBag is fine. 

Now you need to get data for BasicDetails same as FeeMaster. Please reref below sample code for the same.

public ActionResult Index(FormCollection fomr)
{
   ViewBag.RateBase = "";
   ViewBag.RateGround = "";
   ViewBag.RateFloor = "";
   ViewBag.CompoundWall = "";
   ViewBag.LandScapping = "";
   FeeMaster mastertable = (db.FeeMasters.Where(x => x.Id == 1)).SingleOrDefault();
   if (mastertable != null)
   {
     ViewBag.RateBase = mastertable.RateBase;
     ViewBag.RateGround = mastertable.RateGround;
     ViewBag.RateFloor = mastertable.RateFloor;
     ViewBag.CompoundWall = mastertable.CompoundWall;
     ViewBag.LandScapping = mastertable.LandScapping;
   }

   List basicDetailSubTable = (db.BasicDetails).ToList();

   var DyObjectsList = new List; 
   dynamic DyObj = new ExpandoObject(); 
   foreach(var item in basicDetailSubTable)
   {
    DyObj.MeasureBaseTotalCost = (item.MeasureBase * mastertable.RateBase);
    DyObj.MeasureGroundTotalCost = (item.MeasureGround * mastertable.RateGround);
    DyObj.NoOfFloorTotalCost = (item.NoOfFloor  * mastertable.RateFloor);
    DyObjectsList.Add(DyObj);   
   }

   // Use this viewBag in UI to display total cost data
   ViewBag.TotalCosts = DyObjectsList;
}

Another way you can set BasicDetails data in ViewBag Or Strongly type mode and in UI/FronEnd side write multiplication logic to calculate total cost.

Thank you

i use viewbag to deal with master table, in actionmethod

public ActionResult Index(FormCollection fomr)
        {
            ViewBag.RateBase = "";
            ViewBag.RateGround = "";
            ViewBag.RateFloor = "";
            ViewBag.CompoundWall = "";
            ViewBag.LandScapping = "";
            FeeMaster mastertable = (db.FeeMasters.Where(x => x.Id == 1)).SingleOrDefault();
            if (mastertable != null)
            {
                ViewBag.RateBase = mastertable.RateBase;
                ViewBag.RateGround = mastertable.RateGround;
                ViewBag.RateFloor = mastertable.RateFloor;
                ViewBag.CompoundWall = mastertable.CompoundWall;
                ViewBag.LandScapping = mastertable.LandScapping;
            }

to get the value.

but next scenrio is :

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.

Hello, 

There can be several wasy to achive this secnario. but, i would suggesst to create Model Structure. Please check below sample code.

Public Class BasicDetails
{
  Public int MeasureGround { get; set; }
  Public int NoOfFloor { get; set; }
  // all other property
  
  // Declare Parent Model as a property
  Public FeeMaster feeMaster { get; set; }

}

Public Class FeeMaster
{
  public double RateBase { get; set; }
  public NoOfFloorRateBase { get; set; }
  // all other property
}

Thank You