Beispiel #1
0
        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);
        }