public MaterialEditList EditMaterial(string ProductID) { MaterialEditList product = new MaterialEditList(); try { var reader = _db.QueryMultiple("USP_EDIT_MATERIAL_V2", new { P_PRODUCTID = ProductID }, commandType: CommandType.StoredProcedure); var vheader = reader.Read <HeaderEditList>().ToList(); var vfactory = reader.Read <FactoryEditList>().ToList(); var vvendor = reader.Read <VendorEditList>().ToList(); var vcustomer = reader.Read <CustomerEditList>().ToList(); var vpacksize = reader.Read <PacksizeEditList>().ToList(); product.HeaderEditList = vheader; product.FactoryEditList = vfactory; product.VendorEditList = vvendor; product.CustomerEditList = vcustomer; product.PacksizeEditList = vpacksize; reader.Dispose(); } catch (Exception ex) { } return(product); }
public ActionResult EditMaterial(string ProductID) { MaterialEditList material = new MaterialEditList(); FactoryMastercontext masterContext = new FactoryMastercontext(); material = masterContext.EditMaterial(ProductID.Trim()); var allDataset = new { varHeader = material.HeaderEditList, varFactory = material.FactoryEditList, varVendor = material.VendorEditList, varCustomer = material.CustomerEditList, varPacksize = material.PacksizeEditList, }; return(Json(new { allDataset, JsonRequestBehavior.AllowGet })); }