public void Eliminar(PerfilFuncionDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_USP_ELIMINAR); db.AddInParameter(dbCommand, "@id_funcion", DbType.Int32, obj.IdFuncion); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, obj.IdPerfil); db.ExecuteNonQuery(dbCommand); }
public void Actualizar(PerfilFuncionDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_ACTUALIZAR); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, obj.IdPerfil); db.AddInParameter(dbCommand, "@id_funcion", DbType.Int32, obj.IdFuncion); db.AddInParameter(dbCommand, "@orden", DbType.Int32, obj.Orden); db.AddInParameter(dbCommand, "@Estado", DbType.String, obj.Estado); db.ExecuteNonQuery(dbCommand); }
public int Agregar(PerfilFuncionDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_USP_AGREGAR); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, obj.IdPerfil); db.AddInParameter(dbCommand, "@id_funcion", DbType.Int32, obj.IdFuncion); db.AddInParameter(dbCommand, "@orden", DbType.Int32, obj.Orden); db.AddInParameter(dbCommand, "@estado", DbType.String, obj.Estado); int id = db.ExecuteNonQuery(dbCommand); return id; }
protected void btnGrabarFuncion_Click(object sender, EventArgs e) { PerfilFuncionDTO objPerfilFuncionDTO; PerfilFuncionDAO objPerfilFuncionDAO = new PerfilFuncionDAO(); int idPerfil = Convert.ToInt32(this.txtIdPerfil.Text); for (int i = 0; i < tvwFunciones.Nodes.Count; i++) { TreeNode nodo1 = tvwFunciones.Nodes[i]; int idFuncion = int.Parse(nodo1.Value); if (nodo1.Checked) { objPerfilFuncionDTO = objPerfilFuncionDAO.ListarPorClave(idPerfil, idFuncion); if (objPerfilFuncionDTO.IdFuncion == 0) { PerfilFuncionDTO objPerfilFuncion = new PerfilFuncionDTO(); objPerfilFuncion.IdPerfil = idPerfil; objPerfilFuncion.IdFuncion = idFuncion; objPerfilFuncion.Estado = "1"; objPerfilFuncion.Orden = 99; objPerfilFuncionDAO.Agregar(objPerfilFuncion); } } else { PerfilFuncionDTO objPerfilFuncion = new PerfilFuncionDTO(); objPerfilFuncion.IdPerfil = idPerfil; objPerfilFuncion.IdFuncion = idFuncion; objPerfilFuncionDAO.Eliminar(objPerfilFuncion); } } }
public List<PerfilFuncionDTO> Listar() { List<PerfilFuncionDTO> Lista = new List<PerfilFuncionDTO>(); Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { PerfilFuncionDTO obj = new PerfilFuncionDTO(); if (dr["id_perfil"] != System.DBNull.Value) obj.IdPerfil = (int)dr["id_perfil"]; if (dr["id_funcion"] != System.DBNull.Value) obj.IdFuncion = (int)dr["id_funcion"]; if (dr["orden"] != System.DBNull.Value) obj.Orden = (int)dr["orden"]; if (dr["Estado"] != System.DBNull.Value) obj.Estado = (string)dr["Estado"]; } } return Lista; }
public PerfilFuncionDTO ListarPorPerfilFuncion(int IdPerfil, int IdFuncion) { PerfilFuncionDTO obj = null; Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_LISTAR_POR_PERFIL_FUNCION); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, IdPerfil); db.AddInParameter(dbCommand, "@id_funcion", DbType.Int32, IdFuncion); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { obj = new PerfilFuncionDTO(); if (dr["id_perfil"] != System.DBNull.Value) obj.IdPerfil = (int)dr["id_perfil"]; if (dr["id_funcion"] != System.DBNull.Value) obj.IdFuncion = (int)dr["id_funcion"]; if (dr["orden"] != System.DBNull.Value) obj.Orden = (int)dr["orden"]; if (dr["Estado"] != System.DBNull.Value) obj.Estado = (string)dr["Estado"]; } } return obj; }
public List<PerfilFuncionDTO> ListarPorPerfil(int IdPerfil) { List<PerfilFuncionDTO> Lista = new List<PerfilFuncionDTO>(); Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand("USP_PerfilFuncion_ListarPorPerfil"); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, IdPerfil); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { PerfilFuncionDTO obj = new PerfilFuncionDTO(); if (dr["id_perfil"] != System.DBNull.Value) obj.IdPerfil = (int)dr["id_perfil"]; if (dr["id_funcion"] != System.DBNull.Value) obj.IdFuncion = (int)dr["id_funcion"]; if (dr["orden"] != System.DBNull.Value) obj.Orden = (int)dr["orden"]; if (dr["Estado"] != System.DBNull.Value) obj.Estado = (string)dr["Estado"]; if (dr["nombre_funcion"] != System.DBNull.Value) obj.NombreFuncion = (string)dr["nombre_funcion"]; Lista.Add(obj); } } return Lista; }
public PerfilFuncionDTO ListarPorClave(int idPerfil, int idFuncion) { PerfilFuncionDTO obj = new PerfilFuncionDTO(); Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetSqlStringCommand(C_USP_BUSCAR_POR_CLAVE); db.AddInParameter(dbCommand, "@id_perfil", DbType.Int32, idPerfil); db.AddInParameter(dbCommand, "@id_funcion", DbType.Int32, idFuncion); using (IDataReader dr = db.ExecuteReader(dbCommand)) { if (dr.Read()) { obj.IdPerfil = (int)dr["id_perfil"]; obj.IdFuncion = (int)dr["id_funcion"]; } } return obj; }