// Create GRN public ActionResult redirectToGrn(int id) { var grnCreation = _capitaContext.PurchaseOrderSummaries.Where(x => x.VendorId == id).Where(x => x.Qty > 0).ToList(); var vendorUser = _capitaContext.VendorMasters.SingleOrDefault(v => v.S_No == id); var vendorUsers = _capitaContext.PurchaseOrderSummaries.Distinct().FirstOrDefault(v => v.VendorId == id); if (vendorUser == null) { return(HttpNotFound()); } List <SelectListItem> stateNames = new List <SelectListItem>(); List <string> states = _capitaContext.sp_UniquePurId(id).ToList(); purchaseOrderVM stuModel = new purchaseOrderVM(); states.ForEach(x => { stateNames.Add(new SelectListItem { Text = x, Value = x.ToString() }); }); stuModel.StateNames = stateNames; var vendorVM = new purchaseOrderVM { vendormasterDetails = vendorUser, order = grnCreation, Purorder = vendorUsers, StateNames = stateNames }; return(View("Index", vendorVM)); }