// GET: BillOfMaterials public ActionResult MIS() { var js = _capitaContext.sp_GetDataInMatRequsition().Where(c => c.RowsNo == 1).ToList(); var bm = _capitaContext.BillOfMats.ToList(); if (js.Count == 0) { return(View("NoMatRequsitionView")); } var bj = new MIS { boms = bm, salesOrderss = js }; return(View(bj)); }