// GET: RequisionCompra/Create public ActionResult Create() { string UserName = "", ErrorEmail = "", ErrorMessage = ""; int EmployeeID = Function.GetUser(out UserName); bool Result = false, ResultAdm = false; cGetUserInfo GetEmployee = null, EmpJefe = null; tbRequisionCompra tbRequisionCompra = new tbRequisionCompra(); var UserInfo = (from _emp in db.tbEmpleado join _pto in db.tbPuesto on _emp.pto_Id equals _pto.pto_Id join _are in db.tbArea on _pto.are_Id equals _are.are_Id where _emp.emp_Id == EmployeeID select new { _emp, _are, _pto }).FirstOrDefault(); var UserAreaInfo = (from _emp in db.tbEmpleado join _pto in db.tbPuesto on _emp.pto_Id equals _pto.pto_Id join _are in db.tbArea on _pto.are_Id equals _are.are_Id where _emp.emp_EsJefe == true && _pto.are_Id == UserInfo._are.are_Id && _pto.pto_Id == UserInfo._pto.pto_Id select new { _emp, _are }).FirstOrDefault(); GetEmployee = Function.GetUserInfo(EmployeeID); EmpJefe = Function.GetUserInfo(UserInfo._emp.emp_Id); tbRequisionCompra.Reqco_Jefe = UserAreaInfo._emp.emp_Nombres + " " + UserAreaInfo._emp.emp_Apellidos; tbRequisionCompra.are_Id = UserAreaInfo._are.are_Id; tbRequisionCompra.Area = UserAreaInfo._are.are_Descripcion; ViewBag.are_Id = new SelectList(db.tbArea, "are_Id", "are_Descripcion", UserInfo._pto.are_Id); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres"); ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion"); return(View(tbRequisionCompra)); }
public JsonResult ApprovePorAdmin(int?id) { var list = ""; string vReturn = ""; if (id == null) { return(Json("Valor Nulo", JsonRequestBehavior.AllowGet)); } tbRequisionCompra tbRequisionCompra = db.tbRequisionCompra.Find(id); if (tbRequisionCompra.est_Id == GeneralFunctions.Revisada) { if (UpdateState(out vReturn, tbRequisionCompra, GeneralFunctions.AprobadaPorAdmin, GeneralFunctions.stringDefault)) { TempData["swalfunction"] = GeneralFunctions.sol_Aprobada; list = vReturn; } } if (tbRequisionCompra == null) { return(Json("Error al cargar datos", JsonRequestBehavior.AllowGet)); } return(Json(list, JsonRequestBehavior.AllowGet)); }
// GET: RequisionCompra/Details/5 public async Task <ActionResult> Details(int?id) { try { string vReturn = ""; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbRequisionCompra tbRequisionCompra = await db.tbRequisionCompra.FindAsync(id); ViewBag.RequisicionDetalle = db.tbRequisionCompraDetalle.Where(x => x.Reqco_Id == tbRequisionCompra.Reqco_Id).ToList(); if (tbRequisionCompra.est_Id == GeneralFunctions.Enviada) { if (UpdateState(out vReturn, tbRequisionCompra, GeneralFunctions.Revisada, GeneralFunctions.stringDefault)) { TempData["swalfunction"] = GeneralFunctions.sol_Revisada; } else { TempData["swalfunction"] = GeneralFunctions.sol_ErrorUpdateState; } } if (tbRequisionCompra == null) { return(HttpNotFound()); } return(View(tbRequisionCompra)); } catch (Exception) { throw; } }
public bool UpdateState(out string pvReturn, tbRequisionCompra tbRequisionCompra, int State, string 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); tbRequisionCompra.est_Id = State; tbRequisionCompra.Reqco_RazonRechazo = RazonRechazo; Update = db.UDP_Adm_tbRequisionCompra_Update(tbRequisionCompra.Reqco_Id, tbRequisionCompra.est_Id, tbRequisionCompra.Reqco_RazonRechazo, EmployeeID, Function.DatetimeNow()); foreach (UDP_Adm_tbRequisionCompra_Update_Result Res in Update) { ErrorMessage = Res.MensajeError; } pvReturn = ErrorMessage; if (ErrorMessage.StartsWith("-1")) { Function.BitacoraErrores("RequisionCompra", "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(tbRequisionCompra.emp_Id); var Approver = Function.GetUserInfo(EmployeeID); string Correlativo = tbRequisionCompra.Reqco_Correlativo; string Nombres = GetEmployee.emp_Nombres; string CorreoElectronico = GetEmployee.emp_CorreoElectronico; string sApprover = Approver.strFor + Approver.emp_Nombres; if (RazonRechazo == GeneralFunctions.stringDefault) { 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 + " " + 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 = "are_Id,Reqco_GralFechaSolicitud,Reqco_Comentario,Reqco_RazonRechazo")] tbRequisionCompra tbRequisionCompra) { string UserName = "", ErrorMessage = "", Scope = ""; IEnumerable <object> Insert = null; try { int EmployeeID = Function.GetUser(out UserName); IEnumerable <object> Employee = (from _tbEmp in db.tbEmpleado where _tbEmp.emp_EsJefe == true && _tbEmp.est_Id == GeneralFunctions.empleadoactivo && _tbEmp.emp_Id != EmployeeID select new { emp_Id = _tbEmp.emp_Id, emp_Nombres = _tbEmp.emp_Nombres + " " + _tbEmp.emp_Apellidos }).ToList(); ViewBag.are_Id = new SelectList(db.tbArea, "are_Id", "are_Descripcion", tbRequisionCompra.are_Id); ViewBag.emp_Id = new SelectList(db.tbEmpleado, "emp_Id", "emp_Nombres", tbRequisionCompra.emp_Id); ViewBag.est_Id = new SelectList(db.tbEstado, "est_Id", "est_Descripcion", tbRequisionCompra.est_Id); tbRequisionCompra.emp_Id = EmployeeID; tbRequisionCompra.Reqco_GralFechaSolicitud = Function.DatetimeNow(); tbRequisionCompra.est_Id = GeneralFunctions.Enviada; var _Parameters = (from _tbParm in db.tbParametro select _tbParm).FirstOrDefault(); if (String.IsNullOrEmpty(tbRequisionCompra.Reqco_Comentario)) { tbRequisionCompra.Reqco_Comentario = GeneralFunctions.stringDefault; } if (ModelState.IsValid) { Insert = db.UDP_Adm_tbRequisionCompra_Insert(EmployeeID, tbRequisionCompra.are_Id, Function.DatetimeNow(), tbRequisionCompra.Reqco_Comentario, tbRequisionCompra.est_Id, tbRequisionCompra.Reqco_RazonRechazo, EmployeeID, Function.DatetimeNow()); foreach (UDP_Adm_tbRequisionCompra_Insert_Result Res in Insert) { ErrorMessage = Res.MensajeError; Scope = Res.ScopeIdentity; } if (ErrorMessage.StartsWith("-1")) { Function.BitacoraErrores("RequisionCompra", "CreatePost", UserName, ErrorMessage); ModelState.AddModelError("", "No se pudo insertar el registro contacte al administrador."); } else { Session["Reqco_Id"] = Scope; TempData["swalfunction"] = GeneralFunctions.sol_Enviada; return(RedirectToAction("Create", "RequisionCompraDetalle")); } } } catch (Exception ex) { Function.BitacoraErrores("RequisionCompra", "CreatePost", UserName, ex.Message.ToString() + " " + ex.InnerException.Message.ToString()); } return(View(tbRequisionCompra)); }