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