public SqlDataReader DRListaPersonas_BycPerCodigo_cPerRelTipo(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_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 = dr;
}
}
}
}
catch (Exception)
{
throw;
}
return Rs;
}
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 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 DataTable ListaPersona_BycPerCodigo(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_get_Persona_ByCperCodigo";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs.Load(dr);
}
}
}
}
catch (Exception)
{
throw;
}
return Rs;
}
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 string getDelegadoAnduser(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.getDelegadoAnduser(Request);
}
//---------------------------------------------
// 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 setPersona(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.setPersona(Request);
}
public SqlDataReader DRListaPeronas_BycPerApellido_cPerRelTipo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.DRListaPersonas_BycPerCodigo_cPerRelTipo(Request);
}
public DataTable ListaPersona_BycPerCodigo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.ListaPersona_BycPerCodigo(Request);
}
public DataTable ListaPeronas_BycPerApellido_cPerRelTipo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.ListaPersonas_BycPerCodigo_cPerRelTipo(Request);
}
public SqlDataReader DRListaDelegados_BycPerCodigo(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.DRListaDelegados_BycPerCodigo(Request);
}
public Boolean delDelegado(BE_Req_Persona Request)
{
DAPersona ObjPersona = new DAPersona();
return ObjPersona.delDelegado(Request);
}
//---------------------------------------------
// 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);
}
