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