public DataTable getDocAcuerdoAvanceByPersona(BE_Req_Documento Request)
{
BE_Res_Documento Item = new BE_Res_Documento();
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_Acuerdo_Anvance_By_Persona";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs.Load(dr);
}
}
}
}
catch (Exception)
{
throw;
}
return(Rs);
}
public BE_Res_Documento getDocumentoBycDocNDoc_nDocTipo(BE_Req_Documento Request)
{
BE_Res_Documento Item = new BE_Res_Documento();
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_DocumentoBycDocNDoc_nDocTipo";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocNDoc", Request.cDocNDoc);
cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item.cDocCodigo = dr.GetString(dr.GetOrdinal("cDocCodigo"));
Item.nDocTipoNum = dr.GetInt16(dr.GetOrdinal("nDocTipoNum"));
Item.cDocNDoc = dr.GetString(dr.GetOrdinal("cDocNDoc"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}
public BE_Res_Documento getTipoPersona(BE_Req_Documento Request)
{
BE_Res_Documento Item = new BE_Res_Documento();
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_TipoPersona";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item.cPerCodigo = dr.GetString(dr.GetOrdinal("cPerCodigo"));
Item.nAdministrativo = dr.GetInt32(dr.GetOrdinal("Administrativo"));
Item.nAlumno = dr.GetInt32(dr.GetOrdinal("Alumno"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}
public DataTable getDocPendientesConAcuerdo(BE_Req_Documento Request)
{
BE_Res_Documento Item = new BE_Res_Documento();
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_DocPendientesConAcuerdo_BycPerCodigo";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("FiltroPersona", Request.FiltroPersona);
cm.Parameters.AddWithValue("FiltroFecha", Request.FiltroFecha);
cm.Parameters.AddWithValue("FecIni", Request.dFechaIni);
cm.Parameters.AddWithValue("FecFin", Request.dFechaFin);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Rs.Load(dr);
}
}
}
}
catch (Exception)
{
throw;
}
return(Rs);
}
public BE_Res_Documento getUltimoDocumentoBycPerCodigo(BE_Req_Documento Request)
{
BE_Res_Documento Item = new BE_Res_Documento();
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_UltimoDocumentoBycPerCodigo";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item.cDocNDoc = dr.GetString(dr.GetOrdinal("cDocNDoc"));
Item.dDocFecha = dr.GetDateTime(dr.GetOrdinal("dDocFecha"));
Item.cPerApellido = dr.GetString(dr.GetOrdinal("cPerApellido"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return(Item);
}