public async Task <Response> PutTipoPersonal([FromForm] string data) { Response res = new Response(); try { TipoPersonal tipoPersonal = JsonConvert.DeserializeObject <TipoPersonal>(data); TipoPersonal update = await _context.TiposPersonal.FindAsync(tipoPersonal.tipoPersonalId); if (update == null) { res.bError = true; res.cMensaje = "Tipo de Personal no encontrado"; } else { update.cDescripcion = tipoPersonal.cDescripcion; _context.Entry(update).State = EntityState.Modified; await _context.SaveChangesAsync(); } } catch (Exception ex) { res.bError = true; res.cMensaje = ex.Message; } return(res); }
public async Task <ActionResult <Response> > PostTipoPersonal([FromForm] string data) { Response res = new Response(); try { TipoPersonal tipoPersonal = JsonConvert.DeserializeObject <TipoPersonal>(data); TipoPersonal insert = new TipoPersonal { cDescripcion = tipoPersonal.cDescripcion, bEstatus = tipoPersonal.bEstatus }; _context.TiposPersonal.Add(insert); await _context.SaveChangesAsync(); res.nPayload = insert.tipoPersonalId; } catch (Exception er) { res.bError = true; res.cMensaje = er.Message; } //return CreatedAtAction("GetArea", new { id = area.AreaId }, area); return(res); }
public ActionResult DeleteConfirmed(int id) { TipoPersonal tipoPersonal = db.TipoPersonals.Find(id); db.TipoPersonals.Remove(tipoPersonal); db.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult EditarPersonal(TipoPersonal per) { using (sgcfieeContext context = new sgcfieeContext()) { context.TipoPersonal.Update(per); context.SaveChanges(); } return(RedirectToAction("MostrarPersonal")); }
public ActionResult Edit(TipoPersonal tipopersonal) { if (ModelState.IsValid) { db.Entry(tipopersonal).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Create")); } return(View(tipopersonal)); }
public ActionResult Create(TipoPersonal tipopersonal) { if (ModelState.IsValid) { db.TipoPersonal.Add(tipopersonal); db.SaveChanges(); return(RedirectToAction("Create")); } return(View(tipopersonal)); }
public async Task Create(TipoPersonal model) { try { _db.dbSetTipoPersona.Add(model); await _db.SaveChangesAsync(); } catch (Exception e) { throw new Exception(e.Message, e); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Gbukrs,Bukrs,Tipo_pers,Descrip")] TipoPersonal tipoPersonal) { ViewBag.GpoCiaG = HttpContext.Session.GetString(SessionGpoCia); tipoPersonal.Bukrs = tipoPersonal.Bukrs.PadLeft(4, '0'); tipoPersonal.Gbukrs = tipoPersonal.Gbukrs.PadLeft(4, '0'); var items = new List <SelectListItem>(); items = DaBukrs(ViewBag.GpoCiaG); ViewBag.DaBukrs = items.ToList(); string Errores1 = ValidaError(tipoPersonal.Bukrs, tipoPersonal.Gbukrs, tipoPersonal.Tipo_pers, tipoPersonal.Id); string che = Errores1.Substring(0, 1); if (che == "A") { ModelState.AddModelError("Bukrs", "no existe esa Compañía"); return(View(tipoPersonal)); } if (che == "B") { ModelState.AddModelError("Tipo_pers", "registro duplicado"); return(View(tipoPersonal)); } if (id != tipoPersonal.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tipoPersonal); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TipoPersonalExists(tipoPersonal.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(tipoPersonal)); }
// GET: TipoPersonal/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TipoPersonal tipoPersonal = db.TipoPersonals.Find(id); if (tipoPersonal == null) { return(HttpNotFound()); } return(View(tipoPersonal)); }
public ActionResult Edit([Bind(Include = "id,descripcion,fechaCreacion,usuarioId")] TipoPersonal tipoPersonal) { if (ModelState.IsValid) { Usuario usuario = Session["UsuarioData"] as Usuario; tipoPersonal.fechaCreacion = DateTime.Now; tipoPersonal.usuarioId = usuario.Id; db.Entry(tipoPersonal).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.usuarioId = new SelectList(db.Usuarios, "Id", "nombreUsuario", tipoPersonal.usuarioId); return(View(tipoPersonal)); }
// GET: TipoPersonal/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TipoPersonal tipoPersonal = db.TipoPersonals.Find(id); if (tipoPersonal == null) { return(HttpNotFound()); } ViewBag.usuarioId = new SelectList(db.Usuarios, "Id", "nombreUsuario", tipoPersonal.usuarioId); return(View(tipoPersonal)); }
public async Task Update(TipoPersonal model) { try { var _model = await _db.dbSetTipoPersona.FirstOrDefaultAsync(e => e.TipoPersonaId == model.TipoPersonaId); if (_model != null) { _db.Entry(_model).CurrentValues.SetValues(model); await _db.SaveChangesAsync(); } } catch (Exception e) { throw new Exception(e.Message, e); } }
public async Task UpdateEstado(TipoPersonal obj) { try { var _obj = await _db.dbSetTipoPersona.FirstOrDefaultAsync(e => e.TipoPersonaId == obj.TipoPersonaId); if (_obj != null) { _obj.Estado = obj.Estado; await _db.SaveChangesAsync(); } } catch (Exception e) { throw new Exception(e.Message, e); } }
public async Task <ActionResult <Response> > DeleteTipoPersonal(int id) { Response res = new Response(); try { //Area area = JsonConvert.DeserializeObject<Area>(data); TipoPersonal delete = await _context.TiposPersonal.FindAsync(id); if (delete == null) { res.bError = true; res.cMensaje = "Tipo de personal no encontrado"; } else { delete.bEstatus = false; _context.Entry(delete).State = EntityState.Modified; await _context.SaveChangesAsync(); } } catch (Exception ex) { res.bError = true; res.cMensaje = ex.Message; } //var area = await _context.Areas.FindAsync(id); //if (area == null) //{ // return NotFound(); //} //_context.Areas.Remove(area); //await _context.SaveChangesAsync(); return(res); }
//permite devolver la lista de TipoPersonal public static List <TipoPersonal> obtenerListaTipoPersonal() { List <TipoPersonal> lista = new List <TipoPersonal>(); SqlConnection conexion = MiDB.obtenerConexion(); String consulta = "select * from tblTipoPersonal;"; SqlCommand comando = new SqlCommand(consulta, conexion); comando.CommandTimeout = 1; SqlDataReader lector = comando.ExecuteReader(); if (lector.HasRows) { while (lector.Read()) { TipoPersonal auxiliar = new TipoPersonal(); auxiliar.IdTipoPersonal = lector.GetInt32(0); auxiliar.TipoPersonalP = lector.GetString(1); lista.Add(auxiliar); } } return(lista); }
public async Task <IActionResult> Create([Bind("Id,Gbukrs,Bukrs,Tipo_pers,Descrip")] TipoPersonal tipoPersonal) { ViewBag.Mensaje = ""; ViewBag.GpoCiaG = HttpContext.Session.GetString(SessionGpoCia); tipoPersonal.Bukrs = tipoPersonal.Bukrs.PadLeft(4, '0'); tipoPersonal.Gbukrs = tipoPersonal.Gbukrs.PadLeft(4, '0'); var items = new List <SelectListItem>(); items = DaBukrs(ViewBag.GpoCiaG); ViewBag.DaBukrs = items.ToList(); string Errores1 = ValidaError(tipoPersonal.Bukrs, tipoPersonal.Gbukrs, tipoPersonal.Tipo_pers, tipoPersonal.Id); string che = Errores1.Substring(0, 1); if (che == "A") { ModelState.AddModelError("Bukrs", "no existe esa Compañía"); return(View(tipoPersonal)); } if (che == "B") { ModelState.AddModelError("Tipo_pers", "registro duplicado"); return(View(tipoPersonal)); } if (ModelState.IsValid) { _context.Add(tipoPersonal); await _context.SaveChangesAsync(); ViewBag.Mensaje = "Tipo Personal: " + tipoPersonal.Tipo_pers.ToString() + " Grabado con éxito"; TempData["message"] = tipoPersonal.Gbukrs + " Cía: " + tipoPersonal.Bukrs + " - " + tipoPersonal.Descrip; return(RedirectToAction(nameof(Index))); } return(View(tipoPersonal)); }
public async Task <IHttpActionResult> UpdateEstado(TipoPersonal obj) { try { log.Info(new MDCSet(this.ControllerContext.RouteData)); await _repository.UpdateEstado(obj); return(Ok("Registro actualizado correctamente!")); } catch (Exception e) { log.Error(new MDCSet(this.ControllerContext.RouteData), e); return(InternalServerError(e)); } }
[HttpPost][Authorize] public async Task <IHttpActionResult> Create(TipoPersonal obj) { try { log.Info(new MDCSet(this.ControllerContext.RouteData)); await _repository.Create(obj); return(Ok("Tipo de puesto creado correctamente!")); } catch (Exception e) { log.Error(new MDCSet(this.ControllerContext.RouteData), e); return(InternalServerError(e)); } }
public IActionResult Principal(SGCFIEE.Models.UsuarioLogin user) { String usuario = user.matricula; if (usuario.Equals("root")) { using (sgcfieeContext context = new sgcfieeContext()) { TipoPersonal tp = new TipoPersonal(); tp.Nombre = "Default"; context.TipoPersonal.Add(tp); context.SaveChanges(); TipoPersonal tp2 = context.TipoPersonal.Last(); int tipoPer = tp2.IdTipoPersonal; ProgramaEducativo pe = new ProgramaEducativo(); pe.Nombre = "Default"; context.ProgramaEducativo.Add(pe); context.SaveChanges(); ProgramaEducativo pe2 = context.ProgramaEducativo.Last(); int ProEdu = pe2.IdProgramaEducativo; Academicos aca = new Academicos(); aca.IdProgramaEducativo = ProEdu; aca.RTipoPersonal = tipoPer; context.Academicos.Add(aca); context.SaveChanges(); Academicos aca2 = context.Academicos.Last(); int idUsu = aca2.IdAcademicos; Usuarios usunuevo = new Usuarios(); usunuevo.IdAcademico = idUsu; usunuevo.Nombre = "root2"; usunuevo.Tipo = 1; String p = string.Concat("root2", "root"); SHA1 sha = new SHA1CryptoServiceProvider(); byte[] input2 = (new UnicodeEncoding()).GetBytes(p); byte[] h = sha.ComputeHash(input2); string pa = Convert.ToBase64String(h); usunuevo.Contrasenia = pa; context.Usuarios.Add(usunuevo); context.SaveChanges(); return(RedirectToAction("Index")); } } var x = 2; Usuarios usu = new Usuarios(); String pass = string.Concat(user.matricula, user.password); SHA1 sha1 = new SHA1CryptoServiceProvider(); byte[] input = (new UnicodeEncoding()).GetBytes(pass); byte[] hash = sha1.ComputeHash(input); string passwo = Convert.ToBase64String(hash); user.password = passwo; using (sgcfieeContext context = new sgcfieeContext()) { usu = context.Usuarios.Where(e => e.Nombre.Equals(user.matricula) && e.Contrasenia.Equals(user.password)).SingleOrDefault(); if (usu != null) { x = 1; } } if (x == 1) { var claims = new List <Claim>(); claims.Add(new Claim(ClaimTypes.Name, user.matricula)); var userIdentity = new ClaimsIdentity(claims, "login"); var principal = new ClaimsPrincipal(userIdentity); HttpContext.SignInAsync("PKAT", principal); HttpContext.Session.SetString("Matricula", usu.Nombre); HttpContext.Session.SetInt32("TipoUsuario", usu.Tipo); if (usu.Tipo == 3) { HttpContext.Session.SetInt32("IdUsu", usu.IdAlumno.Value); } else { HttpContext.Session.SetInt32("IdUsu", usu.IdAcademico.Value); } return(RedirectToAction("Default")); } else { return(RedirectToAction("Index")); } //return View(); }
// // GET: /TipoPersonal/Edit/5 public ActionResult Edit(int id) { TipoPersonal tipopersonal = db.TipoPersonal.Find(id); return(View(tipopersonal)); }