Fetch Value from Third Level Table

Raju Fodse

I Have Three Table Linked with each other. I want to fetch Value from other table How do I write Code. I Try This but Variable 'mythkvalue' returns null value. How I will get value for mythkvalue

[HttpPost]
public ActionResult CreateP3(Process process)
{
var tr = process.StageID + process.PIPENO + process.Status;
var checkme = (from x in db.Processes
where x.StageID + x.PIPENO + x.Status == tr && x.Status == "OK"
select x).ToList();
var mythkvalue = process.PipeAl.Order.THK;
if (checkme.Count > 0)
{
ModelState.AddModelError("PIPENO", "You are trying Duplicate Pipe Entry");
}
if (ModelState.IsValid)
{
if (mythkvalue > 1)
{
process.MPP = 25;
}
process.CuttingSpeed = (process.ActualMeter*1000)/process.CuttingTime;
db.Processes.Add(process);
db.SaveChanges();
return RedirectToAction("IndexP3");
}
var EmpAtnList = db.Attens.ToList();
IEnumerable AttnList = from s in EmpAtnList.OrderByDescending(s => s.ATTNDATE)
select new SelectListItem
{
Value = s.ATTNSYSID.ToString(),
Text = s.ATTNDATE + "--" + s.Emp.EmpName
};
ViewBag.ATTNSYSID = new SelectList(AttnList, "Value", "Text");
//ViewBag.ATTNSYSID = new SelectList(db.Attens, "ATTNSYSID", "EMPCODE", process.ATTNSYSID);
ViewBag.StageID = new SelectList(db.OMStages, "StageID", "StageName");
ViewBag.NextStageID = new SelectList(db.OMStages.OrderBy(x => x.StageValue), "StageID", "StageName");
ViewBag.PIPENO = new SelectList(db.PipeAls, "PIPENO", "PIPENO");
ViewBag.Status = new SelectList(db.ValueAddLists.Where(x => x.RefName == "PipeStatus"), "RefValue", "Description", process.Status);
return View(process);
}

2 Replies

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

Suraj Kumar8y ago
Accepted answer
Hello Raju,
You can get other table using previous object id or value as in below code.
ET_EXPENSE_HEAD objExpHead = dbEClaim.ET_EXPENSE_HEAD.FirstOrDefault(expHead => expHead.EH_SYS_ID == eH_SYS_ID);
Employee_mstr objEmp = dbHR.Employee_mstr.FirstOrDefault(emp => emp.Emp_cd == objExpHead.EH_EMP_CODE);
Here ET_EXPENSE_HEAD is the first level table. I have created an object of that table and using that object id again objEmp has been created which is the object of Employee_Mstr table. In this way you can create third level table from either above two object value.
Lastly you can check these values in condition and perform action based on that value.

Regard
Suraj
Raju Fodse8y ago
Thanks Suraj, I Try this, but linq takes old value instead of taking new value in 'myThk' Variable
[HttpPost]
        public ActionResult CreateP3(Process process)
        {
            var tr = process.StageID + process.PIPENO + process.Status;
            var checkme = (from x in db.Processes
                           where x.StageID + x.PIPENO + x.Status == tr && x.Status == "OK"
                           select x).ToList();

            var MyThk = (from ot in db.Processes
                         join v in db.PipeAls on ot.PIPENO equals v.PIPENO
                         join c in db.Orders on v.OrderSYSID equals c.OrderSYSID
                         where ot.DPID == process.DPID
                             select c.THK).FirstOrDefault();

                //var MyDia = (from ot in db.Processes
                //             join v in db.PipeAls on ot.PIPENO equals v.PIPENO
                //             join c in db.Orders on v.OrderSYSID equals c.OrderSYSID
                //             select c.DIA).FirstOrDefault();

                //var MyLength = (from ot in db.Processes
                //                join v in db.PipeAls on ot.PIPENO equals v.PIPENO
                //                join c in db.Orders on v.OrderSYSID equals c.OrderSYSID
                //                select v.LENGTH).FirstOrDefault();


            if (checkme.Count > 0)
            {
                ModelState.AddModelError("PIPENO", "You are trying Duplicate Pipe Entry");
            }
            if (ModelState.IsValid)
            {

                //if ((MyThk >= 6 && MyThk <= 12) /*&& (MyDia >= 1 && MyDia <= 108) && (MyLength >= 5 && MyLength <= 7)*/)
                if (MyThk>5)
                {
                    process.MPP = 80;
                    process.TPCPL = 3;
                }
                else
                {
                process.MPP = 10;
                }

                process.CuttingSpeed = (process.ActualMeter*1000)/process.CuttingTime;
                db.Processes.Add(process);
                db.SaveChanges();
                return RedirectToAction("IndexP3");
            }

            var EmpAtnList = db.Attens.ToList();
            IEnumerable AttnList = from s in EmpAtnList.OrderByDescending(s => s.ATTNDATE)
                                                   select new SelectListItem
                                                   {
                                                       Value = s.ATTNSYSID.ToString(),
                                                       Text = s.ATTNDATE + "--" + s.Emp.EmpName
                                                   };

            ViewBag.ATTNSYSID = new SelectList(AttnList, "Value", "Text");

            //ViewBag.ATTNSYSID = new SelectList(db.Attens, "ATTNSYSID", "EMPCODE", process.ATTNSYSID);
            ViewBag.StageID = new SelectList(db.OMStages, "StageID", "StageName");
            ViewBag.NextStageID = new SelectList(db.OMStages.OrderBy(x => x.StageValue), "StageID", "StageName");
            ViewBag.PIPENO = new SelectList(db.PipeAls, "PIPENO", "PIPENO");
            ViewBag.Status = new SelectList(db.ValueAddLists.Where(x => x.RefName == "PipeStatus"), "RefValue", "Description", process.Status);
            return View(process);
        }