public async Task <IActionResult> Create([Bind("Id,Cityname")] City city)
        {
            if (ModelState.IsValid)
            {
                city.Id = Guid.NewGuid();
                _context.Add(city);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(city));
        }
        public async Task <IActionResult> Create([Bind("Nationalid,Id,Fullname,Telno,Mobileno")] Person person)
        {
            if (ModelState.IsValid)
            {
                person.Id = Guid.NewGuid();
                _context.Add(person);
                // await _context.SaveChangesAsync();
                await _context.Database.ExecuteSqlRawAsync($@"
INSERT INTO public.person(
nationalid, id, fullname, telno, mobileno)
VALUES ('{person.Nationalid}', '{person.Id}', '{person.Fullname}', '{person.Telno}', '{person.Mobileno}');                
                ");

                return(RedirectToAction(nameof(Index)));
            }
            return(View(person));
        }