public SqlDataReader DRListaDelegados_BycPerCodigo(BE_Req_Persona Request)
{
SqlDataReader Rs;
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "sp_get_Delegados";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs = dr;
}
}
}
}
catch (Exception)
{
throw;
}
return(Rs);
}
//---------------------------------------------
// Get Persona con PerRelacion for nPerRelTipo
//---------------------------------------------
public DataTable Get_List_Persona_PerRelacion_for_nPerRelTipo(BE_Req_Persona Request)
{
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Get_List_Persona_PerRelacion_for_nPerRelTipo]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nPerRelTipo", Request.nPerRelTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
public Boolean delDelegado(BE_Req_Persona Request)
{
Boolean Item = new Boolean();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "sp_del_Delegado";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("@nPerParTipo", Request.nPerParTipo);
cm.Parameters.AddWithValue("@cPerParCodigo", Request.cPerParCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}
public DataTable ListaPersonas_BycPerCodigo_cPerRelTipo(BE_Req_Persona Request)
{
DataTable Rs = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "sp_ListaPersonas_BycPerCodigo_cPerRelacion";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerApellido", Request.cPerApellido);
cm.Parameters.AddWithValue("cPerRelTipo", Request.cPerRelTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs.Load(dr);
}
}
}
}
catch (Exception)
{
throw;
}
return(Rs);
}
//---------------------------------------------
// Get Persona con PerRelacion for nPerRelTipo
//---------------------------------------------
public DataTable Get_List_Persona_PerRelacion_for_nPerRelTipo(int nPerRelTipo)
{
//Recuperando registros
DataTable dt = new DataTable();
BE_Req_Persona Request = new BE_Req_Persona();
DA_Persona Obj = new DA_Persona();
Request.nPerRelTipo = nPerRelTipo;
return(Obj.Get_List_Persona_PerRelacion_for_nPerRelTipo(Request));
}
public DataTable Get_ListPer_By_cPerRelTipo(string pcPerRelTipo)
{
//Recuperando registros
DataTable dt = new DataTable();
BE_Req_Persona Request = new BE_Req_Persona();
DA_Personas Obj = new DA_Personas();
Request.cPerRelTipo = pcPerRelTipo;
return(Obj.Get_ListPer_By_cPerRelTipo(Request));
}
public Boolean setPersona(BE_Req_Persona Request)
{
Boolean Item = new Boolean();
string codigo = "";
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "sp_set_Persona";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("cPerApellido", Request.cPerApellido);
cm.Parameters.AddWithValue("cPerNombre", Request.cPerNombre);
cm.Parameters.AddWithValue("nPerTipo", Request.nPerTipo);
cm.Parameters.AddWithValue("cUbiGeoCodigo", Request.cUbiGeoCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
codigo = dr.GetString(dr.GetOrdinal("cPerCodigo")).ToString();
}
}
if (codigo.Equals(""))
{
Item = false;
}
else
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}
public string getDelegadoAnduser(BE_Req_Persona Request)
{
string codigo = "";
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "sp_get_UserAndDelegado";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
codigo = dr.GetString(dr.GetOrdinal("cPerCodigo")).ToString();
}
if (codigo.Equals(""))
{
codigo = Request.cPerCodigo;
}
else
{
codigo += Request.cPerCodigo;
}
}
}
}
}
catch (Exception)
{
throw;
}
return(codigo);
}
public DataTable Get_Busqueda_Terceros_By_Tipo_Descr(BE_Req_Persona Request)
{
DataTable Rs = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "usp_Admision_Get_Busqueda_Terceros_By_Tipo_Descr";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nPerRelTipo", Request.nPerRelTipo);
cm.Parameters.AddWithValue("cValorBuscado", Request.cPerApellido);
cm.Parameters.AddWithValue("nTipoBusq", Request.nPerTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs.Load(dr);
}
}
}
}
catch (Exception)
{
throw;
}
return(Rs);
}
public DataTable ListaPeronas_BycPerApellido_cPerRelTipo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.ListaPersonas_BycPerCodigo_cPerRelTipo(Request));
}
public Boolean setPersona(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.setPersona(Request));
}
public DataTable ListaPersona_BycPerCodigo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.ListaPersona_BycPerCodigo(Request));
}
public SqlDataReader DRListaDelegados_BycPerCodigo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.DRListaDelegados_BycPerCodigo(Request));
}
public DataTable Get_Busqueda_Terceros_By_Tipo_Descr(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.Get_Busqueda_Terceros_By_Tipo_Descr(Request));
}
public SqlDataReader DRListaPeronas_BycPerApellido_cPerRelTipo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.DRListaPersonas_BycPerCodigo_cPerRelTipo(Request));
}
public Boolean delDelegado(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.delDelegado(Request));
}
public string getDelegadoAnduser(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return(ObjPersona.getDelegadoAnduser(Request));
}
