public async Task <IActionResult> Edit(int id, [Bind("Id,Gbukrs,Bukrs,Estatus,Desc")] Estatus_stat2 estatus_stat2)
        {
            estatus_stat2.Bukrs  = estatus_stat2.Bukrs.PadLeft(4, '0');
            estatus_stat2.Gbukrs = estatus_stat2.Gbukrs.PadLeft(4, '0');
            ViewBag.GpoCiaG      = estatus_stat2.Gbukrs;
            var items = new List <SelectListItem>();

            items           = DaBukrs(ViewBag.GpoCiaG);
            ViewBag.DaBukrs = items.ToList();

            if (id != estatus_stat2.Id)
            {
                return(NotFound());
            }
            //checar si ya se dio de alta uno igual
            int cnt = (from m in _context.Cat1
                       where m.Gbukrs == estatus_stat2.Gbukrs && m.Bukrs == estatus_stat2.Bukrs
                       select m.Gbukrs).Count();

            if (cnt == 0)
            {
                ModelState.AddModelError("Bukrs", "no existe esa Compañía");
                return(View(estatus_stat2));
            }

            int cnt2 = (from m in _context.Estatus_Stat2
                        where m.Gbukrs == estatus_stat2.Gbukrs && m.Bukrs == estatus_stat2.Bukrs &&
                        m.Estatus == estatus_stat2.Estatus && m.Id != estatus_stat2.Id
                        select m.Gbukrs).Count();

            if (cnt2 != 0)
            {
                ModelState.AddModelError("Estatus", "Registro Duplicado");
                return(View(estatus_stat2));
            }


            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(estatus_stat2);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!Estatus_stat2Exists(estatus_stat2.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(estatus_stat2));
        }
        public async Task <IActionResult> Create([Bind("Id,Gbukrs,Bukrs,Estatus,Desc")] Estatus_stat2 estatus_stat2)
        {
            // mi validacion
            estatus_stat2.Bukrs  = estatus_stat2.Bukrs.PadLeft(4, '0');
            estatus_stat2.Gbukrs = estatus_stat2.Gbukrs.PadLeft(4, '0');
            ViewBag.GpoCiaG      = HttpContext.Session.GetString(SessionGpoCia);
            var items = new List <SelectListItem>();

            items           = DaBukrs(ViewBag.GpoCiaG);
            ViewBag.DaBukrs = items.ToList();
            if (ModelState.IsValid)
            {
                //checar si ya se dio de alta uno igual

                int cnt = (from m in _context.Cat1
                           where m.Gbukrs == estatus_stat2.Gbukrs && m.Bukrs == estatus_stat2.Bukrs
                           select m.Gbukrs).Count();
                if (cnt == 0)
                {
                    ModelState.AddModelError("Bukrs", "no existe esa Compañía");
                    return(View(estatus_stat2));
                }

                int cnt2 = (from m in _context.Estatus_Stat2
                            where m.Gbukrs == estatus_stat2.Gbukrs && m.Bukrs == estatus_stat2.Bukrs &&
                            m.Estatus == estatus_stat2.Estatus && m.Id != estatus_stat2.Id
                            select m.Gbukrs).Count();
                if (cnt2 != 0)
                {
                    ModelState.AddModelError("Estatus", "Registro Duplicado");

                    return(View(estatus_stat2));
                }
                //inserta datos
            }


            /// aqui lo original
            if (ModelState.IsValid)
            {
                _context.Add(estatus_stat2);
                await _context.SaveChangesAsync();

                TempData["message"] = estatus_stat2.Gbukrs + "  Cía: " + estatus_stat2.Bukrs + " - " + estatus_stat2.Desc;

                return(RedirectToAction(nameof(Create)));
                //return RedirectToAction(nameof(Index));
            }
            return(View(estatus_stat2));
        }