// GET: AccionPersonal/Details/5 public async Task <ActionResult> Details(int?id) { tbAccionPersonal tbAccionPersonal = db.tbAccionPersonal.Find(id); string ErrorMessage = "", UserName = ""; try { string vReturn = ""; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (tbAccionPersonal.est_Id == GeneralFunctions.Enviada) { if (UpdateState(out vReturn, tbAccionPersonal, GeneralFunctions.Revisada, GeneralFunctions.stringDefault)) { TempData["swalfunction"] = GeneralFunctions.sol_Revisada; } } if (tbAccionPersonal == null) { return(HttpNotFound()); } } catch (Exception Ex) { ErrorMessage = Ex.Message.ToString(); throw; } return(View(tbAccionPersonal)); }
// GET: AccionPersonal/Create public ActionResult Create() { tbAccionPersonal tbAccionPersonal = new tbAccionPersonal(); string ErrorMessage = ""; try { string UserName = ""; int EmployeeID = Function.GetUser(out UserName); int fecha = Function.DatetimeNow().Year; int SolCount = (from _tbSol in db.tbAccionPersonal where _tbSol.Acp_FechaCrea.Year == fecha && _tbSol.emp_Id == EmployeeID select _tbSol).Count(); IEnumerable <object> Employee = (from _tbEmp in db.tbEmpleado where _tbEmp.emp_EsJefe == true select new { emp_Id = _tbEmp.emp_Id, emp_Nombres = _tbEmp.emp_Nombres + " " + _tbEmp.emp_Apellidos }).ToList(); ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion"); ViewBag.Acp_JefeInmediato = new SelectList(Employee, "emp_Id", "emp_Nombres"); ViewBag.tipmo_id = new SelectList(db.tbTipoMovimiento, "tipmo_id", "tipmo_Movimiento"); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres"); tbAccionPersonal.Acp_FechaSolicitud = Function.DatetimeNow(); } catch (Exception Ex) { ErrorMessage = Ex.Message.ToString(); throw; } return(View(tbAccionPersonal)); }
public JsonResult Approve(int?id) { var list = ""; string vReturn = ""; if (id == null) { return(Json("Valor Nulo", JsonRequestBehavior.AllowGet)); } tbAccionPersonal tbAccionPersonal = db.tbAccionPersonal.Find(id); if (tbAccionPersonal.est_Id == GeneralFunctions.Revisada) { if (UpdateState(out vReturn, tbAccionPersonal, GeneralFunctions.Aprobada, GeneralFunctions.stringDefault)) { TempData["swalfunction"] = GeneralFunctions.sol_Aprobada; list = vReturn; } } if (tbAccionPersonal == null) { return(Json("Error al cargar datos", JsonRequestBehavior.AllowGet)); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> DeleteConfirmed(int id) { tbAccionPersonal tbAccionPersonal = await db.tbAccionPersonal.FindAsync(id); db.tbAccionPersonal.Remove(tbAccionPersonal); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: AccionPersonal/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbAccionPersonal tbAccionPersonal = await db.tbAccionPersonal.FindAsync(id); if (tbAccionPersonal == null) { return(HttpNotFound()); } return(View(tbAccionPersonal)); }
public async Task <ActionResult> Edit([Bind(Include = "Acp_Id,Acp_Correlativo,emp_Id,Acp_JefeInmediato,Acp_FechaSolicitud,tipmo_id,Acp_Comentario,est_Id,Acp_RazonRechazo,Acp_UsuarioCrea,Acp_FechaCrea,Acp_UsuarioModifica,Acp_FechaModifica")] tbAccionPersonal tbAccionPersonal) { if (ModelState.IsValid) { db.Entry(tbAccionPersonal).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion", tbAccionPersonal.est_Id); ViewBag.Acp_JefeInmediato = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres", tbAccionPersonal.Acp_JefeInmediato); ViewBag.tipmo_id = new SelectList(db.tbTipoMovimiento, "tipmo_id", "tipmo_Movimiento", tbAccionPersonal.tipmo_id); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres", tbAccionPersonal.emp_Id); return(View(tbAccionPersonal)); }
// GET: AccionPersonal/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbAccionPersonal tbAccionPersonal = await db.tbAccionPersonal.FindAsync(id); if (tbAccionPersonal == null) { return(HttpNotFound()); } ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion", tbAccionPersonal.est_Id); ViewBag.Acp_JefeInmediato = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres", tbAccionPersonal.Acp_JefeInmediato); ViewBag.tipmo_id = new SelectList(db.tbTipoMovimiento, "tipmo_id", "tipmo_Movimiento", tbAccionPersonal.tipmo_id); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres", tbAccionPersonal.emp_Id); return(View(tbAccionPersonal)); }
public JsonResult Reject(int id, string RazonRechazo) { var list = ""; string vReturn = ""; tbAccionPersonal tbAccionPersonal = db.tbAccionPersonal.Find(id); if (tbAccionPersonal.est_Id == GeneralFunctions.Revisada) { if (UpdateState(out vReturn, tbAccionPersonal, GeneralFunctions.Rechazada, RazonRechazo)) { TempData["swalfunction"] = GeneralFunctions.sol_Rechazada; } } if (tbAccionPersonal == null) { return(Json("Error al cargar datos", JsonRequestBehavior.AllowGet)); //return HttpNotFound(); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult Revisar(int id, string RazonRechazo) { string vReturn = ""; string IsFor = "false"; tbAccionPersonal tbAccionPersonal = db.tbAccionPersonal.Find(id); if (tbAccionPersonal.est_Id == GeneralFunctions.Enviada) { if (UpdateState(out vReturn, tbAccionPersonal, GeneralFunctions.Revisada, RazonRechazo)) { TempData["swalfunction"] = GeneralFunctions.sol_Revisada; IsFor = "true"; } } if (tbAccionPersonal == null) { return(Json("Error al cargar datos", JsonRequestBehavior.AllowGet)); } return(Json(IsFor, JsonRequestBehavior.AllowGet)); }
///////////////////////////////////////////////////////// public bool UpdateState(out string pvReturn, tbAccionPersonal tbAccionPersonal, int State, string Acp_RazonRechazo) { pvReturn = ""; string UserName = "", ErrorEmail = "", ErrorMessage = "", _msj = "", _msjFor = ""; bool Result = false, ResultFor = false; IEnumerable <object> Update = null; var reject = ""; try { int EmployeeID = Function.GetUser(out UserName); tbAccionPersonal.est_Id = State; tbAccionPersonal.Acp_RazonRechazo = Acp_RazonRechazo; Update = db.UDP_Adm_tbAccionPersonal_Update(tbAccionPersonal.Acp_Id, tbAccionPersonal.est_Id, tbAccionPersonal.Acp_RazonRechazo, EmployeeID, Function.DatetimeNow() ); foreach (UDP_Adm_tbAccionPersonal_Update_Result Res in Update) { ErrorMessage = Res.MensajeError; } pvReturn = ErrorMessage; if (ErrorMessage.StartsWith("-1")) { Function.BitacoraErrores("AnticipoSalario", "UpdateState", UserName, ErrorMessage); ModelState.AddModelError("", "No se pudo actualizar el registro contacte al administrador."); return(false); } else { var _Parameters = (from _tbParm in db.tbParametro select _tbParm).FirstOrDefault(); var GetEmployee = Function.GetUserInfo(tbAccionPersonal.emp_Id); var Approver = Function.GetUserInfo(EmployeeID); string Correlativo = tbAccionPersonal.Acp_Correlativo; string Nombres = GetEmployee.emp_Nombres; string CorreoElectronico = GetEmployee.emp_CorreoElectronico; string sApprover = Approver.strFor + Approver.emp_Nombres; if (Acp_RazonRechazo == GeneralFunctions.stringDefault) { Acp_RazonRechazo = null; } ; _msjFor = GeneralFunctions.msj_ToAdmin; switch (State) { case GeneralFunctions.Revisada: _msj = GeneralFunctions.msj_Revisada; break; case GeneralFunctions.AprobadaPorJefe: _msj = GeneralFunctions.msj_RevisadaPorJefe; ResultFor = Function.LeerDatos(out ErrorEmail, Correlativo, _Parameters.par_NombreEmpresa, Nombres, _msjFor, GeneralFunctions.stringEmpty, sApprover, _Parameters.par_CorreoEmpresa); break; case GeneralFunctions.AprobadaPorRRHH: _msj = GeneralFunctions.msj_RevisadaPorRRHH; ResultFor = Function.LeerDatos(out ErrorEmail, Correlativo, _Parameters.par_NombreEmpresa, Nombres, _msjFor, GeneralFunctions.stringEmpty, sApprover, _Parameters.par_CorreoEmpresa); break; case GeneralFunctions.AprobadaPorAdmin: _msj = GeneralFunctions.msj_RevisadaPorAdmin; ResultFor = Function.LeerDatos(out ErrorEmail, Correlativo, _Parameters.par_NombreEmpresa, Nombres, _msjFor, GeneralFunctions.stringEmpty, sApprover, _Parameters.par_CorreoEmpresa); break; case GeneralFunctions.Aprobada: _msj = GeneralFunctions.msj_Aprobada; break; case GeneralFunctions.Rechazada: _msj = GeneralFunctions.msj_Rechazada; reject = " Razon de Rechazo:"; break; } Result = Function.LeerDatos(out ErrorEmail, Correlativo, Nombres, GeneralFunctions.stringEmpty, _msj, reject + " " + Acp_RazonRechazo, sApprover, CorreoElectronico); if (!Result) { Function.BitacoraErrores("AnticipoSalario", "UpdateState", UserName, ErrorEmail); return(false); } if (!ResultFor) { Function.BitacoraErrores("AnticipoSalario", "UpdateState", UserName, ErrorEmail); return(false); } } return(true); } catch (Exception ex) { pvReturn = ex.Message.ToString(); Function.BitacoraErrores("AnticipoViatico", "UpdateState", UserName, ex.Message.ToString()); return(false); } }
public async Task <ActionResult> Create([Bind(Include = "Acp_Id,Acp_Correlativo,emp_Id,Acp_JefeInmediato,Acp_FechaSolicitud,tipmo_id,Acp_Comentario,est_Id,Acp_RazonRechazo,Acp_UsuarioCrea,Acp_FechaCrea,Acp_UsuarioModifica,Acp_FechaModifica")] tbAccionPersonal tbAccionPersonal) { string UserName = "", ErrorEmail = ""; try { cGetUserInfo GetEmployee = null; cGetUserInfo EmpJefe = null; bool Result = false, ResultAdm = false; int EmployeeID = Function.GetUser(out UserName); tbAccionPersonal.emp_Id = EmployeeID; tbAccionPersonal.Acp_FechaSolicitud = Function.DatetimeNow(); tbAccionPersonal.est_Id = GeneralFunctions.Enviada; if (ModelState.IsValid) { IEnumerable <object> Insert = null; string ErrorMessage = ""; Insert = db.UDP_Adm_tbAccionPersonal_Insert(EmployeeID, tbAccionPersonal.Acp_JefeInmediato, Function.DatetimeNow(), tbAccionPersonal.Acp_Comentario, GeneralFunctions.Enviada, tbAccionPersonal.tipmo_id, EmployeeID, Function.DatetimeNow() ); foreach (UDP_Adm_tbAccionPersonal_Insert_Result Res in Insert) { ErrorMessage = Res.MensajeError; } if (ErrorMessage.StartsWith("-1")) { Function.BitacoraErrores("AccionPersonal", "CreatePost", UserName, ErrorMessage); ModelState.AddModelError("", "No se pudo insertar el registro contacte al administrador."); } else { GetEmployee = Function.GetUserInfo(EmployeeID); EmpJefe = Function.GetUserInfo(tbAccionPersonal.Acp_JefeInmediato); Result = Function.LeerDatos(out ErrorEmail, ErrorMessage, GetEmployee.emp_Nombres, GeneralFunctions.stringEmpty, GeneralFunctions.msj_Enviada, GeneralFunctions.stringEmpty, GeneralFunctions.stringEmpty, GetEmployee.emp_CorreoElectronico); ResultAdm = Function.LeerDatos(out ErrorEmail, ErrorMessage, EmpJefe.emp_Nombres, GetEmployee.emp_Nombres, GeneralFunctions.msj_ToAdmin, GeneralFunctions.stringEmpty, GeneralFunctions.stringEmpty, EmpJefe.emp_CorreoElectronico); if (!Result) { Function.BitacoraErrores("AccionPersonal", "CreatePost", UserName, ErrorEmail); } if (!ResultAdm) { Function.BitacoraErrores("AccionPersonal", "CreatePost", UserName, ErrorEmail); } TempData["swalfunction"] = GeneralFunctions.sol_Enviada; return(RedirectToAction("Index")); } } } catch (Exception ex) { Function.BitacoraErrores("AccionPersonal", "CreatePost", UserName, ex.Message.ToString()); return(RedirectToAction("Index")); } IEnumerable <object> Employee = (from _tbEmp in db.tbEmpleado where _tbEmp.emp_EsJefe == true select new { emp_Id = _tbEmp.emp_Id, emp_Nombres = _tbEmp.emp_Nombres + " " + _tbEmp.emp_Apellidos }).ToList(); ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion"); ViewBag.Acp_JefeInmediato = new SelectList(Employee, "emp_Id", "emp_Nombres"); ViewBag.tipmo_id = new SelectList(db.tbTipoMovimiento, "tipmo_id", "tipmo_Movimiento"); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres"); return(View(tbAccionPersonal)); }