calculation between two properties from different models

Please refer below code.

If you are using MVC, then your controller code will be as follows

// create object of context
DBContext objDBContext = new DBContext();
public ActionResult Index()
{
// Get data from first table into custom model 1
var ItemDetail = (from item in objDBContext.Table_1
where
item.ID == 1001
select new Model_1
{
Qty = item.Qty
}).FirstOrDefault();
// Get data from first table into custom model 2
var RateDetail = (from item in objDBContext.Table_2
where
item.ID == 1001
select new Model_2
{
Rate = item.Rate
}).FirstOrDefault();
// Do your calculation here
var Total = ItemDetail.Qty * RateDetail.Rate;
// Create object of your custom model 3
Model_3 objModel_3 = new Model_3();
objModel_3.Total = Total;
// pass your object of custom model 3 to view
return View(objModel_3);
}

All the best.

3 Replies

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

Rajkiran Swain9y ago
https://codereview.stackexchange.com/questions/28609/when-one-property-is-calculated-from-another
0
Rupesh Kahane9y ago
Please refer below code.
If you are using MVC, then your controller code will be as follows
// create object of context
DBContext objDBContext = new DBContext();
public ActionResult Index()
       {
          // Get data from first table into custom model 1
           var ItemDetail = (from item in objDBContext.Table_1
                             where
                             item.ID == 1001
                             select new Model_1
                             {
                                Qty = item.Qty
                             }).FirstOrDefault();

          // Get data from first table into custom model 2
           var RateDetail = (from item in objDBContext.Table_2
                             where
                             item.ID == 1001
                             select new Model_2
                             {
                                Rate = item.Rate
                             }).FirstOrDefault();

          // Do your calculation here
           var Total = ItemDetail.Qty * RateDetail.Rate;

          // Create object of your custom model 3
           Model_3 objModel_3 = new Model_3();
           objModel_3.Total = Total;

           // pass your object of custom model 3 to view
           return View(objModel_3);
       }
All the best.
0
Ramesh Palanivel9y ago
Hi SP,

Kindly post some sample data or screen shot of your issues. It will help us to give proper solution.
0