public ActionResult SubItemVendor(string PrimaryItemID) { SubItemVendorList subitemvendor = new SubItemVendorList(); FactoryMastercontext masterContext = new FactoryMastercontext(); subitemvendor = masterContext.SubItemVendor(PrimaryItemID.Trim()); var allDataset = new { varSubItem = subitemvendor.SubItemList, varVendor = subitemvendor.VendorList, }; return(Json(new { allDataset, JsonRequestBehavior.AllowGet })); }
public SubItemVendorList SubItemVendor(string PrimaryItem) { SubItemVendorList subitemvendor = new SubItemVendorList(); try { var reader = _db.QueryMultiple("USP_GET_SUBITEM_VENDOR_V2", new { P_PRIMARYID = PrimaryItem }, commandType: CommandType.StoredProcedure); var vsubitem = reader.Read <SubItemList>().ToList(); var vvendor = reader.Read <VendorList>().ToList(); subitemvendor.SubItemList = vsubitem; subitemvendor.VendorList = vvendor; reader.Dispose(); } catch (Exception ex) { } return(subitemvendor); }