public async Task <IActionResult> Create([Bind("CustomerName,CustomerNumber,VisionSBU,VillageList,ResidenceTypeCode,EducationCode,NaiscCode,EconomicSubSectorCodeId,EconomicSubSectorCodeISICId")] BnrCustomer bnrCustomer)
        {
            if (ModelState.IsValid)
            {
                _context.Add(bnrCustomer);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            //ViewData["CustomerAccountNumber"] = new SelectList(_context.CustomerAccounts, "CustomerAccountNumber", "FirstName", bnrCustomer.CustomerAccountNumber);
            ViewData["EconomicSubSectorCodeId"]     = new SelectList(_context.EconomicSubSectorCodes, "Code", "Description", bnrCustomer.EconomicSubSectorCodeId);
            ViewData["EconomicSubSectorCodeISICId"] = new SelectList(_context.EconomicSubSectorCodeISICs, "Code", "Description", bnrCustomer.EconomicSubSectorCodeISICId);
            ViewData["EducationCode"]     = new SelectList(_context.Educations, "Code", "Description", bnrCustomer.EducationCode);
            ViewData["NaiscCode"]         = new SelectList(_context.NaicsCodes, "Code", "Description", bnrCustomer.NaiscCode);
            ViewData["ResidenceTypeCode"] = new SelectList(_context.ResidenceTypes, "Code", "Description", bnrCustomer.ResidenceTypeCode);
            ViewData["VillageList"]       = new SelectList(_context.VillageLists, "Villagelist", "VillagelistDescription", bnrCustomer.VillageList);
            ViewData["VisionSBU"]         = new SelectList(_context.VisionSBUs, "VisionSbu", "Description", bnrCustomer.VisionSBU);
            return(View(bnrCustomer));
        }
        public async Task <IActionResult> Edit(string id, [Bind("CustomerName,CustomerNumber,VisionSBU,VillageList,ResidenceTypeCode,EducationCode,NaiscCode,EconomicSubSectorCodeId,EconomicSubSectorCodeISICId")] BnrCustomer bnrCustomer)
        {
            if (id != bnrCustomer.CustomerNumber)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(bnrCustomer);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!BnrCustomerExists(bnrCustomer.CustomerNumber))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            //ViewData["CustomerAccountNumber"] = new SelectList(_context.CustomerAccounts, "CustomerAccountNumber", "FirstName", bnrCustomer.CustomerAccountNumber);
            ViewData["EconomicSubSectorCodeId"]     = new SelectList(_context.EconomicSubSectorCodes, "Code", "Description", bnrCustomer.EconomicSubSectorCodeId);
            ViewData["EconomicSubSectorCodeISICId"] = new SelectList(_context.EconomicSubSectorCodeISICs, "Code", "Description", bnrCustomer.EconomicSubSectorCodeISICId);
            ViewData["EducationCode"]     = new SelectList(_context.Educations, "Code", "Description", bnrCustomer.EducationCode);
            ViewData["NaiscCode"]         = new SelectList(_context.NaicsCodes, "Code", "Description", bnrCustomer.NaiscCode);
            ViewData["ResidenceTypeCode"] = new SelectList(_context.ResidenceTypes, "Code", "Description", bnrCustomer.ResidenceTypeCode);
            ViewData["VillageList"]       = new SelectList(_context.VillageLists, "Villagelist", "VillagelistDescription", bnrCustomer.VillageList);
            ViewData["VisionSBU"]         = new SelectList(_context.VisionSBUs, "VisionSbu", "Description", bnrCustomer.VisionSBU);
            return(View(bnrCustomer));
        }