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)); }