private void CargarRoles()
{
Cls_Roles_BLL objBLL = new Cls_Roles_BLL();
Cls_Roles_DAL objDAL = new Cls_Roles_DAL();
gdvRoles.DataSource = null;
gdvRoles.DataBind();
objBLL.Listar(ref objDAL);
if (objDAL.sError == string.Empty)
{
gdvRoles.SelectedIndex = -1;
if (txtBuscar.Value == string.Empty)
{
gdvRoles.DataSource = objDAL.dtTabla;
}
else
{
DataTable dt = objDAL.dtTabla;
EnumerableRowCollection <DataRow> query = from dtRoles in dt.AsEnumerable()
where dtRoles.Field <string>("Rol").ToLower().Replace(" ", "").Contains(txtBuscar.Value.ToLower().Replace(" ", ""))
select dtRoles;
DataView view = query.AsDataView();
gdvRoles.DataSource = view;
}
gdvRoles.DataBind();
if (gdvRoles.Rows.Count > 0)
{
gdvRoles.Visible = true;
lblMensaje.Visible = false;
lblMensaje.Text = "";
}
else
{
gdvRoles.Visible = false;
lblMensaje.Visible = true;
lblMensaje.Text = "No hay datos que mostrar";
}
}
else
{
lblMensaje.Text = objDAL.sError;
}
}
public void CargarCombos()
{
Cls_Roles_BLL objBLL = new Cls_Roles_BLL();
Cls_Roles_DAL objDAL = new Cls_Roles_DAL();
objBLL.Listar(ref objDAL);
if (objDAL.sError == string.Empty)
{
cmbRoles.DataSource = null;
cmbRoles.DataSource = objDAL.dtTabla;
cmbRoles.DataTextField = "Rol";
cmbRoles.DataValueField = "Id_Rol";
cmbRoles.DataBind();
cmbRoles.SelectedIndex = 0;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowPopup", "alert('Se presento un problema a la hora de cargar el combo de roles');", true);
}
}
public DataTable listarRol(ref string sMsj_error)
{
Cls_Roles_BLL Obj_Rol_BLL = new Cls_Roles_BLL();
return(Obj_Rol_BLL.Listar(ref sMsj_error));
}
