public ActionResult Anular(int iCatalogoID = 0)
{
#region Validar Session
if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
{
return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
}
SessionFixed.IdTransaccionSession = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
#endregion
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "Requerimiento", "CatalogoRequerimiento", "Index");
if (!info.Anular)
{
return(RedirectToAction("Index"));
}
#endregion
rq_Catalogo_Info model = bus_Catalogo.GetInfo_Catalogo(iCatalogoID);
if (model == null)
{
return(RedirectToAction("Index"));
}
model.IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual);
cargar_combos();
return(View(model));
}
public bool anularDB(rq_Catalogo_Info info)
{
try
{
using (Entities_requerimiento Context = new Entities_requerimiento())
{
rq_Catalogo Entity = Context.rq_Catalogo.FirstOrDefault(q => q.iCatalogoID == info.iCatalogoID);
if (Entity == null)
{
return(false);
}
Entity.bEstado = info.bEstado = false;
Entity.vMotivoAnulacion = info.vMotivoAnulacion;
Entity.vUserIDCreacion = info.vUserIDCreacion;
Entity.dFechaAnulacion = info.dFechaAnulacion = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(rq_Catalogo_Info info)
{
try
{
using (Entities_requerimiento Context = new Entities_requerimiento())
{
rq_Catalogo Entity = Context.rq_Catalogo.FirstOrDefault(q => q.iCatalogoID == info.iCatalogoID);
if (Entity == null)
{
return(false);
}
Entity.vCodigo = info.vCodigo;
Entity.vDescripcion = info.vDescripcion;
Entity.iOrder = info.iOrder;
Entity.vUserIDModificacion = info.vUserIDModificacion;
Entity.dFechaModificacion = info.dFechaModificacion = DateTime.Now;
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
tb_LogError_Data LogData = new tb_LogError_Data();
LogData.GuardarDB(new tb_LogError_Info {
Descripcion = ex.Message, InnerException = ex.InnerException == null ? null : ex.InnerException.Message, Clase = "rq_Catalogo_Data", Metodo = "modificarDB", IdUsuario = info.vUserIDModificacion
});
return(false);
}
}
public bool guardarDB(rq_Catalogo_Info info)
{
try
{
using (Entities_requerimiento Context = new Entities_requerimiento())
{
rq_Catalogo Entity = new rq_Catalogo
{
vReferenciaID = info.vReferenciaID,
vCodigo = info.vCodigo,
vDescripcion = info.vDescripcion,
iOrder = info.iOrder,
bEstado = info.bEstado = true,
vUserIDCreacion = info.vUserIDCreacion,
dFechaCreacion = info.dFechaCreacion = DateTime.Now
};
Context.rq_Catalogo.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
tb_LogError_Data LogData = new tb_LogError_Data();
LogData.GuardarDB(new tb_LogError_Info {
Descripcion = ex.Message, InnerException = ex.InnerException == null ? null : ex.InnerException.Message, Clase = "rq_Catalogo_Data", Metodo = "guardarDB", IdUsuario = info.vUserIDCreacion
});
return(false);
}
}
public bool anularDB(rq_Catalogo_Info info)
{
try
{
return(odata.anularDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Anular(rq_Catalogo_Info model)
{
if (!bus_Catalogo.anularDB(model))
{
SessionFixed.IdTransaccionSessionActual = model.IdTransaccionSession.ToString();
ViewBag.Message = "El registro no pudo ser anulado";
cargar_combos();
return(View(model));
}
return(RedirectToAction("Index2", new { vReferenciaID = model.vReferenciaID }));
}
public rq_Catalogo_Info GetInfo_ByCodigo(string vCodigo)
{
try
{
rq_Catalogo_Info info = new rq_Catalogo_Info();
using (SqlConnection connection = new SqlConnection(ConexionesERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand("", connection);
command.CommandText = "SELECT iCatalogoID,vReferenciaID,vCodigo,vDescripcion,iOrder,bEstado "
+ " FROM rq_Catalogo WITH (nolock) WHERE vCodigo = " + "'" + vCodigo.ToString() + "'"
+ " ORDER BY iOrder";
var ResultValue = command.ExecuteScalar();
if (ResultValue == null)
{
return(null);
}
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
info = new rq_Catalogo_Info
{
iCatalogoID = Convert.ToInt32(reader["iCatalogoID"]),
vReferenciaID = reader["vReferenciaID"].ToString(),
vDescripcion = reader["vDescripcion"].ToString(),
vCodigo = string.IsNullOrEmpty(reader["vCodigo"].ToString()) ? null : reader["vCodigo"].ToString(),
iOrder = Convert.ToInt32(reader["iOrder"]),
bEstado = Convert.ToBoolean(reader["bEstado"]),
};
}
}
return(info);
}
catch (Exception)
{
throw;
}
}
private bool validar(rq_Catalogo_Info info, ref string Message)
{
if (string.IsNullOrEmpty(info.vReferenciaID))
{
Message = "Referencia es obligatorio";
return(false);
}
else
{
if (info.vReferenciaID.Trim() == "")
{
Message = "Referencia es obligatorio";
return(false);
}
}
return(true);
}
public ActionResult Modificar([ModelBinder(typeof(DevExpressEditorsBinder))] rq_Catalogo_Info model)
{
if (!validar(model, ref mensaje))
{
SessionFixed.IdTransaccionSessionActual = model.IdTransaccionSession.ToString();
ViewBag.Message = mensaje;
cargar_combos();
return(View(model));
}
if (!bus_Catalogo.modificarDB(model))
{
SessionFixed.IdTransaccionSessionActual = model.IdTransaccionSession.ToString();
ViewBag.Message = "The data was not saved";
cargar_combos();
return(View(model));
}
return(RedirectToAction("Consultar", new { iCatalogoID = model.iCatalogoID, Success = true }));
}
public ActionResult Nuevo([ModelBinder(typeof(DevExpressEditorsBinder))] rq_Catalogo_Info model)
{
model.vUserIDCreacion = SessionFixed.IdUsuario.ToString();
if (!validar(model, ref mensaje))
{
ViewBag.mensaje = mensaje;
cargar_combos();
SessionFixed.IdTransaccionSessionActual = model.IdTransaccionSession.ToString();
return(View(model));
}
if (!bus_Catalogo.guardarDB(model))
{
ViewBag.mensaje = "No se ha podido guardar el registro";
cargar_combos();
SessionFixed.IdTransaccionSessionActual = model.IdTransaccionSession.ToString();
return(View(model));
}
;
return(RedirectToAction("Consultar", new { iCatalogoID = model.iCatalogoID, Success = true }));
}
public ActionResult Index2(string vReferenciaID = "")
{
#region Validar Session
if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
{
return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
}
SessionFixed.IdTransaccionSession = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
#endregion
var model = new rq_Catalogo_Info
{
IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSession),
vReferenciaID = vReferenciaID
};
List <rq_Catalogo_Info> lista = bus_Catalogo.GetList_Catalogo_By_ReferenceID(model.vReferenciaID);
Lista_Catalogo.set_list(lista, model.IdTransaccionSession);
cargar_combos();
return(View(model));
}
public ActionResult Consultar(int iCatalogoID, bool Success = false)
{
#region Validar Session
if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
{
return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
}
SessionFixed.IdTransaccionSession = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
#endregion
rq_Catalogo_Info model = bus_Catalogo.GetInfo_Catalogo(iCatalogoID);
if (model == null)
{
return(RedirectToAction("Index"));
}
model.IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual);
cargar_combos();
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "Requerimiento", "CatalogoRequerimiento", "Index");
if (model.bEstado == false)
{
info.Modificar = false;
info.Anular = false;
}
model.Nuevo = (info.Nuevo == true ? 1 : 0);
model.Modificar = (info.Modificar == true ? 1 : 0);
model.Anular = (info.Anular == true ? 1 : 0);
#endregion
if (Success)
{
ViewBag.MensajeSuccess = MensajeSuccess;
}
return(View(model));
}
public ActionResult Index()
{
#region Validar Session
if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
{
return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
}
SessionFixed.IdTransaccionSession = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
#endregion
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "Requerimiento", "CatalogoRequerimiento", "Index");
ViewBag.Nuevo = info.Nuevo;
#endregion
rq_Catalogo_Info model = new rq_Catalogo_Info
{
IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSession)
};
List <rq_Catalogo_Info> lista = bus_Catalogo.GetList_Catalogo_ReferenceID();
Lista_CatalogoTipo.set_list(lista, Convert.ToDecimal(SessionFixed.IdTransaccionSession));
return(View(model));
}
