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