public DataTable getDocAcuerdoBySustentar(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_By_Sustentar";
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 getCorrelativoBynDocTipo_nPrdCodigo(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_CorrelativoByPeriodo_nDocTipo_cPerCodigo";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo);
cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item.cNumero = dr.GetString(dr.GetOrdinal("Num"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
public DataTable getDocAcuerdoAvanceByPersona(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getDocAcuerdoAvanceByPersona(Request);
}
public Boolean updEstadoDocumento(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.updEstadoDocumento(Request);
}
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 Boolean setCopiaDocumento(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.setCopiaDocumento(Request);
}
public BE_Res_Documento getTipoPersona(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getTipoPersona(Request);
}
public Int32 getNumCorrelativoDocTratamiento(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getNumCorrelativoDocTratamiento(Request);
}
public DataTable getDocPendientesConAcuerdo(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getDocPendientesConAcuerdo(Request);
}
public Boolean setDocUniOrg(BE_Req_Documento 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_set_DocUniOrg";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("nUniOrgCodigo", Request.nUniOrgCodigo);
cm.Parameters.AddWithValue("nDocUniOrgTipo", Request.nDocUniOrgTipo);
cm.Parameters.AddWithValue("nDocUniOrgEstado", Request.nDocUniOrgEstado);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
public Boolean setDocumento(BE_Req_Documento 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_Documento";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("dDocFecha", Request.dDocFecha);
cm.Parameters.AddWithValue("cDocObserv", Request.cDocObserv);
cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo);
cm.Parameters.AddWithValue("nDocEstado", Request.nDocEstado);
cm.Parameters.AddWithValue("cAsunto", Request.Asunto);
cm.Parameters.AddWithValue("cDetalle", Request.Detalle);
cm.Parameters.AddWithValue("dFechaIni", Request.dFechaIni);
cm.Parameters.AddWithValue("dFechaFin", Request.dFechaFin);
cm.Parameters.AddWithValue("cNumDocumento", Request.cDocNDoc);
cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo);
cm.Parameters.AddWithValue("cCodPerSolicita", Request.CodPerSolicita);
cm.Parameters.AddWithValue("nPerRelSolicita", Request.PerRelSolicita);
cm.Parameters.AddWithValue("nCodUORemite", Request.CodUORemite);
cm.Parameters.AddWithValue("nDocPerTipo", Request.nDocPerTipo);
cm.Parameters.AddWithValue("cCodPerRegistra", Request.CodPerRegistra);
cm.Parameters.AddWithValue("cCodPerRecibe", Request.CodPerRecibe);
cm.Parameters.AddWithValue("nCodUODestino", Request.CodUODestino);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
codigo = dr.GetString(dr.GetOrdinal("cDocCodigo")).ToString();
}
}
if (codigo.Equals(""))
{
Item = false;
}
else
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
public Boolean setDocTratamiento(BE_Req_Documento 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_set_DocTratamiento";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("nEleCodigo", Request.nEleCodigo);
cm.Parameters.AddWithValue("nCarCodigo", Request.nCarCodigo);
cm.Parameters.AddWithValue("cCarObs", Request.cCarObs);
cm.Parameters.AddWithValue("nPercent", Request.nPercent);
cm.Parameters.AddWithValue("dDocTraFec", Request.dDocTraFec);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
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;
}
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 Int32 getNumCorrelativoDocTratamiento(BE_Req_Documento Request)
{
Int32 Item = new Int32();
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_NumCorrelativo_From_DocTratamiento";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item = dr.GetInt32(dr.GetOrdinal("Correlativo"));
}
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
public DataTable getDocAcuerdoBySustentar(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getDocAcuerdoBySustentar(Request);
}
public DataTable getDocInformacion(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getDocInformacion(Request);
}
public Boolean updEstadoDocumento(BE_Req_Documento 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_upd_EstadoDocumento";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo);
cm.Parameters.AddWithValue("nDocEstado", Request.nDocEstado);
cm.Parameters.AddWithValue("cDocObserv", Request.cDocObserv);
cm.Parameters.AddWithValue("cPerModCodigo", Request.cPerCodigo);
cm.Parameters.AddWithValue("nDocPerEdiTipo", Request.nDocPerTipo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
codigo = dr.GetString(dr.GetOrdinal("cDocCodigo")).ToString();
}
}
if (codigo.Equals(""))
{
Item = false;
}
else
{
Item = true;
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
public BE_Res_Documento getDocumentoBycDocNDoc_nDocTipo(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getDocumentoBycDocNDoc_nDocTipo(Request);
}
public Boolean setDocProProveido(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.setDocProProveido(Request);
}
public DataTable getPerCopias(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getPerCopias(Request);
}
public BE_Res_Documento getCorrelativoBynDocTipo_nPrdCodigo(BE_Req_Documento Request)
{
DADocumento ObjCorrelativo = new DADocumento();
return ObjCorrelativo.getCorrelativoBynDocTipo_nPrdCodigo(Request);
}
public BE_Res_Documento getUltimoDocumentoBycPerCodigo(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.getUltimoDocumentoBycPerCodigo(Request);
}
public Boolean setDocTratamiento(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.setDocTratamiento(Request);
}
public Boolean setDocIdentifica(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.setDocIdentifica(Request);
}
public Boolean setDocUniOrg(BE_Req_Documento Request)
{
DADocumento ObjDocumento = new DADocumento();
return ObjDocumento.setDocUniOrg(Request);
}
