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