public void Filtrar(ref Cls_Roles_Personas_DAL objDAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
try
{
string error = "";
Crear_Parametros(ref objDAL);
objDAL.dtParametros.Rows.Add("@Filtro", "2", objDAL.sFiltro);
objDAL.dtTabla = Obj_BDService.FiltrarDatos("sp_Filtrar_Roles_Personas", "Roles_Personas", objDAL.dtParametros, ref error);
if (error == string.Empty && objDAL.dtTabla != null)
{
objDAL.sError = string.Empty;
}
else
{
objDAL.sError = error;
}
}
catch (Exception ex)
{
objDAL.sError = ex.Message.ToString();
}
finally
{
Obj_BDService.Close();
}
}
public void Filtrar(ref Cls_Sucursales_DAL objSucDAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
try
{
string error = "";
Crear_Parametros(ref objSucDAL);
objSucDAL.dtParametros.Rows.Add("@pNombre", "2", objSucDAL.sFiltro);
objSucDAL.DtTabla = Obj_BDService.FiltrarDatos("sp_Listar_Sucursales_Direccion_Filtro", "Sucursales", objSucDAL.dtParametros, ref error);
if (error == string.Empty && objSucDAL.DtTabla != null)
{
objSucDAL.sError = string.Empty;
}
else
{
objSucDAL.sError = error;
}
}
catch (Exception ex)
{
objSucDAL.sError = ex.Message.ToString();
}
finally
{
Obj_BDService.Close();
}
}
public void Filtrar(ref Cls_Tarjetas_DAL Obj_Tarjetas_DAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
try
{
string error = "";
Crear_Parametros(ref Obj_Tarjetas_DAL);
Obj_Tarjetas_DAL.DtParametros.Rows.Add("@Usuario", "2", Obj_Tarjetas_DAL.SPersona);
Obj_Tarjetas_DAL.DtTablaTarjetas = Obj_BDService.FiltrarDatos("sp_Listar_Tarjetas_Persona", "Tarjetas", Obj_Tarjetas_DAL.DtParametros, ref error);
if (error == string.Empty && Obj_Tarjetas_DAL.DtTablaTarjetas != null)
{
Obj_Tarjetas_DAL.SError = string.Empty;
}
else
{
Obj_Tarjetas_DAL.SError = error;
}
}
catch (Exception ex)
{
Obj_Tarjetas_DAL.SError = ex.Message.ToString();
}
finally
{
Obj_BDService.Close();
}
}
public void Filtrar(ref Cls_Categoria_DAL Obj_Categoria_DAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
try
{
string vError = "";
Crear_Parametros(ref Obj_Categoria_DAL);
Obj_Categoria_DAL.DtParametros.Rows.Add("@Nombre", "2", Obj_Categoria_DAL.SFiltro);
Obj_Categoria_DAL.DtTablaCategoria = Obj_BDService.FiltrarDatos("sp_Filtrar_Categorias", "Categorias", Obj_Categoria_DAL.DtParametros, ref vError);
Obj_Categoria_DAL.SError = vError;
if (vError == string.Empty && Obj_Categoria_DAL.DtTablaCategoria != null)
{
Obj_Categoria_DAL.SError = string.Empty;
}
else
{
Obj_Categoria_DAL.SError = vError;
}
}
catch (Exception ex)
{
Obj_Categoria_DAL.SError = ex.Message.ToString();
}
finally
{
Obj_BDService.Close();
}
}
public bool HasPrivilege(ref Cls_Membership_DAL Obj_Membership_DAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
string vError = string.Empty;
Crear_Parametros(ref Obj_Membership_DAL);
Obj_Membership_DAL.dtParametros.Rows.Add("@UserLogin", "2", Obj_Membership_DAL.sUserLogin);
Obj_Membership_DAL.dtParametros.Rows.Add("@Privilegio", "2", Obj_Membership_DAL.sPrivilegio);
Obj_Membership_DAL.dtTablMembership = Obj_BDService.FiltrarDatos("sp_Has_Privilege", "Membership", Obj_Membership_DAL.dtParametros, ref vError);
Obj_Membership_DAL.sError = vError;
if (Obj_Membership_DAL.sError == string.Empty)
{
if (Obj_Membership_DAL.dtTablMembership.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public bool Login(ref Cls_Membership_DAL Obj_Membership_DAL)
{
try
{
BDServiceClient Obj_BDService = new BDServiceClient();
string vError = string.Empty;
Crear_Parametros(ref Obj_Membership_DAL);
Obj_Membership_DAL.dtParametros.Rows.Add("@UserLogin", "2", Obj_Membership_DAL.sUserLogin);
Obj_Membership_DAL.dtParametros.Rows.Add("@Contrasena", "2", Obj_Membership_DAL.sContrasena);
Obj_Membership_DAL.dtTablMembership = Obj_BDService.FiltrarDatos("sp_Login", "Membership", Obj_Membership_DAL.dtParametros, ref vError);
Obj_Membership_DAL.sError = vError;
if (Obj_Membership_DAL.sError == string.Empty)
{
if (Obj_Membership_DAL.dtTablMembership.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public void Filtrar(ref Cls_Personas_DAL Obj_Personas_DAL)
{
BDServiceClient Obj_BDService = new BDServiceClient();
string vError = string.Empty;
Crear_Parametros(ref Obj_Personas_DAL);
Obj_Personas_DAL.dtParametros.Rows.Add("@Filtro", "2", Obj_Personas_DAL.sFiltro);
Obj_Personas_DAL.dtTablaPersonas = Obj_BDService.FiltrarDatos("sp_Filtrar_Personas", "Personas", Obj_Personas_DAL.dtParametros, ref vError);
Obj_Personas_DAL.sError = vError;
}